"Translated from MoS article" DB times error ora-12170 from a remote machine connected to Windows

Source: Internet
Author: User
DB times error ora-12170 connecting from a remote machine to Windows

Reference text:
windows:ora-12170 attempting to Connect from Remote Client (Doc ID 748461.1)

Suitable for:
Oracle Net services-version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]
Z*obsolete:microsoft Windows
Generic Windows
Microsoft Windows (32-bit)
Microsoft windowsgeneric windowsmicrosoft Windows (32-bit)

Symptoms:

Unable to connect to the DB through the listener, the client connection timed out with an error: ORA-12170

The local connection on the DB server is no problem.


Reason:
The logged-on user in the listener service is different from the logged-on user in the database service.
In such a case, the listener cannot spawn out the proprietary server process

Solution:
In the Windows Service service, locate the listener service, right-click the Listener service, locate properties-log on, and change its login user to the same OS user as the database service.
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.