Post installation of 18c XE when going to SQL Developer to crate a new connection I receive the following error message when I go to test the connection.
Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
ConnectionParameters:
Role: Sysdba
Connection Type: Basic
Hostname: localhost
Port: 1521
Service Name: XEPDB1
The SQL Developer Welcome Page under databases detected also says:
C:\Oracle18c_XE\dbhomeXE\network\admin
No TNS entries found in {USER Home dir=C:\Users\Scott, ORACLE_HOME=C:\Oracle18c_XE\dbhomeXE\network\admin, Actual=C:\Oracle18c_XE\dbhomeXE\network\admin}
Results of lsnrctl status:
LSNRCTL for 64-bit Windows: Version 18.0.0.0.0 - Production on 28-JAN-2020 14:41:50
Copyright (c) 1991, 2018, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Scott-Dell-XPS8930)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 18.0.0.0.0 - Production
Start Date 28-JAN-2020 14:10:05
Uptime 0 days 0 hr. 31 min. 45 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\Oracle18c_XE\dbhomeXE\network\admin\listener.ora
Listener Log File C:\Oracle18c_XE\diag\tnslsnr\Scott-Dell-XPS8930\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Scott-Dell-XPS8930)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Contents of tnsnames.ora
# tnsnames.ora Network Configuration File: C:\Oracle18c_XE\dbhomeXE\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)
)
)
Additionally, when I go check services I only find two services running:
OracleOraDB18Home1MTSRecoveryService
OracleOraDB18Home1TNSListener
Most forum posts tend to list 5 to 6 services in total.
Tried to manually run the Database Configuration assistant in Advanced Configuration on Step 9 receive:
"[DBT-50000] Unable to check for available memory"
Ran the Database Configuration assistant with the following parameter:
dbca -J-Doracle.assistants.dbca.validate.ConfigurationParams=false
Process stopped with errors of:
1) DIM-00019:create service error. O/S Error: (OS 5) Access denied
2) ORA-12560: TNS protocol adapter error
Message was edited by: f13f7338-8747-4642-9299-5fe44e31267a
Message was edited by: f13f7338-8747-4642-9299-5fe44e31267a