Skip to Main Content

18c Express Edition, Win 10 Pro. No default database (ORA-12560, ORA-12514.) What am I missing?

SondarDec 31 2019 — edited Jan 13 2020

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?

Let's go through this step by step:

  1. I'm installing the Windows package currently available at this link - that's the Feb 20, 2019 release, 18.4.0.0.0. I've checked the download against the checksum and confirmed the download is not corrupted.

  2. 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.

  3. 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:
    INSTALLDIR=C:\oracle\product\18.0.0\
    PASSWORD=<password-known>
    LISTENER_PORT=0
    EMEXPRESS_PORT=0
    CHAR_SET=AL32UTF8
  4. The install script was run from a command terminal "Run as Administrator" by the default (only) user, who is part of the Administrators group.

  5. During the install, I was prompted to allow the application through the firewall. I allowed this for all networks (public and private).

  6. 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: 18.4.0.0.0. Product Language: 1033. Manufacturer: Oracle Corporation. Installation success or error status: 0.
  7. Right after the install, I go to the install directory and try and connect to my newly installed database:

    C:\xe_temp>cd C:\oracle\product\18.0.0\dbhomeXE\bin

    C:\oracle\product\18.0.0\dbhomeXE\bin>.\sqlplus / as sysdba

    SQL*Plus: Release 18.0.0.0.0 - Production on Tue Dec 31 12:32:55 2019
    Version 18.4.0.0.0

    Copyright (c) 1982, 2018, Oracle.  All rights reserved.

    ERROR:
    ORA-12560: TNS:protocol adapter error

    Enter user-name: sys
    Enter password: <yes, I entered the correct pwd!>
    ERROR:
    ORA-12560: TNS:protocol adapter error

    Enter user-name: ^C

  8. That doesn't work. Let's see if we can ping the database:

    C:\oracle\product\18.0.0\dbhomeXE\bin>tnsping localhost

    TNS Ping Utility for 64-bit Windows: Version 18.0.0.0.0 - Production on 31-DEC-2019 12:37:04

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

    Used parameter files:
    c:\oracle\product\18.0.0\dbhomeXE\network\admin\sqlnet.ora

    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)

  9. That seems okay. Is anyone listening?

    C:\oracle\product\18.0.0\dbhomeXE\bin>lsnrctl status

    LSNRCTL for 64-bit Windows: Version 18.0.0.0.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
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for 64-bit Windows: Version 18.0.0.0.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
    SNMP                      OFF
    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...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MS-TEST-WIN-ORACLE)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully
  10. 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.

  11. 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.

  12. Can I connect to the single service that is listed? Nope.

    C:\oracle\product\18.0.0\dbhomeXE\bin>.\sqlplus sys@localhost:1521/CLRExtProc

    SQL*Plus: Release 18.0.0.0.0 - Production on Tue Dec 31 12:34:46 2019
    Version 18.4.0.0.0

    Copyright (c) 1982, 2018, Oracle.  All rights reserved.

    ERROR:
    ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

    Enter user-name: ^C

Can anyone identify what the problem is? Why weren't the XE|PDB1 services installed? Is the syntax of my sqlplus commands correct?

Comments
Post Details
Added on Dec 31 2019
9 comments
1,974 views