Home » RDBMS Server » Server Administration » ORA-01918: user 'HR' does not exist
ORA-01918: user 'HR' does not exist [message #684226] Mon, 26 April 2021 04:04 Go to next message
dancko
Messages: 101
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
Can Anyone help me, please?

[Updated on: Mon, 26 April 2021 04:06]

Report message to a moderator

Re: ORA-01918: user 'HR' does not exist [message #684228 is a reply to message #684226] Mon, 26 April 2021 04:12 Go to previous messageGo to next message
Michel Cadot
Messages: 67918
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The user does not exist on the database you are connected, this is a fact whatever you think, Oracle is too dumb to lie.

Re: ORA-01918: user 'HR' does not exist [message #684230 is a reply to message #684228] Mon, 26 April 2021 04:27 Go to previous messageGo to next message
dancko
Messages: 101
Registered: June 2013
Location: italy
Senior Member
Sorry, why then am I able to connect whit sql developer to HR user on the same machine?
Is it possible that there are two different database on prebuilt machine? Very strange.

  • Attachment: Cattura.JPG
    (Size: 50.73KB, Downloaded 167 times)
Re: ORA-01918: user 'HR' does not exist [message #684233 is a reply to message #684230] Mon, 26 April 2021 04:51 Go to previous messageGo to next message
dancko
Messages: 101
Registered: June 2013
Location: italy
Senior Member
Hi to all,

I understand and resolved the problem
Effectively on Big Data oracle prebuilt machine there are two different SID and on the SID that sqlplus was connected was different from the sql developer connection SID.

[Updated on: Mon, 26 April 2021 04:52]

Report message to a moderator

Re: ORA-01918: user 'HR' does not exist [message #684234 is a reply to message #684233] Mon, 26 April 2021 05:15 Go to previous message
Michel Cadot
Messages: 67918
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Thumbs Up

Previous Topic: Export and Import of huge schemas
Next Topic: Grant Select rights
Goto Forum:
  


Current Time: Fri Jul 23 11:14:29 CDT 2021