Problem with listeners

From: Oliver <ofabelo_at_gmail.com>
Date: Fri, 25 Jul 2014 09:57:35 +0100
Message-ID: <CALQkqm9Lk6ChZc5VOD5iY4ub_Gj82DWPCF+YQZ5+9xWKS=yAQg_at_mail.gmail.com>

Hi,
situation:

1 server under RHEL 6.5 64bit, with 2 instances, a 10g and another with 11g. And a Oracle Gateway 11g using DG4ODBC. 11g Oracle Database listener is configured for both 10g and 11g (port 1521), it is working perfectly.
Problem comes with Oracle Gateway listener, it has same listener name as 11g database (both LISTENER name). I have it working in another server of this way, although situation is a little different (it has a 10g database and a 11g oracle gateway). Port of oracle gateway listener is 1522. When I set the correct environment variables for oracle gateway (ld_library_path, oracle_home and path) and I run lsnrctl status, it shows:

1. if I put listener entry and below sid_list_listener in listener.ora, it shows that listener is not running correctly, but if I do a "lsnrctl start", it shows error tns-01201, it can't find the executable $ORACLE_HOME/bin/DG4ODBC for SID DG4ODBC ..
2. If I put listener entry below of sid_list_listener in listener.ora and I run "lsnrctl status", it shows 11g database listener status output ..

For giving more info:

ORACLE_HOME 11g database is "/u01/app/oracle/product/11.2.0/dbhome_1". ORACLE_HOME 11g gateway is "/u01/app/oracle/product/11.2.0/tg_1".

listener.ora of 11g database:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

listener.ora of 11g gateway:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = DG4ODBC)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/tg_1)
(ENV =

"LD_LIBRARY_PATH=/usr/lib64:/u01/app/oracle/product/11.2.0/tg_1/lib")

(PROGRAM = DG4ODBC))

  )
)

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX)(PORT = 1522))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

I have in the 11g database tnsnames.ora the next:

DG4ODBC =
   (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=XXX)(PORT=1522))
(CONNECT_DATA=(SID=DG4ODBC))
(HS=OK)

   )

Environment variables that I set when I work with 11g gateway is (oracle_base is established too):

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/tg_1 PATH=$PATH:$ORACLE_HOME/bin
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORACLE_HOME PATH LD_LIBRARY_PATH

And environment variables that I set when I work with 11g database is (oracle_base is established too):

ORACLE_SID=ora11g
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
ORACLE_UNQNAME=ora11g

PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORACLE_SID ORACLE_HOME PATH ORACLE_UNQNAME LD_LIBRARY_PATH

I always do logout with oracle user when I want change of working between an instance and another or the oracle gateway .. I don't find what is my problem for now .. Thanks beforehand.

Cheers...

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 25 2014 - 10:57:35 CEST