If not, something wrong with DNS /ACTIVE directory => try using hosts file Test if listener port is reachable/opened for your remote connectionįor that use telnet utility which is available on Unix and can be enabled on Windows.Ĭonnected to (12.222.333.44).ġ) First enable telnet on Windows 7 if it’s not there: If not, check the server availability Ping database hostname Once the connection is established, the client and database server communicate directly. The listener receives incoming client connection requests and hands these requests to the database server. To connect to a database service, clients first contact a listener process that typically resides on the database server. The address portion of the connect descriptor is actually the protocol address of the listener. To connect to a database service, clients use a connect descriptor that provides the location of the database and the name of the database service.
The service name is included in the connect data part of the connect descriptor. An Oracle database is represented to clients as a service that is, the database performs work on behalf of clients.
