| Neeraj |
Posted: Dec 26, 2007 05:27:24 AM |
Total Post: 228
Joined: Jan, 2007
|
hi,
i hav created a small database,i forgot the password of sys & system.
i changed the password of both,
so tell how to change their old password or how to get that old password back. |
|
|
 Babu |
| Posted: Dec 26, 2007 06:49:24 AM |  |
|
Total Post: 86
Joined: Oct, 2007
|
If your oracle version is 10g then try
C:\>set oracle_sid=devdb
C:\>sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Dec 26 17:20:45 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Release 10.2.0.3.0 - Production
SQL>
OR
You need to change your SYS password. Create one new password file.
Babu
|
|
|
|
|
| Neeraj |
| Posted: Dec 26, 2007 07:07:17 AM | |
|
Total Post: 228
Joined: Jan, 2007
|
i m not been able to conn sys as sysdba, it ask for password that i dont hav so how to change it.
how make password file
|
|
|
|
|
| Babu |
| Posted: Dec 26, 2007 07:27:16 AM | |
|
Total Post: 86
Joined: Oct, 2007
|
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/dba.htm#1207
|
|
|
|
|
| Mohammed Taj |
| Posted: Dec 26, 2007 07:32:32 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
As Babu Said,
you can create new password file or you can connect without password with sys user.
for this your OS user is member of ORA_DBA group or sql.authentication_services=NONE in sqlnet.ora file.
|
|
|
|
|
| MOH_DBA |
| Posted: Dec 27, 2007 02:23:05 PM | |
|
Total Post: 123
Joined: Nov, 2007
|
you can change your sys password by connecting using OS Authontication. which means.
if your OS user a memeber of DBA group you can do so.
export OR set ORACLE_SID=your_database_sid
export OR set ORACLE_HOME=your_oracle_home
sqlplus /nolog
conn /as sysdba
alter user sys identifed by your_new_password.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
