Re: Problem accessing DB Link

Thanks,

How silly of me.

RS
Mark D Powell <markp7832_at_my-deja.com> wrote in message news:9540t9$rct$1_at_nnrp1.deja.com...
> It looks like you have a type in your tnsnames.ora:
> (ADDRESS = (PROTOCAL = TCP)(HOST = linux)(PORT = 1521))
> ................protocol
>
>
> In article <TYed6.557$i54.846329_at_newsr1.u-net.net>,
> "RS" <rs_at_rshome.u-net.com> wrote:
> > I've created a DB link from one database to another (Oracle 8i on
 linux).
> >
> > However, when I try to access data on the linked database, I get the
> > following...
> >
> > 1* select * from rjs.a_at_RJS
> > SQL> select * from rjs.a_at_RJSDB
> > 2 ;
> > select * from rjs.a_at_RJSDB
> > *
> > ERROR at line 1:
> > ORA-12538: TNS:no such protocol adapter
> >
> > I don't have any problem connecting normally to either database.
> >
> > I've double checked the TNSNAMES.ORA and LISTENER.ORA files, which
 seem ok
> > to me...
> >
> > Here they are...
> >
> > listener.ora
> >
> > LISTENER =
> > (DESCRIPTION_LIST =
> > (DESCRIPTION =
> > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> > (PROTOCOL_STACK =
> > (PRESENTATION = TTC)
> > (SESSION = NS)
> > )
> > )
> > (DESCRIPTION =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = linux)(PORT = 1521))
> > (PROTOCOL_STACK =
> > (PRESENTATION = TTC)
> > (SESSION = NS)
> > )
> > )
> > )
> >
> > SID_LIST_LISTENER =
> > (SID_LIST =
> > (SID_DESC =
> > (SID_NAME = PLSExtProc)
> > (ORACLE_HOME = /u01/app/oracle/product/815)
> > (PROGRAM = extproc)
> > )
> > (SID_DESC =
> > (ORACLE_HOME = /u01/app/oracle/product/815)
> > (SID_NAME = DEMO)
> > )
> > (SID_DESC =
> > (ORACLE_HOME = /u01/app/oracle/product/815)
> > (SID_NAME = RJS)
> > )
> > (SID_DESC =
> > (ORACLE_HOME = /u01/app/oracle/product/815)
> > (SID_NAME = RJS2)
> > )
> >
> > tnsnames.ora...
> >
> > ORCL =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = AMDPENTIUM3)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SID = ORCL)
> > )
> > )
> >
> > DEMO =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = linux)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SID = DEMO)
> > )
> > )
> >
> > RJS =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCAL = TCP)(HOST = linux)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SID = RJS)
> > )
> > )
> >
> > RJS2 =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCAL = TCP)(HOST = linux)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SID = RJS2)
> > )
> > )
> >
> > Can anyone shed any light on why I get the error.
> >
> > Thanks in Advance.
> >
> > Replies by email also please
> >
> > RS.
> >
> >
>
> --
> Mark D. Powell -- The only advice that counts is the advice that
> you follow so follow your own advice --
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Mon Jan 29 2001 - 17:57:33 CET