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: 4727
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: Server IP address
Next Topic: PLS-00923
Goto Forum:

Current Time: Thu Apr 27 04:41:24 CDT 2017

Total time taken to generate the page: 0.05875 seconds