Home » RDBMS Server » Server Administration » Password file and sysdba
Password file and sysdba [message #275139] Thu, 18 October 2007 08:33 Go to next message
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
Re: Password file and sysdba [message #275140 is a reply to message #275139] Thu, 18 October 2007 08:39 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

OS Authentication is Used.

Regards
Mohammed Taj
Re: Password file and sysdba [message #275151 is a reply to message #275139] Thu, 18 October 2007 09:27 Go to previous messageGo to next message
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;
Re: Password file and sysdba [message #275152 is a reply to message #275151] Thu, 18 October 2007 09:40 Go to previous messageGo to next message
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
Re: Password file and sysdba [message #275514 is a reply to message #275139] Sat, 20 October 2007 23:22 Go to previous message
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.
Previous Topic: dblink and characterset
Next Topic: Oracle 11g tables and installation file
Goto Forum:
  


Current Time: Sat Dec 03 12:13:35 CST 2016

Total time taken to generate the page: 0.07691 seconds