Status: Failure: Failure to test: I / O error: The Network Adapter could not establish the connection

0

I just installed Oracle Database 12c Release 2 (12.2.0.1.0) on my pc with windows 10. The problem is that I can not create a connection from the Oracle SQL Developer and the message appears in red (see image).

When testing the connectivity from the command prompt, the following error appears: ORA-12541: TNS: There is no listener.

C:\Users\JEAN>tnsping ONE

TNS Ping Utility for 64-bit Windows: Version 12.2.0.1.0 - Production on 16-SEP-2017 00:11:30
Copyright (c) 1997, 2016, Oracle.  All rights reserved.
Archivos de parßmetros utilizados:
D:\app\JEAN\product.2.0\dbhome_1\network\admin\sqlnet.ora
Adaptador TNSNAMES utilizado para resolver el alias
Intentando contactar con (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ONE)))
TNS-12541: TNS:no hay ning·n listener

And that's how I got the tnsnames.ora and the listener.ora

tnsnames.ora

# tnsnames.ora Network Configuration File: D:\app\JEAN\product.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ONE =   (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ONE)
    )   )

LISTENER_ONE =   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =   (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )   )

listener.ora

# listener.ora Network Configuration File: D:\app\JEAN\product.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\app\JEAN\product.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\JEAN\product.2.0\dbhome_1\bin\oraclr12.dll")
    )
    (SID_DESC =
      (GLOBAL_DBNAME = Oracle8)
      (SID_NAME = ORCL)
    )
  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.38)(PORT = 1521))
  )

ADR_BASE_LISTENER = D:\app\JEAN\product.2.0\dbhome_1\log

What should I do to solve it?

    
asked by Jean Devonne 16.09.2017 в 08:19
source

1 answer

0

What I did finally was to uninstall the oracle, then in the installation do not change the name of the instance (I left the orcl ) in the previous installation I changed it to ONE because I liked that name even so I was wrong, at the end of the installation I opened the sql developer, in the SID field I put orcl and the connection was made successfully.

    
answered by 09.10.2017 / 18:32
source