Re: Cant make a first time logon on Oracle for NT.

From: Håkan Wahlberg <hakan.wahlberg_at_boliden.se>
Date: 2000/04/16
Message-ID: <38F9E6AA.FC4A7371@boliden.se>#1/1

You need to have a correct NET8 (or SQLNET2.3) configured with tnsnames.ora file in the network/admindirectory,
where you define the node and SID (or service) to connect to.

An example:
MYORC2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = the.hostname.domain)(PORT = 1521))     )
    (CONNECT_DATA =
      (SID = ORC2)
    )
  )

/Håkan W

Mr Me wrote:

> Have just installed the Oracle 8.0.5i on the Windows NT Server 4 but cant
> login for a first time because all the time getting following error (or
> similar) with any username/password:
> ORA-12154: TNS:could not resolve service name
> NT reports a service called OracleServiceORC2 and OracleStartORC2 running
> but cant log on to any of them. Whats wrong?
Received on Sun Apr 16 2000 - 00:00:00 CDT