9 Replies Latest reply: May 27, 2008 3:22 PM by 641052 RSS

    10.2.0 emca/emctl issues

    641052
      I'm having some trouble getting emctl/emca to work again. I can access the database instance via EMC from a Windows client (actually a vmware client on the Linux box). However, I cannot bring up EMC on the Linux box directly because I get this error when I try './emctl start dbconsole':
      OC4J Configuration issue. /lhome/app/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_localhost.localdomain_orcl not found.

      I've tried the emca utility to drop and create the repository but I get errors. The error log shows a line that says:

      ERROR at line 1;
      ORA-06550....
      PLS-00201: identifier 'SYSMAN.SETEMUSERCONTEXT' must be declared
      ORA-06550....
      PL/SQL: Statement ignored

      Also, when I try to just create the repository and it gets to the password entry for DBSNMP user it freezes and never continues. I've checked and this user status is OPEN and not locked.

      All this began to happen after I created a backup plan and ran a test backup. Just as the backup started Oracle became unusable and I couldn't communicate with it via emctl (on the Linux box or through emc on the windows client). Also, I had problems with the listener because of a slight change was made to the hosts file. I believe I have the hosts/listener/tnsnames issue corrected now because I am able to connect to the database from the Windows client and also locally using sqlplus command line on the Linux box where Oracle lives.

      Thanks
      Tommy
        • 1. Re: 10.2.0 emca/emctl issues
          427828
          You can follow this documentation
          http://idevelopment.info/data/Oracle/DBA_tips/Enterprise_Manager/OEM_4.shtml

          May be you changed your hostname and that's why u're facing with this problem
          can you look to you Enterprise Manager's log file?
          • 2. Re: 10.2.0 emca/emctl issues
            641052
            I used that document to try and create the repository.

            As my initial post explained, when i run this command:

            ./emca -config dbcontrol db -repos create

            I enter the SID, listener port number, password for SYS. Then, when I enter the password for DBSNMP nothing happens....it never comes back and I have to Ctl+C to kill the script.

            Any ideas?

            Oh, I am running this as the 'oracle' user.
            • 3. Re: 10.2.0 emca/emctl issues
              427828
              Just wait some minutes ...
              • 4. Re: 10.2.0 emca/emctl issues
                641052
                i've let it run for over an hour though
                • 5. Re: 10.2.0 emca/emctl issues
                  427828
                  Can you post here your EM log files please?
                  $ORACLE_HOME/<host_sid>/sysman/log

                  Did you changed your hostname after Oracle installation and EM configuration?
                  • 6. Re: 10.2.0 emca/emctl issues
                    641052
                    the host name has not changed

                    can you be more specific about which files you want to see?
                    • 7. Re: 10.2.0 emca/emctl issues
                      641052
                      Here's some more info that may help in helping me. :)

                      If I run:
                      ./emca deconfig dbcontrol db -repos drop
                      I get a warning that EM is not configured for this database

                      So, basically, the repository doesn't exist AND i can't create a new one.

                      Just to make sure I'm on track so far, I am using the 'oracle' username, right?
                      • 8. Re: 10.2.0 emca/emctl issues
                        641052
                        here's the log file contents for when I tried to run the emca commands earlier:


                        emca_repos_drop.....
                        ======================================
                        [23-05-2008 12:07:02] Enter SYS user's password :
                        [23-05-2008 12:07:02]
                        [23-05-2008 12:07:02] Enter repository user password :
                        [23-05-2008 12:07:02]
                        [23-05-2008 12:07:02] Getting temporary tablespace from database...
                        [23-05-2008 12:07:03] Found temporary tablespace: TEMP
                        [23-05-2008 12:07:03] Environment :
                        [23-05-2008 12:07:03] ORACLE HOME = /lhome/app/oracle/product/10.2.0/db_1
                        [23-05-2008 12:07:03] REPOSITORY HOME = /lhome/app/oracle/product/10.2.0/db_1
                        [23-05-2008 12:07:03] SQLPLUS = /lhome/app/oracle/product/10.2.0/db_1/bin/sqlplus
                        [23-05-2008 12:07:03] SQL SCRIPT ROOT = /lhome/app/oracle/product/10.2.0/db_1/sysman/admin/emdrep/sql
                        [23-05-2008 12:07:03] EXPORT = /lhome/app/oracle/product/10.2.0/db_1/bin/exp
                        [23-05-2008 12:07:03] IMPORT = /lhome/app/oracle/product/10.2.0/db_1/bin/imp
                        [23-05-2008 12:07:03] LOADJAVA = /lhome/app/oracle/product/10.2.0/db_1/bin/loadjava
                        [23-05-2008 12:07:03] JAR FILE ROOT = /lhome/app/oracle/product/10.2.0/db_1/sysman/admin/emdrep/lib
                        [23-05-2008 12:07:03] JOB TYPES ROOT = /lhome/app/oracle/product/10.2.0/db_1/sysman/admin/emdrep/bin
                        [23-05-2008 12:07:03] Arguments :
                        [23-05-2008 12:07:03] Connect String = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=cmserv1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))
                        [23-05-2008 12:07:03] Action = drop
                        [23-05-2008 12:07:03] Repos User = SYSMAN
                        [23-05-2008 12:07:03] Default tablespace = MGMT_TABLESPACE
                        [23-05-2008 12:07:03] Default Data file = mgmt.dbf
                        [23-05-2008 12:07:03] Dflt Dfile Init size = 20m
                        [23-05-2008 12:07:03] Dflt Dfile Ext size = 20m
                        [23-05-2008 12:07:03] ECM tablespace = MGMT_ECM_DEPOT_TS
                        [23-05-2008 12:07:03] ECM Data file = mgmt_ecm_depot1.dbf
                        [23-05-2008 12:07:03] ECM Dfile Init size = 100m
                        [23-05-2008 12:07:03] ECM Dfile Ext size = 100m
                        [23-05-2008 12:07:03] TEMP tablespace = TEMP
                        [23-05-2008 12:07:03] Create options = 3
                        [23-05-2008 12:07:03] Verbose output = 1
                        [23-05-2008 12:07:03] Output File = /lhome/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_repos_drop_2008-05-23_12-07-02-PM.log
                        [23-05-2008 12:07:03] Repos creation mode = CENTRAL
                        [23-05-2008 12:07:03] MetaLink user name = NOTAVAILABLE_
                        [23-05-2008 12:07:03] MetaLink URL = http://updates.oracle.com
                        [23-05-2008 12:07:03] Export Directory = /lhome/app/oracle/product/10.2.0/db_1/sysman/log
                        [23-05-2008 12:07:03] Import Directory = /lhome/app/oracle/product/10.2.0/db_1/sysman/log
                        [23-05-2008 12:07:03] Checking SYS Credentials ...
                        [23-05-2008 12:07:03] File - /tmp/ur6ml7y6io/dWx9J0vZ8d.sql.

                        SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 23 12:07:03 2008

                        Copyright (c) 1982, 2005, Oracle. All rights reserved.

                        Enter user-name:
                        Connected to:
                        Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
                        With the Partitioning, OLAP and Data Mining options

                        SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
                        With the Partitioning, OLAP and Data Mining options
                        [23-05-2008 12:07:03] Return code = 0.
                        [23-05-2008 12:07:03] OK.
                        [23-05-2008 12:07:03] Dropping the repository..
                        [23-05-2008 12:07:03] Quiescing DB ...
                        [23-05-2008 12:07:03] File - /tmp/CQfZpVTo2G/gZRgEj3N4Q.sql.
                        [23-05-2008 12:07:03] Return code = 0.
                        [23-05-2008 12:07:03] Done.
                        [23-05-2008 12:07:03] Checking for Repos User ...
                        [23-05-2008 12:07:03] File - /tmp/VmybMdVSFT/eMnIzPfY3b.sql.
                        [23-05-2008 12:07:03] Return code = 0.
                        [23-05-2008 12:07:03] Exists.
                        [23-05-2008 12:07:03] Repos User exists..
                        [23-05-2008 12:07:03] Clearing EM Contexts ...
                        [23-05-2008 12:07:03] Clearing contexts. File - /tmp/00TGkBffm7/e9yDjuujhJ.sql.

                        SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 23 12:07:03 2008

                        Copyright (c) 1982, 2005, Oracle. All rights reserved.

                        Enter user-name:
                        Connected to:
                        Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
                        With the Partitioning, OLAP and Data Mining options

                        SQL> SQL> SQL> SQL> SQL> BEGIN SYSMAN.setEMUserContext('', 5); END;

                        *
                        ERROR at line 1:
                        ORA-06550: line 1, column 7:
                        PLS-00201: identifier 'SYSMAN.SETEMUSERCONTEXT' must be declared
                        ORA-06550: line 1, column 7:
                        PL/SQL: Statement ignored


                        Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
                        With the Partitioning, OLAP and Data Mining options
                        [23-05-2008 12:07:03] Clearing contexts. Return code = 150.
                        [23-05-2008 12:07:03] Failed.
                        [23-05-2008 12:07:03] Dropping EM users ...
                        [23-05-2008 12:07:03] Drop EM Users. File - /tmp/RX5oot2ePz/H1AnIhJKVp.sql.

                        SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 23 12:07:03 2008

                        Copyright (c) 1982, 2005, Oracle. All rights reserved.

                        Enter user-name:
                        Connected to:
                        Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
                        With the Partitioning, OLAP and Data Mining options

                        SQL> SQL> SQL> SQL> SQL> SQL> SQL> Rem
                        SQL> Rem $Header: admin_drop_users.sql 26-mar-2003.12:48:27 rpinnama Exp $
                        SQL> Rem
                        SQL> Rem admin_drop_users.sql
                        SQL> Rem
                        SQL> Rem Copyright (c) 2002, 2003, Oracle Corporation.     All rights reserved.
                        SQL> Rem
                        SQL> Rem NAME
                        SQL> Rem     admin_drop_users.sql - <one-line expansion of the name>
                        SQL> Rem
                        SQL> Rem DESCRIPTION
                        SQL> Rem     <short description of component this file declares/defines>
                        SQL> Rem
                        SQL> Rem NOTES
                        SQL> Rem     <other useful comments, qualifications, etc.>
                        SQL> Rem
                        SQL> Rem MODIFIED (MM/DD/YY)
                        SQL> Rem rpinnama     03/26/03 - Remove references to DropRep
                        SQL> Rem rpinnama     03/25/03 - Parameterize repos user
                        SQL> Rem rpinnama     06/03/02 - rpinnama_reorg_rep_scripts_3
                        SQL> Rem rpinnama     05/20/02 - Created
                        SQL> Rem
                        SQL>
                        SQL> Rem
                        SQL> Rem This SQL script requires the following arguments
                        SQL> Rem 1. Name of the repository user
                        SQL> Rem
                        SQL> DEFINE EM_REPOS_USER ="&1"
                        SQL>
                        SQL>
                        SQL>
                        SQL> Rem Generate Drop users script
                        SQL> Rem Error 1918 is received if the repository user does not exist - we simply exit and continue
                        SQL> Rem Error 1940 is received if there is an active session - we continue the loop
                        SQL> Rem Error 30 is received if the session we are killing no longer exists - we continue the loop
                        SQL> Rem NOTE:     The 1940 will be returned until the other end of the session re-accesses it.
                        SQL> Rem     This may take up to several minutes, so we ignore these errors completely.
                        SQL> Rem     If we trace in this loop, we will exit with a buffer overflow,
                        SQL> Rem     so tracing is not done in this loop
                        SQL>
                        SQL>
                        SQL> declare
                        2 l_username varchar2(30);
                        3 l_sid number;
                        4 l_serial number;
                        5 err number;
                        6 c number;
                        7 begin
                        8
                        9      -- First, drop all users, except SYSMAN who have MGMT_USER role and
                        10      -- are created by EM. All users created by EM will have a record
                        11      -- in MGMT_CREATED_USERS table
                        12      --
                        13      c := 0;
                        14      begin
                        15      loop
                        16      BEGIN
                        17      l_username := '';
                        18      select grantee into l_username
                        19           from sys.dba_role_privs
                        20           where granted_role = 'MGMT_USER'
                        21           AND grantee IN (SELECT user_name
                        22                     FROM &EM_REPOS_USER..MGMT_CREATED_USERS
                        23                     WHERE SYSTEM_USER=0)
                        24           AND ROWNUM=1;
                        25
                        26      l_username := upper(l_username);
                        27
                        28      LOOP
                        29
                        30           BEGIN
                        31           FOR crec in (SELECT sid, serial#
                        32                     FROM v$session
                        33                     WHERE username=l_username
                        34                     AND status NOT IN('KILLED'))
                        35           LOOP
                        36           BEGIN
                        37
                        38                DBMS_OUTPUT.PUT_LINE('Killing session for user ' ||
                        39                     l_username || ' Session : ' ||
                        40                     crec.sid || ',' || crec.serial# );
                        41
                        42                EXECUTE IMMEDIATE 'ALTER SYSTEM KILL SESSION ''' ||
                        43                          crec.sid || ',' || crec.serial# || '''';
                        44                EXCEPTION
                        45                WHEN OTHERS THEN
                        46                err := SQLCODE;
                        47                IF err != -30 THEN
                        48                     EXIT;
                        49                END IF;
                        50           END;
                        51           COMMIT;
                        52           END LOOP; -- END OF KILLING SESSION LOOP
                        53
                        54           EXCEPTION
                        55           WHEN OTHERS THEN
                        56           err := SQLCODE;
                        57           IF err != -30 THEN
                        58                EXIT;
                        59           END IF;
                        60           END;
                        61
                        62           IF SQL%NOTFOUND THEN
                        63           EXIT;
                        64           END IF;
                        65
                        66      COMMIT;
                        67
                        68      END LOOP;
                        69
                        70      DBMS_OUTPUT.PUT_LINE('Dropping user ' || l_username);
                        71
                        72      EXECUTE IMMEDIATE 'drop user ' || l_username || ' cascade';
                        73
                        74      EXCEPTION
                        75           WHEN NO_DATA_FOUND THEN
                        76           EXIT;
                        77           WHEN OTHERS THEN
                        78           err := SQLCODE;
                        79           IF err = -1918 THEN
                        80           EXIT;
                        81           ELSE
                        82           IF err = -1940 THEN
                        83           NULL;
                        84           ELSE
                        85           DBMS_OUTPUT.PUT_LINE('not 1940 Error ' || err);
                        86           c := c+1;
                        87           IF c > 50 THEN
                        88                RAISE;
                        89           END IF;
                        90           END IF;
                        91           END IF;
                        92      END;
                        93      end loop;
                        94      end;
                        95 end;
                        96 /
                        old 22:                    FROM &EM_REPOS_USER..MGMT_CREATED_USERS
                        new 22:                    FROM SYSMAN.MGMT_CREATED_USERS
                                       FROM SYSMAN.MGMT_CREATED_USERS
                        *
                        ERROR at line 22:
                        ORA-06550: line 22, column 44:
                        PL/SQL: ORA-00942: table or view does not exist
                        ORA-06550: line 18, column 11:
                        PL/SQL: SQL Statement ignored


                        SQL>
                        SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
                        With the Partitioning, OLAP and Data Mining options
                        [23-05-2008 12:07:03] Drop EM Users. Return code = 0.
                        [23-05-2008 12:07:03] Done.
                        [23-05-2008 12:07:03] Dropping Repos User ...
                        [23-05-2008 12:07:03] Drop Repos User. File - /tmp/5NaJcsseMl/07Ns7JtgG5.sql.

                        SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 23 12:07:03 2008

                        Copyright (c) 1982, 2005, Oracle. All rights reserved.

                        Enter user-name:
                        Connected to:
                        Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
                        With the Partitioning, OLAP and Data Mining options

                        SQL> SQL> SQL> SQL> SQL> SQL> SQL> Rem
                        SQL> Rem $Header: admin_drop_repos_user.sql 26-mar-2003.12:49:29 rpinnama Exp $
                        SQL> Rem
                        SQL> Rem admin_drop_repos_user.sql
                        SQL> Rem
                        SQL> Rem Copyright (c) 2002, 2003, Oracle Corporation.     All rights reserved.
                        SQL> Rem
                        SQL> Rem NAME
                        SQL> Rem     admin_drop_repos_user.sql - <one-line expansion of the name>
                        SQL> Rem
                        SQL> Rem DESCRIPTION
                        SQL> Rem     <short description of component this file declares/defines>
                        SQL> Rem
                        SQL> Rem NOTES
                        SQL> Rem     <other useful comments, qualifications, etc.>
                        SQL> Rem
                        SQL> Rem MODIFIED (MM/DD/YY)
                        SQL> Rem rpinnama     03/26/03 - Remove references to DropRep
                        SQL> Rem rpinnama     03/25/03 - Parameterize repository user
                        SQL> Rem rpinnama     06/03/02 - rpinnama_reorg_rep_scripts_3
                        SQL> Rem rpinnama     05/20/02 - Created
                        SQL> Rem
                        SQL>
                        SQL> Rem
                        SQL> Rem This SQL script requires the following arguments
                        SQL> Rem 1. Name of the repository user
                        SQL> Rem
                        SQL> DEFINE EM_REPOS_USER ="&1"
                        SQL>
                        SQL>
                        SQL> declare
                        2 l_username varchar2(30);
                        3 l_sid number;
                        4 l_serial number;
                        5 err number;
                        6 c number;
                        7 begin
                        8      -- Now, drop the SYSMAN user
                        9      c := 0;
                        10      l_username := upper('&EM_REPOS_USER');
                        11      begin
                        12      loop
                        13      BEGIN
                        14      LOOP
                        15           BEGIN
                        16           FOR crec in (SELECT sid, serial#
                        17                     FROM v$session
                        18                WHERE upper(username)=l_username
                        19                     AND status NOT IN('KILLED'))
                        20           LOOP
                        21           BEGIN
                        22                EXECUTE IMMEDIATE 'ALTER SYSTEM KILL SESSION ''' ||
                        23                          crec.sid || ',' || crec.serial# || '''';
                        24           EXCEPTION
                        25                WHEN OTHERS THEN
                        26                err := SQLCODE;
                        27                IF err != -30 THEN
                        28                     EXIT;
                        29                END IF;
                        30           END;
                        31           commit;
                        32           END LOOP;
                        33           EXCEPTION
                        34           WHEN OTHERS THEN
                        35           err := SQLCODE;
                        36           IF err != -30 THEN
                        37                EXIT;
                        38           END IF;
                        39           END;
                        40           IF SQL%NOTFOUND THEN
                        41           EXIT;
                        42           END IF;
                        43           commit;
                        44      END LOOP;
                        45      execute immediate 'drop user ' || l_username || ' cascade';
                        46      exit;
                        47      EXCEPTION
                        48           WHEN NO_DATA_FOUND THEN
                        49           exit;
                        50           WHEN OTHERS THEN
                        51           err := SQLCODE;
                        52           IF err = -1918 THEN
                        53           EXIT;
                        54           ELSE
                        55           IF err = -1940 THEN
                        56                NULL;
                        57           ELSE
                        58                DBMS_OUTPUT.PUT_LINE('not 1940 err' || err);
                        59                c := c+1;
                        60                IF c > 50 THEN
                        61                RAISE;
                        62                END IF;
                        63           END IF;
                        64           END IF;
                        65      END;
                        66      end loop;
                        67      end;
                        68      commit;
                        69
                        70 end;
                        71 /
                        old 10: l_username := upper('&EM_REPOS_USER');
                        new 10: l_username := upper('SYSMAN');
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        not 1940 err-942
                        declare
                        *
                        ERROR at line 1:
                        ORA-00942: table or view does not exist
                        ORA-06512: at line 61


                        SQL>
                        SQL>
                        SQL>
                        SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
                        With the Partitioning, OLAP and Data Mining options
                        [23-05-2008 12:07:04] Drop Repos User. Return code = 0.
                        [23-05-2008 12:07:04] Done.
                        [23-05-2008 12:07:04] Dropping Roles/Synonymns/Tablespaces ...
                        [23-05-2008 12:07:04] File - /tmp/v9HlMc13n2/PnDWh6FFPQ.sql.

                        SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 23 12:07:04 2008

                        Copyright (c) 1982, 2005, Oracle. All rights reserved.

                        Enter user-name:
                        Connected to:
                        Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
                        With the Partitioning, OLAP and Data Mining options

                        SQL> SQL> SQL> SQL> SQL> SQL> Rem
                        SQL> Rem $Header: admin_drop_synonyms.sql 08-oct-2002.11:18:44 rpinnama Exp $
                        SQL> Rem
                        SQL> Rem admin_drop_synonyms.sql
                        SQL> Rem
                        SQL> Rem Copyright (c) 2002, Oracle Corporation. All rights reserved.
                        SQL> Rem
                        SQL> Rem NAME
                        SQL> Rem     admin_drop_synonyms.sql - <one-line expansion of the name>
                        SQL> Rem
                        SQL> Rem DESCRIPTION
                        SQL> Rem     <short description of component this file declares/defines>
                        SQL> Rem
                        SQL> Rem NOTES
                        SQL> Rem     <other useful comments, qualifications, etc.>
                        SQL> Rem
                        SQL> Rem MODIFIED (MM/DD/YY)
                        SQL> Rem rpinnama     10/08/02 - Remove emd_mntr synonym also
                        SQL> Rem rpinnama     10/04/02 - Drop the newly created public synonyms
                        SQL> Rem skini     06/12/02 - Drop blackout synonym
                        SQL> Rem rpinnama     06/03/02 - rpinnama_reorg_rep_scripts_3
                        SQL> Rem rpinnama     05/20/02 - Created
                        SQL> Rem
                        SQL>
                        SQL> declare
                        2 err number;
                        3 c number;
                        4 begin
                        5
                        6      -- Drop basic roles.
                        7      begin
                        8      execute immediate 'drop role MGMT_USER';
                        9      exception
                        10           when others then
                        11      DBMS_OUTPUT.PUT_LINE('DropRep: Role MGMT_USER does not exist');
                        12      end;
                        13
                        14      --
                        15      -- Drop the following synonyms
                        16      -- DBMS_SHARED_POOL
                        17      -- SETEMVIEWUSERCONTEXT
                        18      -- MGMT$%
                        19      -- MGMT_%
                        20      -- SMP_EMD%
                        21      -- SMP_MGMT%
                        22      -- EMD_MNTR
                        23      -- ECM_UTIL
                        24      --
                        25
                        26      begin
                        27      for crec in (SELECT object_name from all_objects
                        28                WHERE (object_name like 'MGMT$%' OR
                        29                     object_name like 'MGMT_%' OR
                        30                     object_name like 'SMP_EMD%' OR
                        31                     object_name like 'SMP_MGMT%' OR
                        32                     object_name = 'SETEMVIEWUSERCONTEXT' OR
                        33                     object_name = 'DBMS_SHARED_POOL' OR
                        34                     object_name = 'EMD_MNTR' OR
                        35                     object_name = 'ECM_UTIL'
                        36                )
                        37                AND object_type='SYNONYM')
                        38      loop
                        39      begin
                        40      EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM ' || crec.object_name;
                        41
                        42      EXCEPTION
                        43           when others then
                        44           DBMS_OUTPUT.PUT_LINE('DropRep: Public synonym ' || crec.object_name ||
                        45                          ' cannot be dropped');
                        46           -- continue dropping other synonyms.
                        47      end;
                        48      end loop;
                        49      end;
                        50
                        51      begin
                        52      for crec in (select role from sys.dba_roles where role like 'MGMT_%')
                        53      loop
                        54      execute immediate 'drop role ' || crec.role;
                        55      commit;
                        56      end loop;
                        57      exception
                        58      when NO_DATA_FOUND then
                        59      DBMS_OUTPUT.PUT_LINE('DropRep: Roles like MGMT% do not exist');
                        60      WHEN OTHERS THEN
                        61      err := SQLCODE;
                        62      DBMS_OUTPUT.PUT_LINE('Error '||SQLCODE||' dropping roles');
                        63      end;
                        64
                        65      commit;
                        66 end;
                        67 /

                        PL/SQL procedure successfully completed.

                        SQL>
                        SQL> SQL> Rem
                        SQL> Rem $Header: admin_drop_tablespaces.sql 03-jun-2002.15:24:43 rpinnama Exp $
                        SQL> Rem
                        SQL> Rem admin_drop_tablespaces.sql
                        SQL> Rem
                        SQL> Rem Copyright (c) 2002, Oracle Corporation. All rights reserved.
                        SQL> Rem
                        SQL> Rem NAME
                        SQL> Rem     admin_drop_tablespaces.sql - <one-line expansion of the name>
                        SQL> Rem
                        SQL> Rem DESCRIPTION
                        SQL> Rem     <short description of component this file declares/defines>
                        SQL> Rem
                        SQL> Rem NOTES
                        SQL> Rem     <other useful comments, qualifications, etc.>
                        SQL> Rem
                        SQL> Rem MODIFIED (MM/DD/YY)
                        SQL> Rem rpinnama     06/03/02 - rpinnama_reorg_rep_scripts_3
                        SQL> Rem rpinnama     05/20/02 - Created
                        SQL> Rem
                        SQL>
                        SQL>
                        SQL> declare
                        2 err number;
                        3 c number;
                        4 begin
                        5      begin
                        6      for crec in (select tablespace_name
                        7                from sys.dba_tablespaces
                        8                where tablespace_name like 'MGMT_%')
                        9      loop
                        10      DBMS_OUTPUT.PUT_LINE('DropRep: dropping tablespace ' || crec.tablespace_name);
                        11      execute immediate 'drop tablespace ' ||
                        12                crec.tablespace_name ||
                        13                ' including contents';
                        14      end loop;
                        15      exception
                        16      when NO_DATA_FOUND then
                        17      DBMS_OUTPUT.PUT_LINE('DropRep: Tablespaces like MGMT% do not exist');
                        18      WHEN OTHERS THEN
                        19      err := SQLCODE;
                        20      DBMS_OUTPUT.PUT_LINE('DropRep: Error ' || SQLCODE || ' received dropping table');
                        21      end;
                        22      commit;
                        23 end;
                        24 /

                        PL/SQL procedure successfully completed.

                        SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
                        With the Partitioning, OLAP and Data Mining options
                        [23-05-2008 12:07:04] Return code = 0.
                        [23-05-2008 12:07:04] Done.
                        [23-05-2008 12:07:04] Unquiescing DB ...
                        [23-05-2008 12:07:04] Temp File - /tmp/iaulCOsKUm/x1laraT4Mi.sql.
                        [23-05-2008 12:07:04] Return code = 0.
                        [23-05-2008 12:07:04] Done.
                        [23-05-2008 12:07:04] Dropping Repository failed. Please check file /lhome/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_repos_drop_2008-05-23_12-07-02-PM.log for detailed errors.
                        ============================================

                        here's the emca_2008-05-23..... (ran before the attmpt to drop it)
                        ============================================
                        May 23, 2008 12:06:47 PM oracle.sysman.emcp.ParamsManager setFlag
                        CONFIG: Flag '-deconfig' set to true
                        May 23, 2008 12:06:47 PM oracle.sysman.emcp.ParamsManager setFlag
                        CONFIG: Flag 'dbcontrol' set to true
                        May 23, 2008 12:06:47 PM oracle.sysman.emcp.ParamsManager setFlag
                        CONFIG: Flag 'db' set to true
                        May 23, 2008 12:06:47 PM oracle.sysman.emcp.ParamsManager setFlag
                        CONFIG: Flag 'drop' set to true
                        May 23, 2008 12:06:47 PM oracle.sysman.emcp.ParamsManager setParam
                        CONFIG: Setting param: ORACLE_HOME value: /lhome/app/oracle/product/10.2.0/db_1
                        May 23, 2008 12:06:48 PM oracle.sysman.emcp.ParamsManager setParam
                        CONFIG: Setting param: SID value: orcl
                        May 23, 2008 12:06:51 PM oracle.sysman.emcp.ParamsManager setParam
                        CONFIG: Setting param: PORT value: 1521
                        May 23, 2008 12:06:57 PM oracle.sysman.emcp.ParamsManager getParam
                        CONFIG: No value was set for the parameter SYS_PWD.
                        May 23, 2008 12:06:57 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                        CONFIG: SQLEngine connecting with SID: orcl, oracleHome: /lhome/app/oracle/product/10.2.0/db_1, and user: SYS
                        May 23, 2008 12:06:57 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                        CONFIG: SQLEngine created successfully and connected
                        May 23, 2008 12:07:00 PM oracle.sysman.emcp.ParamsManager setParam
                        CONFIG: Setting param: CONFIRMATION ANSWER value:
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager setParam
                        CONFIG: Setting param: CONFIRMATION ANSWER value: yes
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager getParam
                        CONFIG: No value was set for the parameter LOG_FILE.
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager getParam
                        CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager getParam
                        CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                        CONFIG: SQLEngine connecting with SID: orcl, oracleHome: /lhome/app/oracle/product/10.2.0/db_1, and user: SYS
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                        CONFIG: SQLEngine created successfully and connected
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
                        CONFIG: No Database unique name available. Will try to retrieve it from DB itself
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager setParam
                        CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.EMConfig perform
                        INFO: This operation is being logged at /lhome/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_2008-05-23_12-06-46-PM.log.
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager setParam
                        CONFIG: Setting param: EM_HOME value: /lhome/app/oracle/product/10.2.0/db_1
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager setFlag
                        CONFIG: Flag 'db' set to true
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager getParam
                        CONFIG: No value was set for the parameter MODIFY_SID.
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.DatabaseChecks getDbServiceName
                        CONFIG: No service name available. Will try to set db_unique_name.db_domain
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                        CONFIG: SQLEngine connecting with SID: orcl, oracleHome: /lhome/app/oracle/product/10.2.0/db_1, and user: SYS
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                        CONFIG: SQLEngine created successfully and connected
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager setParam
                        CONFIG: Setting param: DB_UNIQUE_NAME value:
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager getParam
                        CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
                        CONFIG: No Database unique name available. Will try to retrieve it from DB itself
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager setParam
                        CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager getParam
                        CONFIG: No value was set for the parameter DB_DOMAIN.
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
                        CONFIG: No db domain available. Will query db for db_domain parameter
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager setParam
                        CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager setParam
                        CONFIG: Setting param: SERVICE_NAME value: orcl
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                        CONFIG: SQLEngine connecting with SID: orcl, oracleHome: /lhome/app/oracle/product/10.2.0/db_1, and user: SYS
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                        CONFIG: SQLEngine created successfully and connected
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager getParam
                        CONFIG: No value was set for the parameter MODIFY_SID.
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager getParam
                        CONFIG: No value was set for the parameter MODIFY_SID.
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager getParam
                        CONFIG: No value was set for the parameter GLOBAL_DB_UNIQUE_NAME.
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
                        CONFIG: No Global database unique name available. Will try to retrieve it from DB itself
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                        CONFIG: SQLEngine connecting with SID: orcl, oracleHome: /lhome/app/oracle/product/10.2.0/db_1, and user: SYS
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                        CONFIG: SQLEngine created successfully and connected
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager getParam
                        CONFIG: No value was set for the parameter DB_DOMAIN.
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
                        CONFIG: No db domain available. Will query db for db_domain parameter
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager setParam
                        CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: orcl
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager getParam
                        CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                        CONFIG: This is expected, as we might be calling it from a non-rac home
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                        CONFIG: Error retrieving the local node for the cluster
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                        CONFIG: PRKH-1010 : Unable to communicate with CRS services.
                        [OCR Error(Native: prsr_initCLSS:[21])]
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                        CONFIG: Cluster Error Message: PRKH-1010 : Unable to communicate with CRS services.
                        [OCR Error(Native: prsr_initCLSS:[21])]
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
                        CONFIG: Sid: orcl Host: cmserv1 Node: null OH: /lhome/app/oracle/product/10.2.0/db_1 agentHome: null isCentral: false
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
                        CONFIG: Sid: orcl Host: cmserv1 Node: null OH: /lhome/app/oracle/product/10.2.0/db_1 isDBC: false
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager setFlag
                        CONFIG: Flag 'IS_CENTRAL_AGENT_CONFIGURED' set to false
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager setFlag
                        CONFIG: Flag 'IS_DBCONTROL_CONFIGURED' set to false
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
                        WARNING: EM is not configured for this database. No EM-specific actions can be performed.
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.ParamsManager getParam
                        CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.EMReposConfig dropRepository
                        CONFIG: Spooling to /lhome/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_repos_drop_2008-05-23_12-07-02-PM.log
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.EMReposConfig dropRepository
                        INFO: Dropping the EM repository (this may take a while) ...
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                        CONFIG: SQLEngine connecting with SID: orcl, oracleHome: /lhome/app/oracle/product/10.2.0/db_1, and user: SYS
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                        CONFIG: SQLEngine created successfully and connected
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray
                        CONFIG: New Env List: [ORACLE_HOME=/lhome/app/oracle/product/10.2.0/db_1, ORACLE_SID=orcl, PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/lhome/app/oracle/product/10.2.0/db_1/bin]
                        May 23, 2008 12:07:02 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
                        CONFIG: Starting execution: /lhome/app/oracle/product/10.2.0/db_1/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=cmserv1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl))) -repos_user SYSMAN -action drop -verbose -output_file /lhome/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_repos_drop_2008-05-23_12-07-02-PM.log
                        May 23, 2008 12:07:04 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
                        CONFIG: Exit value of 30
                        May 23, 2008 12:07:04 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
                        CONFIG: Enter SYS user's password :
                        Enter repository user password :
                        Getting temporary tablespace from database...
                        Found temporary tablespace: TEMP
                        Environment :
                        ORACLE HOME = /lhome/app/oracle/product/10.2.0/db_1
                        REPOSITORY HOME = /lhome/app/oracle/product/10.2.0/db_1
                        SQLPLUS = /lhome/app/oracle/product/10.2.0/db_1/bin/sqlplus
                        SQL SCRIPT ROOT = /lhome/app/oracle/product/10.2.0/db_1/sysman/admin/emdrep/sql
                        EXPORT = /lhome/app/oracle/product/10.2.0/db_1/bin/exp
                        IMPORT = /lhome/app/oracle/product/10.2.0/db_1/bin/imp
                        LOADJAVA = /lhome/app/oracle/product/10.2.0/db_1/bin/loadjava
                        JAR FILE ROOT = /lhome/app/oracle/product/10.2.0/db_1/sysman/admin/emdrep/lib
                        JOB TYPES ROOT = /lhome/app/oracle/product/10.2.0/db_1/sysman/admin/emdrep/bin
                        Arguments :
                        Connect String = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=cmserv1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))
                        Action = drop
                        Repos User = SYSMAN
                        Default tablespace = MGMT_TABLESPACE
                        Default Data file = mgmt.dbf
                        Dflt Dfile Init size = 20m
                        Dflt Dfile Ext size = 20m
                        ECM tablespace = MGMT_ECM_DEPOT_TS
                        ECM Data file = mgmt_ecm_depot1.dbf
                        ECM Dfile Init size = 100m
                        ECM Dfile Ext size = 100m
                        TEMP tablespace = TEMP
                        Create options = 3
                        Verbose output = 1
                        Output File = /lhome/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_repos_drop_2008-05-23_12-07-02-PM.log
                        Repos creation mode = CENTRAL
                        MetaLink user name = NOTAVAILABLE_
                        MetaLink URL = http://updates.oracle.com
                        Export Directory = /lhome/app/oracle/product/10.2.0/db_1/sysman/log
                        Import Directory = /lhome/app/oracle/product/10.2.0/db_1/sysman/log
                        Checking SYS Credentials ... File - /tmp/ur6ml7y6io/dWx9J0vZ8d.sql.Return code = 0.OK.
                        Dropping the repository..
                        Quiescing DB ... File - /tmp/CQfZpVTo2G/gZRgEj3N4Q.sql.Return code = 0.Done.
                        Checking for Repos User ... File - /tmp/VmybMdVSFT/eMnIzPfY3b.sql.Return code = 0.Exists.
                        Repos User exists..
                        Clearing EM Contexts ... Clearing contexts. File - /tmp/00TGkBffm7/e9yDjuujhJ.sql.
                        Clearing contexts. Return code = 150.
                        Failed.
                        Dropping EM users ...
                        Drop EM Users. File - /tmp/RX5oot2ePz/H1AnIhJKVp.sql.
                        Drop EM Users. Return code = 0.
                        Done.
                        Dropping Repos User ... Drop Repos User. File - /tmp/5NaJcsseMl/07Ns7JtgG5.sql.
                        Drop Repos User. Return code = 0.
                        Done.
                        Dropping Roles/Synonymns/Tablespaces ... File - /tmp/v9HlMc13n2/PnDWh6FFPQ.sql.Return code = 0.Done.
                        Unquiescing DB ... Temp File - /tmp/iaulCOsKUm/x1laraT4Mi.sql. Return code = 0.Done.
                        Dropping Repository failed. Please check file /lhome/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_repos_drop_2008-05-23_12-07-02-PM.log for detailed errors.

                        May 23, 2008 12:07:04 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
                        CONFIG: stty: standard input: Invalid argument
                        stty: standard input: Invalid argument
                        stty: standard input: Invalid argument
                        stty: standard input: Invalid argument
                        ORA-06550: line 1, column 7:
                        ORA-06550: line 1, column 7:
                        ORA-06550: line 22, column 44:
                        PL/SQL: ORA-00942: table or view does not exist
                        ORA-06550: line 18, column 11:
                        ORA-00942: table or view does not exist
                        ORA-06512: at line 61

                        May 23, 2008 12:07:04 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
                        WARNING: Error executing /lhome/app/oracle/product/10.2.0/db_1/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=cmserv1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl))) -repos_user SYSMAN -action drop -verbose -output_file /lhome/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_repos_drop_2008-05-23_12-07-02-PM.log
                        May 23, 2008 12:07:04 PM oracle.sysman.emcp.EMReposConfig invoke
                        SEVERE: Error dropping the repository
                        May 23, 2008 12:07:04 PM oracle.sysman.emcp.EMReposConfig invoke
                        INFO: Refer to the log file at /lhome/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_repos_drop_<date>.log for more details.
                        May 23, 2008 12:07:04 PM oracle.sysman.emcp.EMConfig perform
                        SEVERE: Error dropping the repository
                        Refer to the log file at /lhome/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_2008-05-23_12-06-46-PM.log for more details.
                        May 23, 2008 12:07:04 PM oracle.sysman.emcp.EMConfig perform
                        CONFIG: Stack Trace:
                        oracle.sysman.emcp.exception.EMConfigException: Error dropping the repository
                             at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:173)
                             at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:124)
                             at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
                             at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
                             at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
                             at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
                             at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)
                        ================================================
                        • 9. Re: 10.2.0 emca/emctl issues
                          641052
                          New Info:
                          When i run the RepManager script it fails just after Unquiescing DB. It says PL/SQL: ORA-00942: table of view does not exists
                          Dropping Repository failed.

                          I've managed to make it a little bit further in this process. if anyone can help I'd really appreciate it. I want to avoid having to reinstall Oracle if possible.

                          Thanks