| connect database without password [message #146623] |
Fri, 11 November 2005 09:51  |
gjayasekar
Messages: 45
Registered: October 2005
|
Member |
|
|
Hi,
1. How to connect with database without password because password is unknown
2.here cannot change the password for the user because one application is running on particular user
3.is there any way to find out the password
please suggest me
Thanks
jai
|
|
|
|
| Re: connect database without password [message #146640 is a reply to message #146623] |
Fri, 11 November 2005 14:48  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
As a user of database u cannot connect to the database without giving password. because user password is maintain in data dictionary.
Now as a DBA (i.e. sys user) you can connect to the database without giving password. If there is operating system (i.e. o/s)authentication.
you can try this way to connect to your database
oracle_home\bin>sqlplus "sys\change_on_install@sid as syda"
sid--> means your instance name (suppose if instance name is IBM) then
oracle_home\bin>sqlplus "sys\change_on_install@IBM as syda"
secondly without connecting as dba you will not be able to change the password of database users.
As per your third question i want to tell you there is no way to find out the password of dba, but u can recreate new password file which authenticate dba, note:-before that you have remove your already present passwordfile .
regards
Always friend sunilkumar
[Updated on: Fri, 11 November 2005 14:52] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
