ORACLE: solves several problems related to errors in creating an OEM Database

We know that emca can manually maintain the OEM database, but it is not easy to establish it smoothly during actual operations!

The following are personal problems that have been recorded.

I. When emca-repos create is executed for the first time, an error is reported. Check the log and prompt that there are already oem-related users, roles, objects, and so on?

Cause: an error occurs when you create an OEM database! It may be because the previous operations are not completed correctly or the OEM database is already in place.

Solution: Execute emca-repos drop to clear previous information and create again.

 

2. After the above problem is solved, the creation still fails. Check the log and report that the object compilation failed!

Cause: it may be a 10 Gb bug in Oracle. The external (other user objects, system packages, and public objects) objects required by OEM users and roles are not authorized to access these objects!

I have encountered a situation where sysman users cannot access the utl_tcp package.

Solution: grant the required object access permissions to the sysman user based on the error log records under the sysdba permission.

 

Iii. emca-config dbcontrol dB error: job_queue_processes must be greater than or equal to 1

Cause: the initialization parameter is not configured. The value is 0. While OEM requires job_queue_processes to be greater than or equal to 1

Solution: Alter system sets the job_queue_processes parameter. Modify the job_queue_processes parameter in the initialization parameter file.

 

4. Solve the problem above and still report an error. The prompt is run CMD/c d: \ Oracle10g \ app \ oracle \ product \ 10.2.0 \ Server \ bin \ emctl. bat deploy dbconsole D: \ Oracle10g \ app \ oracle \ product \ 10.2.0 \ Server \ oracletest_usercent oracletest: 3938 oracletest usercent Error

Cause: Sorry, after oracle is installed, the directory is changed.

Solution: Modify the path content in the emctl script.

Targetdeploy. pl, emca. bat, emca. pl, and emctl. bat under % ORACLE_HOME % \ bin \

Emca. properties, emomslogging. properties, EMD. properties. emca, and EMD. properties under % ORACLE_HOME % \ sysman \ config \

Note: In particular, emctl. Bat may encounter incorrect variable settings. Perl.exe path and oracle_hostname

 

V. Solve the problem above, you should be able to complete the emca-config dbcontrol db operation and create OEM applications.Program. However, when logging on, the system prompts a Java exception: Error: Java. Lang. Exception exception in sending request null.

Cause: there may be problems with the time zone settings, and there are other unknown causes.

Solution: reset the time zone of the OEM according to the emctl resettz agent prompt. Sometimes you need to modify the EMC. propertities of config \ In the OEM application directoryAgenttzregion= Asia/Shanghai settings.

 

...