بسم الله الرحمن الرحيم

أوراكل فايننشال
أخواني الأعزاء
غيرت الباسورد فقط لإسم المستخدم الرئيسي sysadmin وبعد ما عملت حفظ .
لا يمكنني أن أدخل بإسم المستخدم sysadmin بتضهر رسالة أعيد إدخال الرقم السري مرة أخرى
ولا يمكنني أن أنشيء مستخدمين جدد.

من الممكن عند تغير الباسورد للمستخدم الرئيسي يتعطل .

أخوكم وليد
[email protected]

عزيزي WALEEDAAA,

يمكنك متابعة الخطوات التالية لعمل ريست للباسورد عن طريق SQL ,وأفضل أولا أخذ نسخة من جدول FND_USER ثم عمل التغيير


1. Log in to SQL*Plus as applsys
2. Backup FND_USER and FND_ORACLE_USERID tables using
create table FND_USER_BAK as select * from FND_USER;
create table FND_ORACLE_USERID_BAK as select * from FND_ORACLE_USERID;

3. update FND_USER
set ENCRYPTED_FOUNDATION_PASSWORD ='
2DF3E509EB6A33F9607959C0976E25D997166FAB694ACDDAE466414791A44411',
ENCRYPTED_USER_PASSWORD='
D2FCA9810D86BCA9BE944D3E2E7A4A9E6CDF89AAD633179B701774083F907C13'
where user_name='SYSADMIN';

sql>commit;

The SYSADMIN password is now set to WELCOME.


وبالتوقيق
أخوك / بشر النهدي

