Re: setting up oracle client on linux error ORA-12533

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 8 Feb 2005 09:13:48 -0800
Message-ID: <1107882828.080130.296990@z14g2000cwz.googlegroups.com>

Pedro.DiazR_at_gmail.com wrote:
> Hi, the environmet var :
>
> TSN_ADMIN IS TNS_ADMIN
Although TNS_ADMIN is correct, Oracle will simple bypass the env variable and look for tnsnames.ora in ORACLE_HOME/network/admin directory if it cannot find it.

>
> Greetings!!
>
> OTESAO wrote:
> > Hello
> >
> > I recently installed the instant oracle client on a Suse
> > linux desktop and I've been trying to get sqlplus to work
> >
> > I've installed
> > oracle-instantclient-basic-10.1.0.3-1.i386.rpm
> > oracle-instantclient-jdbc-10.1.0.3-1.i386.rpm
> > oracle-instantclient-sqlplus-10.1.0.3-1.i386.rpm
> >
> > I've setup the TSN_ADMIN and ORACLE_HOME paths and also
> > created a tnsnames.ora file
> >
> > but still get the following error msg on my sqlnet.log:
> >
> > Fatal NI connect error 12533, connecting to:
> > (DESCRIPTION=(ADDRESS
> >
>

LIST=(ADDRESS=(COMMUNITY=TCPCOM)(PROTOCOL=TCP)(HOST=144.243.79.20)(PORT=1521))) Open your tnsnames.ora file and correct the mistake from (ADDRESS LIST=(
to (ADDRESS_LIST=(

There is a _ between address and list.

Regards
/Rauf Received on Tue Feb 08 2005 - 11:13:48 CST