Problem

Configuring Analytics with a complex jdbc url may fail as below

./configureserver --dburl=jdbc.url=jdbc:oracle:thin:@(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=on)(DESCRIPTION=(LOAD_BALANCE=on)(CONNECT_TIMEOUT=10)(RETRY_COUNT=3)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle1.test.server.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=service_apigw)))(DESCRIPTION=(LOAD_BALANCE=on)(CONNECT_TIMEOUT=10)(RETRY_COUNT=3)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle2.test.server.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=svervice_apigw)))) --dbuser=apigw --dbpass=apigw --no-email

bash: syntax error near unexpected token `('

Resolution

Place "" quotes around the jdbc url connection string e.g.

./configureserver --dburl="jdbc.url=jdbc:oracle:thin:@(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=on)(DESCRIPTION=(LOAD_BALANCE=on)(CONNECT_TIMEOUT=10)(RETRY_COUNT=3)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle1.test.server.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=service_apigw)))(DESCRIPTION=(LOAD_BALANCE=on)(CONNECT_TIMEOUT=10)(RETRY_COUNT=3)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle2.test.server.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=svervice_apigw))))" --dbuser=apigw --dbpass=apigw --no-email