| oracle version [message #312402] |
Tue, 08 April 2008 15:28  |
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 #312406 is a reply to message #312402] |
Tue, 08 April 2008 15:35  |
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 |
ThomasG
Messages: 3212
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 |
 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
