Vlakarmis wrote:it appears that you are incapable to follow simple & straight forward directions.
Here are the results from entering what you asked in windows command prompt:
[oracle@localhost ~]$ sqlplus SQL*Plus: Release 184.108.40.206.0 Production on Fri Jan 18 08:43:05 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: / as sysdba Connected to: Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> shutdown abort ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 456146944 bytes Fixed Size 1344840 bytes Variable Size 348129976 bytes Database Buffers 100663296 bytes Redo Buffers 6008832 bytes Database mounted. Database opened. SQL>
I need help trying to understand exactly what happened, why the database suddenly stopped running. Please can you help me?I don't use XE myself so I am not much knowledgeable about it but in general, on Windows, if the service of the database SID(database name ) is stopped for some reason, it kills the database as well and you start seeing the same protocol adaptor error. If the service was running may be your son might had issued(by using the doskey command available through the arrow buttons) the shutdown command and it got stopped. I know it's a very wild guess but I can't think of anything else happening. So for the future, if the service property is set to Automatic for the database name, you should have the database running in the next boot of the windows unless you haven't shut it down explicitly.