Cuando se instala la infraestructura del GRID para un servidor independiente , la Red de Oracle Listener es iniciada desde su directorio de instalación de software, conocido como < Grid_home > . Se requiere un Listener que se ejecute a partir de esta instalación de software para proporcionar capacidades de conexión a la instancia ASM . Esto también se utiliza por defecto para escuchar en todas las instancias de base de datos que están instalados en el mismo servidor.



cat listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora

# Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = dbtest) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/grid) (SID_NAME = dbtest) ) (SID_DESC = (GLOBAL_DBNAME = orcl) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/grid) (SID_NAME = orcl) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) ) ADR_BASE_LISTENER = /u01/app/oracle ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

cat sqlnet.ora # sqlnet.ora

Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/sqlnet.ora # Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) ADR_BASE = /u01/app/oracle


$ORACLE_HOME/u01/app/oracle/product/11.2.0/dbhome_1/network/admin

cat listener.ora # listener3342170619141601331.ora Network Configuration File: /tmp/listener3342170619141601331.ora # Generated by Oracle configuration tools. LISTENER_DBTEST = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522)) ) ) ) #LISTENER.ORA Network Configuration File #Created by Oracle Enterprise Manager Clone Database tool SID_LIST_LISTENER_DBTEST = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = dbtest) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = dbtest) ) )



cat sqlnet.ora #SQLNET.ORA Network Configuration File #Created by Oracle Enterprise Manager Clone Database tool