Re: Problem accessing DB Link

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/