Home » RDBMS Server » Security » password problem...?..urgent plss
icon9.gif  password problem...?..urgent plss [message #113361] Fri, 01 April 2005 11:24 Go to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

my question is that ....
I created one password file to change the password of sysdba ....but now i m able to connect with both the password. .

& if i connect to database as sysdba as below without giving any password in password field i am connected to the database

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 10g Release 10.1.0.2.0 - Production



Note:- [1]
NAME TYPE VALUE
------------------------- ------------- -------------
remote_login_passwordfile string EXCLUSIVE

Note:- [2] I had deleted the original password file

In DBA_users i can see user sys is there....

tell me what should i do..

please help....i need only one password for sysdba

sunil

Report message to a moderator

Re: password problem...?..urgent plss [message #113373 is a reply to message #113361] Fri, 01 April 2005 12:24 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
is this windows?
First read docs.
>>if i connect to database as sysdba as below without giving any password in password field i am connected to the database

There might be many reasons for this.
always shutdown the database and recreate the passwordfile.
check your sqlnet.ora and comment any entry like

SQLNET.AUTHENTICATION_SERVICES


>>Note:- [2] I had deleted the original password file
>>In DBA_users i can see user sys is there....
If you delete passwordfile, it doesnt mean that you are deleting the sys user.

Report message to a moderator

Previous Topic: Restricting Form Items based on user
Next Topic: unable to write to audit file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 21 11:34:22 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.