Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Verifying the version string

Verifying the version string

From: Aaron Newman <aaron_at_newman-family.com>
Date: 3 Aug 2001 14:30:00 -0700
Message-ID: <461e271b.0108031330.3ae40564@posting.google.com>

Hello everyone. I'm write a tool to locate and inventory Oracle databases on a network. I am using the message I get back from the listener service to determine the operating system oracle is running on.

In order to do this properly I need the exact string that appears in the version and there's no way I can purchase oracle for all of the following operating systems to verify the string returned. If anyone out there has oracle running on one of the operating systems below, I would be very appreciative if they can send me the string.

IBM AIX, HP-32 (10.2), HP-32 (11.0), HP-64, TRU-64, INTEL SOLARIS,
DATA GENERAL, UNIXWARE, SGI/IRIX-32, SGI/IRIX-64, SEIMENS (RELIANT),
SEIMENS-64, NCR, FUJITSU-DS, NOVELL, HITACHI, ALPHA OpenVMS, IBM
OS/390

You can get the string by starting the listener controller 'lsnrctl' and entering the status command. Below is an example:

C:\>lsnrctl
LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 03-AUG-2001 17:14:39
(c) Copyright 1998 Oracle Corporation. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=jay)(Port=1521)) STATUS of the LISTENER


Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version
8.1.7.0.0 - Production
Start Date                28-JUL-2001 20:43:36
Uptime                    5 days 20 hr. 33 min. 29 sec
Trace Level               off
Security                  ON
SNMP                      OFF
Listener Parameter File   D:\oracle\ora81\network\admin\listener.ora
Listener Log File         D:\oracle\ora81\network\log\listener.log
Services Summary...
  PLSExtProc            has 1 service handler(s)
  testsid               has 1 service handler(s)
The command completed successfully
LSNRCTL> I only need the version string which includes the OS, such as:
Version                   TNSLSNR for 32-bit Windows: Version
8.1.7.0.0 - Production

If you could, please email me at aaron_at_newman-family.com.

Thank you
Aaron Received on Fri Aug 03 2001 - 16:30:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US