Home » RDBMS Server » Server Administration » Installation
Installation [message #229706] Mon, 09 April 2007 15:25 Go to next message
Messages: 205
Registered: January 2007
Senior Member

I am going to upgrade the oracle software from 8.1.7 to 9.2.0( not the database only the software) on the disaster recovery server.I want to know how to check if oracle 9.2.0 is installed in a single command..I came up with the below command for this.. Please let me know if anyone knows a better command to check up with the oracle installation.

cat /var/opt/oracle/oratab | grep prod

Thanks much!
Re: Installation [message #229707 is a reply to message #229706] Mon, 09 April 2007 15:38 Go to previous messageGo to next message
Messages: 4768
Registered: February 2005
Location: East Coast USA
Senior Member
Start up sqlplus to see what version it is.
Can you even upgrade the s/w without it upgrading your DB?

Note that your method is not very good at all. What if someone decided to edit your oratab file and change or remove entries?
Re: Installation [message #229878 is a reply to message #229707] Tue, 10 April 2007 03:57 Go to previous message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

We have used dbua tool for upgradation from 9i to 10g.
See whether this tool is available in 8i. if yes, it is better option for upgradation.
The other thing is, u don't have to upgrade s/w and database separately.
Just set the initializatin parameter COMPATIBLE appropriately..
Previous Topic: SGA and PGA Parts
Next Topic: Oracle10G
Goto Forum:

Current Time: Wed Aug 23 05:13:05 CDT 2017

Total time taken to generate the page: 0.11417 seconds