Hello,
A month or so ago I downloaded and installed the Windows 18XE database to my laptop. I was able to connect to the database via Toad. Everything was working well.
Suddenly, yesterday, I am unable to connect to the database. When I try to connect with my username to the PDB XEPDB1 I receive the following error message from Toad.
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Items Checked
TNS_ADMIN environment variable is defined as "C:\Oracle\instantclient_18_5\network\admin"
"C:\Oracle\instantclient_18_5\network\admin\tnsnames.ora" was located
The following connect descriptor was found for XEPDB1 in the tnsnames.ora file
XEPDB1 =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
# (HOST = HAMPTON-XPS-13.socal.rr.com)
(HOST = HAMPTON-XPS-13)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XEPDB1)
)
)
"C:\Oracle\instantclient_18_5\network\admin\sqlnet.ora" was located
NAMES.DIRECTORY_PATH specifies TNSNAMES in the sqlnet.ora file
Steps to Take
1. If the database was just started wait a few moments and try again as the database may be initializing
2. Verify that the connect descriptor for XEPDB1 has the correct SERVICE_NAME or SID component in the tnsnames.ora file
3. Verify that the listener is properly configured and that the database is registered with the listener
4. Try to ping HAMPTON-XPS-13 using the Ping button on the toolbar
5. Try to TNSPing XEPDB1 using the TNS Ping button on the toolbar
I followed the steps listed.
1. The database has been running for hours.
2. The connector descriptor has not changed. I have been able to connect to the database for weeks now.
3. I made no changes to the Listener.
4. I can ping HAMPTON-XPS-13.
5. TNSPing XPEDB1 works fine. Here is the output from TNSPing:
C:\app\LnSHa\product\18.0.0\dbhomeXE\bin>TNSPing XEPDB1
TNS Ping Utility for 64-bit Windows: Version 18.0.0.0.0 - Production on 25-JUL-2019 11:41:32
Copyright (c) 1997, 2018, Oracle. All rights reserved.
Used parameter files:
C:\Oracle\instantclient_18_5\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = HAMPTON-XPS-13) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XEPDB1)))
OK (330 msec)
When I try to connect to the database using SYSTEM I receive the same ORA-12514 error, but this time the service name is XE.
I have stopped and started both OracleServiceXE and OracleOraDB18Home1TNSListener from the Windows Services screen. Nothing changes.
When I try to stop the Listener from the Command line using "lsnrctl stop" I receive the following error messages:
LSNRCTL for 64-bit Windows: Version 18.0.0.0.0 - Production on 25-JUL-2019 11:46:30
Copyright (c) 1991, 2018, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=HAMPTON-XPS-13)(PORT=1521)))
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
64-bit Windows Error: 13: Permission denied
I don't know why I don't have permissions. I have administrator rights to my laptop.
Can anyone help me resolve this problem?
Respectfully,
Leon Hampton