Home » RDBMS Server » Server Administration » Oracle Version
Oracle Version [message #261846] Thu, 23 August 2007 15:24 Go to next message
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....
Re: Oracle Version [message #261847 is a reply to message #261846] Thu, 23 August 2007 15:28 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
select * from v$version
Re: Oracle Version [message #261928 is a reply to message #261846] Fri, 24 August 2007 01:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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

Re: Oracle Version [message #262307 is a reply to message #262281] Sun, 26 August 2007 01:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Oracle Version [message #262310 is a reply to message #261846] Sun, 26 August 2007 02:07 Go to previous messageGo to next message
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.

Re: Oracle Version [message #262576 is a reply to message #262310] Mon, 27 August 2007 10:45 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
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

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


Current Time: Wed Dec 07 10:34:17 CST 2016

Total time taken to generate the page: 0.09878 seconds