Resolution for Oracle to connect exceptions using local IP addresses

Source: Internet
Author: User

A few days before the installation of the Oracle test environment, found today cannot use local IP connection, connection prompt error "Oracle The network adapter could not establish the connection"

This problem toss me a long time, online a lot of information is not suitable for my situation. But it ended up being found. Spent a lot of time in other areas without locking the root cause of the problem.


1 began to assume that firewall server client side are excluded

2 Oracle Client side issues (client side of Ubuntu installation)

3 finally using the program test to find or report the network adapter problem The final lock is definitely the database server side issue to continue the search discovery problem.

------------------------------------------------------------------------------------------------------------


1. Make sure that the Oracle Listener monitoring service is started.
2. If your Oracle database is not installed on this machine, turn off the Oracle host firewall (even if your firewall is open for port 1521, because Oracle randomly assigns another port to it when there is a connection request for Port 1521). This is personal opinion! Look high finger point)
3. Make sure that the IP address you are connecting to is correct.

If you have verified the above questions, please continue looking down.


I found this problem when I started my configuration with Eclipse database development.



later, the Oracle SQL developer also failed to connect. Later tried Sqlplus but can connect.




so I sqlplus try again 192.168.1.2 this address (also native) gives the answer.
The first time no listener, prompted to enter the user name but also connected. (It seems that the second time is the same as you input sqlplus)



the answer is clear. When you enter Sqlplus directly, you can log in, but you can't log in by adding the IP to the machine.

puzzled a few hours suddenly think of before playing Oracle (before learning ^_^) where to see can configure monitoring, is to forget where the. So it took another half an hour to finally find it.

It turned out to be net Manager, (it seems that it is better to play software than to play games to benefit more AH)



Start net Manager Select Listener Now you can see the listening address 1 is localhost is not 192.168.1.2 (native) strange, localhost is not 192.168.1.2 (my native IP) ?



so I tried a little bit of 192.168.1.2
Added a 192.168.1.2 with the Add Address button
Save exit restart Oracle Listener monitoring service Wait a moment.






haha incredibly connected on. It seems that localhost is not equal to the 192.168.1.2 (localhost is not through the network card monitoring, hehe personal opinion, I do not understand the network, purely Lenovo. )

Try Oracle SQL Developer also OK.




inadvertently looking at the DOS command to find this.



There are 3 listener endpoints (this is increased by 192.168.1.2IP) The first one is 127.0.0.1 the second is the IPC protocol xxxx (not understand) the third one is the increase of 192.168.1.2.

with the tablets is increased by 192.168.1.2 Ago



only two listening endpoints

Tip: Restarting a service can be managed with commands or with Windows services.

The command is as follows

monitoring start: Lsnrctl start
Listen stop: lsnrctl stop
or just type: Lsnrctl and enter start or stop

start oracle:net start oracleserviceoracle (ORACLE my SID)
Stop oracle:net Stop oracleserviceoracle

Original link: http://www.cnblogs.com/adolfmc/archive/2012/10/07/2713711.html

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.