Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12560 error
Hi Vince,
2 solutions :
set oracle_sid=<MYSID
sqlplus /nolog
That will connect directly to the <MYSID> database on your local machine.
When connecting through NET*8, as you try to, you also need to add <MYSID> to your TNSNAMES.ORA file, either directly in the file or via NET assistant.
Regards,
Kenneth Koenraadt
Systems Consultant
Oracle DBA
plovmand@<no-spam>hotmail.com
Received on Thu Aug 23 2001 - 12:53:38 CDT