Question

Application installed release versus database installed release

  • 5 April 2023
  • 1 reply
  • 31 views
S
Rank
Badge +2

Is there a way to compare application installed release with database installed release?

IFS Apps 10 

Test environment: We want to prove the following is correct

  • IFS Applications MWS Home - Release 10

Production environment:

  • IFS Applications MWS Home - Release 20
  • Oracle database files - Release 20

We have a copy of IFS Application installation files taken to a specific release. We have used these files to install a new MWS Home, this is our Test environment. Our Production environment is at release 20, both application and database file.

 

We will clone the Production Oracle database to Test Oracle database. The result is that application installed files on Test environment are at release 10, but database installed files will then be at release 20.

We can run the following query and this confirms which releases have been applied to the database. Is there a reliable way to confirm which releases have been deployed to the application files on the MWS Home?

SELECT name
FROM ifsapp.module
WHERE    description='DELIVERY'

1 reply

E
Rank
Userlevel 4
Badge +7

Stephen,

The query you’ve listed above on the Module table will give you the components / modules and deliveries applied to the IFS application.

The Oracle Opatch utility will provide details of the Oracle provided patches to the Weblogic middleware and the Oracle database.  For Apps 10 installations Opatch can be accessed at the following location on the middleware host server:

<ifs home>\mw_home\mws\Opatch

For Oracle databases this utility is also available at the following location on the database host server:

<oracle home>\Opatch

To execute the Opatch utility, navigate to the appropriate location, then run the command “opatch -lsinventory”.  This command will generate output listing all patches applied to the mws or the database, depending on the server on which the command was run.

Eugene Wager, systems engineer - IFS Support

Reply


Terms & ConditionsCookie settings