Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> invalid objects on database creation

invalid objects on database creation

From: Van Messner <vmessner_at_bestweb.net>
Date: Sun, 2 Dec 2001 21:25:59 -0500
Message-ID: <u0loue3f5esr51@corp.supernews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US