Oracle 8.05 – Windows Advanced Server

[maperesParticipante]

Ola

Os arquivos de listener,tnsnames.ora foram gerados pelo proprio oracle (Netca)

O serviço de listener está no “ar”.

G:>lsnrctl80 status

LSNRCTL80 for 32-bit Windows: Version 8.0.5.0.0 – Production on 14-JUN-12 10:43:
41

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=172.21.1.147)(Port=1521))

STATUS of the LISTENER

Alias LISTENER
Version TNSLSNR80 for 32-bit Windows: Version 8.0.5.0.0 – Prod
uction
Start Date 13-JUN-12 14:42:54
Uptime 0 days 20 hr. 0 min. 46 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File c:orant8NET80adminlistener.ora
Listener Log File c:orant8NET80loglistener.log
Services Summary…
PCOR has 1 service handler(s)The command completed successfully

O tnsnames gerado pelo Oracle é este :

DEBRET =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = debret)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PCOR)
)
)

Testando :

G:>TNSPING80 DEBRET

TNS Ping Utility for 32-bit Windows: Version 8.0.5.0.0 – Production on 14-JUN-12
10:58:23

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=debret)(PORT=1521))
OK (10 msec)