-
Copy the sqlnet.ora and tnsnames.ora files from the %SMAT_DB_InstallFolder%\samples\useful\ folder to your %19c_Oracle_Database_Home%\network\admin folder.
-
Modify the tnsnames.ora file in the %19c_Oracle_Database_Home%\network\admin as follows (replace SMAT with your database name, and Your_Servername with the name of your database server):
CDB.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = <your servername>)(Port = 1521))
)
(CONNECT_DATA =
(SID = CDB)
)
)ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
SMAT.world = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <your servername> )(Port = 1521))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = smat)))
-
Open the Services tab and click Refresh.
-
Check if the OracleOraDB19Home1TNSListener and the OracleServiceCDB 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 cdb / smat with your database name (cdb / pdb)):
tnsping cdb
tnsping smat
If the connection is not established, check your sqlnet.ora and tnsnames.ora again.