que se encuentran en:
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin
listener.ora
tnsnames.ora
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin
listener.ora
_________________________________________________________________
Configuración básica
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.XX)(PORT = XXXX))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = nomservicio)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
)
)
_____________________________________________________________________________
Configuración con balanceo
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(LOAD_BALANCE=ON)---------------------------------------------------------------------------balanceo
(ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.01)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.02)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
______________________________________________________________________________
Configuracion con GLOBAL_DBNAME
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL=TCP)(HOST = nom_equipo.midominio.local)(PORT=1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
)
ADR_BASE_LISTENER = /u01/app/oracle11
###### argumento nuevo ##############
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=nom_base.midominio.local)
(SID_NAME=nom_base)
(ORACLE_HOME=/u01/app/oracle11/product/11.2.0/dbhome_1/)
)
)
SECURE_REGISTER_LISTENER = (IPC)
__________________________________________________________________
Levantar el Listener
oracle@server#lsnrctl status
oracle@server#lsnrctl stop
oracle@server#lsnrctl start