How to determine the Oracle Application Server Metadata Repository (Portal repository) Version

This post is a 10gAS post and not an ERP one.

Here is the situation: You are analyzing the latest release of CPU patches / updates and the patch readme says "apply this patch only if you have xxxx version of portal metadata repository". Now you want to find out what version of the repository do you have in your environment. These steps will help identify the repository version:



1. login to Enterprise Manager - Application Server Control using the application server control URL.
2. Open the file portlist.ini under $PORTAL_ORACLE_HOME/install and this file will reveal the port on which Application Server Control component will listen.
3. Ensure that the Application Server Control service is running in the services panel.
4. Generally you would use ias_admin usercode and password to login.
5. Once you login, under the 'standalone Instances', choose your portal instance.
6. In the resulting screen, choose portal:portal under 'System Components'.
7. The resulting screen shows something like this:

OracleAS Metadata Repository Used By Portal



Status Up
Name udsard
Start Time Apr 13, 2008 10:04:36 AM
Database Version 10.2.0.3.0
Repository Version 10.1.2.0.2


Now you know your repository version !

- Aravind Kamath