Thursday, October 30, 2008

IAS console does not show new version after upgrade from

This is a problem on all platforms. Oracle says that this is expected behavior. The reason for this being, that OID, SSO and OCA have been upgraded to but the core 10g application server components still remain at This is reported by bug 6125035. The work around for this is to manually change the version number in the $ORACLE_HOME/config/ file to and bounce iasconsole.

How to find the Oracle XML Publisher (BI Publisher) version in EBS 11i & 12

You can find out the XML Publisher version either from the output of the report or from the MetaInfo.class.

strings $OA_JAVA/oracle/apps/xdo/common/MetaInfo.class|grep -i 'XML Publisher'

Steps to De-Install the EM 10g Agent on Windows and Unix

Before uninstalling the Agent, remove the targets from repository associated with the agent:

1. From Grid Control Console remove all targets for the host.

2. Check remove was successfully:

Grid Control Console -> Setup -> Management Services and Repository tab ->In general section click on Deleted Targets ->

The time delete completed must have a date, if not wait 10 minutes.If it still does not have a date, place a check next to the target and click on force delete.

3. After verifying that the targets were deleted, stop the Management Agent.

Go back to the Grid Control UI and remove the host.

Remove the Agent. Check to confirm it was removed successfully.

Click on force delete if necessary.

De-Install the Agent Using OUI

These steps can be performed for an agent that has been installed using any method (agent download script, agent push or manual install using OUI)

For agent on Linux (or any unix flavor like HP,solaris, AIX etc)

1. Stop the agent by running /emctl stop agent

2. Run: /oui/bin/runInstaller

3. The following screen should come up:

4. Select “Deinstall Products” and then select the product you need to de-install.

Click on “Remove” and wait till it completes.

For agent on Windows:

1. Stop the agent first by running: /emctl stop agent

2. Then run setup.exe from /oui/bin

3. The following screen should come up

4. Select “Deinstall Products” and then select the product you need to de-install.

De-Install the Agent Manually

For the Windows Platform:

1. Start the registry editor .From the local machine command prompt , type "regedit"

2. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Oracle remove the respective agent entry
For example :-

Select and remove HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\Key_agent10g

2.1 Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services. Delete the agent service

2.2 Go to HKEY_LOCAL_MACHINE\SYSTEM\ControlSet2\Services. Delete the agent service.
Close the registry editor.

Note: On RAC setup , make sure that the Agent service is deleted on both the nodes . There is no need to stop this "OracleRemExecService" service on Rac as this service get created as part of CRS and database install

3.Clean Up Environment Settings

On Windows NT: Choose Start > Settings > Control Panel > System > Environment.

On Windows 2000 and Windows XP: Choose Start > Settings > Control Panel > System > Advanced > Environment Variables.

In the System Variables section, click the variable PATH in order to modify the value.

Delete the agent home - Click Apply and then click OK.

If there is a CLASSPATH variable under "System Variables", delete the path expressions in the variable that contains the ORACLE_HOME to be removed or some location underneath.Close the Control Panel window.

4. Re-boot the Box

After rebooting you can start the fresh Agent installation

Note- On RAC re-boot both the Nodes

Post-Install Verification

1. Verify that the directory where the agent was previously installed has been removed along with all files.

2. Remove any references to the previously installed agent from the environment settings such as PATH.

3. Confirm that the agent has been removed from the repository:
Log into the repository database via sqlplus as SYSMAN and run the following:
exec mgmt_admin.cleanup_agent(':1830');