OraFAQ Forum: Server Administration » Password file and sysdba

Home » RDBMS Server » Server Administration » Password file and sysdba

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Password file and sysdba [message #275139]

Thu, 18 October 2007 08:33

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

I have created a password file at E:\oracle\product\10.2.0\db_1\database

SQL> conn sys/welcome as sysdba;
Connected to an idle instance.

Then i renamed the password file to TEST.

again tried to connect

SQL> conn sys/welcome as sysdba;
Connected to an idle instance.

It works!!! without a password file. Any idea how the authentication happens ????

Thnx

Report message to a moderator

Re: Password file and sysdba [message #275140 is a reply to message #275139]

Thu, 18 October 2007 08:39

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

OS Authentication is Used.

Regards
Mohammed Taj

Report message to a moderator

Re: Password file and sysdba [message #275151 is a reply to message #275139]

Thu, 18 October 2007 09:27

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

but i have not mentioned any OS user in this statement .
So this authentication should happen through password file right

conn sys/welcome as sysdba;

Report message to a moderator

Re: Password file and sysdba [message #275152 is a reply to message #275151]

Thu, 18 October 2007 09:40

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

NOt right.

1. If your member of ORA_DBA group.
2. SQLNET.AUTHENTICATION_SERVICES=NTS
then you can connect to database without password file.

For Example.

C:\>del c:\oracle\product\database\PWDORA9I.ORA

C:\>ORAPWD file=c:\oracle\product\database\pwdora9i.ora password=ADMIN entries=5


C:\>set oracle_sid=ora9i

C:\>sqlplus /nolog

SQL*Plus: Release 9.0.1.0.1 - Production on Thu Oct 18 18:37:08 2007

(c) Copyright 2001 Oracle Corporation.  All rights reserved.

SQL> conn sys/WRONGPWD as sysdba
Connected.

NOW Here :OS user is member of ORA_DBA group AND SQLNET.authentication_services=NTS

Regards
Mohammed Taj

Report message to a moderator

Re: Password file and sysdba [message #275514 is a reply to message #275139]

Sat, 20 October 2007 23:22

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

In short just make a try to log on by providing an arbitrary user name and password,

conn sdhsj/sahd as sysdba

then show user from sql*plus.

Check about priority between OS authentication and password file authentication.

Report message to a moderator

Previous Topic:	dblink and characterset
Next Topic:	Oracle 11g tables and installation file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 07:42:35 CST 2024