Re: Help me with PO8

From: Sequel Solutions <akolkman_at_sequel.nl>
Date: Mon, 22 Mar 1999 15:34:33 +0100
Message-ID: <36F654F9.27A8CCC2_at_sequel.nl>


[Quoted] Dear Vishal,

Your listener.ora (in oracle/network/admin-directory) must have only one entry.
This is how I have it:

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS =

(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
    )
  )

You must start the listener-daemon on your PC running lsnrctl.exe A dos-box is [Quoted] diplayed and you give the command: start. (On my PC then for some strange reason the Netscape-explorer tries to connect to the Internet but I cancel that).
[Quoted] You should see no errors.

Another thing is your tnsnames.ora. You can connect to the Oracle-database (using 127.0.0.1) with as host the tcp-loopback. This is how tcp-loopback should be defined in tnsname.ora:

Tcp-loopback.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =

(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

I hope I have helped you with this.

Greetings,

Arthur Kolkman / Seequel Solutions

Vishal wrote:

> HI
>
>      Could someone please help me with the installation of Personal Oracle
[Quoted] > 8, but I have an older version of Forms 4.5, I want to use Forms 4.5 with
[Quoted] > Oracle 8 Database, is it possible, if yes then could anyone please guide me
[Quoted] > and advice how to go about installing Oracle 8 database
>
> I got some replies regarding my posting earlier, I understand from that I
[Quoted] > have to use SQL*Net, but which Protocol is to be used.
>
> I need to complete a project in somedays from now, could any of you please
[Quoted] > help me with this.
>
> Vishal
Received on Mon Mar 22 1999 - 15:34:33 CET

Original text of this message