Script to display Oracle Apps 11i Related Information (Instance & Midtier Version/release)

Posted on December 11, 2007. Filed under: Scripts, Version | Tags: , , , |

All,

 

Its been quite sometime since i updated this blog. But here iam with a post (shell script) which will get you most of the required information in one screen on Unix/Linux OS. So, What to expect from the script, :

 

 

 

1. Versions of all mid tier components

2. Information on nodes attached to the instance and other instance related information.

 

 

 

Below is a sample output of the script:

instance-info.jpeg

 

 

 


 

 

This script doesnt require any password, infact this script accesses the database by using the hardcorded apps password 🙂

 

Instructions to download and use the script

 

Click here instance_infosh1.doc

Save the file as “instance_info.sh” (or any name you wish with .sh extension) instead of “instance_infosh1.doc”

Upload the file under any location onto your mid tier.

Execute the script as “./instance_info.sh”

Note: This script has to be executed as the applmgr user.

 

 

For gathering information of components in Windows, follow this link.

 

 

 

 

cheers,

OraclePitStop.

Advertisements

Make a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

6 Responses to “Script to display Oracle Apps 11i Related Information (Instance & Midtier Version/release)”

RSS Feed for OraclePitStop – Lets share some knowledge Comments RSS Feed

Within your script i think you have to change this for a 10g DB:

db_rel=`get_dbversion | grep -i Enterprise | head -1 | awk ‘{print $5}’`
to
db_rel=`get_dbversion | grep -i Enterprise | head -1 | awk ‘{print $7}’`

Thanks GPHW. This script was tested against the 9iDB env. – will include the option for 10g as well. Thanks again.

[…] For gather version information on Unix Flavours click this link […]

A goood site for apps DBA’s

hi from turkey
excellent script. it is very useful for me
thanks

Thanks fatih.

cheers,
OraclePitStop.


Where's The Comment Form?

Liked it here?
Why not try sites on the blogroll...

%d bloggers like this: