Saturday, October 20, 2007

Remove Oracle Portal 3.0.9 from 11i

Print this post

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.

2 comments:

Atul Kumar said...

Nice post famy, Any specific reason for removing 3.0.9.8.4 portal from apps and not let it just sit with 10g portal ?


Atul Kumar
http://onLineAppsDBA.com

Famy Rasheed said...

Actually, portal 3.0.9 schemas
are stored along with the apps objects ( Oracle Applications Database ) in 11i. Any very recently oracle has withdrawn their support for portal 3.0.9. And now ownwards, Portal 10g will be creating its objects and schemas in seperate infra tier dedicated to itself. So people who are upgrading from 11i to R12 or
11i with 10g Database will now need to migrate their portal first. But migration of portal 3.0.9 to 10g for 11i customers is not supported and better way is to re-implement portal 10g and remove your old schemas from apps database.