OraFAQ Forum: Networking and Gateways » What should I do so that the listener is reading the configuration from the new ORACLE Installation

Home » RDBMS Server » Networking and Gateways » What should I do so that the listener is reading the configuration from the new ORACLE Installation (11.2.0.1 EE, 11.2.0.2 XE SLES SP1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What should I do so that the listener is reading the configuration from the new ORACLE Installation [message #650666]

Fri, 29 April 2016 02:26

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

Dear all,

I've a server that is installed with a non OFA architecture

oracle home is as follow

/poznan/oracle/oracle11.2

Next I've installed Oracle 11.2.0.2 XE on this existing machine.

I've set these essentials as follow:

Code: [Select all] [Show/ hide]

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export PATH=$ORACLE_HOME/bin:$PATH

when I do a lsnrctl status

Code: [Select all] [Show/ hide]

oracle@vmdev:~> lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 29-APR-2016 15:15:43

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                29-APR-2016 15:12:55
Uptime                    0 days 0 hr. 2 min. 48 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /poznan/oracle/oracle11.2/network/admin/listener.ora
Listener Log File         /poznan/oracle/diag/tnslsnr/vmdev/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vmdev.poznan.com)(PORT=1521)))
The listener supports no services
The command completed successfully

ls -ld /u01/app/oracle/product/11.2.0/xe

if you notice the above the current listener configuration is still reading from old NON OFA listener.ora.

What should I do so that the listener is reading the configuration from the new ORACLE Installation which adheres to OFA.

many thanks in advance

Report message to a moderator

Re: What should I do so that the listener is reading the configuration from the new ORACLE Installation [message #650669 is a reply to message #650666]

Fri, 29 April 2016 02:33

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Start it from the new installation home.
Remove the previous one.

Report message to a moderator

Re: What should I do so that the listener is reading the configuration from the new ORACLE Installation [message #650670 is a reply to message #650669]

Fri, 29 April 2016 03:04

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

do not have space to upload deinstall.zip in server, can I do the following to remove database installation manually through the following steps:

drop the database in any
stop listener from old home
update inventory to indicate this home has been removed->what is the exact command to remove?
then remove oracle home.

many thanks

Report message to a moderator

Re: What should I do so that the listener is reading the configuration from the new ORACLE Installation [message #650671 is a reply to message #650670]

Fri, 29 April 2016 03:06

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

OS?

Report message to a moderator

Re: What should I do so that the listener is reading the configuration from the new ORACLE Installation [message #650672 is a reply to message #650670]

Fri, 29 April 2016 03:07

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I didn't say remove the home, i said remove the listener which depends on your OS.

Report message to a moderator

Re: What should I do so that the listener is reading the configuration from the new ORACLE Installation [message #650673 is a reply to message #650671]

Fri, 29 April 2016 03:08

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

SLES 11 SP1

Report message to a moderator

Re: What should I do so that the listener is reading the configuration from the new ORACLE Installation [message #650674 is a reply to message #650673]

Fri, 29 April 2016 03:17

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So just stop the current listener (from the previous home), change home (in your environment variables), start the new listener, that's all.

[Updated on: Fri, 29 April 2016 03:18]

Report message to a moderator

Re: What should I do so that the listener is reading the configuration from the new ORACLE Installation [message #650684 is a reply to message #650674]

Fri, 29 April 2016 08:41

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

Dear Michel,

Code: [Select all] [Show/ hide]

oracle@vmdev:~> echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/xe
oracle@vmdev:~> which lsnrctl
/u01/app/oracle/product/11.2.0/xe/bin/lsnrctl
oracle@vmdev:~> ps -ef | grep tnslsnr
oracle    1458   373  0 21:34 pts/0    00:00:00 grep tnslsnr
oracle    3651     1  0 15:12 ?        00:00:01 /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr LISTENER -inherit
oracle@vmdev:~> lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 29-APR-2016 21:34:52

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                29-APR-2016 15:12:55
Uptime                    0 days 6 hr. 21 min. 57 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /poznan/oracle/oracle11.2/network/admin/listener.ora
Listener Log File         /poznan/oracle/diag/tnslsnr/vmdev/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vmdev.poznan.com)(PORT=1521)))
The listener supports no services
The command completed successfully
oracle@vmdev:~>

If u notice the above command , despite listener being started from the new OFA home, listener is still reading from old non OFA home.

any solution to force the listener to read from new Oracle Home, thanks

Report message to a moderator

Re: What should I do so that the listener is reading the configuration from the new ORACLE Installation [message #650688 is a reply to message #650684]

Fri, 29 April 2016 09:36

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to start it from the correct Oracle home.
In other words your ORACLE_HOME and your PATH did not match when you started the listener.

Report message to a moderator

Previous Topic:	connect from clients in wifi environment
Next Topic:	Connecting to MSSQL Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 08 08:45:43 CDT 2025