# Here is how to directly connect to an Oracle DB without setting up tnsname first.
#
# sqlplus "$DB_USER/$DB_PASS@(
#            description=
#            (
#              address_list=(
#                address=
#                  (protocol=tcp)
#                  (host=$DB_HOST)
#                  (port=$DB_PORT)))
#            (
#              connect_data=(
#                service_name=$DB_SVC))
#          )"
#
# sqlplus "$DB_USER/$DB_PASS@(
#            description=
#            (
#              address=
#                  (protocol=tcp)
#                  (host=$DB_HOST)
#                  (port=$DB_PORT))
#            (
#              connect_data=(
#                service_name=$DB_SVC))
#          )"

DB_USER=
DB_PASS=
DB_HOST=
DB_PORT=
DB_SVC=

sqlplus "$DB_USER/$DB_PASS@(description=(address_list=(address=(protocol=tcp)(host=$DB_HOST)(port=$DB_PORT)))(connect_data=(service_name=$DB_SVC)))"

sqlplus "$DB_USER/$DB_PASS@(description=(address=(protocol=tcp)(host=$DB_HOST)(port=$DB_PORT))(connect_data=(service_name=$DB_SRVC)))"