Hi,
Our database is 8.1.6. I need to find out the verison of the Net8 or sqlnet that we have. How should I do this? Thanks.
Printable View
Hi,
Our database is 8.1.6. I need to find out the verison of the Net8 or sqlnet that we have. How should I do this? Thanks.
On Server:
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
PL/SQL Release 8.1.7.2.0 - Production
CORE 8.1.7.0.0 Production
TNS for Solaris: Version 8.1.7.2.0 - Production
NLSRTL Version 3.4.1.0.0 - Production
OR
LSNRCTL> version
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xyz32.oracle.com)(PORT=1521)))
TNSLSNR for Solaris: Version 8.1.7.2.0 - Production
TNS for Solaris: Version 8.1.7.2.0 - Production
Unix Domain Socket IPC NT Protocol Adaptor for Solaris: Version 8.1.7.2.0 - Production
Oracle Bequeath NT Protocol Adapter for Solaris: Version 8.1.7.2.0 - Production
TCP/IP NT Protocol Adapter for Solaris: Version 8.1.7.2.0 - Production,,
The command completed successfully
On Client:
You know what you have installed Or just open the version of the client software folders and see.
Start OUI (Oracle Universal Installer), select Installed Products button, scroll through and expand the list. For 8.1.6, Net8 is pretty much version 8.1.6 across the board.