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

see comment inline below...

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.

TNSNAMES.ORA is used to allow client to connect to DB server. LISTENER.ORA is used to configure the (local?) Oracle listener.

>
> Right now, my biggest problem is that I'm getting 'no listener', when
> my listener is started. I checked status in lsnrctl.

Is the environmental variable TNS_ADMIN set? If so, to what? Received on Sun May 16 2004 - 13:06:20 CDT