Question: In
Oracle 12c, I was unable to create a user using the
"identified by values" clause:
SQL> CREATE USER
"TCNIEHLW2" IDENTIFIED BY VALUES 'MCJAK86199nmkaa!!!!';
CREATE USER "TCNIEHLW2" IDENTIFIED BY VALUES
'MCJAK86199nmkaa!!!!'
*
ERROR at line 1:
ORA-02153:
invalid VALUES password string
This works in Oracle 11g. How do I fix the
ORA-02153: invalid VALUES error? Even more, why has
Oracle changed this functionality?
Answer: You are correct, in
Oracle 12c, this syntax is no longer supported.
The orrr utility gives this for the ORA-02153 error:
ORA-02153: invalid
VALUES password.
Cause: An encoded
password string does not follow the VALUES clause.
Action: Place a proper encoded password
string after the VALUES clause.
dbaforums.org show this about this new 12c
functionality:
On 11.2.0.4 there was possible to create user without an
hash value, if you run:
+++++++
CREATE
USER "TCNIEHLW2" IDENTIFIED BY VALUES 'MCJAK86199nmkaa!!!!';
you have:
SQL>
select password,spare4 from user$ where name='TCNIEHLW2';
PASSWORD
------------------------------
SPARE4
-----------------------------------------------------------------
MCJAK86199nmkaa!!!!
++++++The
user should have been created with:
SQL>
CREATE USER TCNIEHLW3 IDENTIFIED BY PASS;
User
created.
SQL>
select password,spare4 from user$ where name='TCNIEHLW3';
PASSWORD
------------------------------
SPARE4
---------------------------------------------------------------
1D9A699B5B9D0A7D
S:473C0BA0C5902A87650154BE5FBFEA51AA2A92746F821C7DA10CC90B13A6
Prior to 12c the user could have been created with
IDENTIFIED BY VALUES 'MCJAK86199nmkaa!!!!' with 12c this is
no longer possible. This is an new feature in 12c introduced
so the users to be created in the right way.
Also
see:
ORA-02153 on Data Pump import
|
|
|
|
|
Oracle Training from Don Burleson
The best on site
"Oracle
training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop!
|
|
|
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright © 1996 - 2020
All rights reserved by
Burleson
Oracle ®
is the registered trademark of Oracle Corporation.
|
|
