This blog contains different things for Oracle DBA and APPS DBA. All these things should be tested first on test environments. Also to make this blog more useful, please give your comments and share your experience. Thanks
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.
Tuesday 1 February 2011
RMAN-20002: target database already registered in recovery catalog
Introduction:
We moved one the Oracle 10g database from one server to other server, and database was opened with "resetlogs" option. And when we tried to do the register the database it gave the following error
"RMAN-20002: target database already registered in recovery catalog"
Cookbook:
To resolve the issue we issued the following command on rman prompt and then every thing was fine. Following are the errors and command which we ran
----------
RMAN> register database;
starting full resync of recovery catalog
full resync complete
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of register command on default channel at 01/29/2011 22:00:48
RMAN-20002: target database already registered in recovery catalog
RMAN> reset database;
database incarnation already registered
----------
Subscribe to:
Posts (Atom)
Oracle Weblogic 12.2.1.3.0 60820: Select a domain which is a compatible with this environment. stopComponent.sh and start Component.sh give...
-
Oracle 12c Installer error - [INS-10102] Installer initialization failed - no oraInstaller in java.library.path - make sure oraInst.lo...
-
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: In this article we will see, the impact of "Parallel" clause of rebuilding a partition index. We would also enable t...