Hi,
I have recently installed Oracle 18c XE.
lsnrctl status:
LSNRCTL for 64-bit Windows: Version 18.0.0.0.0 - Production on 13-APR-2021 17:12:58
Copyright (c) 1991, 2018, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 18.0.0.0.0 - Production
Start Date 13-APR-2021 15:08:37
Uptime 0 days 2 hr. 4 min. 20 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oracle\product\18.0.0\dbhomeXE\network\admin\listener.ora
Listener Log File C:\oracle\product\18.0.0\diag\tnslsnr\xxxxxxxx\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 2 handler(s) for this service...
The command completed successfully
SQLPLUS works:
sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Tue Apr 13 17:15:19 2021
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
SqlDeveloper not:
In the \listener\alert\log.xml:
<msg time='2021-04-13T17:20:24.895+02:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='XXXXXXXX'
host_addr='fe80::901f:608c:d:942b%27' pid='137476'>
<txt>13-APR-2021 17:20:24 * (CONNECT_DATA=(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=XXXXXXX))(SERVICE_NAME=XE)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=61518)) * establish * XE * 12514
</txt>
</msg>
<msg time='2021-04-13T17:20:24.896+02:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='XXXXXXXX'
host_addr='fe80::901f:608c:d:942b%27' pid='137476'>
<txt>TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
</txt>
</msg>
listener.ora:
# listener.ora Network Configuration File: C:\oracle\product\18.0.0\dbhomeXE\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
DEFAULT_SERVICE_LISTENER = XE
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oracle\product\18.0.0\dbhomeXE)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\oracle\product\18.0.0\dbhomeXE\bin\oraclr18.dll")
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oracle\product\18.0.0\dbhomeXE)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\oracle\product\18.0.0\dbhomeXE\bin\oraclr18.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
tnsnames.ora:
# tnsnames.ora Network Configuration File: C:\oracle\product\18.0.0\dbhomeXE\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
XE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = XE)
)
)
LISTENER_XE =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
Is there something I need to set or configure for this to work?