Re: Problem with listeners

From: Oliver <ofabelo_at_gmail.com>
Date: Fri, 25 Jul 2014 13:04:18 +0100
Message-ID: <CALQkqm8aEPbNPh=_hbpiM9AH3nhJR2VLv-Dsg4mDgooiRNFkiw_at_mail.gmail.com>

I'm sorry, I've got do it work ..
I started from zero and it is working now .. Thanks anyways.

Cheers...

2014-07-25 9:57 GMT+01:00 Oliver <ofabelo_at_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 - 14:04:18 CEST