OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Oracle Version

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

Oracle Version [message #261846]

Thu, 23 August 2007 15:24

Daxesh
Messages: 61
Registered: July 2004

Member

Hello,
Is there any command to know the ORACLE VERSION on the Suse linux? I am not asking sqplus version. Let say I have installed oracle 10g R2. Now how do I know what is the actual version?

Any help would be appreciated....

Report message to a moderator

Re: Oracle Version [message #261847 is a reply to message #261846]

Thu, 23 August 2007 15:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

select * from v$version

Report message to a moderator

Re: Oracle Version [message #261928 is a reply to message #261846]

Fri, 24 August 2007 01:34

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you don't have a database to connect, try this hack:

strings $ORACLE_HOME/bin/oracle | grep 'ORACLE PL/SQL'

But the official way is to launch OUI and click on "Installed Products".

Regards
Michel

[Updated on: Fri, 24 August 2007 01:35]

Report message to a moderator

Re: Oracle Version [message #262281 is a reply to message #261846]

Sat, 25 August 2007 21:58

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

Senior Member

strings $ORACLE_HOME/bin/oracle | grep 'ORACLE PL/SQL'

Michel , what we can say about this?

SQL> SELECT * FROM PRODUCT_COMPONENT_VERSION;

PRODUCT                                                          VERSION                                                          STATUS
---------------------------------------------------------------- ---------------------------------------------------------------- ----------------------------------------------------------------
NLSRTL                                                           10.2.0.1.0                                                       Production
Oracle Database 10g Enterprise Edition                           10.2.0.1.0                                                       Prod
PL/SQL                                                           10.2.0.1.0                                                       Production
TNS for Solaris:                                                 10.2.0.1.0                                                       Production

SQL> !strings $ORACLE_HOME/bin/oracle | grep 'ORACLE PL/SQL'
ORACLE PL/SQL V10.2.0.0.0 - Beta

Report message to a moderator

Re: Oracle Version [message #262307 is a reply to message #262281]

Sun, 26 August 2007 01:55

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Michel , what we can say about this?

That you didn't follow the sticky that states that lines should not exceed 80 characters when formatted. Above all when it is useless like here.

Then maybe you didn't look at the same home, maybe you have a beta version, maybe there is a bug...
But surely a hack is not 100% valid.

Regards
Michel

Report message to a moderator

Re: Oracle Version [message #262310 is a reply to message #261846]

Sun, 26 August 2007 02:07

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

Senior Member

Sorry that I have not formated correct. Actually it goes like my SQL*plus setting in which set linesize was 200.

Report message to a moderator

Re: Oracle Version [message #262576 is a reply to message #262310]

Mon, 27 August 2007 10:45

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

Then maybe you didn't look at the same home, maybe you have a beta version, maybe there is a bug...
But surely a hack is not 100% valid.

Michel Can you bit explain?

Quote:

Sorry that I have not formated correct. Actually it goes like my SQL*plus setting in which set linesize was 200.

Its Otay but dont make it habbit Wink

[Updated on: Mon, 27 August 2007 10:46]

Report message to a moderator

Re: Oracle Version [message #262578 is a reply to message #262576]

Mon, 27 August 2007 10:57

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Then maybe you didn't look at the same home, maybe you have a beta version, maybe there is a bug...
But surely a hack is not 100% valid.

Michel Can you bit explain?

What do you want me to explain?

Regards
Michel

Report message to a moderator

Previous Topic:	Alter System Reset................
Next Topic:	upgrading to 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 09:19:29 CST 2024