Working with Ora10gXE on a Windows 2003 server I could not connect sqlplus / as sysdba but could as sqlplus sys/pword@sid as sysdba
Got ORA-12560:TNS:protocol adapter error".
After big searches on Google could not get a clear cut answer, everything trended towards not being able to sqlplus at all. I found a couple posts where someone specifically asked why they can do sqlplus sys/pwd@sid as sysdba but not sqlplus / as sysdba
But most of the answers where as if the user could not sqlplus at all.
Finally out of curiosity I echo’d %ORACLE_SID% and got nothing back.
So I added the SID to the environmental variables rebooted and the problem was fixed.
Not sure about the exact mechanics of the fix but I assume that when just connecting sqlplus / it is looking for the environmental variable vrs using the listener to make the connection?
Maybe someone can explain?
No comments:
Post a Comment