Re: Cannot Start Listener in 10g, But Can in 9i

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Mon, 15 Mar 2010 09:43:13 -0700 (PDT)
Message-ID: <c11c5f15-e398-416d-ae9a-a9ef7df9f8db_at_z11g2000yqz.googlegroups.com>

On Mar 15, 12:06 pm, "if_inves..._at_yahoo.com" <basis_consult..._at_hotmail.com> wrote:

snip

> I upgraded a Win2000 (SP4) server from Oracle 9i to 10.2.0.4. (It is a
> SAP system, not
> supported for Ora11).
>
> The upgrade went well. I used DBUA. I can start the database in 10g.
>
> However, when I try to start the listener, the response is a set of
> TNS errors:
> (TNS-12542: TNS:address already in use,  TNS-12560: TNS:protocol
> adapter error,
>  TNS-00512: Address already in use).
>
> I checked "netstat -a" , the port is free and few connections are
> being used. I
> tried changing ports, etc..., but the problem persists.
>
> The interesting thing is that the listener works when I  "switch it"
> to the 9i
> version.
>
> That is, I change the env. variables ORACLE_HOME and the registry
> settings ORACLE_HOME, ORACLE_HOME_NAME, ORACLE_GROUP_NAME
> to point to 9i.
>
> I log off and on, and start the listener from <Oracle_9i home>\bin.
> (Because
> the 10g version is on the path).
>
> Then, the listener start and stops without any problems, using the
> same port
> as in 10g. I make sure that the listener is stopped.
>
> However, when I switch the env. variable and the regsitry settings
> back to 10g,
> in 10g I can start the database, but the listener has the 'TNS"
> errors, previously
> mentioned.
>
> Also, I copied the listener.ora and tnsnames.ora to the <10g Home>
> \network\admin,
> and adapted them for the new Oracle Home.
>
> Any ideas will be greatly appreciated.

Windows uses services right? Maybe you need to disable or do something to the 9 version of the listener service before using the 10 version?

Sorry we don't run oracle on windows around here ... just guessing! Received on Mon Mar 15 2010 - 11:43:13 CDT