Fix Sqlplus, began to use SQL Developer, landed after the big strange:
The network adapter could not establish the connection
(+﹏+) ~ Crazy Dizzy
Look at the process and estimate that the problem we are experiencing should be the same:
First, open the SQL Developer
Double click to enter:
Enter the Admin interface:
Double-click the database connection, I have already connected once, so there is a connection record, here if not connected friends can create a new connection, such as two ways can:
OK, after clicking Connect, it appears:
Then, appear ( we want the result!) Come ):
This means: The network adapter cannot establish a connection ... (+﹏+) ~ Crazy Dizzy
What ' s it mean?
In fact, the original service is not open, which service? That's it:
Oracloradb11g_home1tnslistener
Just open it, it's all right!
Next, by the way other services, to friends to see, otherwise it is not worth the meaning!
Once Oracle is installed, the system creates a series of Oracle services that guarantee the proper operation of Oracle.
You can see the following services in the Administrative Tools service in Control Panel:
1. Oracle ORCL VSS Writer Service.
Oracle Volume Map Copy write service, VSS (Volumeshadow Copy service) enables the creation of a high-fidelity point-in-time image, that is, a mapped copy (shadowcopy), for storage infrastructure devices such as disks, arrays, and so on. It can create a mapped copy on multiple volumes or on a single volume without affecting the system's system performance.
2, ORACLEDBCONSOLEORCL.
Oracle Database Console service, ORCL is the instance identity of Oracle, and the default instance is ORCL. When running Enterprisemanager, this service needs to be started. This service is set by default to boot automatically .
3, ORACLEJOBSCHEDULERORCL.
Oracle Job scheduling service, ORCL is the Oracle instance identity. This service is set to disabled by default.
4, Oraclemtsrecoveryservice
The service allows the database to act as a resource manager for transactions in a Microsoft Transaction Server, com/com+ object, and distributed environment.
5, Oracleoradb11g_home1clragent
The service acts as a hosting process for. NET stored procedures and can be wrapped in. NET assemblies as stored procedures in Oracle, similar to previous Java stored procedures
6, Oracleoradb11g_home1tnslistener.
Listener service, the service is required only when the database requires remote access, and the service is set to boot by default.
7, ORACLESERVICEORCL
Database service, which automatically starts and stops the database. ORCL is the instance identity of Oracle. This service is set to boot by default.
Oracle the network adapter could not establish the connection