This content has been marked as final. Show 11 replies
Although not explicitly forbidden,such an environment is not recommended. The error says Oracle cannot interpret ORACLE_SID,the OS itself (echo $ORACLE_SID) may have another point of view.
I added export before each environment variable.
the error changed:
sqlplus "/as sysdba"
ORA-01031: insufficient privileges
This may help..
"Please run $ORACLE_HOME/install/changePerm.sh. This is if you want to invoke sqlplus from other than oracle unix account"
sqlplus "/as sysdba"The need to quote ended with 10g. Just to confirm that is not causing a problem, what happens when you do
sqlplus / as sysdba1) no quote
2) space before 'as'
And ... which OS and which OS user are you using to log in? It looks like a *nix variant. If so, typically only a member of the OSDBA group can use that syntax.
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 issue happened on my box too.
i'm using solaris 5.10, ORACLE_HOME, ORACLE_OWNER, ORACLE_SID are set.
it is working ok when cd $ORACLE_HOME in OS.
but fail with same error when launching sql plus
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