oracle password has $ character in it

ratikmishra1 · Post by **ratikmishra1** » Tue Mar 06, 2007 10:13 am

Oracle enterprise stage is failing to connect to the database if the password has a $ character in it.

I tried "$DS_ENABLE_RESERVED_CHAR_CONVERT = True" hoping that this column level setting would also work for the password. But that did not work.

I am setting the user id, password for the connection. I am getting the following error message
"Incorrect dboption list; it failed on Expected "," or "}", got: "$", line 1."

Will appreciate any help.

Thanks
Rati

DSguru2B · Post by **DSguru2B** » Tue Mar 06, 2007 10:17 am

You need to enclose your password within quotes. Before that you need to apply a patch. Refer herefor an ECASE number.

ratikmishra1 · Post by **ratikmishra1** » Tue Mar 06, 2007 3:59 pm

Thanks for your help. I will rather pick a fight with DBAs to change the password.

DSguru2B · Post by **DSguru2B** » Tue Mar 06, 2007 4:00 pm

Whatever sails your boat