Use of Ampersand (&) special character in DB user password
(Doc ID 2717051.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Standard Edition - Version 11.2.0.4 to 19.8.0.0.0 [Release 11.2 to 19]Information in this document applies to any platform.
Symptoms
My colleagues had to define a new password for their application this morning and they used one with this special character &. And of course they cannot connect to the schema anymore because Oracle is asking to give the value of the variable after the & character.
Find below the output of what we are getting.
$. set_enviro xe_bloom
Setting environment variable for 12.2.0.1
$sqlplus user_risk
SQL*Plus: Release 12.2.0.1.0 Production on Wed Sep 30 11:58:54 2020
Copyright (c) 1982, 2017, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
$sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Wed Sep 30 11:59:28 2020
Copyright (c) 1982, 2017, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
SQL> alter user user_risk identified by "TWwx^k8SqsH1K50&bHUBQBLCnV";
Enter value for bhubqblcnv:
As you can see in the password above there are two special characters ^ and &.
Changes
NA
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |