Home » RDBMS Server » Server Administration » where to find RDBMS version
where to find RDBMS version [message #54933] Tue, 17 December 2002 02:27 Go to next message
Kim Carlsen
Messages: 13
Registered: September 2002
Junior Member
Hi

Where can I find the complete version including patch version in my Windows server?
Is it in the reg? or a file?
I need to find the RDBMS version of my server, by script, before I´ve have an instance. How do I do that?

Merry Xmas
Kim
Re: where to find RDBMS version [message #54934 is a reply to message #54933] Tue, 17 December 2002 02:56 Go to previous messageGo to next message
B
Messages: 327
Registered: August 1999
Senior Member
At startup for NT ( service pack X )
W2K control panel->systeme

RDMS -> connect DB and :

select * from v$version
Re: where to find RDBMS version [message #54939 is a reply to message #54933] Tue, 17 December 2002 10:12 Go to previous messageGo to next message
Kim Carlsen
Messages: 13
Registered: September 2002
Junior Member
I´cant connect to the DB, because there´s no DB.
I need to check the version before I have a DB.
Re: where to find RDBMS version [message #54941 is a reply to message #54933] Tue, 17 December 2002 11:54 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
That would be :

C:>Program FilesOracleInventoryComponentsoracle.rdbms

By script, use :

c:
cd
cd C:Program FilesOracleInventoryComponentsoracle.rdbms
dir > c:temporacle.version.txt

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Re: where to find RDBMS version [message #54947 is a reply to message #54939] Wed, 18 December 2002 05:30 Go to previous message
Kim Carlsen
Messages: 13
Registered: September 2002
Junior Member
The problem is that, if there´s no oracle_sid I cannot get the version, se below.
The other thing is that I cannot use this method, because I´m building an installer using installshield, and need do know the version, before the instances are created.
I cannot find anything in the registry or in any file that contains e.g. "8.1.7.0.0"

Kim

E:oracleora81BIN>svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

ORA-12560: TNS:protocol adapter error
SVRMGR> exit
Server Manager complete.

E:oracleora81BIN>set oracle_sid=test

E:oracleora81BIN>svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production

SVRMGR>
Previous Topic: shutdown abort - and then what?
Next Topic: SQL Error - Temp Segment...
Goto Forum:
  


Current Time: Thu Sep 19 23:13:48 CDT 2024