| orapwd file deleted [message #291295] |
Thu, 03 January 2008 13:22  |
LaFilipina
Messages: 51
Registered: May 2007
Location: spain
|
Member |
|
|
Hi All,
I've tried to search my problem here in this forum but I didn't find one that is similar.
I have deleted orapwd file for one of our databases thinking that it's ok (I wanted to change the sys password) - I know this could be the dumbest thing ever.
The database is running fine but I am scared that when the database needs to be bounced, a problem may arise due to this.
I have created a new orapwd file but everytime I log in to the database using sys as sysdba, I am getting this error:
ERROR:
ORA-01031: insufficient privileges
If I try to alter user sys to the new password, I am getting this error:
Warning: Entry/Exit code is optimized. Cannot restore context (UNWIND 22)
alter user sys
*
ORA-03113: end-of-file on communication channel
I don't know what else to do. I also tried to issue this command:
grant sysdba to sys; but I got this message:
ERROR at line 1:
ORA-01999: password file mode has changed from 'exclusive' to 'shared'
The init.ora file indicates that the paremeter remote_login_passwordfile is in exclusive mode... so I don't understand the error.
I am hoping for your expert help once again.
Thanks and best regards,
LaFilipina
|
|
|
|
| Re: orapwd file deleted [message #291301 is a reply to message #291295] |
Thu, 03 January 2008 14:14  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
After creating new password file you still not able to connect as user sys??
Do you give password ?? like
sqlplus sys/password as sysdba??
Post the entries of your sqlnet.ora.
|
|
|
|
| Re: orapwd file deleted [message #291392 is a reply to message #291301] |
Fri, 04 January 2008 01:25 |
LaFilipina
Messages: 51
Registered: May 2007
Location: spain
|
Member |
|
|
Hi DreamsZ,
The first thing I actually did is to remove the file and create a new password file. Then I logged in to sqlplus and tried to change the password for sys. I tried several times and I keep getting the same error:
Warning: Entry/Exit code is optimized. Cannot restore context (UNWIND 22)
alter user sys
*
ORA-03113: end-of-file on communication channel
|
|
|
|
|
|
| Re: orapwd file deleted [message #291401 is a reply to message #291396] |
Fri, 04 January 2008 01:47 |
LaFilipina
Messages: 51
Registered: May 2007
Location: spain
|
Member |
|
|
Hi Michael
I can't shutdown the database right now as I would need coordination with users before I do that. I would have to wait till then. I will post here once I am able to do the following steps to say how did it go.
I didn't shutdown the database before I removed the orapwd file... did the file get corrupted because of that?
|
|
|
|
|
|
|
|
|
|
| Re: orapwd file deleted [message #291413 is a reply to message #291409] |
Fri, 04 January 2008 02:23 |
LaFilipina
Messages: 51
Registered: May 2007
Location: spain
|
Member |
|
|
makes a lot of sense!
I couldn't wait to know what will happen so I made an 8i database and did exactly what I did. I encountered the same error. Looks like this is indeed a no no for 8i databases. I performed the steps you enumerated, Michel and it seemed to have worked until the part of me issuing alter user sys identified by ***
BUT when I tried to login to sqlplus as sys I get this error:
connect sys@dbname.world / as sysdba
Enter password: ********
ERROR:
ORA-01031: insufficient privileges
I granted sys with sysdba privileges successfully but when I try to login again as sys, I get the same error... how could it be?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
