OraFAQ Forum: Server Administration » how to check the version

Home » RDBMS Server » Server Administration » how to check the version

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to check the version [message #258580]

Mon, 13 August 2007 02:03

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?

Report message to a moderator

Re: how to check the version [message #258584 is a reply to message #258580]

Mon, 13 August 2007 02:05

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

select * from v$version

Report message to a moderator

Re: how to check the version [message #258588 is a reply to message #258580]

Mon, 13 August 2007 02:13

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

Report message to a moderator

Re: how to check the version [message #258604 is a reply to message #258588]

Mon, 13 August 2007 03:10

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: how to check the version [message #258613 is a reply to message #258580]

Mon, 13 August 2007 03:38

kimy1214
Messages: 8
Registered: August 2007

Junior Member

hi all,
thanks for the reply. got the versions already!

cheers!

Report message to a moderator

Re: how to check the version [message #258631 is a reply to message #258613]

Mon, 13 August 2007 03:56

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

From which method?

Regards
Michel

Report message to a moderator

Re: how to check the version [message #258640 is a reply to message #258580]

Mon, 13 August 2007 04:07

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!

Report message to a moderator

Re: how to check the version [message #258646 is a reply to message #258640]

Mon, 13 August 2007 04:17

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: how to check the version [message #258647 is a reply to message #258580]

Mon, 13 August 2007 04:21

kimy1214
Messages: 8
Registered: August 2007

Junior Member

also unsure. anyway, i will check. thanks a lot!

Report message to a moderator

Re: how to check the version [message #260701 is a reply to message #258631]

Mon, 20 August 2007 14:15

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.

Report message to a moderator

Re: how to check the version [message #260772 is a reply to message #258580]

Mon, 20 August 2007 22:02

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.

Report message to a moderator

Re: how to check the version [message #261745 is a reply to message #260772]

Thu, 23 August 2007 08:36

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.

Report message to a moderator

Re: how to check the version [message #261780 is a reply to message #261745]

Thu, 23 August 2007 10:30

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.

Report message to a moderator

Previous Topic:	Defragmenting
Next Topic:	Create a new oracle home

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 21:59:01 CDT 2024