KB46208: "syntax error near unexpected token `('" error message is encountered when trying to create an Oracle DSN using the console version of the Connectivity Wizard on UNIX/Linux in MicroStrategy 9.x & 10.x

SYMPTOM:
 
The following error is encountered when trying to create an Oracle DSN using the console version of the Connectivity Wizard on UNIX/Linux in Strategy 9.x & 10.x:
 

syntax error near unexpected token `('

 
CAUSE:
 
This error message is encountered when there is a syntax error in the command being used to create the Oracle DSN.
 
ACTION:
 
Ensure that the syntax is correct. Oracle DSNs can be created by using the following syntax:

mstrconnectwiz ORCLW DataSourceName HostName (SID | -sname:ServiceName) PortNumber 

 
The following syntax is used to specify Alternate Servers:

HostName=hostvalue:PortNumber=portvalue:{SID=sidvalue |ServiceName=servicevalue}

 
For example:

mstrconnectwiz ORCLW new_oracle_DSN DB1_server_name -sname:ORCL 1526 -u:dm_owner -p:my_password -alt:'(HostName=DB2_server_name:PortNumber=1526:ServiceName=ORCL)' 

 
 
 
 

KB46208