Welche Optionen sind in der Datenbank installiert:

COLUMN comp_name format a40
COLUMN STATUS format a8
COLUMN version format a12
COLUMN schema format a12
 
 
 
SELECT comp_name
     , STATUS 
     , version
     , schema
FROM dba_registry
/
 
COLUMN parameter format a30
COLUMN VALUE format a30
 
 
SELECT * FROM v$option
/
 

Wo finde ich mehr Informationen:

Oracle Support Portal:

• Information On Installed Database Components and Schemas [ID 472937.1]
• How to Check and Enable/Disable Oracle Binary Options [ID 948061.1]

siehe

• http://shrikantrao.wordpress.com/2011/12/29/oracle-11-2-new-feature-chopt-utility/

@?/rdbms/admin/spdrop 

Zuvor sys und sysman Passwort ermitteln oder neu setzen.

1. Versuch mit emca

emca -deconfig dbcontrol db -repos drop

2.Versuch mit SQL

SHUTDOWN IMMEDIATE;
STARTUP RESTRICT;
EXEC sysman.emd_maintenance.remove_em_dbms_jobs;
EXEC sysman.setEMUserContext('',5);
REVOKE dba FROM sysman;
DECLARE
CURSOR c1 IS
SELECT owner, synonym_name name
FROM dba_synonyms
WHERE table_owner = 'SYSMAN'
;
BEGIN
FOR r1 IN c1 LOOP
IF r1.owner = 'PUBLIC' THEN
EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;
ELSE
EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;
END IF;
END LOOP;
END;
/
DROP USER mgmt_view CASCADE;
DROP ROLE mgmt_user;
DROP USER sysman CASCADE;
ALTER SYSTEM DISABLE RESTRICTED SESSION;

Quellen:

• Note.278100.1 Ext/Pub How to Recreate the DB Control Repository

@?/rdbms/admin/catnorul.sql

@?/rdbms/admin/catnoexf.sql

Deinstallation vom Expression Filter löscht automatisch auch den Rules Manager!

siehe auch ow To Install/Uninstall Expression Filter Feature or EXFSYS schema along with Rules Manager (Doc ID 258618.1)

@?/rdbms/admin/owmuinst.plb

OLAP Catalog und Oracle OLAP API / OLAP Analytic Workspace

@?/olap/admin/catnoamd.sql
@?/olap/admin/olapidrp.plb
@?/olap/admin/catnoaps.sql
@?/olap/admin/catnoxoq.sql
@?/olap/admin/cwm2drop.sql
 
DROP public synonym OlapFactView;
DROP public synonym OlapDimView;
DROP public synonym DBMS_ODM;
 
#EXPDP datapump handler TABLE handlers entfernen für OLAP DATA:
SELECT * FROM sys.exppkgact$ WHERE package IN('DBMS_AW_EXP','DBMS_CUBE_EXP') AND schema= 'SYS';
 
DELETE FROM sys.exppkgact$ WHERE package = 'DBMS_AW_EXP'   AND schema= 'SYS';
DELETE FROM sys.exppkgact$ WHERE package = 'DBMS_CUBE_EXP' AND schema= 'SYS';
 
commit;
 
#Datenbank durchstarten
 
startup force

Option aus DB Kernel entfernen ( nur wenn man das nie wieder installieren möchte!)

# DB Stoppen
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk olap_off
make -f ins_rdbms.mk ioracle
# DB Starten

Falls folgende Fehler bei einem nächsten Export mit expdp auftritt, wurde die SYS.EXPPKGACT$ nicht komplett angepasst:

BEGIN "SYS"."DBMS_CUBE_EXP".SCHEMA_CALLOUT(:1,0,1,'11.02.00.00.00'); END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 1245
ORA-06550: line 1, column 8:
PLS-00201: identifier 'SYS.DBMS_CUBE_EXP' must be declared

siehe: EXPDP: PLS-201 identifier 'SYS.DBMS_CUBE_EXP' must be declared (Doc ID 1328829.1)

• How To Remove the Oracle OLAP API Objects From 9i and 11g Databases [ID 278111.1]
• How To Remove The OLAP Option In 10g And 11g [ID 332351.1]

Prüfen ob Spatial im Einsatz ist:

CONNECT / AS sysdba
SELECT owner,index_name FROM dba_indexes WHERE ityp_name = 'SPATIAL_INDEX'; 
 
SET pages 200
COLUMN owner FOR a20
COLUMN TABLE_NAME FOR a30
COLUMN column_name FOR a25
 
SELECT owner
    , TABLE_NAME
    , column_name
 FROM dba_tab_columns
WHERE data_type = 'SDO_GEOMETRY'
  AND owner != 'MDSYS'
ORDER BY 1,2,3;

MDSYS User löschen:

DROP USER mdsys cascade;

Falls Fehler ORA-14452 attempt to drop .. index on temporary table already ⇒ „startup force“ der Datenbank und nochmals versuchen.

Alte Synonyme löschen:

SET heading off
SET feedback off
 
spool delete_syn.sql
SELECT 'drop public synonym "' || synonym_name || '";' FROM dba_synonyms WHERE table_owner='MDSYS'; 
spool off
 
