Re: Oracle 8i Lite installation problem

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Fri, 06 Aug 1999 15:45:43 -0700
Message-ID: <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 Sat Aug 07 1999 - 00:45:43 CEST

Original text of this message