El servicio "CLRExtProc" tiene 1 instancia(s). (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc))) Log del Listener C:\app\OLIVER\product\18.0.0\diag\tnslsnr\URIEL-PC\listener\alert\log.xmlĭESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=URIEL-PC)(PORT=1521))) Parámetros del Listener C:\app\OLIVER\product\18.0.0\dbhomeXE\network\admin\listener.ora Versión TNSLSNR for 64-bit Windows: Version 18.0.0.0.0 - Production Which I tried and got Conectándose a (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=URIEL-PC)(PORT=1521))) ESTADO del LISTENER I also tried changing the Host name in the listener.ora file and in the connection window in SQLDeveloper to localhost (As It was the one I got when installing the SQL Express Edition) and reloading the listener but that gave me the exact same error so I kept the original.Īlso, I found a solution to the problem here where I should check if the listener was running by trying C:\> lsnrctl status
In the listener, there is a HOST called "Uriel-PC" and actually I don't know any Uriel but I figured that since I've got the Express Edition right from the Oracle page it should be right, so I wrote the info in the "New Database Connection" window in SQLDeveloperĪnd I got the error I mention. (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = URIEL-PC)(PORT = 1521)) (ORACLE_HOME = C:\app\OLIVER\product\18.0.0\dbhomeXE) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)Īnd my listener.ora file is: #listener.ora Network Configuration file: C:\app\OLIVER\product\18.0.0\dbhomeXE\NETWORK\ADMIN\listener.ora The tsnames.ora file is: #tsnames.ora Network Configuration file: C:\app\OLIVER\product\18.0.0\dbhomeXE\NETWORK\ADMIN\tnsnames.ora
Multitenant container database: localhost:1521Ĭonnection database: localhost:1521/XEPDB1ĮM Express URL: And when I tried to connect in the SQLDeveloper I got "I/O Error: The Network Adapter could not establish the connection"
#ORACLE SQL DEVELOPER LOCALHOST PRO#
I'm trying to connect to a local database in a computer (from someone else in fact) with Windows Pro and after a long time trying I finnaly installed SQL Express Edition and SQLDeveloper in the 64-bit version.Īfter the installation finished in the SQL Express Edition I was asked to write a password and got the following information for the database: