A special character | in the password is NOT working in SQL job type after entering in the autosys_secure. However, it works in the manual sqlplus connection. Any idea? It is a production problem
A double quote around the password might help. We do need to quote around entire password string which has the special chars even in the manual sqlplus connection.
Kishore Kumar Udathaneni
Be very careful which special characters you use some cannot be made literal.
At command line autosys_secure -c -o ‘ ‘
Will be needed and depending on the other special character you may also need to ‘my\/character’
It all depends.. also in many releases @ is not good for oracle.. it means connect as...
Nothing in this message is intended to constitute an electronic signature unless a specific statement to the contrary is included in this message.
Confidentiality Note: This message is intended only for the person or entity to which it is addressed. It may contain confidential and/or privileged material. Any review, transmission, dissemination or other use, or taking of any action in reliance upon this message by persons or entities other than the intended recipient is prohibited and may be unlawful. If you received this message in error, please contact the sender and delete it from your computer.
The issue is now resolved.
AIG Technology Services | Compute Hosting Services,
Cell 718 902 6645
Production Operations Grp. 973-533-3000 (6-2) | AutoSys Monitoring Support # 1-973-533-3000 (6-1-3)
Retrieving data ...