|PlsqlDatabaseConnectString error for installation in RAC environment [message #383657]
||Thu, 29 January 2009 09:26
Registered: January 2009
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
PlsqlDatabaseConnectString (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = DBServer1)(PORT = 1522)) (ADDRESS = (PROTOCOL = TCP)(HOST = DBServer2)(PORT = 1522)) (CONNECT_DATA = (SERVICE_NAME = ServiceName) ) ) TNSNamesFormat
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.