Originally posted by akhadar
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
c:\set oracle_sid = ricd
SQL> conn / as sysdba
ERROR:
ORA-12560: TNSrotocol adapter error
Warning: You are no longer connected to ORACLE.
SQL> conn /@ricd as sysdba
Connected.
According to ur post, i suspect u are setting oracle_sid in command prompt and opening a sqlplusw session and entering user credentials.
That is wrong.
I suspected because
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
after the banner you logged into SQLPLUSW, where from you got command prompt in that?
c:\set oracle_sid = ricd
SQL> conn / as sysdba
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"