This content has been marked as final. Show 11 replies
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.
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?
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 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