Background:
- Windows 10 2004
- vsphere 6.7
- Oracle XE 18c
Procedure:
- I do a fresh install of XE with no visible errors.
- I open a cmd window and do: sqlplus / as sysdba
- I run: select * from v$version;
select * from v$version
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:\APP\MyUser\PRODUCT\18.0.0\DBHOMEXE\DATABASE\INITXE.ORA'
LSNRCTL for 64-bit Windows: Version 18.0.0.0.0 - Production on 15-SEP-2020 09:28:54
Copyright (c) 1991, 2018, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.3.244)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 18.0.0.0.0 - Production
Start Date 14-SEP-2020 17:21:38
Uptime 0 days 16 hr. 7 min. 20 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\app\MyUser\product\18.0.0\dbhomeXE\network\admin\listener.ora
Listener Log File C:\app\MyUser\product\18.0.0\diag\tnslsnr\DESKTOP-T7RFK8C\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.3.244)(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
Can anyone assist? Note I can easily rollback to an eariler VM snapshot and start from scratch if necessary.