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 EBS Cloud manager deployment on OCI
Please follow the Oracle support document. Deploying Oracle E-Business Suite Cloud Manager Version 20.1.1.X on Oracle Cloud Infrastructure ...
-
Introduction: We use EMC BCV feature to clone our production database, and it was all working fine, but suddenly we started getting the erro...
-
Introduction: How to create a second amdin user for Oracle Application APEX. CookBook: 1- unlock the account FLOWS_030000 and login with FLO...
-
Oracle 12c Installer error - [INS-10102] Installer initialization failed - no oraInstaller in java.library.path - make sure oraInst.lo...
No comments:
Post a Comment