Perform SQL Net Configuration on the Database Server - Intergraph Smart Materials - Version 10.1 - Installation & Upgrade - Hexagon

Intergraph Smart Materials Installation (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Installation & Upgrade
Smart Materials/Smart Reference Data Version
10.1
  1. 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.

  2. 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)))

  3. Open the Services tab and click Refresh.

  4. Check if the OracleOraDB19Home1TNSListener and the OracleServiceCDB are running.

    The service name might differ depending on your database SID.

  5. Open a Command Prompt window as an administrator.

  6. 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.