Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » PlsqlDatabaseConnectString error for installation in RAC environment (Apex 3.1.2, Suse 10)
PlsqlDatabaseConnectString error for installation in RAC environment [message #383657] Thu, 29 January 2009 09:26
Messages: 1
Registered: January 2009
Junior Member
I am installing APEX 3.1.2 on 10gR2 RAC environment. I have two DB nodes. Also, I have two HTTP servers for load balancing. I run the apexins file and create database service, and modify the service to add failover attributes, change the password for admin, unlock apex public user, stop http server, and modify dads.conf file. After that I restart the HTTP server, and i can restart the server. When I checked the log, I saw following error.
/u01/oracle/PROD/Apache/Apache/bin/apachectl startssl: execing httpd
Syntax error on line 21 of /u01/oracle/PROD/Apache/modplsql/conf/dads.conf:
PlsqlDatabaseConnectString takes 1-2 arguments, Connect String to Database (SID, Service Name, TNS)

Here is my dads.conf
Alias /i/ "/u01/oracle/PROD/Apache/images/"
AddType text/xml xbl
AddType text/x-component htc
<Location /pls/apex>
Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlDatabaseConnectString (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = DBServer1)(PORT = 1522)) (ADDRESS = (PROTOCOL = TCP)(HOST = DBServer2)(PORT = 1522)) (CONNECT_DATA = (SERVICE_NAME = ServiceName) ) ) TNSNamesFormat
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDefaultPage apex
PlsqlDatabasePassword abcdefg
PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
Allow from all

I am not sure what I did wrong in PlsqlDatabaseConnectingString. I use exactly the same TNSalias that I used in the OHS machines. Please advise. Thanks.
Previous Topic: Data Conversion and Conversion Process Flow (merged 2 by LF and 4 by MC)
Next Topic: Linking Interactive Reports
Goto Forum:

Current Time: Sat Aug 13 06:33:08 CDT 2022