I installed oracle 10g but the oracle user is an ldap user and its home directory is on a nfs server.
The installation went ok. the inventory was created locally.
the profile exists on the nfs server.
When I do sqlplus "/as sysdba", I get
ORA-12162: TNS:net service name is incorrectly specified
the tnsping returns a reponse and the ORACLE_SID, ORACLE_HOME and LD_LIBRARY_PATH and PATH are all set in the profile and they are correctly set (when doing echo).
What am I missing?
Usually all the installations went ok but I was using a local user. This time I am using a remote user.
I am also getting the same problem.
When i try to connect through sqlplus and enter the use name and password i get the same error. I did some of the steps but in vain.
i have installed Oracle on Enterprize Linux.
We have the same problem. We have some DB running on Solaris and some running on Linux.
The '/ as sysdba' connection works on all Solaris Servers, but on none of the Linux Systems.
We found out that if you change the oracle user to use dba as the primary group instead of oinstall it works - but this does not seem to be the right solution.
Has anybody another suggestion?
Same thing here.
Just finished installing 11g. Trying to start SQL*Plus but SQL*Plus returned "ORA-12162: TNS:net service name is incorrectly specified".
Solution: I was logged in as root when trying to launch SQL*Plus. Exited back to user oracle and got into SQL*Plus OK.
Hope this helps,
That's interesting. I ran into the same thing when I was working with an Oracle Database 11g in a VM on my Mac. The problem was odd because tnsping worked but SQL failed. It turned out that I'd forgot to change the server's hosts file IP address but the DNS entry was valid. More here on my blog:
I had the same problem. I exited my shell and started a fresh one, and it worked.
Had the environment settings for ORACLE_HOME, PATH, ORACLE_SID in the .cshrc. I thought I had them set correctly in the shell but maybe not.
Anyways, if you get this it error it could be your environment variables.
I manually started my listener by going to $ORACLE_HOME/bin $ lsnrctl and then LSNRCTL>start and then started my DB
If you have multiple listeners, then go to .$ORACLE_HOME/network/admin/tnsnames.ora, if your listener name are LNSRXXX and LSNRYYY, and the DB uses LSNRYYY then,
LSNRCTL> set current_listener LSNRYYY
If you have only the default listener then LSNRCTL>start would suffice
Next step set env variables , $ORACLE_HOME and $ORACLE_SID and finally start the db by
SQL>conn / as sysdba
Edited by: ajay.nair on Dec 21, 2009 5:15 PM
Edited by: user9931657 on Dec 21, 2009 5:46 PM