Hi,
I try to connect via SQL DEVELOPER and:
Code:
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=UiuFEMUZSgirJh1QQoR0hw==)
listener.ora:
Code:
DEFAULT_SERVICE_LISTENER = XE
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myubuntu)(PORT = 1539))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
tnsnames.ora
Code:
# tnsnames.ora Network Configuration File: /opt/oracle/product/18c/dbhomeXE/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_XE =
(ADDRESS = (PROTOCOL = TCP)(HOST = myubuntu)(PORT = 1539))
systemctl status oracle-xe-18c.service
Code:
● oracle-xe-18c.service - SYSV: This script is responsible for taking care of configuring the RPM Oracle XE D>
Loaded: loaded (/etc/init.d/oracle-xe-18c; generated)
Active: active (exited) since Thu 2021-04-08 18:01:17 -05; 55min ago
Docs: man:systemd-sysv-generator(8)
Process: 15882 ExecStart=/etc/init.d/oracle-xe-18c start (code=exited, status=0/SUCCESS)
Apr 08 18:01:12 myubuntu systemd[1]: Starting SYSV: This script is responsible for taking care of configuring>
Apr 08 18:01:12 myubuntu oracle-xe-18c[15882]: Starting Oracle Net Listener.
Apr 08 18:01:12 myubuntu su[15889]: (to oracle) root on none
Apr 08 18:01:12 myubuntu su[15889]: pam_unix(su:session): session opened for user oracle by (uid=0)
Apr 08 18:01:15 myubuntu oracle-xe-18c[15882]: Oracle Net Listener started.
Apr 08 18:01:15 myubuntu oracle-xe-18c[15882]: Starting Oracle Database instance XE.
Apr 08 18:01:15 myubuntu su[16019]: (to oracle) root on none
Apr 08 18:01:15 myubuntu su[16019]: pam_unix(su:session): session opened for user oracle by (uid=0)
Apr 08 18:01:17 myubuntu oracle-xe-18c[15882]: Oracle Database instance XE started.
Apr 08 18:01:17 myubuntu systemd[1]: Started SYSV: This script is responsible for taking care of configuring >
Help me, please. Thanks.
Bookmarks