نسيت كلمة السر

أخوي بركان ... اذا كنت ناسي باسوورد مستخدم عادي من المستخدمين ...... ادخل بالــ DBA

ثم اعمل الجملة التالية ...

Alter user scott identified by newPass;

شكراً

سأجربها وشكرا على الرد السريع.

السلام عليكم ....

اخي بركان انت لم تحدد اي نوع من المستخدمين .... وطريقة الاخ sql man ناجحه ..

وهناك طريقة اخرى وهي انك

وهناك طريقة الى وهي انك تذهب الى Database Configuration Assistant

وتنشء قاعده جديدة في حالة انك نسيت الباسورد DBA

يعني مايحتاج تسوي ري انستال حق الاوراكل

وهذه طريقة ارجاع الباسورد

Goal:
How to change the EM Administrator account (ias_admin) for the EM Web Site in EM 9.0.2

Environment:
Oracle Enterprise Manager 9.0.2
Oracle9iAS Release 2

Solution:
A. If you already know the current EM Administrative password for ias_admin, you can change the password from within the EM Web Site by clicking on the Preferences link on the top right-hand side of the screen.
1. You must enter the old password, the new password and confirm the new password. 
or 
You can also go to command line and issue the following syntax:
On Unix:
emctl set password <newpassword>
emctl authenticate <newpassword>
On Windows NT/2000:
emctl set password <oldpassword> <newpassword>
emctl authenticate <newpassword>
2. Restart the EMD using the emctl start command
NOTE: When issuing this first stop command, use the OLD password. Then start EMD. The new password will take effect from then on.

B. If you have forgotten the EM Administrative password for ias_admin, the solution depends on your platform. Please follow the platform specific steps below:
Windows NT / 2000:
(Per the Oracle9iAS Release 2 Addendum Release Notes, section 11.5)
The Enterprise Manager Web Site will enforce use of the current Administrator (ias_admin) password when you log in to Enterprise Manager, stop the Enterprise Manager Service, or change the ias_admin password. If you have forgotten your ias_admin password then you must reset it using the following procedure while you are logged on to your PC as the person who installed Oracle9iAS: 
1.Edit the following file and locate the line that defines the credentials property for use the ias_admin user: 
%ORACLE_HOME%\sysman\j2ee\config\jazn-data.xml
The following example shows the section of jazn-data.xml with the credentials entry in boldface type: 
<realm>
<name>enterprise-manager</name>
<users> 
<user> 
<name>ias_admin</name> 
<credentials>rJqp85BkhFwAyw9ddl0PnFlUBVaWzbfT</credentials> 
</user> 
2.Remove the entire line that contains the <credentials> property from jazn-data.xml. 
3.Enter the following command from DOS Command window: 
%ORACLE_HOME%\bin\emctl set password reset <new password>

Unix:
On unix platforms, this step is not necessary because the emctl utility does not require the old password in order to set the new password

ممكن تحدث ملف الباسورد او تنشء ملف باسورد جديد لقاعدة بيانات محددة عن طريق كوماند برومبت orapwd

ممكن يا اخ احمد تعطينل مثال على استخدام الامر السابق

اى كلمة سر تقصد

اذا كانت اللى فى البداية

scott/tiger

انا ما اشتغل على 9i

Salamo 3alykom

Mr Hussain you were explaining how to change the password in AS(APPLICATION SERVER!!!!!) I think the person wants to know the how toc ange the password in DATABASE SERVER!!!

salam

Syntax: 
------- 
When you type ORAPWD at the DOS-prompt, it will enlist the syntax to use it 
D:\> ORAPWD 
Usage: orapwd file=<fname> password=<password> entries=<users> 

where 
file - name of password file (mand), 
password - password for SYS and INTERNAL (mand), 
entries - maximum number of distinct DBA and OPERs (opt), 
There are no spaces around the equal-to (=) character. 

File: 
this option lets you specify the name of the password file. It should containt the full path, <ORACLE_HOME>\DATABASE, and be of this format 
PWD<SID>.ORA. Its content is encrypted. 

Password: 
sets the password for internal. 

Entries: 
specifies the maximum number of distinct SYSDBA and SYSOPER USERS

orapwd file=ora_home\database_name\file_name password=what entries=5