Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problems with creating new database
In the Enterprise Manager, have the OEM rediscover the services on the node you are on so it will be in the OEM list or the repository cannot run agaist it.
Matt Arrocha
marrocha_at_bellsouth.net
Haresh Assumal <assumal_at_sprynet.com> wrote in article
<01bcc9ce$42ee7120$fab1aacc_at_mycomp.intermediainc.com>...
> I am new to oracle and I have been working to create a new database using
> oracle 8 under NT4.0.
> I used the tool - Database Assistant and created a new database called
TST.
> I then had to manually modify the listener.ora and manually create a
> Service to the new SID (also called TST).
>
> Now I tried to go into the enterprise manager as "system" using the new
> service and I get an error in the Oracle Repository Manager:
>
> XP-07016: A database error has occurred:
> insert into smp_rep_version (c_component, c_current_version, c_unused)
> values (:1,:2,'')
> ORA-01552: cannot use system rollback segment for non-system tablespace
> 'USR'
>
> What do I need to do? Shouldn't the utiltiy that created the database
take
> care of this? What is the best way to manage/create a database. Oracel 8
> tools do not seem to be integrated/work properly. If thats the case then
> whats the best way to manage the database, although I may be using the
> tools wrong.
>
> Thanks,
> Haresh Assumal
>
> Email: assumal_at_sprynet.com
>
>
>
>
>
Received on Sat Oct 04 1997 - 00:00:00 CDT