Re: Using oracle server installation as a client...

Check that you are using the correct connection type. It sounds to me like either the listener.ora file on the server has a wrong entry or the tnsnames file on the client does, ie, tcp/ip on the client but ipc/pipes on the server.

In article <361048C1.813B558B_at_netspace.net.au>,   Jeremy <jpburton_at_netspace.net.au> wrote:
> Hi All,
> Due to hardware availability, our setup involves running the
> Oracle 8 server on an Intel platform (we are using the Solaris x86 to be
> more precise). We do, however, need to connect to this from a Solaris
> Sparc platform. After having spoken to Oracle about this,
> they advised that to do this, we would need the Sparc server software,
> and to install this but not use it as a server (the server on the Intel
> box is running fine - have connected to it locally via tcp/ip and from
> an NT box using tcp/ip). My problem is that I can't get the connections
> working from the Sparc box. I ahve configured the tnsnames.ora file, and
> added the correct entry for the Intel box. I can use tnsping and get a
> ping. However whenever I try and connect to it using either the DBD
> mobule in perl, or even sqlplus, I have troubles. sqlplus just sits
> there doign nothign -not even prompting me for a password, whilst using
> the DBD interface in perl I get an error message:
> ORA-06401: NETCMN: invalid driver designator
>
> Anyone got any ideas as to hwo I might be able to get this working??
>
> Thanks,
>
> Jeremy Burton
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 01 1998 - 00:00:00 CEST