Wednesday, July 6, 2011

ORACLE DATABASE “GENISYS” NOT CONNECTED FROM CLIENT MACHINE

It is also a possibility of not connecting oracle database "Genisys" from the Client machine that:

 

The Host address is not matching with the Server IP address / Name in "Listner.ora" file available in "Oracle\Ora92\network\admin"

 

LISTENER

 

The Oracle Database Listener is the database server software component that manages the network traffic between the Oracle Database and the client. The Oracle Database Listener listens on a specific network port (default 1521) and forwards network connections to the Database. The Listener is comprised of two binaries: (1) tnslsnr which is the Listener itself and (2) the Listener Control Utility (lsnrctl) which is used to administer the Listener on the server or remotely

 

The Listener can also be remotely managed by creating one or more alias entries in a listener.ora file. The Listener uses the TNS_ADMIN environmental variable to locate the listener.ora file, so multiple configuration files can be setup by setting TNS_ADMIN prior to executing lsnrctl. To set up a computer to remotely administer a Listener:

 

1. Install Oracle software that contains SQL*Net or Net8, which is usually the Oracle client. You may have to copy the lsnrctl (or lsnrctl.exe) executable from a server installation as it is not installed as part of the basic Oracle client software.

 

2. Configure the local listener.ora to resolve to the remote Listener.

 

The syntax is similar to a tnsnames.ora entry.

 

 If the listener.ora does not exist, create and insert the entry.

 

 Otherwise, add the entry to the listener.ora file.

 

A listener.ora file can contain multiple entries.

 

 <alias> = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (Host = <host>) (Port = <port>)))

 

 3. Start from the command line lsnrctl

 

 4.  Restart the Server and then try to connect the Oracle Genisys Database.

 

Nageswaran AG

 

 

No comments: