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

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
*:/appl/oracle/product/8.1.7:N

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
joy_division
Messages: 4642
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

hi,
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..
Regards
DIpALl
Previous Topic: Server IP address
Next Topic: PLS-00923
Goto Forum:
  


Current Time: Wed Dec 07 16:47:45 CST 2016

Total time taken to generate the page: 0.05655 seconds