Home » Infrastructure » Unix » oracle version (aix 5.3)
oracle version [message #312402] Tue, 08 April 2008 15:28 Go to next message
talashil
Messages: 8
Registered: April 2008
Junior Member
Gurus,

I have a question . I have 9i and 10g on the same box. excluding oratab option and looking into dbs for init<sid>.ora file , are there any other options to find out whaether it's 9i db or 10g db ?

Thanks
Re: oracle version [message #312403 is a reply to message #312402] Tue, 08 April 2008 15:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can login an query. It is the most reliable method. Oratab/Initisid.ora can be easily spoofed.
Re: oracle version [message #312405 is a reply to message #312402] Tue, 08 April 2008 15:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> are there any other options to find out whaether it's 9i db or 10g db ?

What is "it"; database files, executable files, etc?

>looking into dbs for init<sid>.ora file
what would initSID.ora file tell you
COMPATIBLE=8.1.7
Re: oracle version [message #312406 is a reply to message #312402] Tue, 08 April 2008 15:35 Go to previous messageGo to next message
talashil
Messages: 8
Registered: April 2008
Junior Member
Thanks for the reply !!!..

I need the info with out logging into DB.

Basically after I create the DB on the host how to know it's 9i or 10g db ?

Thanks
Re: oracle version [message #312414 is a reply to message #312406] Tue, 08 April 2008 16:42 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Why do you need it without logging in?

When you need it right after you created the database, then to a

select banner from v$version;


at the end of the database creation script.

Without logging there is no way I could see to be sure which version a database is.

If you have two Oracle homes, it would be perfectly possible that you have similar initSID.ora files in both of them, for 9i and 10g version databases with the same SID. The easiest way I can think of on finding out which it really is is logging in and querying v$version.
Re: oracle version [message #312415 is a reply to message #312402] Tue, 08 April 2008 16:55 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Basically after I create the DB on the host how to know it's 9i or 10g db ?
If OFA is used, the software version will be part of the fully qualified path name as defined from/by $ORACLE_HOME

also 'strings' utility can be used to 'mine' the executables residing in $ORACLE_HOME/bin

Also what I typically do is create various SID.env files; one per instance.
The 2 key values in each of these files are
ORACLE_HOME=
ORACLE_SID=

Again, with OFA, then it is trivial to see which SIDs exist & which version they are.

[Updated on: Tue, 08 April 2008 16:58] by Moderator

Report message to a moderator

Previous Topic: Performance Issue on Sun Sloaris - Maybe Unix or Hardware Option ?
Next Topic: upgradation of 9.2.0.8 to 10gR2 on hpux system
Goto Forum:
  


Current Time: Fri Mar 29 06:11:37 CDT 2024