5 Replies Latest reply on Aug 19, 2004 12:38 PM by 427992

    Error while loading the Repository database using OAIIMPORT

    423709
      We are building a test oai environment I am trying to load the repository with the export dump from our production oai using the OAIIMPORT script.

      I get the following error message:

      Deleting all tables, indexes, and logs ...
      Executing: sqlplus system/manager@IASDB.ACCOUNTS.INTERN @sql/deinstall_schema

      SQL*Plus: Release 9.0.1.4.0 - Production on Wed Aug 18 15:04:50 2004

      (c) Copyright 2001 Oracle Corporation. All rights reserved.

      Connected to:
      Oracle9i Enterprise Edition Release 9.0.1.4.0 - Production
      With the Partitioning option
      JServer Release 9.0.1.4.0 - Production

      DROP USER oaihub902 CASCADE
      *
      ERROR at line 1:
      ORA-01940: cannot drop a user that is currently connected

      Disconnected from Oracle9i Enterprise Edition Release 9.0.1.4.0 - Production
      With the Partitioning option
      JServer Release 9.0.1.4.0 - Production
      Recreating user ...
      Executing: sqlplus system/manager@IASDB.ACCOUNTS.INTERN @sql/hub1 oaihub902

      SQL*Plus: Release 9.0.1.4.0 - Production on Wed Aug 18 15:04:50 2004

      (c) Copyright 2001 Oracle Corporation. All rights reserved.

      Connected to:
      Oracle9i Enterprise Edition Release 9.0.1.4.0 - Production
      With the Partitioning option
      JServer Release 9.0.1.4.0 - Production

      DOC>** hub1.sql
      DOC>** Modified 11/14/2001 Arvind : Commented Out excessive priviledge from oaihub user
      DOC>** Modified 01/03/2002 Arvind : Added Parameter for oaihub user password
      DOC>** CREATE user oaihub902 and assign table space.
      DOC>*/
      old 1: CREATE USER oaihub902 IDENTIFIED BY &1 DEFAULT TABLESPACE USERS PROFILE DEFAULT ACCOUNT UNLOCK
      new 1: CREATE USER oaihub902 IDENTIFIED BY oaihub902 DEFAULT TABLESPACE USERS PROFILE DEFAULT ACCOUNT UNLOCK
      CREATE USER oaihub902 IDENTIFIED BY oaihub902 DEFAULT TABLESPACE USERS PROFILE DEFAULT ACCOUNT UNLOCK
      *
      ERROR at line 1:
      ORA-01920: user name 'OAIHUB902' conflicts with another user or role name
      User altered.
      User altered.
      Grant succeeded.
      Grant succeeded.
      DOC>** Grant privileges TO user oaihub902.
      DOC>*/
      Grant succeeded.
      Grant succeeded.
      Grant succeeded.
      Grant succeeded.
      Grant succeeded.
      Grant succeeded.
      Grant succeeded.
      Grant succeeded.
      Grant succeeded.
      Grant succeeded.
      Grant succeeded.
      Disconnected from Oracle9i Enterprise Edition Release 9.0.1.4.0 - Production
      With the Partitioning option
      JServer Release 9.0.1.4.0 - Production
      Importing metadata ...
      Executing: imp system/manager@IASDB.ACCOUNTS.INTERN fromuser=oai touser=oaihub902 commit=y file=uranus_aug04_exp.dmp
      Executing: sqlplus oaihub902/oaihub902@IASDB.ACCOUNTS.INTERN @sql/post_import
      SQL*Plus: Release 9.0.1.4.0 - Production on Wed Aug 18 15:04:52 2004
      (c) Copyright 2001 Oracle Corporation. All rights reserved.
      Connected to:
      Oracle9i Enterprise Edition Release 9.0.1.4.0 - Production
      With the Partitioning option
      JServer Release 9.0.1.4.0 - Production

      DOC> ** Create Tables
      DOC> */
      DOC> ** Workflow Tables and Sequences
      DOC> */
      CREATE TABLE lookupid (id NUMBER(10) NOT NULL
      *
      ERROR at line 1:
      ORA-00955: name is already used by an existing object
      CREATE TABLE lookup (tableid NUMBER(10) NOT NULL
      *
      ERROR at line 1:
      ORA-00955: name is already used by an existing object

      DOC> ** Component Info Tables and Sequences
      DOC> */
      CREATE TABLE ComponentInfo (name VARCHAR2(256) NOT NULL,
      *
      ERROR at line 1:
      ORA-00955: name is already used by an existing object

      CREATE TABLE ComponentInfoValue (seqnum NUMBER
      *
      ERROR at line 1:
      ORA-00955: name is already used by an existing object
      CREATE TABLE AppIDTable (appid     NUMBER
      *
      ERROR at line 1:
      ORA-00955: name is already used by an existing object

      CREATE TABLE RepoIDTable (repoid NUMBER
      *
      ERROR at line 1:
      ORA-00955: name is already used by an existing object

      CREATE TABLE MessageInfoIDTable (messageinfoid NUMBER
      *
      ERROR at line 1:
      ORA-00955: name is already used by an existing object

      DOC> ** Correlation
      DOC> */
      CREATE TABLE msg_correlation ( messageinfoid     NUMBER,
      *
      ERROR at line 1:
      ORA-00955: name is already used by an existing object

      DOC> ** Tracking and Status Tables
      DOC> */
      CREATE TABLE MessageStatusTable ( SenderApp     NUMBER,
      *
      ERROR at line 1:
      ORA-00955: name is already used by an existing object

      DOC> ** Error Table and resubmission AQ
      DOC> */
      CREATE TABLE oai_agent_error ( errorID     NUMBER
      *
      ERROR at line 1:
      ORA-00955: name is already used by an existing object

      DOC> ** Create Views
      DOC> */
      CREATE VIEW lcoview as
      *
      ERROR at line 1:
      ORA-00955: name is already used by an existing object


      CREATE VIEW eventview as
      *
      ERROR at line 1:
      ORA-00955: name is already used by an existing object


      CREATE VIEW eventlcoview as
      *
      ERROR at line 1:
      ORA-00955: name is already used by an existing object


      CREATE VIEW emdview as
      *
      ERROR at line 1:
      ORA-00955: name is already used by an existing object


      CREATE VIEW dsoview as
      *
      ERROR at line 1:
      ORA-00955: name is already used by an existing object


      DOC> ** Create Queues
      DOC> */
      DOC> ** Hub Queue
      DOC> */

      Procedure created.


      PL/SQL procedure successfully completed.

      DOC> ** Error Queue
      DOC> */
      CREATE type oai_agent_error_type as object ( errorID     NUMBER,
      *
      ERROR at line 1:
      ORA-00955: name is already used by an existing object


      DECLARE
      *
      ERROR at line 1:
      ORA-24001: cannot create QUEUE_TABLE, OAIHUB902.OAI_AGENT_ERROR_OBJQTAB already
      exists
      ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2284
      ORA-06512: at "SYS.DBMS_AQADM", line 56
      ORA-06512: at line 3



      PL/SQL procedure successfully completed.

      DOC> ** Create Sequences
      DOC> */
      SELECT * FROM SEQUENCE_VALUES;
      *
      ERROR at line 3:
      ORA-06550: line 3, column 18:
      PL/SQL: ORA-00942: table or view does not exist
      ORA-06550: line 3, column 4:
      PL/SQL: SQL Statement ignored
      ORA-06550: line 6, column 44:
      PLS-00364: loop index variable 'SEQ_REC' use is invalid
      ORA-06550: line 6, column 4:
      PL/SQL: Statement ignored


      DROP TABLE SEQUENCE_VALUES
      *
      ERROR at line 1:
      ORA-00942: table or view does not exist
      Disconnected from Oracle9i Enterprise Edition Release 9.0.1.4.0 - Production
      With the Partitioning option
      JServer Release 9.0.1.4.0 - Production


      Any idea why these errors and how to fix this ?

      Thanks in advance
      Devika.