Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01031: insufficient privileges -- HOW TO RESOLVE ? PLEASE HELP..

Ujjwal RanaJul 14 2015 — edited Jul 14 2015

Hi,

Everything was running accordingly except with an issue with ENTERPRISE MANAGER which i have posted on the discussion. So while following the supportive answer from the discussion what i did is I tried changing listener and then i got this error messages ORA-01031: insufficient privileges .  After then I uninstalled database again and re-tried removing all the listener again and re-tried adding the listener again but that did not wok. I have grid installed in my pc.I have already uninstalled database from dbca therefore I wonder how could i solve the above issue ? I have oracle grid in my pc and here are some information which you might need it.

[grid@example admin]$ echo $ORACLE_SID

+ASM

[grid@example admin]$ echo $ORACLE_HOME

/u01/app/11.2.0/grid

[grid@example admin]$ su - oracle

Password:

[oracle@example ~]$ echo $ORACLE_SID

orcl

[oracle@example ~]$ echo $ORACLE_HOME

/u01/app/oracle/product/11.2.0/db_1

[oracle@example ~]$ echo $ORACLE_UNQNAME

orcl

[oracle@example ~]$

[grid@example admin]$ vi sqlnet.ora

#NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, EZCONNECT)

SQLNET.AUTHENTICATION_SERVICES= (ALL)

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, EZCONNECT)

ADR_BASE = /u01/app/grid

This post has been answered by Ujjwal Rana on Jul 14 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 11 2015
Added on Jul 14 2015
7 comments
3,843 views