I have recovered my Oracle database using RMAN after following this tutorial
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>
lsnrctl status
, SQL Developer configuration,tnsping
, firewall settings,telnet
to listener address. – Balazs Papp Sep 16 '17 at 17:37tnsping orcl
andlsnrctl 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