Ora 8 / Linux: Connect problem

From: Uwe Schneider <pi_at_nospam.richard-schneider.de>
Date: Sun, 31 Jan 1999 18:09:31 +0100
Message-ID: <36B48E4B.BC1DF6DF@nospam.richard-schneider.de>

Hi, Experts,

I am currently experiencing a strange behaviour while locally connecting to my own linux server running Oracle 8.05. My instance is named "LINX".

"tnsping linx" gives positive results (OK). In listener.log I can see "Ping" entries.
"sqlplus system" works, after having set the ORACLE_SID environment variable. The same with the DBD/DBI perl API. With netstat I don't see connected TCP sockets for this client access.
sqlplus system_at_linx or an explicit connect to "dbi:Oracle:linx" as connect target in DBI programs do NOT work. The listener log file does contain the corresponding connect line:

31-JAN-99 17:53:26 *
(CONNECT_DATA=(SID=linx)(CID=(PROGRAM=)(HOST=majestix)(USER=pi))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=28749)) * establish *
linx * 0

There seems to be a problem within the SQL*Net dialog. strace -p <PID of SQLPLUS>
gives:

write(8, "\0)\0\0\6\0\0\0\0\0\1\5\4\3\2\1\0"..., 41) = 41
read(8, "\0\220\0\0\6\0\0\0\0\0\1\5\0Linu"..., 2064) = 144
write(8, "\0\20\0\0\6\0\0\0\0\0\2\37\0\37\0"..., 16) = 16
read(8, "\0\v\0\0\6\0\0\0\0\0\2", 2064) = 11

write(8, "\0\312\0\0\6\0\0\0\0\0\3v\2P\354"..., 202) = 202 read(8,

and the last read blocks (FD 8 corresponds to the socket to listener)

Can you give me any hints?

Uwe Schneider       | Telefon +49 7251 / 82587
Karlsdorfer Str. 31 | Mail    pi_at_richard-schneider.de
76646 Bruchsal      |

Linux - OS al dente! Received on Sun Jan 31 1999 - 11:09:31 CST