svrmgrl command prompt tns error!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: svrmgrl command prompt tns error!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi!

    Many thanks for the reply!

    I try to invoke command prompt from sql*plus by typing:
    sql> host

    Then I type set oracle_sid = sidname

    Then svrmgrl

    tns error!

    svrmgrl>

    This way could not connect internal!

    Here lies the problem!


    How to resolve the above problem!


    Regaards,


    Amit.


  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi Amit,

    Make sure you have a entry in tnsnames.ora file for you SID and try the following command to test the connectivity from command prompt or Unix Prompt

    tnsping SID

    Any specific reason for using the following steps to connect thru server manager because if you want to Invoke server manager just directly goto command prompt or Unix prompt and perform the following steps

    set oracle_sid=youroraclesid

    svrmgrl

    connect internal

    If you are on Oracle 8i you need not Invoke server manager to connect to Internal you can invoke in you sqlplus itself

    SQL> connect internal

    Shoud connect you to internal

    Regards
    Santosh

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