Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2388
  • Last Modified:

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:
0
Dba_Oracledb
Asked:
Dba_Oracledb
  • 6
  • 4
1 Solution
 
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
 
Dba_OracledbAuthor Commented:
what should be done to solve it...?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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
 
Chakravarthi AyyalaDatabase 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:
what does oracle wallet do exaclty, and what are consequences of disabling it...
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now