ORA-122203: TNS: unable to connect to destination
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: ORA-122203: TNS: unable to connect to destination

  1. #1
    Join Date
    Nov 2000
    Posts
    42

    Question

    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.
    ========
    LARRY ELLISON

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Try

    > svrmgrl

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

    It works for 8.1.6.

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Nov 2000
    Posts
    42

    Question You are wrong

    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.
    ========
    LARRY ELLISON

  4. #4
    Join Date
    May 2001
    Location
    Chennai
    Posts
    57
    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



  5. #5
    Join Date
    May 2001
    Location
    Chennai
    Posts
    57
    ------------------------------------------------------------------------
    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

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    What does it say fot SID_LIST_LISTENER in your LISTENER.ORA file?




  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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!

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    He must have 8i :-)

  9. #9
    Join Date
    May 2001
    Location
    Chennai
    Posts
    57
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width