Remove Portal Schema from 11i
You may remove Oracle Portal 3.0.9 only if you are not using Oracle Portal with
E-Business Suite 11i or if you have migrated existing Oracle Portal 3.0.9 functionality
to Oracle Portal 10g .
It is recommended that the removal of Oracle Portal 3.0.9 be done only after the
migration to Oracle Portal 10g. To remove Oracle Portal 3.0.9 objects from your
E-Business Suite 11i database, follow the steps below.
1. Remove Oracle Portal 3.0.9 dependencies from schema CTXSYS
Download Portal patch 3497474 and follow the instructions in the Readme.
This patch removes Portal 3.0.9 dependencies from schema CTXSYS.
2. Remove Oracle Portal 3.0.9 dependencies from the Oracle Applications schema
Download Oracle Applications patch 43695277 and follow the instructions in the Readme.
This patch removes Portal 3.0.9 dependencies from the Oracle Applications schema.
3. Deinstall Oracle Portal 3.0.9 schemas from your E-Business Suite 11i database
Deinstall the Oracle Portal 3.0.9 and Oracle Login Server schemas in the database using the
Oracle Portal Configuration Assistant.
3.1. Run the shell script $IAS_ORACLE_HOME/assistants/opca/launch.sh to
start the Oracle Portal Configuration Assistant.
Window Step 1 of 6: Installation Options appears.
Click the option to Deinstall Oracle Portal and the Login Server.
3.2. Follow the instructions on the remaining screens to complete the
deinstallation.
3.3. Verify Oracle Portal and Oracle Login Server schemas have been removed.
Start SQL*Plus and verify that no rows are returned from the following query:
% sqlplus
SQL> connect system/<system_password> as sysdba
SQL> select username from all_users
SQL> where username like ‘PORTAL%’
SQL> /
You have successfully removed Oracle Portal 3.0.9 from your E-Business Suite 11i database.