Shulou(Shulou.com)06/01 Report--

Operating system version: windows server 2012R2

Database version: oracle 11.2.0.1

Problem description: oracle 11.2.0.1, which was built on a vmware virtual machine and then installed on windows server2012R2, was intended to test oracle

Can the latest CPU patch set for oracle 11.2.0.1 be available in the windows server2012R2 operating system? unexpectedly, after the patch, restart the oracle database service, check

The monitoring status of the Times is wrong, and the error is as follows:

Microsoft Windows [version 6.3.9600]

(C) 2013 Microsoft Corporation. All rights reserved.

C:\ Users\ Administrator > lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0-Production on 19-December-2017 09:15:39

Copyright (c) 1991, 2010, 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 listener

TNS-12560: TNS: protocol adapter error

TNS-00511: no listener

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

Process:

Check the status of the database instance, which is open

C:\ Users\ Administrator > sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tuesday 19 December 09:16:16 2017

Copyright (c) 1982, 2010, 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 status of the database listening service and find that the monitoring service is running:

According to the monitoring error prompt, view the operating system name:

Check the monitor error report again:

It is found that the listening error is found because the hostname in the listening configuration file is WIN-0QKPVTN4SB8.localdomain. Verify whether the listener configuration file is as prompted by the error message:

According to the content of the listening configuration file, it is indeed WIN-0QKPVTN4SB8.localdomain. Try to change the HOST in the listening configuration file to WIN-0QKPVTN4SB8, and again

Start the listener, and the listener starts successfully:

C:\ Users\ Administrator > lsnrctl start

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0-Production on 19-December-2017 09:21:43

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

Start tnslsnr: please wait a moment.

TNSLSNR for 64-bit Windows: Version 11.2.0.1.0-Production

The system parameter file is C:\ oracle\ product\ 11.2.0\ dbhome_1\ network\ admin\ listener.ora

Write log information 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)

STATUS of LISTENER

-

Alias LISTENER

Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0-Produ

Ction

Launch date 19-December-2017 09:21:44

Normal running time 0 days, 0 hours, 0 minutes, 1 second

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

Listening Endpoint Summary.

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=WIN-0QKPVTN4SB8) (PORT=1521))

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

Service summary..

The service "CLRExtProc" contains 1 instance.

Instance "CLRExtProc", status UNKNOWN, contains 1 handler for this service.

Command executed successfully

C:\ Users\ Administrator >

C:\ Users\ Administrator > sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tuesday 19 December 09:21:54 2017

Copyright (c) 1982, 2010, 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 19-December-2017 09:22:06

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

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

STATUS of LISTENER

-

Alias LISTENER

Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0-Produ

Ction

Launch date 19-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

Listening Endpoint Summary.

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=WIN-0QKPVTN4SB8) (PORT=1521))

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

Service summary..

The service "CLRExtProc" contains 1 instance.

Instance "CLRExtProc", status UNKNOWN, contains 1 handler for this service.

The service "orcl" contains 1 instance.

Instance "orcl", status READY, contains 1 handler for this service.

The service "orclXDB" contains 1 instance.

Instance "orcl", status READY, contains 1 handler for this service.

Command executed successfully

C:\ Users\ Administrator >

This problem has been solved satisfactorily, but it is strange why the host name of the listener configuration is WIN-0QKPVTN4SB8.localdomain, and why the listener startup also reports an error TNS-12545.

In addition, it is said on the Internet that it is possible to change the host name after the HOST in the listening configuration program to the IP address, but the problem is that the host name of the database server is generally not modified.

But relatively speaking, the IP is much more likely to be modified. If you change the HOST of the listening configuration to IP, and the server changes the IP address later, you also need to modify the database listening configuration file, which is difficult to maintain.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.