SQL Net Configuration on the Database Server - Intergraph Smart Materials - Version 2020 (10.0) - Installation & Upgrade - Hexagon

Intergraph Smart Materials Installation (2020)

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

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

    )

    )

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

  4. Open a Command Prompt window as an administrator.

  5. Use the TNSPING utility to test connectivity (replace smat with your database name): tnsping smat

    SQLNet01

    If the connection is not established, check your sqlnet.ora and tnsnames.ora again.