I have installed the Oracle 11g express database and intends to access it from the sql developer but at the time to establish the connection I get the following error, I have been searching the internet but I do not clarify.
Status: Failure: Failure to test: Listener refused the connection with the following error: ORA-12528, TNS: listener: all appropriate instances are blocking new connections
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production
Start Date 03-DIC-2017 10:34:13
Uptime 0 days 0 hr. 46 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product.2.0\server\network\admin\listener.ora
Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\TOSHIBA-JOSE\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TOSHIBA-JOSE)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 3 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
Tue Dec 05 18:06:36 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production.
Using parameter settings in server-side pfile C:\ORACLEXE\APP\ORACLE\PRODUCT.2.0\SERVER\DATABASE\INITXE.ORA
System parameters with non-default values:
sessions = 172
spfile = "C:\ORACLEXE\APP\ORACLE\PRODUCT.2.0\SERVER\DBS\SPFILEXE.ORA"
memory_target = 1G
control_files = "C:\ORACLEXE\APP\ORACLE\ORADATA\XE\CONTROL.DBF"
compatible = "11.2.0.0.0"
db_recovery_file_dest = "C:\oraclexe\app\oracle\fast_recovery_area"
db_recovery_file_dest_size= 10G
undo_management = "AUTO"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
dispatchers = "(PROTOCOL=TCP) (SERVICE=XEXDB)"
shared_servers = 4
job_queue_processes = 4
audit_file_dest = "C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP"
db_name = "XE"
open_cursors = 300
diagnostic_dest = "C:\ORACLEXE\APP\ORACLE"
Tue Dec 05 18:06:41 2017
PMON started with pid=2, OS id=1448
Tue Dec 05 18:06:41 2017
PSP0 started with pid=3, OS id=12468
Tue Dec 05 18:06:42 2017
VKTM started with pid=4, OS id=16752 at elevated priority
Tue Dec 05 18:06:42 2017
GEN0 started with pid=5, OS id=7136
Tue Dec 05 18:06:42 2017
DIAG started with pid=6, OS id=3752
Tue Dec 05 18:06:42 2017
DBRM started with pid=7, OS id=8528
Tue Dec 05 18:06:42 2017
DIA0 started with pid=8, OS id=13212
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Time drift detected. Please check VKTM trace file for more details.
Tue Dec 05 18:06:42 2017
MMAN started with pid=9, OS id=11924
Tue Dec 05 18:06:43 2017
DBW0 started with pid=10, OS id=11428
Tue Dec 05 18:06:43 2017
LGWR started with pid=11, OS id=15780
Tue Dec 05 18:06:43 2017
CKPT started with pid=12, OS id=15056
Tue Dec 05 18:06:43 2017
SMON started with pid=13, OS id=8820
Tue Dec 05 18:06:43 2017
RECO started with pid=14, OS id=10092
Tue Dec 05 18:06:43 2017
MMON started with pid=15, OS id=9948
Tue Dec 05 18:06:43 2017
MMNL started with pid=16, OS id=6100
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
ORACLE_BASE from environment = C:\oraclexe\app\oracle
Tue Dec 05 18:06:44 2017
ALTER DATABASE MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\CONTROL.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) El sistema no puede encontrar el archivo especificado.
ORA-205 signalled during: ALTER DATABASE MOUNT...