This content has been marked as final. Show 18 replies
Check items 3 and 6 from http://download-uk.oracle.com/docs/cd/B19306_01/win.102/b14304/external.htm#i1014020
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)
what is the value of remote_login_passwordfile
SQL> show parameter remote_login_passwordfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
(I'm trying to connect locally, on the same machine where Oracle is installed)
is your ORACLE_SID ok ?
You can't connect on your client with / only on the server.
OR create a password file and connect to database with a granted sysdba user.
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:
is your OS user member of ORA_DBA group ?
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...
You should add OS user to the DBA group on the windows server only then you will be able to connect to the database without providing any sys password i.e by '/ as sysdba'.
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.
I also had similar problem, which started after I installed HTML DB. With this solution now I am able to connect /as sysdba. Thanks to you and Petre Vasu.