Friday, October 30, 2009

Clone E-business suite and grid control problem

When discovering oracle applications on grid control 10.2.05, you encounter error "Wrong System Name" or "Waited for five minutes" and you see the context file mentioned on the log is not correct, then
1. Source your environment for EBusiness Suite instance.
2. Run sqlplus as apps user
SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;
3. Run AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers, to repopulate the required system tables.
4. Bounce Agent.
5. Retry to discover EBusiness Suite instance.

Wednesday, October 28, 2009

Grid Agent URL connection interrupted

When trying to open agent URL, something like https://host:3872/emd/main, you receive connection interrupted message on your browser. Go to your agent home/bin directory.
> ./emctl stop agent
> ./emctl secure agent
> ./emctl start agent

EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet..

When you execute "emctl upload" command, you receive "EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet..."
Check your repository URL, you probably use secure connection to OMS, change the URL to https://oms_server:1159/em/upload. Restart your agent.

Patching Setup - My Oracle Support authorization failed

When you receive this message when setup patching on Grid Control 10.2.0.5: "My Oracle Support authorization failed. - Although metalink credentials are correct and successfully validated, an error occurred while downloading a sample patch from the patch url specified. Please check log files for details." then go see the log file on $ORACLE_HOME/sysman/log/emoms.log.
Just see some lines at the end of the file, use tail -n 100 emoms.log.
If you see ORA-14400, then using sqlplus and as sysman, run this on sqlplus:
exec emd_maintenance.analyze_emd_schema(‘SYSMAN’);