Hello,
I'm using Oracle XE 18.c on a Windows 64 bit OS
In the prior version I was able to connect from one system to another with ease. With 18c I'm running into an error.
I'm trying to connect from one system to another. They have identical configurations.
On the secondary (calling) system I get the following results when I issue the tnsping command:
C:\WINDOWS\system32>tnsping PrimarySystem1
TNS Ping Utility for 64-bit Windows: Version 18.0.0.0.0 - Production on 20-MAY-2019 10:14:49
Copyright (c) 1997, 2018, Oracle. All rights reserved.
Used parameter files:
C:\app\product\18.0.0\dbhomeXE\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = myhost.mydomain.com) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xepdb1)))
TNS-12541: TNS:no listener
On the secondary (calling) system the contents of sqlnet.ora are:
# sqlnet.ora Network Configuration File: C:\app\product\18.0.0\dbhomeXE\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
When I run lsnrctl stat on the primary (called) system I get the results:
C:\app\product\18.0.0\dbhomeXE\bin>lsnrctl stat
LSNRCTL for 64-bit Windows: Version 18.0.0.0.0 - Production on 20-MAY-2019 10:03:45
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 20-MAY-2019 08:29:42
Uptime 0 days 1 hr. 34 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\app\product\18.0.0\dbhomeXE\network\admin\listener.ora
Listener Log File C:\app\product\18.0.0\diag\tnslsnr\ParishServer1\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=127.0.0.1)(PORT=5500))(Security=(my_wallet_directory=C:\APP\PRODUCT\18.0.0\admin\XE\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "44efef2f77cc44bfa0eadd23f5997842" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "xepdb1" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\app\product\18.0.0\dbhomeXE\bin>
It seems that the listener is running on the primary (called) system and the listener has a service of "xepdb1" running. I don't know what I'm doing wrong. Do you have an idea why the secondary (calling) system thinks that the listener is not running on the primary (called) system?
Ultimately I'm trying to login as a user on the primary system. That user was created in the container XEPDB1.
Thanks for looking at this.