My Oracle Support Banner

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 and later
Information in this document applies to any platform.


This document aims to provide reference to log on database correctly when password has special character(s).


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:




    • Passwords containing any character other than alphabetic characters, numbers, and special characters. For example:



                     " "

  • 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:




    • Passwords containing only numbers
    • Passwords containing only alphabetic characters (a–z, A–Z)
  • Do not include double-quotation marks within the password.
  • Do not use an actual word for the entire password.



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
 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 ?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.