This content has been marked as final. Show 18 replies
Thank you, Pierre, but unfortunatelly it still doesn't work :(
sqlnet.ora already had these lines :
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
I've also added the
OSAUTH_PREFIX_DOMAIN with value TRUE here : HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1
(it wasn't at all)
Oracle database is installed on my machine.
ORACLE_SID is orcl.
Did some testing :
1) sqlplus sys/<passw> as sysdba : OK
2) Enter user-name: sys/<passw>@orcl as sysdba : FAILS !
ORA-12154: TNS:could not resolve the connect identifier specified
sqlplus / as sysdba : FAILS !
ORA-01031: insufficient privileges
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.
Message was edited by:
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 the same issues from the beginning..
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.