Home » RDBMS Server » Security » Remote connection without Password (oracle 12c Windows 2012)
Remote connection without Password [message #670746] Tue, 24 July 2018 02:19 Go to next message
muthukrish104
Messages: 71
Registered: November 2017
Member
Hi,

Recently we have changed the password of SYS, SYSTEM users through.

ORAPWD as well as ALTER USER ....

All the servers are asking the new password while connecting remotely,
but only one server is connecting without password.

Here is the settings.

SQLNET.AUTHENTICATION_SERVICES=(NTS,NONE)

remote_login_passwordfile string EXCLUSIVE


Where I am lagging.

Regards
M.Krish
Re: Remote connection without Password [message #670748 is a reply to message #670746] Tue, 24 July 2018 02:56 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
Can you show us what you're doing?
Re: Remote connection without Password [message #670750 is a reply to message #670746] Tue, 24 July 2018 03:33 Go to previous messageGo to next message
John Watson
Messages: 8085
Registered: January 2010
Location: Global Village
Senior Member
This does not look right
SQLNET.AUTHENTICATION_SERVICES=(NTS,NONE)
the values are incompatible. You probably want to set it to ALL, which is the default.
Re: Remote connection without Password [message #670751 is a reply to message #670750] Tue, 24 July 2018 05:40 Go to previous messageGo to next message
muthukrish104
Messages: 71
Registered: November 2017
Member
Hi Gazzag, John,

We are just doing this remotely.

conn sys@alias as sysdba
Then password

We tried with ALL also in it "SQLNET.AUTHENTICATION_SERVICES=(NTS,NONE)". But no use.

Thanks and regards
M.krish
Re: Remote connection without Password [message #670752 is a reply to message #670751] Tue, 24 July 2018 05:56 Go to previous messageGo to next message
John Watson
Messages: 8085
Registered: January 2010
Location: Global Village
Senior Member
what does this mean,Quote:
We tried with ALL also in it "SQLNET.AUTHENTICATION_SERVICES=(NTS,NONE)". But no use.
And if you really do want help, you have to show what you are doing: the content of the files, the SQL*Plus session. Use copy/paste, enclosed within [code] tags.
Re: Remote connection without Password [message #670753 is a reply to message #670746] Tue, 24 July 2018 06:45 Go to previous messageGo to next message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

SQLNET.AUTHENTICATION_SERVICES is of no use for remote connections, it comes into play only with local connections.
(SYS%) Remote connections ALWAYS use password file.
(@seniors: I know it can be worked around but it is the biggest security hole that can set so I won't mention it.)
Re: Remote connection without Password [message #670755 is a reply to message #670753] Tue, 24 July 2018 07:19 Go to previous messageGo to next message
muthukrish104
Messages: 71
Registered: November 2017
Member
Hi,

Yes,
Here is the attachment, which shows the connection description.

Kindly check.



Regards
M.Krish
Re: Remote connection without Password [message #670756 is a reply to message #670755] Tue, 24 July 2018 08:36 Go to previous messageGo to next message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What does this image show?

Re: Remote connection without Password [message #670765 is a reply to message #670756] Wed, 25 July 2018 00:32 Go to previous messageGo to next message
muthukrish104
Messages: 71
Registered: November 2017
Member
Hi Michel,

It simply shows.

conn sys@<alias name> as sysdba

Regards
M.Krish
Re: Remote connection without Password [message #670766 is a reply to message #670765] Wed, 25 July 2018 00:36 Go to previous messageGo to next message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And?
What is the purpose to post it?

Re: Remote connection without Password [message #670771 is a reply to message #670766] Wed, 25 July 2018 02:52 Go to previous messageGo to next message
muthukrish104
Messages: 71
Registered: November 2017
Member
Hi Michel,

This is the reply to Mr.Gazzag's Post.



Quote:

Can you show us what you're doing?
Regards
M.Krish
Re: Remote connection without Password [message #670775 is a reply to message #670771] Wed, 25 July 2018 03:04 Go to previous messageGo to next message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

OK, but it does not show if you use or not a password to connect, so it does not actually show what you're doing. Seeing your image we can't guess if it is a case of "it works" or one of "it does nor work".

Anyway, I gave you the explanation.

Re: Remote connection without Password [message #671917 is a reply to message #670775] Mon, 24 September 2018 04:56 Go to previous message
muthukrish104
Messages: 71
Registered: November 2017
Member
Hi Michel,

As I had mentioned earlier,
we were using this method.

"conn sys@<alias name> as sysdba".

But now we have removed the parameter of NTS in:
SQLNET.AUTHENTICATION_SERVICES=(...)

So, now a days we input the password, even while connecting directly to the server.

Regards
M.Krish
Previous Topic: authorization Required.
Next Topic: Database security issues
Goto Forum:
  


Current Time: Fri Dec 13 21:00:19 CST 2019