Re: using Bequeath protocol ?

<sybrandb_at_yahoo.com> a écrit dans le message news: a1d154f4.0310130554.410aed4a_at_posting.google.com... "Alkos" <azerty_at_nospam.org> wrote in message news:<bmdpff$ja75_at_news.rd.francetelecom.fr>...
> Hello,
>
> Can anyone explain to us how to set Bequeath protocol's parameters in tnsnames.ora ?
> We are trying to use that protocol on a 8.1.7.4 and connection fails.
> tnsping does work fine but any try to connect through jdbc:oci8 (client application is of course
> on the same host as the instance, it was the actual reason of using Bequeath)
> Our connect string for java is : jdbc:oracle:oci8:@<SID>_BEQ
> Oracle's reply is
> ORA-12545 Connect failed because target host or object does not exist
>
> Here below is an excerpt of our tnsnames.ora
>
> <SID>_BEQ =
> (DESCRIPTION =
>
> (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle)
>
> (argv0 = oracle<SID>)
>
> (args = '(DESCRIPTION = (LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
>
> (envs = 'ORACLE_HOME=/exec/commun/prog/ora817,ORACLE_SID=<SID>')
>
> )
>
> (CONNECT_DATA = (SID = <SID>))
>
> )

jdbc *NEEDS* tcp/ip and won't work without it.

Sybrand Bakker
Senior Oracle DBA

Hello Mister Bakker,

Actually, our Java programs connecting through oracle:jdbc:oci8:@<SERVICE_NAME> work quite fine <SERVICE_NAME> =

(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL=beq) (PROGRAM=/u00/app/oracle/product/8.1.7/bin/oracle) (ARGV0=oracle<SID>)
(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
(ENVS='ORACLE_HOME=/u00/app/oracle/product/8.1.7,ORACLE_SID=<SID>')
)
)

Please try this and confirm ;)

Be seeing you,
Alkos
Junior Oracle's Stuff Engineer Received on Mon Oct 13 2003 - 11:11:43 CDT