How to connect Oracle database using Service Name?
Try below steps:
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!!