tnsnames.ora - cws-khuntly/WebSphere GitHub Wiki

---

date: 2025-05-08 12:43:11 created: 2025-05-08 12:43:04 categories:

• WebSphere / Oracle SQL*Plus

---

Create the directory:

mkdir -pv ${HOME}/workspace/Oracle/admin

Create the tnsnames.ora file:

vi ${HOME}/workspace/Oracle/admin/tnsnames.ora

Add the appropriate entries:

dbname=

    (DESCRIPTION=

        (ADDRESS=

            (PROTOCOL=TCP)

            (HOST=${DATABASE_HOST_FQDN})

            (PORT=${DATABASE_HOST_PORT})

        )

        (CONNECT_DATA=

            (SERVICE_NAME=${ORACLE_SERVICE_NAME})

        )

    )

Export the TNS_ADMIN variable:

declare -x TNS_ADMIN="${HOME}/workspace/Oracle/admin"