I've tried also :
but then, for both :
connect sys/<passwd>@orcl as sysdba
connect / as sysdba
I've got these 2 errors :
1)error message from sql*plus : "The procedure entry point snlinAddrLocalhost could not be located in the dynamic link library oranl10.dll"
ORA-12557: TNS:protocol adapter not loadable.
issue solved !
with regards to Petre Vasu (email@example.com)
I've modified the order of the ORACLE_HOMEs I have, using the Universal Installer (> Installed Products / Environment Variables). The ORACLE_HOME of the database should be the first one.
There can be other situations like we need to set the PATH env variable as well. Suppose if you have 2 or more oracle homes , and different versions of sqlplus , you need to set PATH for the mail database ORACLE_HOME\bin.
I had the same issue. That is even after setting the ORACLE_HOME,it gave the same error when connecting via SQLPLUS . So I set the PATH to my main ORALCE_HOME\bin path. Then it worked...
I have two Oracle homes ( One for earlier installed SOA10g, and another for current installing SOA11g).
I have the right sqlora.net file. I have removed the old path and reset to point the new oracle home. I have this home entry as the first entry in my Universal installer too.
I AM ABLE TO CONNECT WITH sys USER AS SYSDBA on THE SAME SYSTEM ( I MEAN WHERE i INSTALLED THE DATABASE) USING THE command prompt.
But I am not able to connect as the SYSDBA with sys ACCOUNT through the SQLDeveloper tool. or RCU tool? Any help please. Again I am able to connect as a normal user through the SQL developer using the SYSTEM account.