Topic: Backup & Recovery >> password file
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Tony |
Posted: Sep 18, 2007 08:43:43 AM |
Total Post: 26
Joined: Dec, 2006
|
Hi, i have a little proble about the password file. It have made my database to be in mess in that, i cannot open my database.
This is what happened. Am running oracle on a linux operating system. I tried to open the enterprise manager console and tried to login as normal i.e username: sys, Password: Oracle, as a SYSDBA. It was doing well before. This time its not opening. I try to start it up using that the console and on logging in it refuses.
NB: When in command prompt the database is opening very well and everything is running as usual. I understand that the console uses the password file for authentication and so i decided to shutdown the database and recreate the password file using the orapwd utility and it execute very in the same location where it was and the same name.
Now here comes the mess, that even the database that was running in the command prompt is no longer running and now giving an error that the database cannot be opened due to an invalid password file.
Remember my oracleSID is traindb and the owner is user ORACLE with password ORACLE. I have never recreated the password file before. It was in its default form.
Whaen i recreated it i specified the number of entries being 20 and the password as syspass and now the file to the exact location with the same name as it was.
What should i do. Pliz with all your kind assist.
Thanks in advance.
|
|
|
 Mohammed Taj |
| Posted: Sep 18, 2007 12:37:12 PM |  |
|
Total Post: 746
Joined: Jul, 2007
|
You should use FORCE=Y in your password file scripts.
and also post exact command which your performed.
Regards
Taj
|
|
|
|
|
| Tony |
| Posted: Sep 20, 2007 04:35:32 AM | |
|
Total Post: 26
Joined: Dec, 2006
|
Thanks very much Taj, You really made my day. All i had to do was to issue the FORCE=Y key word It it was well with me and now tha database is up and running.
Taj, This is how my command was:
In the oracle home inside a folder called dbs
#> orapwd file=orapwtraindb password=oracle entries=10 force=y
Now what happens if i change the password to a different one and try to logging using the old password.
Please explain to me.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
