Generation issue ora-47999 for creating an EM Database

Copyright, not reprinted!

1. Use of dvca
Dvca-action option-Oh % ORACLE_HOME %-jdbc_str JDBC: oracle: OCI: @ orcl-sys_passwd Oracle-owner_account dvo-owner_passwd oracle_1
Exception
Java. Lang. noclassdeffounderror: Oracle/security/MISC/checksum
Solution: locate ojmisc. Jar under ORACLE_HOME/jlib and put it under ORACLE_HOME/JDK/JRE/lib/Ext.
2.
D:/> dvca-silent-Action disable-service oracleserviceorcl-sys_passwd Oracle-owner_account dvo-owner_passwd oracle_1-logfile C:/a. Log
An error occurred while using dvca in Oracle 11g.
Exception in thread "Main" Java. Lang. Exception: Version mismatch!
At oracle. Security. Misc. c11.c (C11)
At oracle. Security. Misc. checksum. Sha (checksum)
At oracle. Security. datval. dvca. util. stringutil. D (stringutil. Java: 521)
At oracle. Security. datval. dvca. commandarguments. processarguments (command
Arguments. Java: 1072)
At oracle. Security. datval. dvca. dvca. startca (dvca. Java: 71)
At oracle. Security. datval. dvca. dvca. Main (dvca. Java: 274)

I did not solve this problem either. Later, I tried to bypass the restriction under the Database Vault.

3. An error occurred while recreating dbconsole after installing Database Vault.
View three emca logs
Oracle. sysman. assistants. util. sqlengine. sqlfatalerrorexception: ORA-20001: sysman already exists ..

Check the drop log. The following error is returned. The sysman user has not deleted the log. If you enter
Row 3 has an error:
ORA-01031: insufficient Permissions
ORA-06512: In line 113

Use dvam to manage user logon and assign the dv_accmgr role to sys

4. An error occurred while creating the trigger after installing Oracle Database Vault. The bug should be upgraded to 10.2.0.4, but this problem still exists in version 11.1.0.6,
The bug number is 5696532. No fix is found currently.
ORA-47999: Internal Database Vault error: Create trigger
Temporary solution:
Log on to dvo to disable the trigger dvsys. dv_before_ddl_trg. Add the trigger and enable it again.

5. Delete the archive
Emca-deconfig dbcontrol DB-repos drop
You must delete the EM database manually. Otherwise, an error is reported during creation.
Drop user sysman cascade;
Drop user mgmt_view cascade;
Drop role mgmt_user;

6. An error occurred while creating the database.
Emca-config dbcontrol DB-repos create
Java. SQL. sqlexception: ORA-04063: Package body "sysman. mgmt_audit_log" has
Errors ORA-06508: PL/SQL: cocould not find Program unit being called ORA-06512:
At "sysman. em_target", line 1615 ORA-06512: At "sysman. mgmt_target", line 2705
ORA-06512: At line 1

Solution: Pay attention to the logon authorization immediately after the emca has created sysman. You must grant the permissions before creating the package.
1. log on to sysman and compile
SQL> exec emd_maintenance.recompile_invalid_objects;
2. Check the status
SQL> select object_name, object_type from dba_objects where owner = 'sysmance' and status = 'invalid ';
3. If it is still invalid
SQL> Conn/As sysdba
SQL> grant execute on utl_file to sysman;
SQL> conn sysman
SQL> alter package mgmt_audit_log compile;

7. EM does not have DVA web application 404 Problems
Oracle 11gr1 does not automatically deploy the DVA web application after selecting the Database Vault component,
In this case, we need to manually deploy the service in the Solaris. The deployment method can be seen in my previous document.
Http://blog.csdn.net/wonder4/archive/2008/12/17/3540184.aspx
After the EM database is rebuilt, the Web application of DVA is also deleted and needs to be redeployed.