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 ----------

 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...