Re: problem with listner on a box with 10g and 9i

if I set the ORACLE_HOME from DOS, I can sqlplus into my 10g database from the command line. This bypasses the listener.

now I get 'no listener' even when my listener is started. I think I did screwed around with the registry and did something. I changed my ORACLE_HOME setting in the registry to point to the path with my 10g installation. Then I believe I changed it back to the path of my 9i database home(apparently I did something else, too because its not working).

Here is my question. I have two oracle homes. One for the 9i database and one for the 9i developer suite. I can see this in the registry. I have 10g installed in another path. However, I do not see a home2(only home0 and home1) in the registry. Shouldn't a third oracle home have been created when I installed 10g?

The proper way to set an ORACLE_HOME in windows is to:

1. regedit
2. hkey_local_machine/software/oracle -- I can set the ORACLE_HOME at the top level. -- I can also drill down to: oracle_homes\oracle0\<oracle_home>

I assume I set it in both locations right? Anywhere else?

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1084737043.504810_at_yasure...
> Ryan Gaffuri wrote:
>
> > This is windows XP. I'm doing this at home. So its not urgent.
> >
> > I have 10g installed. I have a new database. I can login if I go to
> > the command line.
> >
> > 1. I started my listener with lsnrctl, and it listed my 9i databases
> > as active and not my 10g database.
> > 2. My lsnrctl is the 10g version. I looked in Network/admin for 10g
> > and no listener, etc... files existed. However, there are 2 10g
> > listeners listed in my services? How can that be? It looks like its
> > looking at my 9i home.
> >
> > 3. I checked my tnsnames.ora in my 9i home. It has my 10g database
> > listed, but its not 'seen' when I run lsnrctl.
> >
> > 4. It looks like my 10g install, did not create another Oracle home in
> > my registry? Isn't it supposed to do that automatically?
> >
> > 5. I changed my ORACLE_HOME to point to the path of my 10g install and
> > now after I get start listener and try to connect, I get 'no
> > listener'. I changed it back and the problem continues(this may be a
> > combination of things).
> >
> > Anyone have any idea? I never work with network issues. I read the
> > release notes and followed the instructions for a 10g install.
> >
> > Another on thing. I run the 10g net manager gui and it only sees my 9i
> > databases. I can't figure out what tnsnames its reading. The one in my
> > 9i home has my 10g database in it.
> >
> > Right now, my biggest problem is that I'm getting 'no listener', when
> > my listener is started. I checked status in lsnrctl.
>
> Set the correct ORACLE_HOME and ORACLE_SID.
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Sun May 16 2004 - 18:39:00 CDT