The listener supports no services

C:\windows\system32>lsnrctl status listener1

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 – Production on 31-JAN-2018 17:21 :51

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PRCSGI1167L.ad. .c om)(PORT=1522))) STATUS of the LISTENER ———————— Alias listener1 Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 – Produ ction Start Date 31-JAN-2018 17:01:17 Uptime 0 days 0 hr. 20 min. 38 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File D:\app\oracle\product\12.1.0\dbhome_1\network\admin\li stener.ora Listener Log File D:\app\oracle\diag\tnslsnr\PRCSGI1167L\listener1\alert \log.xml Listening Endpoints Summary… (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PRCSGI1167L.ad. .com)(PORT=152 2))) The listener supports no services The command completed successfully

C:\windows\system32>lsnrctl reload listener1

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 – Production on 31-JAN-2018 17:21 :55

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PRCSGI1167L.ad. .c om)(PORT=1522))) The command completed successfully

C:\windows\system32>lsnrctl status listener1

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 – Production on 31-JAN-2018 17:21 :59

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PRCSGI1167L.ad. .c om)(PORT=1522))) STATUS of the LISTENER ———————— Alias listener1 Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 – Produ ction Start Date 31-JAN-2018 17:01:17 Uptime 0 days 0 hr. 20 min. 45 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File D:\app\oracle\product\12.1.0\dbhome_1\network\admin\li stener.ora Listener Log File D:\app\oracle\diag\tnslsnr\PRCSGI1167L\listener1\alert \log.xml Listening Endpoints Summary… (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PRCSGI1167L.ad. .com)(PORT=152 2))) The listener supports no services The command completed successfully

C:\windows\system32>lsnrctl status listener1

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 – Production on 31-JAN-2018 17:22 :26

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PRCSGI1167L.ad. .c om)(PORT=1522))) STATUS of the LISTENER ———————— Alias listener1 Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 – Produ ction Start Date 31-JAN-2018 17:01:17 Uptime 0 days 0 hr. 21 min. 13 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File D:\app\oracle\product\12.1.0\dbhome_1\network\admin\li stener.ora Listener Log File D:\app\oracle\diag\tnslsnr\PRCSGI1167L\listener1\alert \log.xml Listening Endpoints Summary… (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PRCSGI1167L.ad.com)(PORT=152 2))) The listener supports no services The command completed successfully

C:\windows\system32>lsnrctl reload listener1

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 – Production on 31-JAN-2018 17:22 :33

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PRCSGI1167L.ad. .c om)(PORT=1522))) The command completed successfully

C:\windows\system32>lsnrctl stop listener1

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 – Production on 31-JAN-2018 17:22 :36

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PRCSGI1167L.ad. .c om)(PORT=1522))) The command completed successfully

C:\windows\system32>lsnrctl start listener1

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 – Production on 31-JAN-2018 17:22 :45

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

Starting tnslsnr: please wait…

TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 – Production System parameter file is D:\app\oracle\product\12.1.0\dbhome_1\network\admin\lis tener.ora Log messages written to D:\app\oracle\diag\tnslsnr\PRCSGI1167L\listener1\alert\l og.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PRCSGI1167L.ad. .c om)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PRCSGI1167L.ad. .c om)(PORT=1522))) STATUS of the LISTENER ———————— Alias listener1 Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 – Produ ction Start Date 31-JAN-2018 17:22:48 Uptime 0 days 0 hr. 0 min. 6 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File D:\app\oracle\product\12.1.0\dbhome_1\network\admin\li stener.ora Listener Log File D:\app\oracle\diag\tnslsnr\PRCSGI1167L\listener1\alert \log.xml Listening Endpoints Summary… (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PRCSGI1167L.ad. .com)(PORT=152 2))) Services Summary… Service “CLRExtProc” has 1 instance(s). Instance “CLRExtProc”, status UNKNOWN, has 1 handler(s) for this service… Service “ORCL” has 1 instance(s). Instance “ORCL”, status UNKNOWN, has 1 handler(s) for this service… The command completed successfully

C:\windows\system32>SQLPLUS system/In111123@orcl1

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 31 17:23:11 2018

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Last Successful login time: Wed Jan 31 2018 17:13:25 +08:00

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt ions

SQL> quit Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64 bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt ions

C:\windows\system32>

# listener.ora Network Configuration File: D:\app\oracle\product\12.1.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = PRCSGI1167L.ad.i.com)(PORT = 1522))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\app\oracle\product\12.1.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\oracle\product\12.1.0\dbhome_1\bin\oraclr12.dll") 
    )
	(SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = D:\app\oracle\product\12.1.0\dbhome_1)
      (SID_NAME = ORCL)
    )
  )

SID_LIST_LISTENER1 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\app\oracle\product\12.1.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\oracle\product\12.1.0\dbhome_1\bin\oraclr12.dll") 
    )
	(SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = D:\app\oracle\product\12.1.0\dbhome_1)
      (SID_NAME = ORCL)
    )
  )  
  
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = PRCSGI1167L.ad.i.com)(PORT = 1521))
    )
  )

# tnsnames.ora Network Configuration File: D:\app\oracle\product\12.1.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = PRCSGI1167L.ad.i.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )

ORCL1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = PRCSGI1167L.ad.i.com)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )

Similar Posts: