Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> invalid objects on database creation
In Solaris I created a new database, made some "normal" tablespaces - users,
tools etc. Then ran these scripts:
@$ORACLE_HOME/rdbms/admin/catalog.sql
alter user system default tablespace tools;
@$ORACLE_HOME/rdbms/admin/catexp.sql
@$ORACLE_HOME/rdbms/admin/catblock.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
@$ORACLE_HOME/rdbms/admin/catoctk.sql
@$ORACLE_HOME/rdbms/admin/catobtk.sql
@$ORACLE_HOME/rdbms/admin/caths.sql
@$ORACLE_HOME/rdbms/admin/utllockt.sql
@$ORACLE_HOME/rdbms/admin/dbmspool.sql
@$ORACLE_HOME/rdbms/admin/catsnap.sql
@$ORACLE_HOME/rdbms/admin/dbmssnap.sql
I end up with serveral dozen invalid objects which I cannot compile:
SYS.DBMS_AQADM SYS.DBMS_AQADM_SYS SYS.DBMS_AQ_IMPORT_INTERNAL SYS.DBMS_AQ_SYS_EXP_INTERNAL SYS.DBMS_AQ_SYS_IMP_INTERNAL SYS.DBMS_ASYNCRPC_PUSH SYS.DBMS_DEFER_QUERY SYS.DBMS_DEFER_SYS SYS.DBMS_DEFER_SYS_PART1 SYS.DBMS_IAS_INST SYS.DBMS_IAS_INST_UTL SYS.DBMS_IAS_INST_UTL_EXP SYS.DBMS_IAS_TEMPLATE SYS.DBMS_PRVTAQIM SYS.DBMS_PRVTAQIP SYS.DBMS_PRVTAQIS SYS.DBMS_REPCAT_MAS SYS.DBMS_REPCAT_RGT SYS.DBMS_REPCAT_RGT_ALT SYS.DBMS_REPCAT_RGT_CHK SYS.DBMS_REPCAT_RGT_CUST SYS.DBMS_REPCAT_RGT_UTL SYS.DBMS_REPCAT_SNA_UTL SYS.DBMS_REPCAT_UTL SYS.DBMS_SNAPSHOT SYS.LOGMNR_KRVRDREPDICT3
It looks like they all have to do with advanced queueing. Is there one or more additional Oracle-supplied scripts I need to run? I did not have this problem creating a 9i database on Win2000.
Thanks Received on Sun Dec 02 2001 - 20:25:59 CST