Solved

unable to connect to sqlplus as sysdba

Posted on 2011-02-24
10
2,217 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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to recover a database from a user managed backup

734 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