| ORA-01918: user 'HR' does not exist [message #684226] |
Mon, 26 April 2021 04:04  |
 |
dancko
Messages: 108
Registered: June 2013
Location: italy
|
Senior Member |
|
|
Hi to all
My Database version is Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production on oracle linux prebuilt virtual machine BigDataLite.
On that database I want change the password to HR user with alter user command, but I get the error: "ORA-01918: user 'HR' does not exist".
However, the HR user exists and I run queries on HR tables with the SQL Developer graphical tool, but from SqlPlus I'm not able to connect e change password to it.
Following the alter table command I type in sqlplus:
SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 26 04:47:59 2021
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter user-name: hr
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: sys /as sysdba
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> alter user HR identified by password;
alter user HR identified by password
*
ERROR at line 1:
ORA-01918: user 'HR' does not exist
[Updated on: Mon, 26 April 2021 04:06] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
