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)
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 Go to next message
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:


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

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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

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

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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

OS?

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 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
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.

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 Go to previous messageGo to next message
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
SLES 11 SP1
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
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 Go to previous messageGo to next message
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
Dear Michel,

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
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 Go to previous message
Michel Cadot
Messages: 68728
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.

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


Current Time: Tue Dec 17 22:13:07 CST 2024