OraFAQ Forum: Security » Cannot change the password for the user sys

Home » RDBMS Server » Security » Cannot change the password for the user sys

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

Cannot change the password for the user sys [message #255771]

Wed, 01 August 2007 13:38

molazwm
Messages: 4
Registered: August 2007

Junior Member

Cannot change the password for the user sys in the Oracle application R12

i want to change the default password for the user sys
my sqlnet.ora contains this line

SQLNET.AUTHENTICATION_SERVICES= (None)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10
so i made this steps to change the password:

Code: [Select all] [Show/ hide]

$sqlplus sys/change_on_install as sysdba 
ERROR: 
ORA-01031: insufficient privileges

"you can see that the default password does not work"

so i try to make the sqlnet.ora to be like that

#SQLNET.AUTHENTICATION_SERVICES= (None)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10

and i try to use the OS AUTHENTICATION :

Code: [Select all] [Show/ hide]

$sqlplus "/ as sysdba" 

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jul 29 15:27:34 2007 

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

Connected to: 
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production 
With the Partitioning, OLAP and Data Mining options 
SQL>sho user 
USER is "SYS" 
SQL>alter user sys identified by new_pass; 
User altered. 
SQL>exit

- And then rollback SQLNET.ora changes to prevent unlegal connections :

SQLNET.AUTHENTICATION_SERVICES= (None)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10

- and try to connect with the new password

Code: [Select all] [Show/ hide]

$sqlplus sys/new_pass as sysdba 
ERROR: 
ORA-01031: insufficient privileges

I changed the system password successfully and after i connect as system i try to change the sys password but it does not work also.

I do not know what to do .....?????
can you help me !!!!!

Report message to a moderator

Re: Cannot change the password for the user sys [message #255772 is a reply to message #255771]

Wed, 01 August 2007 13:41

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

It should work.
Create another password file.

Report message to a moderator

Re: Cannot change the password for the user sys [message #255775 is a reply to message #255771]

Wed, 01 August 2007 13:59

molazwm
Messages: 4
Registered: August 2007

Junior Member

Dear DreamzZ

Actually the application database does not have a password file
when I type

Code: [Select all] [Show/ hide]

SQL>select * from V$pwfile_users;
no row selected

I will create a new password file ,but I need the sys password to create the new password file !!!!

am I right,

regards,
molazwm

Report message to a moderator

Re: Cannot change the password for the user sys [message #255776 is a reply to message #255775]

Wed, 01 August 2007 14:14

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

I will create a new password file ,but I need the sys password to create the new password file !!!!

No

goto $ORACLE_HOME/dbs

Code: [Select all] [Show/ hide]

orapwd file=orapwdMYDB password=oracle entries=5;

Code: [Select all] [Show/ hide]

V$pwfile_users

Code: [Select all] [Show/ hide]

SQL> create user DreamzZ identified by DreamzZ;

User created.

SQL>  Grant sysdba to  DreamzZ;

Grant succeeded.

SQL>  select * from V$pwfile_users;

USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
SYS                            TRUE  TRUE
DREAMZZ                        TRUE  FALSE

Report message to a moderator

Re: Cannot change the password for the user sys [message #255779 is a reply to message #255771]

Wed, 01 August 2007 14:20

molazwm
Messages: 4
Registered: August 2007

Junior Member

Dear DreamzZ
Thanks for your replay

you said

Quote:

goto $ORACLE_HOME/dbs

orapwd file=orapwdMYDB password=oracle entries=5;

the password value (oracle) will be the new password for user sys ??? and that means i can type any value other than oracle ...right ????

regards,
molazwm

Report message to a moderator

Re: Cannot change the password for the user sys [message #255797 is a reply to message #255779]

Wed, 01 August 2007 15:12

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Yes thats Password and YOU CAN CHANGE IT accroding to your requirments and ENTRIES

Quote:

the number of database users that can be granted SYSDBA or SYSOPER. This parameter should be set to a higher value than the number of anticipated users to prevent having to delete and recreate the password file.

Report message to a moderator

Re: Cannot change the password for the user sys [message #255799 is a reply to message #255771]

Wed, 01 August 2007 15:18

molazwm
Messages: 4
Registered: August 2007

Junior Member

Dear DreamzZ,

Thank you for your help, I appreciate that .... Very Happy

regards,
molazwm

Report message to a moderator

Previous Topic:	How and where to report a vulnerability?
Next Topic:	How can I attach FGA to a schema?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 13 20:20:10 CDT 2025