Category Archives: OHS

PlsqlDatabaseConnectString takes 1-2 arguments, Connect String to Database (SID, Service Name, TNS)

If you see the error bellow it means that you haven’t configured the mod_plsql PlsqlDatabaseConnectString parameter correctly in dads.conf. There are multiple ways to configure it:

1. Connection string:

PlsqlDatabaseConnectString server_hostname:1521:DB_SID

2. TNSName entry with tnsnames.ora

PlsqlDatabaseConnectString TNS_ENTRY

For this to work you also need to have a tnsnames.ora file in OHS_HOME/network/admin/tnsnames.ora (in my case /u01/app/oracle/product/FMW/Oracle_WT/network/admin/tnsnames.ora) with the corresponding tns entry.

3. TNSNameFormat (Notice there are no spaces)

PlsqlDatabaseConnectString     (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DB_SERVICE_NAME)))

With this you can put multiple servers, create load balance, etc. as you would do with a tns entry in tnsnames.ora file.