client connect to 10g instance

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Thu, 23 Jun 2005 13:11:56 -0500
Message-ID: <BAY107-F56C4D788F5FC44CA8E60997EA0@phx.gbl>

Is this right or has something changed in 10g (10.1.0.3.0). This is on RHEL4 x86_64.

I am consisting getting an:

ora-12535 tns: operation timed out

when trying to connect from my client windows machine to the Linux server with 10g Ent ed.

I can perform a loopback with no problem.

See the result of the adapters command and the ldd command:

ORACLE_SID=orcl
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/10.1.0

[oracle_at_host admin]$ sqlplus system/pwd_at_orcl

SQL*Plus: Release 10.1.0.3.0 - Production on Thu Jun 23 10:35:22 2005

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options

SQL> show user
USER is "SYSTEM"
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle_at_host admin]$ cd $ORACLE_HOME/bin
[oracle_at_host bin]$ adapters sqlplus

Oracle Net transport protocols linked with sqlplus are:

Oracle Net naming methods linked with sqlplus are:

Oracle Advanced Security options linked with sqlplus are:

    RC4 40-bit encryption
    RC4 56-bit encryption
    RC4 128-bit encryption
    RC4 256-bit encryption
    DES40 40-bit encryption
    DES 56-bit encryption
    3DES 112-bit encryption
    3DES 168-bit encryption

    AES 128-bit encryption
    AES 192-bit encryption
    AES 256-bit encryption

    MD5 crypto-checksumming
    SHA-1 crypto-checksumming
    Kerberos v5 authentication
    RADIUS authentication
[oracle_at_host bin]$ adapters tnslsnr

Oracle Net transport protocols linked with tnslsnr are:

Oracle Net naming methods linked with tnslsnr are:

Oracle Advanced Security options linked with tnslsnr are:

    AES 128-bit encryption
    AES 192-bit encryption
    AES 256-bit encryption

    MD5 crypto-checksumming
    SHA-1 crypto-checksumming
    Kerberos v5 authentication
    RADIUS authentication
[oracle_at_host bin]$ ldd sqlplus

libsqlplus.so => /u01/app/oracle/product/10.1.0/lib/libsqlplus.so (0x0000002a95557000)

libclntsh.so.10.1 =>
/u01/app/oracle/product/10.1.0/lib/libclntsh.so.10.1 (0x0000002a9570c000)

libnnz10.so => /u01/app/oracle/product/10.1.0/lib/libnnz10.so (0x0000002a965b3000)

        libdl.so.2 => /lib64/libdl.so.2 (0x000000389af00000)
        libm.so.6 => /lib64/libm.so.6 (0x0000002a96837000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x0000002a969bd000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00000038a2a00000)
        libc.so.6 => /lib64/libc.so.6 (0x0000002a96b53000)
        /lib64/ld-linux-x86-64.so.2 (0x000000389a800000)

[oracle_at_host bin]$

Also, why do I have 4 listener proccess? I have never seen this in 8i or 9i.
[oracle_at_host bin]$ ps -ef | grep tnslsnr
oracle 23646 1 0 09:32 ? 00:00:00 /u01/app/oracle/product/10.1.0/bin/tnslsnr LISTENER -inherit oracle 23647 23646 0 09:32 ? 00:00:00 /u01/app/oracle/product/10.1.0/bin/tnslsnr LISTENER -inherit oracle 23648 23647 0 09:32 ? 00:00:00 /u01/app/oracle/product/10.1.0/bin/tnslsnr LISTENER -inherit oracle 23649 23647 0 09:32 ? 00:00:00 /u01/app/oracle/product/10.1.0/bin/tnslsnr LISTENER -inherit oracle 940 23587 0 12:25 pts/2 00:00:00 grep tnslsnr
[oracle_at_host bin]$

thanks.

Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 23 2005 - 14:17:13 CDT