ORA-122203: TNS: unable to connect to destination

[l-ellison]

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.

[dknight]

Try

> svrmgrl

That's svrmgr (ell) as in line mode.

It works for 8.1.6.

Good luck.

[l-ellison]

Hi. Thank you for answering...

I'm on Windows NT... svrmgrl is the Server Manager command for Unix, but svrmgr30 is the command for Windows.

Thank you anyway.

[isaady]

Hi,

In NT, before issuing the SVRMGRL command in the DOS-PROMPT, set ur oracle side and oracle home as:

C:\SET ORACLE_SID=sid_name
C:\SET ORACLE_HOME=path of ur oracle server installation

and then
C:\SVRMGRL

would help u get access to the Server Manager of Oracle.

Kevin

[isaady]

------------------------------------------------------------------------
svrmgrl is the Server Manager command for Unix, but svrmgr30 is the command for Windows.
-----------------------------------------------------------------------

In Oracle 8.0.5, SVRMGRL command works fine....!!!!

Kevin

[julian]

What does it say fot SID_LIST_LISTENER in your LISTENER.ORA file?

[pando]

from 8i svrmgrl in NT is named svrmgrl, svrmgr30 is for Oracle 8
if you dont want to do set ORACLE_SID everytime you run svrmgrl from ms-dos you have to edit the enviroment variables in NT

issady are you sure you dont have 8i client installed? svrmgrl only works form 8i!

[julian]

He must have 8i :-)

[isaady]

Yeap...

Sorry mate....

Oversight from my end....

In deed its rite...SVRMGRL works only from Oracle 8i and i apologise for my error to that issue...


Kevin