missing sys objects
Guess2Nov 14 2011 — edited Dec 1 2011DB Version: 10.2.0.5
OS: AIX
We created a new database manually and ran the following catalog scripts. I think we are missing some of the data dictionary scripts. There are 705 more SYS,SYSTEM objects in another database. We are missing alot of the LOCK views (DBA_LOCKS, DBA_WAITERS, DBA_BLOCKERS).
Where can I find a list of which scripts should be run when you manually create a database? I googled around and I could not see a complete list. I usually use the DBCA.
The database starts and functions.
@$ORACLE_HOME/rdbms/admin/catalog.sql;
@$ORACLE_HOME/rdbms/admin/catproc.sql;
@$ORACLE_HOME/sqlplus/admin/pupbld.sql;
@$ORACLE_HOME/sqlplus/admin/help/hlpbld.sql helpus.sql;