I have setup the gateway configuration .and restart the listener, listener fails to restart
With below error
TNS-01201: Listener cannot find executable $ORACLE_HOME/bin/dg4odbc for SID XYZ
Listener.ora file looks like below
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = XYZ)
(ORACLE_HOME = /app/oracle/product/11.2.0/db_home2)
(SID_NAME = orcl )
)
(SID_DESC =
(SID_NAME= POSTGRESDB)
(ORACLE_HOME = /app/oracle/product/11.2.0/db_home2)
(PROGRAM=dg4odbc)
(ENVS=LD_LIBRARY_PATH = /opt/progress/datadirect/Connect_for_ODBC_70/lib:
/app/oracle/product/11.2.0/db_home2/lib:
/lib:/usr/lib:/etc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0 )(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
Solution:
Add complete path for executable program i.e
PROGRAM=/app/oracle/product/11.2.0/gateway/bin/dg4odbc
you can find the full path using locate command
#locate dg4odbc
#/app/oracle/product/11.2.0/gateway/bin/dg4odbc
Change the in listener.ora file
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = XYZ)
(ORACLE_HOME = /app/oracle/product/11.2.0/db_home2)
(SID_NAME = orcl )
)
(SID_DESC =
(SID_NAME= POSTGRESQL)
(ORACLE_HOME = /app/oracle/product/11.2.0/db_home2)
(PROGRAM=/app/oracle/product/11.2.0/gateway/bin/dg4odbc)
(ENVS=LD_LIBRARY_PATH = /opt/progress/datadirect/Connect_for_ODBC_70/lib:
/app/oracle/product/11.2.0/db_home2/lib:
/lib:/usr/lib:/etc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0 )(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
Listener started successfully ………. Cheers!!!……. :)
No comments:
Post a Comment