Re: Oracle7 Networking Question

Thanks a Million,
It worked like a charm.

Added Value: LOCAL
Data Type: Reg_SZ
String: SQL*Net Alias Name

On 17 Jun 1997 10:34:37 GMT, "Muli Koppel" <mkoppel_at_barakitc.co.il> wrote:

>Hello,
>
>yes there is a way if your clients are WINDOWS 95 or NT workstatisons:
>
>Enter the REGISTERY for ORACLE
> (Regedit --> HKEY_LOCAL_MACHINE --> SOFTWARE --> ORACLE)
>
> at the ORACLE level, add the following key :
>
> LOCAL=instance_name
>
>at your given example
>
> LOCAL=SERVER
>
>this way you'll be able to write sqlplus SCOTT/TIGER.
>
>so long,
>
>
>Muli Koppel
>
>An independent DBA
>
>Dave Wilga <dwilga_at_erols.com> wrote in article
><33a8c41a.10745991_at_news.erols.com>...
>> Configuration:
>> Oracle 7.3 NT (single instance) Installed and accessible from both
>> the server it is installed on, as well as client machines through
>> SQL*Net.
>>
>> Question:
>> Is there a configuration option to allow CLIENT machines to access a
>> database on another machine WITHOUT specifying the Host String in the
>> logon? ie.. SCOTT/TIGER and not SCOTT/TIGER_at_SERVER
>>
>> My default installation allows this when logging in while at the
>> server machine, but not the clients. I figure it may have something
>> to do with LISTERNER.ORA and/or TNSNAMES.ORA but this particular
>> concept is subtly hidden in the manuals. Any help appreciated.
>>
>>
>>
Received on Tue Jun 17 1997 - 00:00:00 CDT