OraFAQ Forum: Server Administration » Remote login works even without password file

Home » RDBMS Server » Server Administration » Remote login works even without password file

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

Remote login works even without password file [message #131337]

Fri, 05 August 2005 07:19

rgopani
Messages: 15
Registered: June 2005
Location: rupesh_gopani@yahoo.com

Junior Member

Hi,

I am connecting my database DB1 from remote machine node1.
Now for that apart from initialization parameter I need to create a password file using orapwd utility on maching where DB1 resides.A password file created.While creating password file I gave this command.

orapwd file=C:\oracle\ora92\dbs\pwdorcl.ora password=oracle entries=5;

now when i try to connect using oracle password to sys user it denies and says wrong password.

When i try to connect using oracle9i password which is in oracle database it gets connected which is surprising.Then what is the use of password argument of orapwd utility?

secondly when i remove my password file even then it allows me to connect to a database(DB1) which is already down from remove node.If database is down how did it know that this is the password ??

I m confused..

Report message to a moderator

Re: Remote login works even without password file [message #131351 is a reply to message #131337]

Fri, 05 August 2005 08:29

mrmarath
Messages: 23
Registered: July 2005

Junior Member

hi
Can you just send me the sqlnet.ora contents and the value of remote_login_passwordfile from init.ora ?
Thanks
Rajesh

Report message to a moderator

Re: Remote login works even without password file [message #131420 is a reply to message #131351]

Fri, 05 August 2005 23:27

rgopani
Messages: 15
Registered: June 2005
Location: rupesh_gopani@yahoo.com

Junior Member

sqlnet.ora contents

# SQLNET.ORA Network Configuration File: C:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

#NAMES.DEFAULT_DOMAIN = netx

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

***********************************************
value of parameter remote_login_passwordfile

SQL> show parameter remote_login

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE

Report message to a moderator

Re: Remote login works even without password file [message #131421 is a reply to message #131420]

Fri, 05 August 2005 23:45

mrmarath
Messages: 23
Registered: July 2005

Junior Member

Rupesh,

do one thing,comment this line

SQLNET.AUTHENTICATION_SERVICES= (NTS)

in sqlnet.ora and save .Try to connect again as sys.

hope this will work for you.Let me know.
good luck!
Rajesh

Report message to a moderator

Re: Remote login works even without password file [message #131426 is a reply to message #131421]

Sat, 06 August 2005 02:07

rgopani
Messages: 15
Registered: June 2005
Location: rupesh_gopani@yahoo.com

Junior Member

Hi rajesh,

I will do that R&D tommorow or day after tomorrow due to heavy workload and will get back to u.U can add me in yr yahoo messanger for tech. discussion. my id is rupesh_gopani@yanoo.com

Thanks for yr response.

Bye
Rupesh Gopani

Report message to a moderator

Previous Topic:	deleting old archive log files..!
Next Topic:	ORA-17412

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 26 10:21:57 CDT 2026