Saturday, November 1, 2014

ORA-01031: insufficient privileges

[oracle@STDBY admin]$ sqlplus sys@DBSTP11G as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Nov 1 01:14:18 2014

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

Enter password:
ERROR:
ORA-01031: insufficient privileges

After following all listed in the below URL

http://askdba.org/weblog/2008/05/ora-1031-as-sysdba/

My issue could not got resolved

Then i started looking into tnsnames.ora and listener.ora file

and i found that oracle_home value is incorrect in listener.ora file

After correcting it .It got resolved

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

  Diagnosing a long parsing issue in Oracle Database Slide 1: Topic: Diagnosing a Long Parsing Issue in Oracle Database Slide 2: Parsing is ...

  • (no title)
    List of Oracle Wait Events 11.2.0.3 ADR block file read ADR block file write ADR file lock AQ propagation connection AQ spill debug i...
  • (no title)
    DATE :-- 1 st Sep 2014 Error Starting Listener Error:--  [oracle@PR11G admin]$ lsnrctl start LSNRCTL fo...