SET heading ON
SET feedback ON
 
#alle löschen
@delete_syn.sql

Weitere Spatial User löschen:

DROP USER mddata cascade;
 
-- Only created as of release 11g:
DROP USER spatial_csw_admin_usr cascade;
DROP USER spatial_wfs_admin_usr cascade;

Spatial bleibt aber evlt. weiterhin die der V$OPTION , siehe Note:273573.1!

Pürfen und bei Bedarf aus der Registry entfernen:

sqlplus / AS sysdba
 
sql>EXEC dbms_registry.removed('Spatial');

• Steps for Manual De-installation of Oracle Spatial [ID 179472.1]
• How To Deinstall Oracle Spatial Keeping Oracle Locator [ID 1070647.1]

10gR2:

@?/ord/im/admin/imdinst.sql
-- alle von Oracle interMedia abhängigen Objekte löschen
@?/ord/im/admin/imdtyp.sql
 
startup force

11gR2: Nach dem Upgrade können so auch die User ORDPLUGINS ,ORDSYS,SI_INFORMTN_SCHEMA entfernt werden:

@?/rdbms/admin/catcmprm.sql ORDIM

für 11g

• Where to Find the Information to Install, Upgrade, Downgrade and Deinstall interMedia/Oracle Multimedia? [ID 337415.1]
• http://docs.oracle.com/cd/E16338_01/appdev.112/e10777/ap_instl_upgrd.htm#CHDFEABI

10g auf Unix:

#Datenbank zuvor stoppen
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dm_off
make -f ins_rdbms.mk ioracle
#Datenbank wieder starten

Tipp Solaris: make mit /usr/ccs/bin/make mit vollen Pfad verwenden!

DB Registry ändern:

EXEC dbms_registry.removed('ODM');

Objekte nach der Migration in 11g entfernen

DROP USER DMSYS CASCADE;
DELETE FROM SYS.EXPPKGACT$ WHERE SCHEMA = 'DMSYS';
commit;
SELECT COUNT(*) FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'DMSYS';
SELECT 'Drop public synonym ' ||'"'||SYNONYM_NAME||'";'   FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'DMSYS';

Fehler beim nächsten Datapump Export:

>>> ORA-31642: the following SQL statement fails: 
BEGIN "DMSYS"."DBMS_DM_MODEL_EXP".SCHEMA_CALLOUT(:1,0,1,'11.02.00.04.00'); END;
ORA-06550: line 1, COLUMN 8:
PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared
ORA-06550: line 1, COLUMN 8:
PL/SQL: Statement ignored

Lösung ⇒ Database Data Pump Export fails with PLS-00201 identifier DMSYS.DBMS_MODEL_EXP must be declared (Doc ID 304449.1)

sqlplus / AS sysdba
 
SELECT COUNT(*) FROM xppkgact$ WHERE schema='DMSYS'; 
 
-- >> 0
 
DELETE FROM exppkgact$ WHERE SCHEMA='DMSYS'; 
commit;

• How To Remove the Data Mining Option from the Database [ID 297551.1]
• How To Remove DMSYS Schema In 11G [ID 1497250.1]

@?/ctx/admin/catnoctx.sql
DROP PROCEDURE sys.validate_context;

• 10g R2 - Manual Installation, Deinstallation of Oracle Text 10gR2 [ID 979705.1]
• 11g R2 - Manual installation, deinstallation and verification of Oracle Text 11gR2 [ID 970473.1]

Bei Fehlern mit XDB
Da XDB auch Oracle Text verwendet kann nach dem Entfernen von Oracle Text es zu Fehlern in XDB kommen.

siehe : XDB.DBMS_XDBT Invalid And Compilation Errors With PLS-00201 identifier CTXSYS.CTX_OUTPUT Must Be Declared [ID 296869.1]

Lösung:

DROP package XDB.dbms_xdbt;
ALTER PROCEDURE xdb.XDB_DATASTORE_PROC compile 
 
EXECUTE dbms_regxdb.validatexdb;

Zuerst die DB stoppen

cd $ORACLE_HOME/rdbms/lib
 
make -f ins_rdbms.mk rat_off ioracle

Support Portal:

• How to enable Partitioning in Oracle Database Enterprise Edition 11.2 on Windows [ID 1188238.1]

Zuerst die DB stoppen

Unter Linux:

cd $ORACLE_HOME/rdbms/lib
 
make -f ins_rdbms.mk dv_off ioracle

Unter Windows (Powershell Beispiel!):

cd $ENV:ORACLE_HOME\bin
 
move oradv11.dll oradv11.dll.orig 
 
 
#search service
Get-Service -Name "OracleService*"
 
#stop the service in a administrativen Session
Stop-Service -name OracleServiceGPI
 
#restart the service
Start-Service -name OracleServiceGPI

Restart the Database

Wurde Data Vault eingesetzt siehe die Support Node für die weiteren notwendigen Schritte.

See also:

• How to uninstall Database Vault from a 11g DataGuard environment (Doc ID 1379916.1)

Support:

• How To Diagnose Components With NON VALID Status In DBA_REGISTRY After an Upgrade (Doc ID 753041.1)