Good day to all, the problem is the following, when I came to work today I discovered that the base had fallen, started restarting services, etc., but I get the error TNS-12514: TNS: the listener does not currently have data about the service requested in the connection descriptor. I put everything that is
listener.ora

SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\app\Oracle\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = #(ADDRESS = (PROTOCOL = TCP)(HOST = MMK-T-0198)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.249)(PORT = 1521)) # (ADDRESS = (PROTOCOL = TCP)(HOST = 10.205.232.54)(PORT = 1521)) ) ) ADR_BASE_LISTENER = D:\app\Oracle

tnsnames.ora

 # tnsnames.ora Network Configuration File: D:\app\Oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.249)(PORT = 1521)) #MMK-T-0198 (CONNECT_DATA = (SERVER = DEDICATED) (SID = orcl) ) )

sqlnet.ora

 # sqlnet.ora Network Configuration File: D:\app\Oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora # Generated by Oracle configuration tools. # This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT. SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)

Alert log / log.xml

 <msg time='2016-08-29T14:50:37.279+03:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='MMK-T-0198' host_addr='fe80::19f4:5e4e:a0c0:8645%11'> <txt>29-АВГ-2016 14:50:37 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=MMK-T-0198$))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.249)(PORT=1446)) * establish * orcl * 12571 </txt> </msg> <msg time='2016-08-29T14:50:47.280+03:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='MMK-T-0198' host_addr='fe80::19f4:5e4e:a0c0:8645%11'> <txt>TNS-12571: TNS:сбой ΠΏΡ€ΠΎΠ³Ρ€Π°ΠΌΠΌΡ‹ записи Π² ΠΏΠ°ΠΊΠ΅Ρ‚Π΅ TNS-12560: TNS:ошибка Π°Π΄Π°ΠΏΡ‚Π΅Ρ€Π° ΠΏΡ€ΠΎΡ‚ΠΎΠΊΠΎΠ»Π° TNS-00530: Ошибка Π°Π΄Π°ΠΏΡ‚Π΅Ρ€Π° ΠΏΡ€ΠΎΡ‚ΠΎΠΊΠΎΠ»Π° 64-bit Windows Error: 54: Unknown error TNS-12514: TNS:ΠΏΡ€ΠΎΡΠ»ΡƒΡˆΠΈΠ²Π°Ρ‚Π΅Π»ΡŒ Π² Π΄Π°Π½Π½Ρ‹ΠΉ ΠΌΠΎΠΌΠ΅Π½Ρ‚ Π½Π΅ ΠΈΠΌΠ΅Π΅Ρ‚ Π΄Π°Π½Π½Ρ‹Ρ… ΠΎ слуТбС, Π·Π°ΠΏΡ€Π°ΡˆΠΈΠ²Π°Π΅ΠΌΠΎΠΉ Π² дСскрипторС соСдинСния </txt> </msg>

lsnrctl status hangs. tnsping either an error or a response time of up to 3 minutes. Help please understand what's the matter, the base before leaving for the weekend worked.

  • Perhaps the base has not risen. What is the base status? Access to the machine with base is, through sqlplus it is connected? - Viktorov
  • @IDrakonl yes through sqlplus. I noticed that when restarting, the OracleService service cannot start by itself. More details about the status of the base please? - Ethernets
  • select status from v$instance; what returns? There is an assumption that the base after the fall simply did not start. The listener does not see it - Viktorov
  • @lDrakonl STATUS OPEN - Ethernets
  • @lDrakonl Already did reconfig listener does not help. Whatever I do, I get a TNS-12514 error. And I don’t understand how to raise the base, everything seems to be running, but the listener is not visible - Ethernets

1 answer 1

@NikolayBaranenko Thank you so much for the answer. The problem was solved. And 90% of the problem was the overflow of listener.log logs. The remaining 10% decided to disable IPv6. Also many thanks to @lDrakonl for participating in solving the problem.