This blog contains different things for Oracle DBA, APPS DBA and Middleware technologies. All these things should be tested first on test environments before applying in the Prod environments, please follow the standard Change control to apply all the PreProd and Prod changes. Also to make this blog more useful, please give your comments and share your experience. Thanks
Search This Blog
Saturday, 26 February 2011
login with sysdba ORA-01031: insufficient privileges
Introduction:
If you try to connect with sysdba from client machine, it might give you the following error
ORA-01031: insufficient privileges
Cookbook:
You need to create the password for in $ORACLE_HOME/dbs location, and following is an example to create the password file.
$ orapwd file=$ORACLE_HOME/dbs/orapwSID password=type_password entries
once you run this command on the Oracle Server, then again try to login from the client with sysdba, it will work.
Subscribe to:
Post Comments (Atom)
Oracle 19c - patch 19.22 unavailability for Windows platform
Oracle 19c - patch 19.22 unavailability for Windows platform Having upgraded the Oracle 11g 11.2.0.4 database to Oracle 19c 19.3.0.0.0 whi...
-
Oracle 12c Installer error - [INS-10102] Installer initialization failed - no oraInstaller in java.library.path - make sure oraInst.lo...
-
Introduction: This post is related to describe the Report server issue with Oracle 9i AS R2. For this release of Application Server, the X S...
-
Oracle 12c install error - Oracle Net Configuration Assistant keep searching the listener ports The installer will stuck on the Oracle Net ...
No comments:
Post a Comment