 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:
$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 #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
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 |
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;
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 |
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 |
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.
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
