Dopo aver correttamente installato e testato Oracle XE su un Windows Server 2008, ho avuto la necessità di modificare il nome del server. In seguito a questa operazione, il processo TNS Listener di Oracle XE non è più ripartito. Vediamo come ho risolto il problema.

Il problema era legato al nome del server, che è rimasto configurato al vecchio valore sui file di configurazione di Oracle. Per verificarlo ho usato l’utility lsnrctl:

C:\Users\Administrator>lsnrctl

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 – Production on 28-AGO-2012 10:25:51

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

Welcome to LSNRCTL, type “help” for information.

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

32-bit Windows Error: 2: No such file or directory

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-U0W5G2EX0GE)(PORT=1521)))

TNS-12545: Connect failed because target host or object does not exist

TNS-12560: TNS:protocol adapter error

TNS-00515: Connect failed because target host or object does not exist

32-bit Windows Error: 1001: Unknown error

 

LSNRCTL> start

Starting tnslsnr: please wait…

TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 – Production

System parameter file is C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora

Log messages written to C:\oraclexe\app\oracle\diag\tnslsnr\elefante\listener\alert\log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))

Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-U0W5G2EX0GE)(PORT=1521)))

TNS-12545: Connect failed because target host or object does not exist

TNS-12560: TNS:protocol adapter error

TNS-00515: Connect failed because target host or object does not exist

32-bit Windows Error: 1001: Unknown error

 

Listener failed to start. See the error message(s) above…

Ho aperto il file listener.ora al path

C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora

e ho modificato il valore della variabile HOST con quello nuovo.

LSNRCTL> start

Starting tnslsnr: please wait…

 

TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 – Production

System parameter file is C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora

Log messages written to C:\oraclexe\app\oracle\diag\tnslsnr\elefante\listener\alert\log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=elefante)(PORT=1521)))

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

STATUS of the LISTENER

————————

Alias LISTENER

Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 – Production

Start Date 28-AGO-2012 10:27:34

Uptime 0 days 0 hr. 0 min. 3 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Default Service XE

Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora

Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\elefante\listener\alert\log.xml

Listening Endpoints Summary…

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=elefante)(PORT=1521)))

Services Summary…

Service “CLRExtProc” has 1 instance(s).

Instance “CLRExtProc”, status UNKNOWN, has 3 handler(s) for this service…

Service “PLSExtProc” has 1 instance(s).

Instance “PLSExtProc”, status UNKNOWN, has 1 handler(s) for this service…

The command completed successfully