Oracle not available offline

oracle

I recently faced a weird problem where I cannot use/log into any Oracle user nor even System account as well as not being able to access my database.
I have a Windows 10 64 bits Home edition, and I did multiple new installation of both Oracle XE 11g release 2 and Oracle XE 18c.
When I installed the XE 11g R2, and when trying to connect to SQLplus using the command line I get the following error
enter image description here

So searched for this error and I found that it is probably related to the database as it is not being mounted correctly everytime:
I did the following:
enter image description here

Now I get the ORA-00119 & ORA00130 ERRORS, and I honeslty don't know where is the problem especially because all of these problems do not occur when I'm using an Internet Connexion using WIFI at home.
If anyone got any idea on how I can fix this please share!
Here are the following settings I currently have for Oracle:

LSNRCTL status:
enter image description here

the C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\listner.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = ASUS-AlexLutinNoir)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

**the C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\tnsnames.ora **

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ASUS-AlexLutinNoir)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

The services that are running for oracle :
enter image description here

My envirement variables:
enter image description here

Best Answer

sqlplus / as sysdba
create pfile from spfile;
exit

Now edit C:\oraclexe\app\oracle\product\11.2.0\server\database\initXE.ora. Remove the line with local_listener, you use the default 1521 port on your local machine, you do not need that line. Once done:

sqlplus / as sysdba
create spfile from pfile;
startup

The problem is that your hostname is ASUS-ALEXLUTINNOIR, but only the first 15 characters was put in the local_listener parameter (ASUS-ALEXLUTINN). The database can't resolve that hostname when starting up. In such a simple configuration you do not need the local_listener set, just leave it blank (remove), so the database will register itself to the listener running on the default port (1521).

Related Question