Re: Oracle7 Networking Question

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