G Deinstalling the Oracle Content DB Middle Tier

This appendix discusses deinstallation of Oracle Content DB middle tiers, and includes the following topics:

• Deinstalling the Oracle Content DB Middle Tier

• Additional Cleanup Tasks

• Deinstalling Oracle Content DB from a Single Computer

Note: To reinstall an Oracle Content DB middle tier, you must first deinstall any previous middle-tier instances that exist on the computer where you want to reinstall.

Deinstalling the Oracle Content DB Middle Tier

To deinstall an Oracle Content DB middle tier:

1. Before beginning the deinstallation procedure, stop all Oracle processes.

2. Log in as the operating system user who installed the middle tier you want to deinstall.

3. Stop all processes associated with the middle tier you want to deinstall.

   
   

   See Also: Oracle Content Database Administrator's Guide for more information about stopping Oracle Content DB processes

   
   

4. Run the following script on the middle tier. You only need to perform this step if this is the first middle tier that was configured.

   
   

   Tip: Before you run the script, ensure that the $ORACLE_HOME%ORACLE_HOME% variable is set, and that $ORACLE_HOME/jdk/bin%ORACLE_HOME%\jdk\bin appears in the $PATH variable.

   
   

   %ORACLE_HOME%\jdk\bin\java -classpath %ORACLE_HOME%\content\lib\content.jar:%ORACLE_HOME%\jlib\ldapjclnt10.jar oracle.ifs.ecm.tools.credential.CleanProvStatusFootprints OidUrl=ldap://infra_host_name:oracle_internet_directory_port OidSuperUserName=cn=orcladmin OidSuperUserPassword=password_for_cn=orcladmin_user DomainDisplayName=oracle_content_db_domain_display_name
   
   

   For example:

   %ORACLE_HOME%\jdk\bin\java -classpath %ORACLE_HOME%\content\lib\content.jar:%ORACLE_HOME%\jlib\ldapjclnt10.jar oracle.ifs.ecm.tools.credential.CleanProvStatusFootprints OidUrl=ldap://myhost.mycompany.com:389 OidSuperUserName=cn=orcladmin OidSuperUserPassword=mypassword DomainDisplayName=CONTENT
   
   

   
   

   Tip: The Oracle Content DB domain display name is typically CONTENT. If you are unsure of the display name for your Oracle Content DB domain, see Oracle Content Database Administrator's Guide for information about how to find this information in Oracle Directory Manager.

   
   

5. Run the Deconfig tool, as follows:

   cd %ORACLE_HOME%\perl\5.6.1\bin\MSWin32-x86
   perl %ORACLE_HOME%\bin\deconfig.pl
   
   

6. Start Oracle Universal Installer.

7. When the Welcome screen displays, click Deinstall Products to display the Inventory screen.

8. Select the instance you want to deinstall, and click Remove.

9. When the Confirmation screen displays, verify the components selected for deinstallation. Click Yes to continue and display the Deinstallation Progress screen.

   Monitor the progress of the deinstallation. If you see a prompt asking you to run deconfig.pl, click OK to continue, because you have already run this tool as part of Step 4.

10. Exit Oracle Universal Installer when the deinstallation is complete.

11. Delete the Oracle home directory and its contents.

Additional Cleanup Tasks

If you are deinstalling the first Oracle Content DB middle tier that was configured, this section describes additional cleanup tasks. You should only perform the following tasks if you want to remove your entire Oracle Content DB installation.

Removing Oracle Content DB Information From Oracle Internet Directory

If you are deinstalling the first Oracle Content DB middle tier that was configured, you should clean up Oracle Content DB entries from Oracle Internet Directory. You can do this by running the oidprovtool and ldapdelete commands on the OracleAS Infrastructure computer.

Note: Before you remove Oracle Content DB entries from Oracle Internet Directory, ensure that the $ORACLE_HOME%ORACLE_HOME% variable is set on your OracleAS Infrastructure tier. The Oracle Content DB domain display name is typically CONTENT. If you are unsure of the display name for your Oracle Content DB domain, see Oracle Content Database Administrator's Guide for information about how to find this information in Oracle Directory Manager.

To remove Oracle Content DB entries from Oracle Internet Directory:

1. Run the following oidprovtool command:

   %ORACLE_HOME%\bin\oidprovtool operation=delete ldaphost=fully_qualified_infra_host_name ldap_port=Oracle_Internet_Directory_port ldap_user_dn=cn=orcladmin ldap_user_password=password_for_cn=orcladmin_user application_dn=orclApplicationCommonName=oracle_content_db_domain_display_name,cn=IFS,cn=Products,cn=oraclecontext organization_dn=realm_name interface_version=3.0
   
   

   For example:

   %ORACLE_HOME%\bin\oidprovtool operation=delete ldaphost=myhost.mycompany.com ldap_port=389 ldap_user_dn=cn=orcladmin ldap_user_password=mypassword application_dn=orclApplicationCommonName=CONTENT,cn=IFS,cn=Products,cn=oraclecontext organization_dn=dc=us,dc=oracle,dc=com interface_version=3.0
   
   

   If you have multiple Oracle Content DB Sites, you must run this command for each realm on which an Oracle Content DB Site is based.

