TNS-12545 of Oracle for Windows monitoring issues

Operating system version: Windows Server 2012R2

Database version: Oracle 11.2.0.1

Problem Description: A Windows Server 2012R2 built on a VMware virtual machine, and then the Oracle 11.2.0.1 installed on Windows SERVER2012R2, would have wanted to test Oracle

The latest set of CPU patches for Oracle 11.2.0.1 can not be in the Windows SERVER2012R2 operating system, did not expect to finish patching, restart the Oracle database service, view

Monitor status times wrong, error is as follows:

Microsoft Windows [version 6.3.9600]
(c) Microsoft Corporation. All rights reserved.
C:\users\administrator>lsnrctl status
Lsnrctl for 64-bit windows:version 11.2.0.1.0-production on 1 September-December-2017 09:15:39
Copyright (c) 1991, Oracle. All rights reserved.
Connecting to (Description= (address= (protocol=tcp) (Host=win-0qkpvtn4sb8.localdomain
) (port=1521)))
TNS-12545: Connection failed because the target host or object does not exist
TNS-12560:TNS: Protocol Adapter error
TNS-00515: Connection failed because the target host or object does not exist
64-bit Windows Error:1001:unknown Error
Connecting to (Description= (address= (PROTOCOL=IPC) (key=extproc1521))
Tns-12541:tns: No listening program
TNS-12560:TNS: Protocol Adapter error
TNS-00511: No listening program
64-bit Windows error:2: No such file or directory

    Process:

View the database instance state, the DB instance is open
C:\users\administrator>sqlplus/as sysdba
sql*plus:release 11.2.0.1.0 Production on Tuesday December 09:16:16
Copyright (c) 1982, oracle.  All rights reserved.
Connect to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
with the partitioning, OLAP, Data Mining and Real Application testing options
Sql> select Open_mode from V$database;
Open_mode
--------------------
READ WRITE
Sql>

Check the database listening service status and discover that the monitoring service is running:

Check the operating system name according to the listening error message:

Check the monitoring error again:

found that the monitoring error is because the host name in the listening configuration file is Win-0qkpvtn4sb8.localdomain, verify that the listener configuration file as an error prompt:

By listening to the profile content, it is true that Win-0qkpvtn4sb8.localdomain, attempting to modify the host in the listening configuration file to Win-0qkpvtn4sb8, again

Start the listener and the listener will start successfully:

C:\users\administrator>lsnrctl start
Lsnrctl for 64-bit windows:version 11.2.0.1.0-production on 1 September-December-2017 09:21:43
Copyright (c) 1991, Oracle. All rights reserved.
Start Tnslsnr: Please wait ...
Tnslsnr for 64-bit windows:version 11.2.0.1.0-production
System parameter file is C:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
Log information written to C:\oracle\diag\tnslsnr\WIN-0QKPVTN4SB8\listener\alert\log.xml
Monitoring: (Description= (Address= (protocol=tcp) (HOST=WIN-0QKPVTN4SB8) (port=1521)))
Monitoring: (Description= (Address= (PROTOCOL=IPC) (PIPENAME=\\.\PIPE\EXTPROC1521IPC)))
Connecting to (Description= (address= (protocol=tcp) (HOST=WIN-0QKPVTN4SB8) (port=1521))
The STATUS of LISTENER
------------------------
Alias LISTENER
Version Tnslsnr for 64-bit windows:version 11.2.0.1.0-produ
Ction
Start date 1 September-December-2017 09:21:44
Uptime 0 days 0 hours 0 minutes 1 seconds
Trace level off
Security On:local OS Authentication
SNMP OFF
Listener parameter File C:\oracle\product\11.2.0\dbhome_1\network\admin\listen
Er.ora
Listener log File c:\oracle\diag\tnslsnr\WIN-0QKPVTN4SB8\listener\alert\
Log.xml
Listener Endpoint Summary ...
(Description= (address= (protocol=tcp) (HOST=WIN-0QKPVTN4SB8) (port=1521)))
(Description= (address= (PROTOCOL=IPC) (PIPENAME=\\.\PIPE\EXTPROC1521IPC)))
Service Summary:
The service "Clrextproc" consists of 1 instances.
The instance "Clrextproc", State UNKNOWN, contains 1 handlers for this service ...
Command execution succeeded
C:\users\administrator>

C:\users\administrator>sqlplus/as SYSDBA
Sql*plus:release 11.2.0.1.0 Production on Tuesday December 19 09:21:54 2017
Copyright (c) 1982, Oracle. All rights reserved.
Connect to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options
Sql> alter system register;
The system has changed.
Sql> quit
From Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options Disconnect
C:\users\administrator>lsnrctl status
Lsnrctl for 64-bit windows:version 11.2.0.1.0-production on 1 September-December-2017 09:22:06
Copyright (c) 1991, Oracle. All rights reserved.
Connecting to (Description= (address= (protocol=tcp) (HOST=WIN-0QKPVTN4SB8) (port=1521))
The STATUS of LISTENER
------------------------
Alias LISTENER
Version Tnslsnr for 64-bit windows:version 11.2.0.1.0-produ
Ction
Start date 1 September-December-2017 09:21:44
Uptime 0 days 0 hours 0 minutes 21 seconds
Trace level off
Security On:local OS Authentication
SNMP OFF
Listener parameter File C:\oracle\product\11.2.0\dbhome_1\network\admin\listen
Er.ora
Listener log File c:\oracle\diag\tnslsnr\WIN-0QKPVTN4SB8\listener\alert\
Log.xml
Listener Endpoint Summary ...
(Description= (address= (protocol=tcp) (HOST=WIN-0QKPVTN4SB8) (port=1521)))
(Description= (address= (PROTOCOL=IPC) (PIPENAME=\\.\PIPE\EXTPROC1521IPC)))
Service Summary:
The service "Clrextproc" consists of 1 instances.
The instance "Clrextproc", State UNKNOWN, contains 1 handlers for this service ...
The service "ORCL" consists of 1 instances.
Instance "ORCL", state ready, contains 1 handlers for this service ...
The service "Orclxdb" consists of 1 instances.
Instance "ORCL", state ready, contains 1 handlers for this service ...
Command execution succeeded
C:\users\administrator>

To this issue is a satisfactory solution, but why the listener configured host name is Win-0qkpvtn4sb8.localdomain, and listen to start also reported wrong TNS-12545, very strange.

In addition, the network said that the monitoring configuration program in the host name after the change to an IP address, do not want to modify this must be possible, but the problem is that the database server hostname is generally not modified

, but the chances of IP being modified are mostly, if the host of the listening configuration is modified to IP, the server will change the IP address, and the database listening configuration file should be modified, which is not good for maintenance.

TNS-12545 of Oracle for Windows monitoring issues