Re: Oracle 8i Lite installation problem

From: Terry Dykstra <tdykstra_at_cfol.ab.ca>
Date: Mon, 9 Aug 1999 13:07:05 -0600
Message-ID: <37af26bb_at_news.cadvision.com>


use odbc:polite as the serverstring in sql/plus. 

--
Terry Dykstra
Canadian Forest Oil Ltd.
See you at Techwave 99:  http://www.sybase.com/events/techwave99/
Frank van Bortel wrote in message <37AB6597.D3361DB7_at_vnl.nl>...
sam pal wrote:
use Net8 assit providid by oracle  then
As per I know
For example
Database name ora8i
                       port 1521
                    hostname 127.0.0.1  (this loopback address I don't know the
exact word for this Ip address)

then go to ms-dos prompt
cd c:\orawin988i\bin\lsnrctl start
then
start oracle
For you have to start listner first

"Ferenczi László" wrote:

> Hi !
>
> I have a little problem with Oracle 8i Lite (4.0). I installed it to my Win
> 98 PC and
> when tryed to start sql*plus I got a following error.
>
> TNS: could not resolve the service name      (I think)
>
> And said me. Listener not avaiable.
>
> How can I configure the tnsnames.ora, sqlnet.ora, listener.ora ?
>
> Who have got any idea ??
>
> Laszlo Ferenczi


Not very effective. You don't need a listener, set tnsnames to contain at least:
Beq-local.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (PROTOCOL = BEQ)
          (PROGRAM = oracle80)
          (ARGV0 = oracle80ORCL)
          (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
 Also set automatic_ipc = ON in sqlnet.ora

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
V&L Informatica BV                   Hunzestraat 4
Palandijn 3, 7521 PN Enschede        7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046
053-4341500
 

Received on Mon Aug 09 1999 - 21:07:05 CEST

Original text of this message