2. Next, run the following ldapdelete command:

   %ORACLE_HOME%\bin\ldapdelete -h fully_qualified_infra_host_name -p Oracle_Internet_Directory_Port -D cn=orcladmin -w =password_for_cn=orcladmin_user -v "cn=oracle_content_db_domain_display_name,cn=IFS,cn=Products,cn=OracleContext,realm_name"
   
   

   For example:

   %ORACLE_HOME%\bin\ldapdelete -h myhost.mycompany.com -p 389 -D cn=orcladmin -w mypassword -v "cn=CONTENT,cn=IFS,cn=Products,cn=OracleContext,dc=us,dc=oracle,dc=com"
   
   

   If you have multiple Oracle Content DB Sites, you must run this command for each realm on which an Oracle Content DB Site is based.

3. Next, run the following ldapdelete command:

   %ORACLE_HOME%\bin\ldapdelete -h fully_qualified_infra_host_name -p oracle_internet_directory_port -D cn=orcladmin -w =password_for_cn=orcladmin_user -v "cn=Associated Mid-tiers,orclApplicationCommonName=oracle_content_db_domain_display_name,cn=IFS,cn=Products,cn=OracleContext"
   
   

   For example:

   %ORACLE_HOME%\bin\ldapdelete -h myhost.mycompany.com -p 389 -D cn=orcladmin -w mypassword -v "cn=Associated Mid-tiers,orclApplicationCommonName=CONTENT,cn=IFS,cn=Products,cn=OracleContext"
   
   

4. Next, run the following ldapdelete command:

   %ORACLE_HOME%\bin\ldapdelete -h fully_qualified_infra_host_name -p oracle_internet_directory_port -D cn=orcladmin -w =password_for_cn=orcladmin_user -v "cn=Component Owners,orclApplicationCommonName=oracle_content_db_domain_display_name,cn=IFS,cn=Products,cn=OracleContext"
   
   

   For example:

   %ORACLE_HOME%\bin\ldapdelete -h myhost.mycompany.com -p 389 -D cn=orcladmin -w mypassword -v "cn=Component Owners,orclApplicationCommonName=CONTENT,cn=IFS,cn=Products, cn=OracleContext"
   
   

5. Next, run the final ldapdelete command:

   %ORACLE_HOME%\bin\ldapdelete -h fully_qualified_infra_host_name -p oracle_internet_directory_port -D cn=orcladmin -w =password_for_cn=orcladmin_user  -v "orclApplicationCommonName=oracle_content_db_domain_display_name,cn=IFS,cn=Products,cn=OracleContext"
   
   

   For example:

   %ORACLE_HOME%/bin/ldapdelete -h myhost.mycompany.com -p 389 -D cn=orcladmin -w mypassword -v "orclApplicationCommonName=CONTENT,cn=IFS,cn=Products,cn=OracleContext"
   
   

6. Restart OC4J_Security using the Application Server Control. Alternatively, you can use the following opmnctl command:

   opmnctl restartproc process-type=OC4J_SECURITY
   
   

   You can find the opmnctl utility in %ORACLE_HOME%\opmn\bin.

Removing Schemas and Tablespaces from the Database

If you are deinstalling the first Oracle Content DB middle tier that was configured, you should clean up Oracle Content DB entries from Oracle Internet Directory. You can do this by running the oidprovtool and ldapdelete commands on the OracleAS Infrastructure computer.

1. On the database computer, go to the Oracle home of the database.

2. Connect to SQL*Plus as the database user SYS, with the SYSDBA option.

3. Drop the Oracle Content DB schemas (CONTENT, CONTENT$ID, and CONTNET$CM), the Oracle Workflow schema (OWF_MGR), and the Oracle Content DB tablespaces by executing the following commands. The first command may take a few minutes to run.

   drop user CONTENT cascade;
   drop user content$ID cascade;
   drop user CONTENT$CM cascade;
   drop user OWF_MGR cascade;
   drop tablespace CONTENT_IFS_MAIN including contents;
   drop tablespace CONTENT_IFS_LOB_N including contents;
   drop tablespace CONTENT_IFS_LOB_I including contents;
   drop tablespace CONTENT_IFS_LOB_M including contents;
   drop tablespace CONTENT_IFS_CTX_K including contents;
   drop tablespace CONTENT_IFS_CTX_I including contents;
   drop tablespace CONTENT_IFS_CTX_X including contents;
   drop tablespace WORKFLOW_IFS_MAIN including contents;
   
   

4. If you are using raw devices for database file storage, you must recreate the dropped tablespaces manually. For more information, refer to "Using the Raw Storage Type with Oracle Content DB".

Deinstalling Oracle Content DB from a Single Computer

To deinstall Oracle Content DB, OracleAS Infrastructure, and Oracle Database from a single computer:

1. Log in as the operating system user who installed the Oracle Content DB middle tier you want to deinstall.

2. Start Oracle Universal Installer.

3. On the Select Installation Method screen, select Advanced Installation and click Next.

4. On the Specify File Locations screen, click Installed Products.

5. The Inventory dialog box appears. Under Oracle Homes, locate and remove the following items, in order:

   1. Oracle Content DB

   2. OracleAS Infrastructure, if you want to deinstall it

   3. Oracle Database, if you want to deinstall it

6. Exit Oracle Universal Installer.