Background: My own machine to do Oracle server, the other machine can ping my machine, but JDBC is not even, and later with Plsql even appear no listening program ....
After I reinstalled Oracle yesterday, there was a ora-12541:tns when connecting to Oracle with PL/SQL developer : No listener errors , such as:
In the help of Wang Peng, found that the original is Oracle monitoring did not start, restart monitoring after the connection is successful, the following to share with you how to start the monitoring of Oracle .
1. Open Net Configuration Assistant
2. Select the listener configuration, next
3. Select Reconfigure, Next
4. Select Listener, Default, Next
Note: If your listener is started, a prompt box appears, select Yes
5. Select the protocol, use the default TCP protocol, next
6. Select port number, use standard port number 1521, next
7. Do not configure another listener, select No, Next
8. Listener configuration Complete, next
To re-match the service name, test the connection
1. Select the NET Server configuration and Next
2. Select Reconfigure, Next
3. Select the database name and next
4. Fill in the service name, which is the full database name when you create the database, next
5. Select the TCP protocol and the next step
6. Fill in the hostname (you can fill in your IP address, you can also fill in your hostname), using the standard port number 1521, next
7. Perform the test and the next step
8. Select Change Login
9. Fill in the user name and password to determine
10. Test connection success, next step
11. Network SERVICE name, default (same as previous database name), next
12. Do not configure another NET service name, select No, Next
13.Net Service name configuration completed, Next, complete
Start Pl/sqldeveloper, enter user name and password, login successful
Reprinted from: http://blog.csdn.net/wwbmyos/article/details/11475551/
Oracle-12541:tns: no listener.