I've (seemingly) successfully installed the 18.4 version of the 18c XE database on Win 10 Pro, but no matter how many times I do the install and no matter what I try, I cannot connect to anything. Is there something obvious I'm missing or should do to make the database accessible?
I'm installing the Windows package currently available at this link - that's the Feb 20, 2019 release, 184.108.40.206.0. I've checked the download against the checksum and confirmed the download is not corrupted.
I'm installing the package in a x64-based VM, running Win 10 Pro (build 18363) with 8.87 GB of RAM available. It's a VirtualBox VM, which I assume works - as there's a link to a VirtualBox appliance right here on the landing page of this forum.
To make sure I'm not mis-typing anything, I extracted the contents of the downloaded archive to C:\xe_temp\, and installed with the following batch script:
setup.exe /s /v"RSP_FILE=c:\xe_temp\sQ-XEInstall.rsp" /v"/L*v c:\xe_temp\setup.log" /v"/qn"
and the following lines in the corresponding response file:
The install script was run from a command terminal "Run as Administrator" by the default (only) user, who is part of the Administrators group.
During the install, I was prompted to allow the application through the firewall. I allowed this for all networks (public and private).
The file that was created during the installation, C:\xe_temp\setup.log, contains the line
MSI (s) (A0:F4) [15:49:24:863]: Windows Installer installed the product. Product Name: Oracle Database 18c Express Edition. Product Version: 220.127.116.11.0. Product Language: 1033. Manufacturer: Oracle Corporation. Installation success or error status: 0.
Right after the install, I go to the install directory and try and connect to my newly installed database:
C:\oracle\product\18.0.0\dbhomeXE\bin>.\sqlplus / as sysdba
SQL*Plus: Release 18.104.22.168.0 - Production on Tue Dec 31 12:32:55 2019
Copyright (c) 1982, 2018, Oracle. All rights reserved.
ORA-12560: TNS:protocol adapter error
Enter user-name: sys
Enter password: <yes, I entered the correct pwd!>
ORA-12560: TNS:protocol adapter error
Enter user-name: ^C
That doesn't work. Let's see if we can ping the database:
TNS Ping Utility for 64-bit Windows: Version 22.214.171.124.0 - Production on 31-DEC-2019 12:37:04
Copyright (c) 1997, 2018, Oracle. All rights reserved.
Used parameter files:
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
OK (20 msec)
That seems okay. Is anyone listening?
LSNRCTL for 64-bit Windows: Version 126.96.36.199.0 - Production on 31-DEC-2019 12:33:56
Copyright (c) 1991, 2018, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MS-TEST-WIN-ORACLE.local)(PORT=1521)))
STATUS of the LISTENER
Version TNSLSNR for 64-bit Windows: Version 188.8.131.52.0 - Production
Start Date 31-DEC-2019 12:01:52
Uptime 0 days 0 hr. 32 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
Default Service XE
Listener Parameter File c:\oracle\product\18.0.0\dbhomeXE\network\admin\listener.ora
Listener Log File c:\oracle\product\18.0.0\diag\tnslsnr\MS-TEST-WIN-ORACLE\listener\alert\log.xml
Listening Endpoints Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
The command completed successfully, and lists at least one service. However, from researching this problem, I'd also expect to see the XE and XEPDB1 services listed there, too.
I checked in the Windows services console - the only Oracle services listed (and running) are OracleOraDB18Home1MTSRRecoveryService and OracleOraDB18Home1TNSListener. I've tried stopping and re-starting them, to no avail.
Can I connect to the single service that is listed? Nope.