Re: Version

Arv,

If you want to be confused .... read on .

You asked about identifying the version of SQLNet on the server.
Your SQL*Plus prompt is the *Client*. SQL*Plus is a Client even if installed into the same ORACLE_HOME as the Database.
The SQLNet Server component is the Listener which you can identify by the process name "tnslsnr" when you do a "ps -ef" on your Unix server. Execute the command "lsnrctl" from the ORACLE_HOME of your server to enter the Listener command prompt. The banner would give you the version information.

Here's the confusing part ..
You can have a listener which is not running from the same ORACLE_HOME as the database --- and, therefore, need not be the same version as the database. Your Database ORACLE_HOME could be
/u01/app/oracle/product/8.1.7 but your listener might still be running from
/u00/app/oracle/product/8.0.5 and your client might be running from
/u02/app/oracle/product/9.0.1 !

Thus, the Database, SQLNet/Net8/Net8i/OracleNet listener and Client can all be different versions. Hemant K Chitale

"AN Kumar" <af281_at_city.ac.uk> wrote in message news:a6l1pt$rli$1_at_canard.ulcc.ac.uk...
> The following presumably means Im running version 8.1.7.0.0 of SQLnet?
>
> dev -/export/home/oracle>sqlplus
>
> SQL*Plus: Release 8.1.7.0.0 - Production on Tue Mar 12 14:00:54 2002
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> Cheers
>
> Arv
>
> Niall Litchfield (n-litchfield_at_audit-commission.gov.uk) wrote:
> : run Oracle installer and list the installed components. If its anything
> : other than Net8 I'll eat my hat.
>
>
> : --
> : Niall Litchfield
> : Oracle DBA
> : Audit Commission UK
> : *****************************************
> : Please include version and platform
> : and SQL where applicable
> : It makes life easier and increases the
> : likelihood of a good answer
>
> : ******************************************
> : "AN Kumar" <af281_at_city.ac.uk> wrote in message
> : news:a6l0q4$rg7$1_at_canard.ulcc.ac.uk...
> : > A quick question from a Oracle novice:
> : >
> : > how do you find out the version of SQLnet you are running on a Oracle
> : > 8i(8.1.7) server?
> : >
> : > TIA
> : >
> : > Arv
>
>
Received on Tue Mar 12 2002 - 08:11:32 CST