ORA-6114 Problem

Hello,

I have this problem only when I try to connect to my Oracle server from Pro*C programs.

Inside the programs, we have tried connecting with:

user/pass_at_T:servermachine:dbname
user IDENTIFIED by pass at dbname USING connstring

and the error is always the same:

ORACLE error--

ORA-06114: NETTCP: SID lookup failure

On the server side, ~oracle/tcp/log/orasrv.log tell me:

24-AUG-95 14:47:51 /home/oracle/bin/orasrv[ 9099]: ERROR while processing request from host machine.CC.McGill.CA: 24-AUG-95 14:47:51 /home/oracle/bin/orasrv[ 9099]: ERROR: SID lookup failure for '*'

My guess would be that Pro*C doesn't copy the database name in the SQL statement to the structure. I was able to duplicate the problem by using sqlplus with: username/password_at_T:machinename:*

I could not find this error anywhere in the book although I found one that is similar: ORA-6420. The fun part is that from remote machines, we can connect using Oraperl, sqlplus, even the NeXT oracle utilities work just fine. I have a tnsnames.ora file and a listener.ora file and an oratab file that are (I suppose) ok (since sqlplus works fine).

I have tried both sunos 4 and solaris 2.4 versions od the Pro*C stuff and I get the bahaviour on both platforms.

I just can't believe these libs have bugs, too many people use them succesfully.

Please, what have I missed?

Thanks a lot.

--


Yves Lepage
yves_at_cc.mcgill.ca