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 -> Re: Checking the server version

Re: Checking the server version

From: Jeff <jeff_at_work.com>
Date: Wed, 12 Mar 2003 13:20:17 GMT
Message-ID: <b4nc6j$4hj$1@cronkite.cc.uga.edu>


In article <8SOdncTU37JOvPOjXTWcjA_at_giganews.com>, "Gabriel Gonzalez" <no-spam_at_no-spam.com> wrote:
>Easiest? Connect with SQLPlus, you'll see the banner that tells the
>version... you can also query the data dictionary, but you gotta connect
>first.

That tells you the version of SQLPlus, which may or may not be current to the database. The best way to get the database version, IMHO, is to query v$version. If you cannot connect, you can also find the version in the alert log... assuming the database has ever been started at all. Received on Wed Mar 12 2003 - 07:20:17 CST

Original text of this message

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