unable to connect to sqlplus as sysdba

Db's are up and running but after setting env and sqlplus / as sysdba i am getting following error.

Its a rac, able to login to sqlplus on other nodes. only problem on primary node.

sun 5.10


SQL*Plus: Release 11.1.0.7.0 - Production on

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

ERROR:
ORA-12534: TNS:operation not supported


Enter user-name:
Dba_OracledbAsked:
Who is Participating?
 
Chakravarthi AyyalaConnect With a Mentor Database AdministratorCommented:
I'm wondering the failure is happening due to SQLNET.WALLET_OVERRIDE = TRUE.
For the sake of testing, is it possible for you to comment the above line and try?

(Ref: http://download.oracle.com/docs/cd/E11882_01/network.112/e16543/authentication.htm#DBSEG30253)
0
 
Dba_OracledbAuthor Commented:
may be need to clean up smon process ??
0
 
Chakravarthi AyyalaDatabase AdministratorCommented:
This is what it is saying.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
SQL> !oerr ora 12534
12534, 00000, "TNS:operation not supported"
// *Cause:  An internal function received a request to perform an
// operation that is not supported (on this machine).
// *Action:  Not normally visible to the user. For further details, turn
// on tracing and reexecute the operation. If error persists, contact
// Oracle Customer Support.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Dba_OracledbAuthor Commented:
what should be done to solve it...?
0
 
Chakravarthi AyyalaDatabase AdministratorCommented:
1. did you set your ORACLE_SID
2. after you set the ORACLE_SID, please issue "env | grep -i oracle_sid"
3. make sure that the SID was properly set
4. then try one more time connecting as "sqlplus / as sysdba"

0
 
Dba_OracledbAuthor Commented:
did all those, i just created another user from second node and tried to connect using that new user from 1st node and its worked.

Only / as sysdba dba not working !!
0
 
Chakravarthi AyyalaDatabase AdministratorCommented:
Do you have wallet in this DB?
0
 
Dba_OracledbAuthor Commented:
how to confirm it ?
0
 
Dba_OracledbAuthor Commented:
yes i see wallet enabled


SQLNET.WALLET_OVERRIDE = TRUE
WALLET_LOCATION =
(SOURCE=
(METHOD = FILE)
(METHOD_DATA = (DIRECTORY=/home/user_name_XXX/wallet)
0
 
Dba_OracledbAuthor Commented:
what does oracle wallet do exaclty, and what are consequences of disabling it...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.