Script to display Oracle Apps 11i Related Information (Instance & Midtier Version/release)
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:
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.
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}’`
GPHW
December 12, 2007
Thanks GPHW. This script was tested against the 9iDB env. – will include the option for 10g as well. Thanks again.
oraclepitstop
December 12, 2007
[…] For gather version information on Unix Flavours click this link […]
Versions of components in Oracle Apps « OraclePitStop - Lets share some knowledge
December 14, 2007
A goood site for apps DBA’s
Dhanvir
December 25, 2007
hi from turkey
excellent script. it is very useful for me
thanks
fatih
October 17, 2008
Thanks fatih.
cheers,
OraclePitStop.
oraclepitstop
October 17, 2008