Saturday, 20 September 2014

RMAN-20004: target database name does not match name in recovery catalog

After production database(PCARD) clone with same DBID but different name(PCARDQC7).

PCARD --> dbname of production database
PCARDQC7 -> dbname of cloned database
dbid --> 1781864831 for both PCARD and PCARDQC7 .

In production database:-
SQL> select dbid,name,CREATED  from v$database;

      DBID NAME      CREATED
---------- --------- ---------
1781864831 PCARD   21-SEP-13


SQL> select dbid,name,CREATED  from v$database;

      DBID NAME      CREATED
---------- --------- ---------
3057056505 PCADQC7 26-SEP-14

In Cloned server connect to PCARDQC7 and unregister it from catalog:
export ORACLE_SID=pcardqc7
rman target / catalog rman/rman@rmancat
rman > unregister database; -- This command available in 10.1 onwards.

In production server connect to PCARD and re-register in catalog:
export ORACLE_SID=pcard
rman target / catalog rman/rman@rmancat
rman > register database;










Wednesday, 3 September 2014

R12-oafm, forms and oacore exiting with status 204, status 3 and status 150 after IP address change:

adstrtal.sh: Exiting with status 3 and adoafmctl.sh: exiting with status 204

Solution to fix this issue:

Problem: IP address is present in OC4J lock files, Once IP address is changed - lock files contain the wrong IP address which causes the problem to fail OC4J.

Steps to be followed to exit with 0:

Open a new session and set the environment with apps user.
Go to $ADMIN_SCRIPTS_HOME ( cd $INST_TOP/ADMIN/SCRIPTS)
adopmnctl.sh stop
Verify the staus once: ps -ef grep grep opmn
Delete the persistence directory with below commands:
rm -r $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/*
rm -r $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/*
rm -r $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*
adopmnctl.sh start
Check if the issue has been resolved: adapcctl.sh status

Number of Visitors