السلام عليكم اخ بشار
للعلم قمت بتجربة فكرتك لكنها لم تنجح
فقد قمت بالاتى:
-CREATE NEW USER
-UPDATE IN THE TWO ROWS (ENCRYPTED_FOUNDATION_PASSWORD &ENCRYPTED_USER_PASSWORD
(
WITH EXISTING TWO ROWS FOR
AS NEXT:
SQL> SELECT USER_NAME,ENCRYPTED_FOUNDATION_PASSWORD,ENCRYPTED_USER_PASSWORD
2 FROM FND_USER
3 WHERE USER_NAME='SYSADMIN';

USER_NAME
--------------------------------------------------------------------------------
ENCRYPTED_FOUNDATION_PASSWORD
--------------------------------------------------------------------------------
ENCRYPTED_USER_PASSWORD
--------------------------------------------------------------------------------
SYSADMIN
ZG5F59A1F9F7071DC4113DAE8B185D06006A24038EC2905B0281D43766060F77B030745236E9C84E
37FC97FEA526691A3153
ZG8F5E367BF0E0B2EE0AB733B12A400EF4C131A91C14F93846BE6C3DB51E9519CDD62DECA40CCA01
7F3752B6AB8725CF5A99


SQL> SELECT USER_NAME,ENCRYPTED_FOUNDATION_PASSWORD,ENCRYPTED_USER_PASSWORD
2 FROM FND_USER
3 WHERE USER_NAME='TEST';

USER_NAME
--------------------------------------------------------------------------------
ENCRYPTED_FOUNDATION_PASSWORD
--------------------------------------------------------------------------------
ENCRYPTED_USER_PASSWORD
--------------------------------------------------------------------------------
TEST
DF3E509EB6A33F9607959C0976E25D997166FAB694ACDDAE466414791A444112
D2FCA9810D86BCA9BE944D3E2E7A4A9E6CDF89AAD633179B701774083F907C13


SQL> UPDATE FND_USER
2 SET ENCRYPTED_FOUNDATION_PASSWORD=
3 'ZG5F59A1F9F7071DC4113DAE8B185D06006A24038EC2905B0281D43766060F77B030745236E9C84E37FC97FEA526691A3153',
4 ENCRYPTED_USER_PASSWORD=
5 'ZG8F5E367BF0E0B2EE0AB733B12A400EF4C131A91C14F93846BE6C3DB51E9519CDD62DECA40CCA017F3752B6AB8725CF5A99'
6 WHERE USER_NAME=TEST;

1 row updated.

SQL> COMMIT;

Commit complete.
-TRY TO CONNECT TO APPLICATION WITH NEW PASSWORD AND ALSO OLD ONE
BUT DID NOT CONNECT

THANKS

عزيزي searcher
لضيق لوقت لدي وجدت هذا المقاله في دعم اواكل يمكن ان تساعدك ( لم تجربها )

أخوك /بشر النهدي
PURPOSE
-------

Document the steps to reset the APPS and APPLSYS password for Oracle
Applications 11.5 after a failed attempt to change the APPS and APPLSYS
password
has occurred.


SCOPE & APPLICATION
-------------------

Provide Application System Administrators or Database Administrators
with the
ability to reset the APPS and APPLSYS password back to the original
Oracle
default values.

The standard method of changing the APPS and APPLSYS password is
documented in
the Oracle Applications System Administrator's Guide.

Passwords in Applications are encrypted, both at the database level and
at the
application level. The APPS and APPLSYS password must always be the same

password at the database and application level (APPS /<SameWord> and
APPLSYS /
<SameWord>).



How to Reset the APPS and APPLSYS Passwords in Release 11.5
-------------------------------------------------------------
Below are the SQL statements that will help you reset the APPS and
APPLSYS
passwords to APPS, the APPLSYSPUB password to PUB, and the SYSADMIN
password to
SYSADMIN.


WARNING: This procedure will cause all user passwords to
become invalid. ALL users passwords will need to
be reset through the sysadmin responsibility.


Reset the Oracle User IDs
-------------------------------------------------------------
Open a SQL*Plus as SYSTEM and reset the passwords for the
APPS, APPLSYS, and the APPLSYSPUB Oracle user ID:

ALTER USER apps IDENTIFIED BY apps;
ALTER USER applsys IDENTIFIED BY apps;
ALTER USER applsyspub IDENTIFIED BY pub;



Backup the FND_ORACLE_USERID and FND_USER tables
-------------------------------------------------------------
Open a SQL*Plus session as APPLSYS and backup the tables:

create table FND_ORACLE_USERID_BAK as
(select * from FND_ORACLE_USERID);

create table FND_USER_BAK as
(select * from FND_USER);




Reset the APPS and APPLSYS application encrypted passwords
-------------------------------------------------------------
Open a SQL*Plus session as APPLSYS and update the
FND_ORACLE_USERID table.

update FND_ORACLE_USERID
set ENCRYPTED_ORACLE_PASSWORD =
'C4E9B59142D7A3F5C2BB0DA9C215A5C9A623EDB3473AC895876A253C0093F4E0'
where ORACLE_USERNAME in ('APPS', 'APPLSYS');
commit;

Verify the table update:

select ENCRYPTED_ORACLE_PASSWORD
from FND_ORACLE_USERID
where ORACLE_USERNAME IN ('APPS', 'APPLSYS');



Reset the APPLSYSPUB application encrypted password
-------------------------------------------------------------
Open a SQL*Plus session as APPLSYS and update the
FND_ORACLE_USERID table.

update FND_ORACLE_USERID
set ENCRYPTED_ORACLE_PASSWORD =
'D5ECA7C25E91A5C9D7D2E6C7287E73BEFB6DE76691E6CCBAD1426F611452D241'
where ORACLE_USERNAME = ('APPLSYSPUB');
commit;

Verify the table update:

select ENCRYPTED_ORACLE_PASSWORD
from FND_ORACLE_USERID
where ORACLE_USERNAME = 'APPLSYSPUB';



Reset SYSADMIN application encrypted password
-------------------------------------------------------------
Open a SQL*Plus session as APPLSYS and update the
FND_USER table.

update FND_USER
set ENCRYPTED_FOUNDATION_PASSWORD =
'3F73DF5A01B3AA52848BE530B531EB8FB734167F6D43E800ED4E6F2AEB0B1EA6',
ENCRYPTED_USER_PASSWORD=
'D6E0B6830686B0E7A28577D2DA696FF5F8570774C9A0BF980C8C28DB246D43CB'
where USER_NAME='SYSADMIN';
commit;

Verify the table update:

select ENCRYPTED_FOUNDATION_PASSWORD, ENCRYPTED_USER_PASSWORD
from FND_USER
where USER_NAME = 'SYSADMIN';


REFERENCES
----------

Note:1013526.102