Connect Oracle Database using Service Name ✍

Self-Help & Learn
,
1

Problem:

How to connect Oracle database using Service Name?

Solution:

Try below steps: :point_down:

  • Provide //host:port/servicename in database name field.

  • Remove values from Host Name and Port Number

Or try this one:

  • Provide /servicename with correct values for hostname and port fields

If connection still not established, here is a simple and effective way:

  • Select Access as ‘Native (JDBC)’

  • Leave Host Name and Port Number fields empty

  • Set ‘Database Name’ with something like below

    (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = host1-vip)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = host2-vip)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = db-service)(FAILOVER_MODE =(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5))))

Note: Provide proper values in above string.

Enjoy the automation with ☞ AutomationEdge!!