In article <tkmmd0i0k6m85c_at_beta-news.demon.nl>, Sybrand Bakker says...
>
>
>"vk02720" <vk02720_at_my-deja.com> wrote in message
>news:4d814faa.0107101133.115a7566_at_posting.google.com...
>> What is the difference in logging in using the following 2 ways on UNIX
(AIX)?
>> sqlplus username/password_at_INST
>> versus
>> export ORACLE_SID=INST
>> sqlplus username/password
>>
>>
>> TIA
>
>The first method will use whatever protocol you defined in your tnsnames.ora
>for inst (usually TCP/IP)
>The second method will use the Bequeath protocol.
>This is a form of InterProcess Communication.
>As you are on the server, you shouldn't use a WAN protocol like TCP/IP to
>connect, as it has more overhead.
>
>Hth,
>
>Sybrand Bakker, Senior Oracle DBA
>
>
>
Thanks.
On some machines, the Bequeath protocol does not work. Only sqlplus
username/password_at_INST seems to work. What should be modified ( any .ora files
etc. ) to make it work using Bequeath protocol ? The oracle server is on same
machine as sqlplus user. Also, what IPC mechanism is used ?
Received on Tue Jul 10 2001 - 16:19:04 CDT
