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: 4621
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: Tue Oct 25 04:19:29 CDT 2016

Total time taken to generate the page: 0.14401 seconds