Home » RDBMS Server » Server Administration » how to check the version
how to check the version [message #258580] Mon, 13 August 2007 02:03 Go to next message
kimy1214
Messages: 8
Registered: August 2007
Junior Member
we have oracle application installed in our solaris 9 server. wat is the command to check version of oracle?
Re: how to check the version [message #258584 is a reply to message #258580] Mon, 13 August 2007 02:05 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

select * from v$version
Re: how to check the version [message #258588 is a reply to message #258580] Mon, 13 August 2007 02:13 Go to previous messageGo to next message
kimy1214
Messages: 8
Registered: August 2007
Junior Member
thanks for ur quick reply. i need a command that i can issue in command line. like "showrev -p", to show the installed patches. i actually dont know wer to submit "select * from v$version ". pls advise, not really familiar on tis. thanks
Re: how to check the version [message #258604 is a reply to message #258588] Mon, 13 August 2007 03:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It means you connect to the database and execute this statement.
You can also execute OUI (Oracle Universal Installer) or use "opatch lsinventory".

Regards
Michel
Re: how to check the version [message #258613 is a reply to message #258580] Mon, 13 August 2007 03:38 Go to previous messageGo to next message
kimy1214
Messages: 8
Registered: August 2007
Junior Member
hi all,
thanks for the reply. got the versions already!

cheers!
Re: how to check the version [message #258631 is a reply to message #258613] Mon, 13 August 2007 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From which method?

Regards
Michel
Re: how to check the version [message #258640 is a reply to message #258580] Mon, 13 August 2007 04:07 Go to previous messageGo to next message
kimy1214
Messages: 8
Registered: August 2007
Junior Member
connecting to the database and execut the command. by teh way, hope u can help. how to check the platform requirement for oracle apps 11.5.9? thanks a lot!
Re: how to check the version [message #258646 is a reply to message #258640] Mon, 13 August 2007 04:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
how to check the platform requirement for oracle apps 11.5.9? thanks a lot!

I don't know, I think it is in the installation guide, isn't it?

Regards
Michel
Re: how to check the version [message #258647 is a reply to message #258580] Mon, 13 August 2007 04:21 Go to previous messageGo to next message
kimy1214
Messages: 8
Registered: August 2007
Junior Member
also unsure. anyway, i will check. thanks a lot!
Re: how to check the version [message #260701 is a reply to message #258631] Mon, 20 August 2007 14:15 Go to previous messageGo to next message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
Michel Cadot wrote on Mon, 13 August 2007 04:56
From which method?

Regards
Michel



On the server at the command line do

% sqlplus -? | grep Release | cut -f3 -d " "

make sure your ORACLE_HOME is set properly.
--
Sanjay B.
Re: how to check the version [message #260772 is a reply to message #258580] Mon, 20 August 2007 22:02 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Hai this is the SQL*Plus version. Not the Oracle Version.

A simply sqlplus -V will work for seeing SQL*plus version.
Re: how to check the version [message #261745 is a reply to message #260772] Thu, 23 August 2007 08:36 Go to previous messageGo to next message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
Arju wrote on Mon, 20 August 2007 23:02
Hai this is the SQL*Plus version. Not the Oracle Version.

A simply sqlplus -V will work for seeing SQL*plus version.


Your right ... but usually on the server, the sqlplus is the same version as the rdbms ... so nearly true ... still not 100%.

Do "select * from v$version;"

--
Sanjay B.
Re: how to check the version [message #261780 is a reply to message #261745] Thu, 23 August 2007 10:30 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Sanjay Bajracharya wrote on Thu, 23 August 2007 07:36
Arju wrote on Mon, 20 August 2007 23:02
Hai this is the SQL*Plus version. Not the Oracle Version.

A simply sqlplus -V will work for seeing SQL*plus version.


Your right ... but usually on the server, the sqlplus is the same version as the rdbms ... so nearly true ... still not 100%.

Do "select * from v$version;"

--
Sanjay B.



OP got his answer in ist reply.
Previous Topic: Defragmenting
Next Topic: Create a new oracle home
Goto Forum:
  


Current Time: Fri Dec 09 03:56:34 CST 2016

Total time taken to generate the page: 0.09676 seconds