Re: Cannot Start Listener in 10g, But Can in 9i
From: if_investor_at_yahoo.com <basis_consultant_at_hotmail.com>
Date: Mon, 15 Mar 2010 10:43:52 -0700 (PDT)
Message-ID: <e927a0bb-371c-4d30-9e8b-56a70a756e7d_at_g4g2000yqa.googlegroups.com>
On Mar 15, 1:04 pm, "if_inves..._at_yahoo.com" <basis_consult..._at_hotmail.com> wrote:
> On Mar 15, 12:43 pm, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
>
>
>
>
>
> > 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!- Hide quoted text -
>
> > - Show quoted text -
>
> Hi,
>
> Thanks for the reply. The 9i listener service is started manually,
> and I don't start
> it when I run 10g.
>
> How would I find more information on the reason for the TNS errors? I
> tried
> increasing the listener trace level, but I did not get more
> information.
>
> Thanks- Hide quoted text -
>
> - Show quoted text -
Date: Mon, 15 Mar 2010 10:43:52 -0700 (PDT)
Message-ID: <e927a0bb-371c-4d30-9e8b-56a70a756e7d_at_g4g2000yqa.googlegroups.com>
On Mar 15, 1:04 pm, "if_inves..._at_yahoo.com" <basis_consult..._at_hotmail.com> wrote:
> On Mar 15, 12:43 pm, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
>
>
>
>
>
> > 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!- Hide quoted text -
>
> > - Show quoted text -
>
> Hi,
>
> Thanks for the reply. The 9i listener service is started manually,
> and I don't start
> it when I run 10g.
>
> How would I find more information on the reason for the TNS errors? I
> tried
> increasing the listener trace level, but I did not get more
> information.
>
> Thanks- Hide quoted text -
>
> - Show quoted text -
Hi, thanks to those who read and responded to my question. I resolved
the issue.
I copied the sqlnet.ora, listener.ora and tnsnames.ora from an
existing Ora10g
Win2000 system, copied them to the server which I upgraded, and
adapted them.
This resolved the issue.
I am not sure why the 9i *.ora files did not work, once I adapted
Oracle_Home,
but that was the problem.
Thanks,
QZ
Received on Mon Mar 15 2010 - 12:43:52 CDT