1 de junho de 2011 às 10:28 pm #99478

Ronin

Participante

Boa tarde,

 Pessoal, abaixo estão as configurações!!

Brigadão

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

Generated by Oracle configuration tools.

–LISTENER DO SERVIDOR
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl11g.grupomil.local.com.br)(PORT = 1521))
)
)

ADR_BASE_LISTENER = /u01/app/oracle

–TNSNAMES DO CLIENTE
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.132)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

–RESULTADO DO PING DO CLIENTE PARA O SERVIDOR

[oracle@ap51mat admin]$ ping 172.16.1.132 PING 172.16.1.132 (172.16.1.132) 56(84) bytes of data.
64 bytes from 172.16.1.132: icmp_seq=1 ttl=64 time=2.71 ms
64 bytes from 172.16.1.132: icmp_seq=2 ttl=64 time=0.463 ms
64 bytes from 172.16.1.132: icmp_seq=3 ttl=64 time=0.453 ms

— RESULTADO DO TNSPING DO CLIENTE PARA O SERVIDOR

[oracle@ap51mat admin]$ tnsping ORCL 10

TNS Ping Utility for Linux: Version 11.2.0.1.0 – Production on 31-MAY-2011 15:22:02

Used parameter files:
/u01/app/oracle/product/11.2.0/client_2/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.132)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (0 msec)
OK (10 msec)
OK (0 msec)
OK (10 msec)
OK (0 msec)

— RESULTADO DO LISTENER DO SERVIDOR

[oracle@orcl11g admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 – Production on 01-JUN-2011 15:23:39

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 – Production
Start Date 01-JUN-2011 13:41:49
Uptime 0 days 1 hr. 41 min. 50 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/list ener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/orcl11g/listener/alert/lo g.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl11g.grupomil.local.com.br)(PORT= 1521)))
Services Summary…
Service “orcl.grupomil.local.com.br” has 1 instance(s).
Instance “orcl”, status READY, has 1 handler(s) for this service…
Service “orclXDB.grupomil.local.com.br” has 1 instance(s).
Instance “orcl”, status READY, has 1 handler(s) for this service…
The command completed successfully

— RESULTADO SQLNET.ORA DO CLIENTE

[oracle@ap51mat admin]$ cat sqlnet.ora

sqlnet.ora Network Configuration File: /u01/app/oracle/product/11.2.0/client_2/network/admin/sqlnet.ora

Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /u01/app/oracle