0

I have recovered my Oracle database using RMAN after following this tutorial

http://www.isaca.org/Groups/Professional-English/oracle-database/GroupDocuments/CKE-Database_Disaster_Recovery_using_only_RMAN_Backups.pdf

after I have recovered the database I have created listener ORCL using NETCA ....when I run SQL developer it can connect to the database on port 1521 when I'm on the server ...

but I'm not able to connect to the database remotely !!!

my windows firewall is OFF !!!it's too bad the one who write this tutorial didn't talk about the listener recovery .

I can ping my listener using the command tnsping orcl...the lister is already is started not OFF ...I really have no clue what to do . when I try to connect remotely using SQL developer I get the error "network adapter can't establish connection" ...while my SQL developer can connect to other database normally .

C:\Windows\System32>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 16-SEP-2017 
20:40
:42

 Copyright (c) 1991, 2010, Oracle.  All rights reserved.

 Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
 STATUS of the LISTENER
 ------------------------
 Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - 
Produ
ction
Start Date                16-SEP-2017 20:35:56
Uptime                    0 days 0 hr. 4 min. 47 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\app\MOD\product\11.2.0\dbhome_1\network\admin\liste
ner.ora
Listener Log File         c:\app\mod\diag\tnslsnr\osama-PC\listener\alert\log.xm
l
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=osama-PC)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

 C:\Windows\System32>

tnsping orcl result

C:\Windows\system32>tnsping orcl

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 17-
SEP-2
017 17:43:32

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:
C:\app\MOD\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = 
TCP)
(HOST = osama-PC)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCL)))
OK (10 msec)

C:\Windows\system32>

lsnrctl services result

  C:\Windows\system32>lsnrctl services

 LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 17-SEP-2017 
 17:46
 :10

  Copyright (c) 1991, 2010, Oracle.  All rights reserved.

  Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
  Services Summary...
  Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
   Handler(s):
  "DEDICATED" established:0 refused:0 state:ready
     LOCAL SERVER
   Service "orclXDB" has 1 instance(s).
   Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
     "D000" established:0 refused:0 current:0 max:1022 state:ready
     DISPATCHER <machine: OSAMA-PC, pid: 2396>
     (ADDRESS=(PROTOCOL=tcp)(HOST=osama-PC)(PORT=49415))
The command completed successfully

C:\Windows\system32>
  • Mere words are not enough, post the outputs for proof. lsnrctl status, SQL Developer configuration, tnsping, firewall settings, telnet to listener address. – Balazs Papp Sep 16 '17 at 17:37
  • @BalazsPapp I have added the output of lsnrctl status. – Osama Al-Banna Sep 16 '17 at 17:42
  • the database instance name is ORCL my listener name is ORCL also . – Osama Al-Banna Sep 16 '17 at 17:49
  • No, your listener name is not ORCL, it is - as it should be - LISTENER. The name of the listener has no bearing. Show us the result of 'tnsping orcl'. How is your connection in SQL Dev defined? Is it "basic" or "tns"? What are the values you've supplied for each field of the connection definition. BTW, there was no reason for the link to tell you about "recovering the listener", as there is nothing to "recover". I'd be using the oracle docs instead of some unknown website. – EdStevens Sep 16 '17 at 21:46
  • @EdStevens I have added the output of tnsping orcl and lsnrctl services my SQL developer connection defined as basic not tns....I used this because this link is the most simple tutorial that match with my recovery scenario Oracle Doc is not simple and very complex to understand . – Osama Al-Banna Sep 17 '17 at 14:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.