Home » RDBMS Server » Security » ORA-01917: user or role does not exist (oracle 10g Linux)
ORA-01917: user or role does not exist [message #609995] Sat, 15 March 2014 09:21 Go to next message
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...

Re: ORA-01917: user or role does not exist [message #609997 is a reply to message #609995] Sat, 15 March 2014 09:33 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
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.
Re: ORA-01917: user or role does not exist [message #609998 is a reply to message #609995] Sat, 15 March 2014 09:42 Go to previous messageGo to next message
John Watson
Messages: 4672
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.
Re: ORA-01917: user or role does not exist [message #609999 is a reply to message #609997] Sat, 15 March 2014 09:42 Go to previous messageGo to next message
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??
Re: ORA-01917: user or role does not exist [message #610000 is a reply to message #609999] Sat, 15 March 2014 09:45 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
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.
Re: ORA-01917: user or role does not exist [message #610001 is a reply to message #610000] Sat, 15 March 2014 09:49 Go to previous messageGo to next message
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
Re: ORA-01917: user or role does not exist [message #610002 is a reply to message #610001] Sat, 15 March 2014 09:55 Go to previous messageGo to next message
John Watson
Messages: 4672
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.
Re: ORA-01917: user or role does not exist [message #610003 is a reply to message #610002] Sat, 15 March 2014 10:07 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
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> 


Re: ORA-01917: user or role does not exist [message #610004 is a reply to message #610003] Sat, 15 March 2014 10:12 Go to previous message
John Watson
Messages: 4672
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:
  


Current Time: Tue Oct 21 01:24:20 CDT 2014

Total time taken to generate the page: 0.99988 seconds