Re: Ora 8 / Linux: Connect problem

Hi,

I am getting the similar error. When I try to connect to the Oracle instance via Net8. I am getting the oracle error ORA-12500. And in the log file, it says

31-JAN-99 07:06:51 *
(CONNECT_DATA=(SID=WAW)(CID=(PROGRAM=)(HOST=db.workatweb.co m)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=204.227.19.11)(PORT=2639)) * es
tablish * WAW * 12500
TNS-12500: TNS:listener failed to start a dedicated server process  TNS-12546: TNS:permission denied
  TNS-12560: TNS:protocol adapter error    TNS-00516: Permission denied
    Linux Error: 13: Permission denied

Can someone tell me why I am getting this> BTW, I am using RH 5.2 linux.

Thanks a bunch!

Nguyen Nguyen
nguyen.nguyen_at_infosoft-consulting.com

In article <36B48E4B.BC1DF6DF_at_nospam.richard-schneider.de>, Uwe Schneider <pi_at_nospam.richard-schneider.de> wrote:
>
>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 - 12:49:24 CST