Home » RDBMS Server » Security » Remote login without password
Remote login without password [message #179576] Wed, 28 June 2006 01:50 Go to next message
Messages: 3
Registered: June 2006
Junior Member
i have a oracle db 9.0 version in a windows 2003 server machine.

the net service name of that oracle db in a remote windows 2003 server machine is say insp.
if i login as administrator of that remote machine and type connect sys/asdsadf@insp as sysdba it is getting connected. the password mentioned is random and a wrong one.

how the oracle db is authenticating the password for sysdba.
pl note that if i log as another user (not an adminstrator), then the same is not getting connected

my second query is if there are 2 db running in the machine,then
connect / as sysdba throws service handle not initialised error.
this error is coming even after setting oracle_sid in the command prompt explicitely.
But connecting with the sys/syspassword@net_service_name as sysdba is working by giving the correct net service name of the db.
why the earlier way wasnt working ??
thanks in advance
Re: Remote login without password [message #179591 is a reply to message #179576] Wed, 28 June 2006 02:38 Go to previous message
Messages: 3
Registered: June 2006
Junior Member
when i commented the SQLNET.AUTHENTICATION_SERVICES= (NTS) line in sqlnet.ora in the remote machine/localmachine, then it didnt allow to login with a wrong password.

what does this mean ??
Previous Topic: history of users
Next Topic: who is the actual user ??
Goto Forum:

Current Time: Mon Dec 06 12:15:18 CST 2021