Solved

unable to connect to sqlplus as sysdba

Posted on 2011-02-24
10
2,185 Views
Last Modified: 2012-05-11
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:
0
Comment
Question by:Dba_Oracledb
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
10 Comments
 

Author Comment

by:Dba_Oracledb
ID: 34972838
may be need to clean up smon process ??
0
 
LVL 8

Expert Comment

by:Chakravarthi Ayyala
ID: 34972862
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
 

Author Comment

by:Dba_Oracledb
ID: 34973038
what should be done to solve it...?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 8

Expert Comment

by:Chakravarthi Ayyala
ID: 34973207
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
 

Author Comment

by:Dba_Oracledb
ID: 34973743
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
 
LVL 8

Expert Comment

by:Chakravarthi Ayyala
ID: 34974704
Do you have wallet in this DB?
0
 

Author Comment

by:Dba_Oracledb
ID: 34975250
how to confirm it ?
0
 

Author Comment

by:Dba_Oracledb
ID: 34975281
yes i see wallet enabled


SQLNET.WALLET_OVERRIDE = TRUE
WALLET_LOCATION =
(SOURCE=
(METHOD = FILE)
(METHOD_DATA = (DIRECTORY=/home/user_name_XXX/wallet)
0
 
LVL 8

Accepted Solution

by:
Chakravarthi Ayyala earned 500 total points
ID: 34975532
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
 

Author Comment

by:Dba_Oracledb
ID: 34989013
what does oracle wallet do exaclty, and what are consequences of disabling it...
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question