20 de janeiro de 2011 às 7:11 pm #97868

ramasine

Participante

Fabio, meu listener.ora está assim.
Tenho duas instãncias instaladas nesta máquina, com a mesma versão de binários 11.2.0.2
Os nomes delas CDMDES e CDMTST, que tipo de linha você pede para acrescentar? Ja tenho usado a porta 1521 e queria usar a 1522 para a instância CDMTST….a 1521 já atende a CDMDES…

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

Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

  (ADDRESS = (PROTOCOL = TCP)(HOST = lxcmcidb1)(PORT = 1521))

)

)

ADR_BASE_LISTENER = /u01/app/grid

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent

[oracle@lxcmcidb1]/home/oracle> lsnrctl status listener

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.2.0 – Production on 20-JAN-2011 15:03:56

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.2.0 – Production
Start Date 11-JAN-2011 14:48:56
Uptime 9 days 0 hr. 15 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/lxcmcidb1/listener/alert/log.xml

Listening Endpoints Summary…

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lxcmcidb1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.5)(PORT=1521)))

Services Summary…

Service “+ASM” has 1 instance(s).
Instance “+ASM”, status READY, has 1 handler(s) for this service…
Service “CDMDES” has 1 instance(s).
Instance “CDMDES”, status READY, has 1 handler(s) for this service…
Service “CDMDESXDB” has 1 instance(s).
Instance “CDMDES”, status READY, has 1 handler(s) for this service…
Service “CDMTST” has 1 instance(s).
Instance “CDMTST”, status READY, has 1 handler(s) for this service…
Service “CDMTSTXDB” has 1 instance(s).
Instance “CDMTST”, status READY, has 1 handler(s) for this service…
The command completed successfully