Sample Header Ad - 728x90

ORA-12152: TNS: unable to send break message - Only LISTENER restart works

0 votes
2 answers
3750 views
i have a strange problem with our Oracle 12.1.0.1.0 on our VM Windows Server 2016. I create a daily batch script whichs creates a dump file (via EXP) and execute some sql statements (via SQLPlus). After a few hours the batch scripts doesnt work anymore. So i try to start the batch manually to see what happens. The login at SQLPlus and EXP returns this error message: > ORA-12152: TNS: unable to send break message So i try to start SQLPlus manually, but i get the same error, if i try to connect as USER@SID. My application which uses a direct database drivers works fine. So the database in the background works. I think its a problem with the listener, because if i restart the listener (lsnrctl restart) sqlplus and exp works, but after a few hours the problem comes back. Listener.ora: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = O:\Oracle\product\12.1.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:O:\Oracle\product\12.1.0\dbhome_1\bin\oraclr12.dll") ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = MY_HOSTNAME)(PORT = 1521)) ) ) Sqlnet.ora: SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) Tnsnames.ora: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = MY_HOSTNAME)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL) ) ) Does anybody has an idea? Edit 1: lsnrctl stat: LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 17-JAN-2022 08:41:48 Copyright (c) 1991, 2013, Oracle. All rights reserved. Anmeldung bei (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS: Kein Listener TNS-12560: TNS: Fehler bei Protokolladapter TNS-00511: Kein Listener 64-bit Windows Error: 2: No such file or directory Anmeldung bei (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SERVER)(PORT=1521))) STATUS des LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 64-bit Windows: Version 12.1.0.1.0 - Production Startdatum 13-JAN-2022 15:55:54 Uptime 3 Tage 16 Std. 45 Min. 56 Sek. Trace-Ebene off Sicherheit ON: Local OS Authentication SNMP OFF Parameterdatei des Listener O:\Oracle\product\12.1.0\dbhome_1\network\admin\listener.ora Log-Datei des Listener O:\Oracle\diag\tnslsnr\SERVER\listener\alert\log.xml Zusammenfassung Listening-Endpunkte... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SERVER)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=SERVER)(PORT=5500))(Security=(my_wallet_directory=O:\ORACLE\admin\ORCL\xdb_wallet))(Presentation=HTTP)(Session=RAW)) Services Übersicht... Dienst "CLRExtProc" hat 1 Instanzen. Instanz "CLRExtProc", Status UNKNOWN, hat 1 Handler f³r diesen Dienst... Dienst "ORCL" hat 1 Instanzen. Instanz "orcl", Status READY, hat 1 Handler für diesen Dienst... Dienst "ORCLXDB" hat 1 Instanzen. Instanz "orcl", Status READY, hat 1 Handler für diesen Dienst... Der Befehl wurde erfolgreich ausgef³hrt. Log from listener\alert\log.xml: 17-JAN-2022 08:48:46 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=O:\Oracle\product\12.1.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=XXXX::XXXX:XXXX:XXXX:606b%3)(PORT=59736)) * establish * orcl * 0 TRC file: https://pastebin.com/8rdvmEm3
Asked by Athris (21 rep)
Jan 13, 2022, 03:14 PM
Last activity: Feb 10, 2025, 08:21 PM