ORA-122203: TNS: unable to connect to destination

[cadbilbao]

Hi all!

Following the steps from "Oracle8 Enterprise Edition Getting
Started for Windows NT" in order to create my XXX database:

+ I installed Oracle 8.0.5 without any Database.
+ I rebooted
+ I created initXXX.ora
+ C:\MYDIR> ORADIM80 -NEW -SID XXX -INTPWD PASSWORD -STARTMODE AUTO
-PFILE ORACLE_HOME\DATABASE\INITXXX.ORA
+ I checked that OracleServiceXXX was running
+ C:\MYDIR> SET ORACLE_SID=XXX

But when trying to 'C:\MYDIR> SVRMGR30', I get this message:

ORA-122203: TNS: unable to connect to destination

I've checked OracleTNSListener, and it's running...

Any suggestion? Thank you in advance.

 

[binjovi]

HI,

TRY TO CONNECT USING SVRMGRL..

HAVE FUN..

BINS

 

[carp]

You might also want to try to TNSPING the instance.
Also, using lsnrctl, make sure listener is not only running, but has a service handler for your instance.

 

[rcurva]

I supposed you already checked the following env variables when you invoked the command prompt to run svrmgr30:

ORACLE_SID=<SID>
local=<SID>