Re: login without host name on NT Oracle 8.15

Hi Leon,

What you want is not possible in the way you seem to want it. First of all, hopefully you are not creating one database per application or user. You will end up with multiple instances and you will soon run out of resources. You should create multiple schemas in one instance. Secondly, on the server itself there have always been two methods to connect 'locally':
either set the ORACLE_SID environment variable or the corresponding registry key OR create the key HKLM\software\oracle\local. A database created by the assistant will have ORACLE_SID set to the new database.
Thus you will be able to connect without service name to one database only, or you will be continually changing registry keys. It is not desirable either: suppose you have a wrong ORACLE_SID, and you are by accident connecting to the wrong database.

Hth,

Sybrand Bakker, Oracle DBA
Leon Rzhemovskiy <lrzhemov_at_home.com> wrote in message news:377DA188.251DE417_at_home.com...
> Hi,
>
> The question is: How to modify net8 settings in order to login to the
> database on local machine
> without setting host name (sqlplus scott/tiger)
>
> I have found it is no problem if database has been created using
> database assistant.
> If I am running script to create database I need to use host name like:
> sqlplus scott/tiger_at_home
>
> Thanks
> Leon
> lrzhemov_at_home.com
>
Received on Sat Jul 03 1999 - 03:38:27 CDT