Remove Agent/targets from Oracle Enterprise Manager

Connect to the OEM Grid Repository and perform the following:

1. List all the registered targets
SQL> select target_name from mgmt_targets where target_type=’oracle_emd’;

2. Remove target from the list
SQL> exec mgmt_admin.cleanup_agent(‘target:3872′);

Coexist 10gR2 and 11gR2 RAC database on the same cluster

See the article by Murali Vallath

coexist 10gR2 and 11gR2 RAC db on the same cluster.. stumbling blocks

On AIX, VIP fails to come up, with error "Invalid Parameters, Or Failed To Bring Up VIP".

Modify the line containing ENTSTAT in $ORA_CRS_HOME/bin/racgvip script as follows:

$ENTSTAT -d $_IF | $GREP -iEq
'.*lan.*state.*:.*operational.*|.*link.*status.*:.*up.*|
.*port.*operational.*state.*:.*up.*|.*driver.*flags.*:.*up.*'

Oracle RAC 11gR2: root.sh fails

Problem:
root.sh fails with the following error:
CRS-4124: Oracle High Availability Services startup failed.
CRS-4000: Command Start failed, or completed with errors.
ohasd failed to start: A specified file does not support the ioctl system call.
ohasd failed to start at /oracle/product/11.2.0/gridhome/crs/install/rootcrs.pl line 451.


Solution:

• Clean the following directories:

/etc/oracle,
/var/tmp/.oracle
/tmp/.oracle

• Rerun root.sh

Debugging Oracle Universal Installer (OUI)

The following command starts Oracle Universal Installer (OUI) with tracing turned on:

$ ./runInstaller -logLevel trace -debug -J-DTRACING.ENABLED=true -J-DTRACING.LEVEL=2