ORA-01017 During Logon with Password Having Special Characters
(Doc ID 2901628.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterInformation in this document applies to any platform.
Purpose
This document aims to provide reference to log on database correctly when password has special character(s).
Scope
For support personnel and end users.
NOTE: In the images and/or the document content below, the password used represents fictitious data and only for testing purpose. Any similarity to password in actual system is purely coincidental and not intended in any manner.
Please review following guidance on password in product documentation:
- Choose passwords carefully.
Minimum Requirements for Passwords describes the minimum requirements for passwords. Follow these additional guidelines when you create or change passwords:
- Make the password have a length of between 12 and 30 bytes, and include both alphabetic characters and digits in the password.
- Have the password contain at least one digit, one upper-case character, and one lower-case character.
- Use mixed case characters and special characters in the password. (See Ensuring Against Password Security Threats by Using the 12C Password Version for more information.)
- You can include multibyte characters in the password but not in the password of any common user or role.
- Use the database character set for the password's characters, which can include the underscore (_), dollar ($), and number sign (#) characters.
- You must enclose the following passwords in double-quotation marks:
- Passwords containing multibyte characters
- Passwords starting with numbers or special characters and containing alphabetic characters. For example:
"123abc"
"#abc"
"123dc$"
- Passwords containing any character other than alphabetic characters, numbers, and special characters. For example:
"abc>"
"abc@",
" "
- You do not need to specify the following passwords in double-quotation marks.
- Passwords starting with an alphabetic character (a–z, A–Z) and containing numbers (0–9) or special characters ($, #, _). For example:
abc123
ab23a
ab$#_
- Passwords containing only numbers
- Passwords containing only alphabetic characters (a–z, A–Z)
- Passwords starting with an alphabetic character (a–z, A–Z) and containing numbers (0–9) or special characters ($, #, _). For example:
- Do not include double-quotation marks within the password.
- Do not use an actual word for the entire password.
Details
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
Purpose |
Scope |
Details |
Issue 1: Password string has character '$' in the middle ('$' is not the end character)after alphabetic string |
How to set password having special characters and use it to log on database via SQLPlus ? |