Hi,
Recently I have installed Oracle 11g XE in my laptop with Windows 10 64-bit machine. The installation was smooth. However, I have issue with listener. Can someone please let me know if 11g XE works on Windows 10 o/s ?
C:\>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 26-JUN-2018 12:09:46
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production
Start Date 26-JUN-2018 12:05:38
Uptime 0 days 0 hr. 4 min. 9 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora
Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\FOCH2GJMYP\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=FOCH2GJMYP.asiapacific.hpqcorp.net)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
C:\>
If I look at installation document, it says -
https://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#BABEBCDB
2.1.2 Windows Firewall Configuration
If you plan to install Oracle Database XE onto a computer running Windows Firewall, which was first introduced in Windows XP Service Pack 2 and Windows Server 2003 Service Pack 1, and then connect to it from another computer, check that the firewall has not been configured to block communication from the following incoming ports. These ports are the default ports that Oracle Database XE users.
- 1521: Oracle Database Listener
- 2030: Oracle Services for Microsoft Transaction Server
- 8080: Oracle HTTP Transaction Server
I am not sure if that is causing the issue. But can you please let me know how to know if they are blocked in windows firewall ? In-case blocked, how to open them? OR the issue is something else? Please help.
Please note: I have not done any changes to listener.ora or tnsnames.ora. They are just what originally installed. And the DB is up and running. I am able to connect from command prompt -
C:\>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Tue Jun 26 12:03:17 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2260048 bytes
Variable Size 666895280 bytes
Database Buffers 394264576 bytes
Redo Buffers 5517312 bytes
Database mounted.
Database opened.
SQL>
Thanks,
-Anand