Home » RDBMS Server » Security » Cannot change the password for the user sys
icon5.gif  Cannot change the password for the user sys [message #255771] Wed, 01 August 2007 13:38 Go to next message
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:

$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 :


$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



$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 !!!!!
Re: Cannot change the password for the user sys [message #255772 is a reply to message #255771] Wed, 01 August 2007 13:41 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
It should work.
Create another password file.
Re: Cannot change the password for the user sys [message #255775 is a reply to message #255771] Wed, 01 August 2007 13:59 Go to previous messageGo to next message
molazwm
Messages: 4
Registered: August 2007
Junior Member
Dear DreamzZ

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

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
Re: Cannot change the password for the user sys [message #255776 is a reply to message #255775] Wed, 01 August 2007 14:14 Go to previous messageGo to next message
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
orapwd file=orapwdMYDB password=oracle entries=5;


V$pwfile_users


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

Re: Cannot change the password for the user sys [message #255779 is a reply to message #255771] Wed, 01 August 2007 14:20 Go to previous messageGo to next message
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
Re: Cannot change the password for the user sys [message #255797 is a reply to message #255779] Wed, 01 August 2007 15:12 Go to previous messageGo to next message
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.
icon14.gif  Re: Cannot change the password for the user sys [message #255799 is a reply to message #255771] Wed, 01 August 2007 15:18 Go to previous message
molazwm
Messages: 4
Registered: August 2007
Junior Member
Dear DreamzZ,

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

regards,
molazwm
Previous Topic: How and where to report a vulnerability?
Next Topic: How can I attach FGA to a schema?
Goto Forum:
  


Current Time: Thu Mar 28 09:39:14 CDT 2024