OraFAQ Forum: Security » ORA-01917: user or role does not exist

Home » RDBMS Server » Security » ORA-01917: user or role does not exist (oracle 10g Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01917: user or role does not exist [message #609995]

Sat, 15 March 2014 09:21

rashaDBA
Messages: 3
Registered: March 2014

Junior Member

Hello everyone...
i am new to this forum and also to oracle world. i want to be a dba and want to get some useful knowledge and resolving error tips from your side.. so please help me out..

i made a password file.
for eg
orapwd file=xyz password=xyz entries=20;
now i have one confusion of where to write this command ( on cmd(linux)or after exporting your database)

after it got created i tried granting privileges
i conn as sysdba
grant sysdba to xyz
now i am getting an error..

ERROR at line 1:
ORA-01917: user or role 'xyz' does not exist...

Report message to a moderator

Re: ORA-01917: user or role does not exist [message #609997 is a reply to message #609995]

Sat, 15 March 2014 09:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Learn to Read The Fine Manual

http://www.oracle.com/pls/db121/search?word=orapwd

[oracle@localhost ~]$ oerr ora 1917
01917, 00000, "user or role '%s' does not exist"
// *Cause: There is not a user or role by that name.
// *Action: Re-specify the name.

Report message to a moderator

Re: ORA-01917: user or role does not exist [message #609998 is a reply to message #609995]

Sat, 15 March 2014 09:42

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

The syntax you are using requires that the user as already been created; you need to study the create user command.

Report message to a moderator

Re: ORA-01917: user or role does not exist [message #609999 is a reply to message #609997]

Sat, 15 March 2014 09:42

rashaDBA
Messages: 3
Registered: March 2014

Junior Member

thanks sir..
but i created one..
please make it clear..where do we create a password file.. on cmd prompt??

Report message to a moderator

Re: ORA-01917: user or role does not exist [message #610000 is a reply to message #609999]

Sat, 15 March 2014 09:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

The password file has NOTHING to do with creating any USER or ROLE

the password file is NOT required to open, logon, or use any Oracle DB.

Report message to a moderator

Re: ORA-01917: user or role does not exist [message #610001 is a reply to message #610000]

Sat, 15 March 2014 09:49

rashaDBA
Messages: 3
Registered: March 2014

Junior Member

[oracle@oracle10g ~]$ orapwd file=rashu password=bush entries=20;
[oracle@oracle10g ~]$ export oracle_sid=orcl
[oracle@oracle10g ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Mar 15 20:18:43 2014

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> grant sysdba to rashu;
grant sysdba to rashu
*
ERROR at line 1:
ORA-01917: user or role 'RASHU' does not exist

Report message to a moderator

Re: ORA-01917: user or role does not exist [message #610002 is a reply to message #610001]

Sat, 15 March 2014 09:55

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

Please read our OraFAQ Forum Guide and please read How to use [code] tags and make your code easier to read
You have already been pointed to the syntax for creating a user.
You will never achieve your stated ambition of working in database administration if you ignore advice.

Report message to a moderator

Re: ORA-01917: user or role does not exist [message #610003 is a reply to message #610002]

Sat, 15 March 2014 10:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Sat Mar 15 08:01:00 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> grant sysdba to rashu;
grant sysdba to rashu
                *
ERROR at line 1:
ORA-01917: user or role 'RASHU' does not exist


SQL> create user rashu identified by ID10T;

User created.

SQL> grant sysdba to rashu;

Grant succeeded.

SQL>

Report message to a moderator

Re: ORA-01917: user or role does not exist [message #610004 is a reply to message #610003]

Sat, 15 March 2014 10:12

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

You are typing three words more than necessary:

orclz>
orclz> grant sysdba to rashu;
grant sysdba to rashu
                *
ERROR at line 1:
ORA-01917: user or role 'RASHU' does not exist


orclz> grant sysdba to rashu identified by ID10T;

Grant succeeded.

orclz>

[Updated on: Sat, 15 March 2014 10:12]

Report message to a moderator

Previous Topic:	Reset Database vault owner password
Next Topic:	How to restrict schema access to specfic IP address

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 19:03:17 CST 2025