Re: Personal Oracle 8.1.6 and Forms 6i on Win98

Hi,

you need the listener only if you are going to user Developer stuff, such as Forms or Procedure builder. I start the listener via the 'normal' Win9x startup folder (see menu Start-Programs-Startup)

Note that you have to put the file listener.ora in the personal_home\admin\network (or net80) directory and not in the developer-home\admin\network (or net80) dir.

In tnsnames you can refer to HOST=127.0.0.1

My listener.ora looks like:
# LISTENER.ORA Network Configuration File: D:\ORA_PERS\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC4))
      )


      (ADDRESS_LIST =


        (ADDRESS = (PROTOCOL = TCP)(HOST = demo)(PORT = 1521))
      )

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )


      (ADDRESS = (PROTOCOL = TCP)(HOST = demo)(PORT = 2481))

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\ORA_PERS)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = DBCASPER)
(ORACLE_HOME = D:\ORA_PERS)
(SID_NAME = DBCASPER)

    )
  )

Arie Mars
arie_at_pca-online.nl
Steve <noadd_at_somewhere.com> schreef in berichtnieuws 3A087131.ADE41557_at_somewhere.com...

> I have successfully installed Personal Oracle 8.1.6 on a Windows 98
> machine and created a database using the DB Assistant with a SID of
> DEV01.
>
> When I connect using SQL*PLUS using system/manger (note SID not
> specified) I connect OK. However when I connect using
> system/manager_at_dev01 I get ORA-12541: TNS:no listener.
>
> Q. How is the connection possible without specifying the SID and not
> having the listener running?
>
> I then installed Forms 6i successfully.  When I start Forms Builder and
> connect to the 8.1.6 database using system/manager (again no SID) I get
> ORA-1034: Oracle not available.  When I connect using
> system/manager_at_dev01 I get the message ORA-12203: TNS: unable to connect
> to destination.
>
> Q. Why can I not connect in either case here.  I hoped it would have
> behaved as connecting through SQL*Plus.
>
> Finally, I can connect when I start the listener but I'm sure I've never
> had to do this with a Personal Oracle database before.  Where is the
> best place to start the listener automatically, it doesn't work if I
> start it in the autoexec.bat file and I'm not sure where to place it in
> the registry.
>
> Cheers
>
>