-
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.
-
Define oracle_sid in registry / env variables.
Sanjay
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|