Solved

unable to connect to sqlplus as sysdba

Posted on 2011-02-24
10
2,139 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
  • 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:ReliableDBA
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 8

Expert Comment

by:ReliableDBA
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:ReliableDBA
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:
ReliableDBA 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
oracle 11g 23 73
Oracle - SQL Where clause causing Invalid Number Error 4 32
How to free up undo space? 3 39
Oracle - Query link database loop 8 37
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

813 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now