After manual database creation (10.2.0.1), run the following command during EM creation:
Emca-config dbcontrol db-repos create
The following error occurs:
ORA-06550: line 1, column 21:
PLS-00302: component 'valid' must be declared
ORA-06550: line 1, column 7: PL/SQL: Statement ignored
The VALID is found to be the valid of the dbms_registry package. It seems that this package is not installed by default after manual installation. This makes the problem simple.
To create this package, you need to run the following two running files. Be sure to run the first task first; otherwise, an error is reported.
1 )? /Rdbms/admin/prvctl. plb
2 )? /Rdbms/admin/catclust. SQL
SPFILE error causing database startup failure (ORA-01565)
ORA-01172, ORA-01151 error handling
ORA-00600 [2662] troubleshooting
Troubleshooting for ORA-01078 and LRM-00109
Notes on ORA-00471 Processing Methods