Skip to Main Content

Connecting to XE database

Eslam_ElbyalyNov 26 2022 — edited Nov 26 2022

Hi.
I am on Oracle Developer suite 10g. I am trying to connect Oracle Reports to Oracle db XE 18c.

Here's is my tnsnames.ora files...
1- XE db
-------------------
# tnsnames.ora Network Configuration File: D:\app\product\18.0.0\dbhomeXE\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_XE =
(ADDRESS = (PROTOCOL = TCP)(HOST = Eslam-PC)(PORT = 1521))

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

2- Dev suite
-----------------
# tnsnames.ora Network Configuration File: D:\DevSuiteHome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Eslam-PC)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
-------------
When I try to connect, I get the following errors:
Unable to connect to the specified database.
TNS: could not resolve the connect identifier specified.

P.S. I have another 10g database enterprise edition installed. But it's service and listener start manually. And I did not start them.

Comments
Post Details
Added on Nov 26 2022
1 comment
12 views