Re: Problem using TOAD with Oracle8 Personal

It looks like you have a TNS_ADMIN entry in your windows registry, pointing to HOME0. Is that true?

Try renaming it to TNS_ADMIN_BAK and load TOAD again.

If that doesn't work, from Server Login, click <SQL*Net Help> button to pull up that dialog, select each Oracle Home, and click the <Set as TOAD Home> button. TOAD will use that home and ignore the rest of the Oracle Multiple Home settings, once "Use the TOAD Home" is checked on the Server Login dialog. (TOAD Home is a feature of commercial TOAD, not freeware TOAD)

For further support of TOAD commercial, contact Quest Software at support_at_quest.com.

Thanks!

--
Steve Chapman
TOAD Development Team
Quest Software, Inc.

www.quest.com
www.toadsoft.com


"Robert Wagner" <RobertWagner_at_alum.mit.edu> wrote in message
news:v7Ye5.25414$9E6.136794_at_newsr1.maine.rr.com...


> I've done a little more exploration. A recent respondent from that TOAD


> egroup pointed out that my problem might be not having Oracle Listener

> started, but I do. I just now found that turning it OFF doesn't affect my

> ability to access the db from Oracle8 Navigator OR my Access application.

> Presumably, this is one of the ways that Oracle8 Personal Edition is

> different from regular Oracle.

>

> So, my questions are:

> 1) Does TOAD need it?  If so:

> 2) Could I simply have it configured wrong?

>

> FWIW, here is the contents of my LISTENER.ORA file:

> -----

> LISTENER =

>   (ADDRESS_LIST =

>         (ADDRESS=

>           (PROTOCOL= IPC)

>           (KEY= oracle.world)

>         )

>         (ADDRESS=

>           (PROTOCOL= IPC)

>           (KEY= ORCL)

>         )

>         (ADDRESS=

>           (PROTOCOL= IPC)

>           (KEY= EXTPROC0)

>         )

>         (ADDRESS=

>           (COMMUNITY= NMP.world)

>           (PROTOCOL= NMP)

>           (SERVER= VECTRA-NT)

>           (PIPE= ORAPIPE)

>         )

>         (ADDRESS=

>           (PROTOCOL= TCP)

>           (Host= vectra-nt)

>           (Port= 1521)

>         )

>         (ADDRESS=

>           (PROTOCOL= TCP)

>           (Host= vectra-nt)

>           (Port= 1526)

>         )

>         (ADDRESS=

>           (PROTOCOL= TCP)

>           (Host= 127.0.0.1)

>           (Port= 1521)

>         )

>   )

> STARTUP_WAIT_TIME_LISTENER = 0

> CONNECT_TIMEOUT_LISTENER = 10

> TRACE_LEVEL_LISTENER = 0

> SID_LIST_LISTENER =

>   (SID_LIST =

>     (SID_DESC =

>       (GLOBAL_DBNAME = vectra-nt)

>       (SID_NAME = ORCL)

>     )

>     (SID_DESC =

>       (SID_NAME = extproc)

>       (PROGRAM=extproc)

>     )

>   )

> PASSWORDS_LISTENER = (oracle)

>

> -----

>

> TIA  >>> Robert

> ===========================

> "Robert Wagner" <RobertWagner_at_alum.mit.edu> wrote in message

> news:LP%d5.23038$9E6.128259_at_newsr1.maine.rr.com...

> > I download the freeware version of TOAD to use with Oracle8 Personal

> > edition. For some reason, I can't connect. I've read the help file

 stuff,


> > but it's no help.


> >

> > I AM seeing the connection names in the top right ("Database') dropdown

 list


> > of the server login window.Here's a typical error output:


> > ----------------

> > ORA-06413: Connection not open.

> > Details:

> > *** First assume we have a valid install and registry

> > ***

> > Oracle home is set to D:\orant

> > Bin path is set to D:\orant\bin\

> > Using: D:\ORANT\BIN\ORA804.DLL

> >

> > 2) Oracle Home Key is SOFTWARE\ORACLE\HOME0

> > Looking for TNS_ADMIN environmental variable

> > TNS_ADMIN environmental variable doesnt exist,

> > looking for TNS_ADMIN reg key using home key: >SOFTWARE\ORACLE\HOME0<

> > Oracle Path is now D:\orant\NET80\ADMIN

> > Looking for D:\orant\NET80\ADMIN\tnsnames.ora

> > tnsnames.ora found

> > tnsnames entry: CMEXAMPLE

> > tnsnames entry: TCPEXAMPLE

> > tnsnames entry: NMPEXAMPLE

> > tnsnames entry: EXTPROC_CONNECTION_DATA

> > tnsnames entry: BEQ-LOCAL

> > tnsnames entry: SPXEXAMPLE

> > tnsnames entry: TCP-LOOPBACK

> > ------------

> > I'm not sure that the problem with the TNS_ADMIN environment variable is

> > actually the problem, since it IS found in SOFTWARE\ORACLE\HOME0, but I

> > originally didn't have it in the Registry at all. I created three such

> > entries--one each in

> > SOFTWARE\ORACLE\,

> > SOFTWARE\ORACLE\HOME0, and

> > SOFTWARE\ORACLE\ALL_HOMES\ID0.

> > All were created with the correct path for my Win NT machine,

> > "D:\orant\NET80\ADMIN".

> >

> > What worries me (a little) is the statement "Oracle Path is now

> > D:\orant\NET80\ADMIN", since the PATH variable in

> > SOFTWARE\ORACLE\ALL_HOMES\ID0 is (correctly) set to "D:\orant".

> >

> > Can anyone make any sense out of this?

> >

> > TIA

> >

> >

> >

>

>