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
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:
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:
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) ) )