Hi all,
I recently installed Oracle 11.1.0.7.0 on a Windows Server 2008 standard server 6.0 service pack 2. Everything is working as it should.
I
can open the database control web page on the local computer.
I
can connect locally to the database from SQL Plus
I
can connect locally to the database from Oracle SQL Developer
The database control web page shows the database is up and running as well as the listener. All is good! As the status shows:
C:\>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 11-APR-2012 07:24
:02
Copyright (c) 1991, 2008, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.1.0.7.0 - Produ
ction
Start Date 10-APR-2012 16:58:34
Uptime 0 days 14 hr. 25 min. 33 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File F:\app\oracle\product\11.1.0\db_2\network\admin\listen
er.ora
Listener Log File f:\app\oracle\diag\tnslsnr\SLOTH\listener\alert\log.xm
l
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SLOTH.qmuzik.local)(PORT=1521)))
Services Summary...
Service "qmzorcl" has 1 instance(s).
Instance "qmzorcl", status READY, has 1 handler(s) for this service...
Service "qmzorclXDB" has 1 instance(s).
Instance "qmzorcl", status READY, has 1 handler(s) for this service...
Service "qmzorcl_XPT" has 1 instance(s).
Instance "qmzorcl", status READY, has 1 handler(s) for this service...
The command completed successfully
But when I open Oracle SQL Developer from another PC and try to connect, I am unable to do so!
I keep getting the following error:
Status: Failure - Test failed: IO Error: The Network Adapter could not establish the connection.
What do I need to do, so that I can connect from a remote computer?
Can anyone please assist me in this matter?
Many thanks in advance!
Kind regards,
Richard