I installed Oracle 11XE a while back - suddenly I am getting ORA-01034 and ORA-27101 errors when trying to connect
My ORACLE_HOME and ORACLE_SID appear to be correct.
My listener.ora file is:
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)
)
(SID_DESC =
(SID_NAME = XE)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
))
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = Home-PC)(PORT = 1521))
)
(PROGRAM = extproc)
)
DEFAULT_SERVICE_LISTENER = (XE)
The following Windows Services are all started:
OracleJobSchedulerXE
OracleMTSRecoveryService
OracleServiceXE
OracleXEClrAgent
OracleTNSListener
When I switch Windows Firewall off (just in case it is blocking port 1521), it still brings up the error
What else can I check?
Copyright Notice:Content Author:「Mike」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/25454381/unable-to-connect-to-oracle-xe