Actually i post this problem here not in the application forum because i think that this is a pure DBA task.

The problem is :

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 !!!!!

ok .. we can see the problem together

please do this steps :

1- copy the sqlnet.ora to sqlnet.ora.org ( backup of this file )
2- open sqlnet.ora and remove the lines :
SQLNET.AUTHENTICATION_SERVICES= (None)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10

and so add the following lines :
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

3- try to change the password agian and past the result

Dear ayman
first, thank you for your replay.

second, If I do your changes to the SQLNET.ora file then the connection as sysdba will be controled by the Operating System authentication !!! so if I type

$SQLPLUS anything/anything as sysdba
SQL>sho user
USER is "SYS"

Actually, I can type

$SQLPLUS / as sysdba
SQL>sho user
USER is "SYS"

I think this will not solve our problem ...
I hope you get my point

thanks,

ok dear

can i ask about your OS?

My OS is RHEL4

Oracle Unbreakable linux

ok let's see the following :

1- remote_login_passwordfile parameter
2- O7_DICTIONARY_ACCESSIBILITY parameter
3- if the user in dba group or not ?

the answers are :

* the remote_login_passwordfile parameter is set to exclusive.
* O7_DICTIONARY_ACCESSIBILITY =false
* I am sure that the user is a member in the DBA group caues i am already able to connect as sys withe the OS authentication ...

thanks in advance

regards,
mohamed

Ok Dear Mohamed

i am interesting to know the reason

- do you have apassword file?

sorry for MSN Messenger . we can do it here . and here we will have More replies from our professional brothers

Dear All,

I find the solution for the problem:

* I find that the application database is created without a password file so when i type:

SQL>select * from v$pwfile_users; 

The result is "no row selected"

and then i create a new password file .......!!

I hope this solution may help others who may face the same problem.

Regards,
Mohamed Adel

yes brother .

i feel that the problem in the paaaword file .. i asked you about it .. :angry:

i am so happy for solving it .

Dear aiman

Thanks for your help

I wish you a good day

Regards,
mohame

d

الأخ / molazwm
الاخ / aiman_g

اشكركما لحسن ادارة الموضوع .. وتحليل المشكلة ثم عرض الحل

جزاكما الله كل خير

جزانا و اياك أخى

انه تواضع منكم .. و ما هذا الا ما تعلمنا من اخواننا هنا فى المنتدى

فكلنا نستفيد من اخواننا هنا لكى نستطيع أن نفيد فيما بعد .. و الله المستعان

أرجوكم شرح هده الأسطر في SQLNET.ORA

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

ماهي القيم الممكنة عوض (NTS)