Oracle connection using sqlplus statement

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)))

Have more questions? Submit a request

0 Comments

Article is closed for comments.