| How can change SYS password and back if we have Windows Admin account [message #406568] |
Thu, 04 June 2009 11:56  |
2884
Messages: 12
Registered: May 2009
|
Junior Member |
|
|
I can access to Windows by Administrator user, that means I can connect to Oracle DB in this server via "conn /as sysdba"
Some programs require sys password, but unfortunately I don't have sys password
Can I do like that:
- backup DB password file
- connect to DB via Windows account and reset sys password
- do some works by new sys password
- after that, recover old password file
My questions are:
- Can we have temporary sys password by that way?
- If can, which version of Oracle we can do?
Thanks
|
|
|
|
|
|
| Re: How can change SYS password and back if we have Windows Admin account [message #406571 is a reply to message #406569] |
Thu, 04 June 2009 12:02  |
2884
Messages: 12
Registered: May 2009
|
Junior Member |
|
|
| gentlebabu wrote on Thu, 04 June 2009 23:59 |
If you want sys password; Try to re-create oracle password file.
| Quote: | >>- backup DB password file
- connect to DB via Windows account and reset sys password
- do some works by new sys password
- after that, recover old password file
|
totoaly wrong; check your sqlnet.ora; Is there any parameter like sqlnet.authentication_service?
thanks
|
Yes I know of course we need to setup parameter sqlnet.authentication_service for Windows authenticate before
My question is the way to change and back old password that we don't know
|
|
|
|
|
|
|
|
|
|
|
|
| Re: How can change SYS password and back if we have Windows Admin account [message #406731 is a reply to message #406684] |
Fri, 05 June 2009 09:40 |
2884
Messages: 12
Registered: May 2009
|
Junior Member |
|
|
| JRowbottom wrote on Fri, 05 June 2009 18:30 | At a higher level, why do your programs need to connect as SYS?
There's nothing (other than shutting down and restarting the database) that they can do as sys that they can't (and should) do from a different account.
Don't use SYS for application things.
Just don't.
No - not even then.
|
My program requires sys not normal account in some special keys to restructure database
|
|
|
|
|
|
|
|
| Re: How can change SYS password and back if we have Windows Admin account [message #407265 is a reply to message #406743] |
Tue, 09 June 2009 06:37 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
You really need to have a word with your 3rd party suppliers and tell them to learn how to code properly.
I would say that if you don't know the SYS password, then that means that you aren't entitled to connect to the database as SYS, and that's the end of the matter. It's up to you at this point to convince me why I should help you to gain access to the SYS password on a database for which you don't have it.
|
|
|
|
| Re: How can change SYS password and back if we have Windows Admin account [message #407295 is a reply to message #406568] |
Tue, 09 June 2009 08:09 |
samg4ug
Messages: 33
Registered: July 2007
Location: India
|
Member |
|
|
Hi,
The setting for logging in as "/as sysdba" in windows should be like the following:
ORACLE_HOME/network/admin/sqlnet.ora file's entry: SQLNET.AUTHENTICATION_SERVICES= (NTS)
And the user that has oracle installation must be a dba user if not admin.
If these two are secured then you should be able to login as sysdba.
Once you are logged in query the dba_users table and save the password column's value. Now change the sys password and use it if it is still required even after logging in as sysdba.
Once your job is completed issue following command to reassign the old password which is unknown to you:
alter user sys identified by value 'old_password_hex_value';
I think this should work.
Regards,
Sam G
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
