DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Sqlplus wont open

  1. #1
    Join Date
    Dec 2001
    Posts
    320

    Question

    hi all,
    i tried a recovery scenario where a database will be restored to another host.
    after restoring and recovering the database to the new host, sqlplus wont open when i use the sys user (it shows ORA-12560), but the strange thing is that from the C:\ prompt (i'm using windows 2000 Advanced Server) and after setting the Oracle_sid, it logins successfully.
    now how can i login to the database from SQLPLUS?

    Regards.

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Define oracle_sid in registry / env variables.

    Sanjay

  3. #3
    Join Date
    Dec 2001
    Posts
    320
    Thank you Sanjay, it worked.

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