Symdiag fails to connect to Database

Products

• Data Loss Prevention Core Package

Issue/Introduction

We have a requirement to run the Linux SymDiag tool with the following command 

./symdiag.run -noup -prod enforce -enforcedb <protect password>

 

SymDiag Fails to run successfully with below error:

"Error connecting to the Oracle Enforce database

Connection String: @(description=(address=(host=hostname)(protocol=tcp)(port=1528))(connect_data=(service_name=protect)))

Error message: ORA-01017: invalid username/password; logon denied"

 

The password has been verified with SQLPlus

Cause

Special Characters used in the Password (eg. $&)

Resolution

Passwords with special characters need to be wrapped in single quotes in command prompt to run SymDiag in this manner