RE: Version of Oracle Database without connecting to the database.

If your running as oracle, (owner). The listener password protection will not inhibit you.  

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fuad Arshad Sent: Friday, October 24, 2008 12:05 PM
To: oracle-l_at_freelists.org
Subject: Fw: Version of Oracle Database without connecting to the database.      

• Forwarded Message ---- From: Fuad Arshad <fuadar_at_yahoo.com> To: Bradd Piontek <piontekdd_at_gmail.com> Sent: Friday, October 24, 2008 11:04:53 AM Subject: Re: Version of Oracle Database without connecting to the database.

Thanks bradd that was precisely what i was looking for . i dont need the exact patchset just looking for major numbers

for the all the other answers
looking at the inventory might need extra work which would have made it complicated.
lsnrctl status would not work if the listener is password protected . based on the config oratab can be set to different locations which might not help in looking at oratab and oratab doesnt have the version number in the file.
sqlplus -v seems to be the simplest way to get this information.

Thanks all for the quick responses.  

• Original Message ---- From: Bradd Piontek <piontekdd_at_gmail.com> To: fuadar_at_yahoo.com Cc: oracle-l_at_freelists.org Sent: Friday, October 24, 2008 10:58:31 AM Subject: Re: Version of Oracle Database without connecting to the database.

or you could try "sqlplus -v'
# sqlplus -v

SQL*Plus: Release 10.2.0.3.0 - Production

sqlplus doesnt' always match the exact patchset of the database, but it'll get you the major level.
I'd use that in conjuction with the oratab to get the oracle_homes.

opatch is nice, but it assumes you know the oracle_home already.

Bradd Piontek
  "Next to doing a good job yourself,

        the greatest joy is in having someone 
        else do a first-class job under your  
        direction."

• William Feather

On Fri, Oct 24, 2008 at 10:45 AM, Fuad Arshad <fuadar_at_yahoo.com> wrote:

Folks,
I'm trying to find a way to script finding an approximation of the version of the database without connecting to the database itself. The goal is to try to find out of the Oracle_home is a Oracle 10 home , 9 home etc .

right now i'm doiing something like
DATAVERSION1=`echo $ORACLE_HOME | awk -F/ '{print $6}'` expecting that $6 would lead me to something like /usr/local/oracle/product/10.2

but this is not a very foolproof implementation since installs can take various forms and break this implementation.

Any ideas of how i can get the oracle version info considering that i will always know the value of $ORACLE_HOME.
--

http://www.freelists.org/webpage/oracle-l  

--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 24 2008 - 12:03:41 CDT