-
Copy the sqlnet.ora and tnsnames.ora files from the %SMAT_DB_InstallFolder%\samples\useful\ folder to your %18c_Oracle_Database_Home%\network\admin folder.
-
Modify the tnsnames.ora file in the %18c_Oracle_Database_Home%\network\admin as follows (replace SMAT with your database name, and Your_Servername with the name of your database server):
SMAT.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = Your_Servername)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = SMAT)
(GLOBAL_NAME = SMAT.world)
)
)
-
Open the Services tab and click Refresh.
Check if the OracleOraDB18Home1TNSListener and the OracleServicesmat are running.
The service name might differ depending on your database SID.
-
Open a Command Prompt window as an administrator.
-
Use the TNSPING utility to test connectivity (replace smat with your database name): tnsping smat
If the connection is not established, check your sqlnet.ora and tnsnames.ora again.