Using a script lookup to query data in an external Oracle database source encounters errors with the Oracle credentials. The credentials used for authentication are saved to a text file and encrypted with the Symantec DLP Credential Utility. For some environments it is a requirement that the Oracle password contains a special character however some special characters in the password fail the authentication process after being encrypted.
You can check the Tomcat localhost log and the Oracle listener.log (use “lsnrctl status” to find out where the log is hiding) for potential errors related to your lookup plugin, for more information please review your admin guide and contact our Enterprise Support for technical assistance.
Oracle advises avoidance of “#” and “$” usually due to their use of these characters in naming of objects, at least for “$” (for example, “v$instance”)…
The use of special characters in credentials for authentication similar to the following list might encounter such problems