-
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.
Sample scripts are available on the database server in %SMAT_DB_InstallFolder%\samples 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)))