Re: New Database on NT???

Mike wrote:
>
> Howdy,
>
> 2 questions:
>
> 1) I've created a new database using the NT Instance manager. The db was
> created fine and I can TNSPING it and also connect using svrmgr23. However, I
> get an "ORA-12505: TNS:listener counld not resolve SID given in connect
> descriptor" when I try to connect using sqlplus. The tnsnames.ora looks good.
> Also, ORA-12505 is not in the Error help file.

Is there an entry for the new instance SID in your $ORACLE_HOME/network/admin/LISTENER.ORA on the server ??

Alter and restart the listener process !

>
> 2) How do I create a new database not using the GUI Instance manager?
>

copy your $ORACLE_HOME/database/init.ora to $ORACLE_HOME/database/init<NEWSID>.ora

alter in this file parameter DB_NAME to NEWDATABASENAME

G:\ORANT73\BIN\ORADIM73 -new -sid NEWSID -startmode auto -intpwd YOURPASSWORD -pfile=G:\ORANT73\DATABASE\init<NEWSID>.ora -maxusers 5

> Thanks!
 

-- 
----------------------------------------------------------------------
Dipl.Ing.(BA) Sebastian Rehm   Robert BOSCH GmbH Reutlingen QI/LBS3-Rt  
Tel: ++49-7121-35-4019  fax: 35-1689 mailto:Sebastian.Rehm_at_rt.bosch.de
----------------------------------------------------------------------