Tuesday, March 06, 2007

Oracle EBS 11i with 10G OEM

For our remote administration of databases, I was asked to configure our own internal EBS 11.5.10 environment in Oracle Enterprise Manager 10g.

First the Oracle EBS plugin was installed on the Oracle Management Server.

Second I had to install an agent on the EBS machine, and also apply the plugin patch into the Intelligent Agent home (patch p4678538_11i_LINUX.zip).

After the plugin patch I also applied the OAM integration patch (p3410599_11i_GENERIC.zip).

After patching the Agent home and defining targets in OEM, the Oracle EBS environment was configured in OEM. There was still one problem, when trying to configure the database target I could not connect with the sys account. Every time I tried to connect with sys, the following error occurred :

ORA-01017: invalid username/password; logon denied ORA-27037: unable to obtainfile status Compaq Tru64 UNIX Error: 2: No such file or directory Additionalinformation: 3

I found out that all I needed was a password file.....
Following note 359979.1 from Metalink helped me.

1. set REMOTE_LOGIN_PASSWORDFILE to exclusive (static parameter..)
2. Create password file using orapwd utility
3. restart database

After this you can rerun the database configuration in Grid Control....

1 comment:

Unknown said...

Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.