Situation: If you have a sqlplus statement (as below) through which you are able to connect with Oracle Database and want to make a Database connection in AIS using this sqlPlus statement.
sqlplus 'username/password@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=portNo)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=mydb)))'
Solution: You can use below Server Url format in the Database info activity to make a Database connection:-
jdbc:oracle:thin:@(DESCRIPTION =(LOAD_BALANCE=on)(ADDRESS =
(PROTOCOL = TCP)(HOST = hostname)(PORT =
portNo))(ADDRESS = (PROTOCOL = TCP)(HOST =
hostname)(PORT = portNo))(CONNECT_DATA =(SERVER =
DEDICATED)(SERVICE_NAME = mydb)))
Comments
0 comments
Article is closed for comments.