Супермаг рвет связь с Оракл : Oracle

Начались у нас проблемы, с тем что Супермаг разрывает соединение с Базой Оракл.
2023.12.13 (среда) 09:15:55 1.51.0.0 sp5 [97] ERROR Sm.Cash.Server
----- Прерывание работы программы -----
сообщение: "ORA-03114: нет связи с ORACLE"
исключение: Sm.Core.InteropException
hResult: 80040E14h; доп. код: 3114
источник: OraOLEDB
----- Причина исключения, уровень вложения 1 -----
сообщение: "ORA-03114: нет связи с ORACLE"
исключение: Sm.Core.InteropException
hResult: 80040E14h; доп. код: 3114
источник: OraOLEDB
----- Причина исключения, уровень вложения 2 -----
сообщение: "ORA-03114: нет связи с ORACLE"
исключение: Sm.Core.InteropException
hResult: 80040E14h; доп. код: 3114
источник: OraOLEDB
----- Причина исключения, уровень вложения 3 -----
сообщение: "ORA-03114: нет связи с ORACLE"
исключение: Sm.Core.InteropException
hResult: 80040E14h; доп. код: 3114
источник: OraOLEDB

2023.12.13 (среда) 09:02:37 1.51.0.0 sp5 [1474] ERROR (64 бита)
Ошибка в DatabaseMonitoring.InspectRegisteredUsersCash: ----- Прерывание работы программы -----
сообщение: "Ошибка соединения с БД.
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist"
исключение: Sm.Core.BaseException
источник: Sm.Server
метод: Void Connect()
в Sm.Server.Database.OracleDb.Connect()
в Sm.Server.Database.OracleDb..ctor(String connectionString, String sessionId, Boolean doConnect)
в Sm.AppServer.DatabaseHost.CreateDatabaseConnection()
в Sm.AppServer.DatabaseHost.PrepareDatabaseConnection()
в Sm.AppServer.DatabaseHost.ExecuteQuery(Action`1 localMethod)
в Sm.AppServer.DatabaseMonitoring.ReadAppServerNoSessionUsers(DatabaseHost host)
в Sm.AppServer.DatabaseMonitoring.InspectRegisteredUsersCache(DatabaseHost host, Boolean needInspectDatabase)
----- Причина исключения, уровень вложения 1 -----
сообщение: "ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist"
исключение: Oracle.ManagedDataAccess.Client.OracleException
источник: Oracle Data Provider for .NET, Managed Driver
метод: PR Get(OracleInternal.ConnectionPool.ConnectionString, Boolean, OracleInternal.ConnectionPool.CriteriaCtx, System.String, Boolean)
в OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, CriteriaCtx criteriaCtx, String affinityInstanceName, Boolean bForceMatch)
в OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, CriteriaCtx criteriaCtx, String affinityInstanceName, Boolean bForceMatch)
в OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, CriteriaCtx criteriaCtx)
в Oracle.ManagedDataAccess.Client.OracleConnection.Open()
в Sm.Server.Database.OracleDb.Connect()

Почему Супермаг, а не oracle?

С сетью все в порядке? Если в это время пинговать сервер, что происходит?
На сервере в alert_log что написано?

2023.12.13 (среда) 10:06:30 1.51.0.0 sp5 Sm.Main
----- Прерывание работы программы -----
сообщение: "ORA-03114: нет связи с ORACLE"
hResult: 80004005h; доп. код: 3114
источник: OraOLEDB
----- Уровень вложения 1 -----
сообщение: "ORA-03114: нет связи с ORACLE"
hResult: 80040E14h; доп. код: 3114
источник: OraOLEDB
----- Уровень вложения 2 -----
сообщение: "select ObjType,
TypeName,
ShortName,
IsDocument,
PostLevel,
UsesClientIndex,
UsesLocFrom,
UsesLocTo,
UsesLocation,
AuxTable,
UsesPrice,
AuxSpecTable,
OpCode,
AppModule
from Supermag.SSObjectTypes OT,Supermag.SSDocTypes TMain
where OT.ObjType=TMain.DocType(+)"
hResult: 80004005h
источник: SmLibaryBase trace
исключение: System.Runtime.InteropServices.COMException
метод: Boolean CanClose(Sm.Interfaces.DomainWindowClosureReason)
в Sm.Interfaces.IDomainWindow.CanClose(DomainWindowClosureReason pReason)
в Sm.Main.MainPageControl.CanCloseAllDomains(Int32 exceptIndex)
в Sm.Main.MainPageControl.Sm.Main.Link.IDomainContainer.CloseAllDomains()
в Sm.Main.MainPageControl.Sm.Main.Link.IDomainContainer.CloseApplication()
в Sm.Main.MainFrame.WndProc(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
в System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

У нас и Супермаг и Оракл на одном сервере

Говорят же тебе - в alert.log посмотри...

где файл alert.log найти?

нашел

Wed Dec 13 10:04:06 2023
Errors in file D:\ORACLE\ORASERV\diag\rdbms\leger\leger\trace\leger_j002_26904.trc:
ORA-12012: ошибка при автоисполнении задания 61
ORA-20021: Сервер Супермага не запущен
ORA-06512: на "SUPERMAG.SCHEDULE", line 291
ORA-06512: на line 1
Wed Dec 13 10:04:06 2023
Errors in file D:\ORACLE\ORASERV\diag\rdbms\leger\leger\trace\leger_j001_37016.trc:
ORA-12012: error on auto execute of job 150
ORA-20021: Сервер Супермага не запущен
ORA-06512: at "SUPERMAG.SCHEDULE", line 291
ORA-06512: at line 1
Wed Dec 13 10:04:06 2023
Errors in file D:\ORACLE\ORASERV\diag\rdbms\leger\leger\trace\leger_j000_19460.trc:
ORA-12012: error on auto execute of job 129
ORA-20021: Сервер Супермага не запущен
ORA-06512: at "SUPERMAG.SCHEDULE", line 291
ORA-06512: at line 1
Wed Dec 13 10:04:19 2023
Maximum of 148 enabled roles exceeded for user OPERATOR_SKLAD_BM. Not loading all the roles.
Wed Dec 13 10:04:19 2023
Maximum of 148 enabled roles exceeded for user OPERATOR_SKLAD_BM. Not loading all the roles.
Wed Dec 13 10:04:19 2023
Maximum of 148 enabled roles exceeded for user OPERATOR_SKLAD_BM. Not loading all the roles.
Wed Dec 13 10:04:28 2023
Starting background process SMCO
Wed Dec 13 10:04:28 2023
SMCO started with pid=29, OS id=40476
Wed Dec 13 10:04:29 2023
Errors in file D:\ORACLE\ORASERV\diag\rdbms\leger\leger\trace\leger_j002_26904.trc:
ORA-12012: error on auto execute of job 126
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
KUP-11024: This external table can only be accessed from within a Data Pump job.
ORA-06512: at "SUPERMAG.SCHEDULE", line 291
ORA-06512: at line 1
Wed Dec 13 10:04:40 2023
Errors in file D:\ORACLE\ORASERV\diag\rdbms\leger\leger\trace\leger_j000_19460.trc:
ORA-12012: error on auto execute of job 126
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
KUP-11024: This external table can only be accessed from within a Data Pump job.
ORA-06512: at "SUPERMAG.SCHEDULE", line 291
ORA-06512: at line 1
Wed Dec 13 10:05:01 2023
Errors in file D:\ORACLE\ORASERV\diag\rdbms\leger\leger\trace\leger_j000_19460.trc:
ORA-12012: error on auto execute of job 126
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
KUP-11024: This external table can only be accessed from within a Data Pump job.
ORA-06512: at "SUPERMAG.SCHEDULE", line 291
ORA-06512: at line 1
Wed Dec 13 10:12:05 2023
Thread 1 cannot allocate new log, sequence 5060
Private strand flush not complete
Current log# 1 seq# 5059 mem# 0: D:\ORACLE\ORADATA\LEGER\REDO01.LOG
Thread 1 advanced to log sequence 5060 (LGWR switch)
Current log# 2 seq# 5060 mem# 0: D:\ORACLE\ORADATA\LEGER\REDO02.LOG
Wed Dec 13 10:21:14 2023
Maximum of 148 enabled roles exceeded for user OPERATOR_SKLAD_BM. Not loading all the roles.
Wed Dec 13 10:21:16 2023
Maximum of 148 enabled roles exceeded for user OPERATOR_SKLAD_BM. Not loading all the roles.
Wed Dec 13 10:21:19 2023
Maximum of 148 enabled roles exceeded for user OPERATOR_SKLAD_BM. Not loading all the roles.

Errors in file D:\ORACLE\ORASERV\diag\rdbms\leger\leger\trace\leger_j001_41756.trc:
ORA-12012: error on auto execute of job 150
ORA-20021: Сервер Супермага не запущен
ORA-06512: at "SUPERMAG.SCHEDULE", line 291
ORA-06512: at line 1
Wed Dec 13 09:03:55 2023
Errors in file D:\ORACLE\ORASERV\diag\rdbms\leger\leger\trace\leger_j003_39304.trc:
ORA-12012: ошибка при автоисполнении задания 61
ORA-20021: Сервер Супермага не запущен
ORA-06512: на "SUPERMAG.SCHEDULE", line 291
ORA-06512: на line 1
Wed Dec 13 09:03:55 2023
Errors in file D:\ORACLE\ORASERV\diag\rdbms\leger\leger\trace\leger_j000_21528.trc:
ORA-12012: error on auto execute of job 129
ORA-20021: Сервер Супермага не запущен
ORA-06512: at "SUPERMAG.SCHEDULE", line 291
ORA-06512: at line 1
Wed Dec 13 09:04:14 2023
Maximum of 148 enabled roles exceeded for user OPERATOR_SKLAD_BM. Not loading all the roles.
Wed Dec 13 09:04:34 2023
Maximum of 148 enabled roles exceeded for user OPERATOR_SKLAD_BM. Not loading all the roles.
Wed Dec 13 09:04:35 2023
Maximum of 148 enabled roles exceeded for user OPERATOR_SKLAD_BM. Not loading all the roles.
Wed Dec 13 09:04:42 2023
Maximum of 148 enabled roles exceeded for user OPERATOR_SKLAD_BM. Not loading all the roles.
Wed Dec 13 09:05:07 2023
Starting background process SMCO
Wed Dec 13 09:05:07 2023
SMCO started with pid=66, OS id=35888
Wed Dec 13 09:05:08 2023
Errors in file D:\ORACLE\ORASERV\diag\rdbms\leger\leger\trace\leger_j001_40448.trc:
ORA-12012: error on auto execute of job 126
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
KUP-11024: This external table can only be accessed from within a Data Pump job.
ORA-06512: at "SUPERMAG.SCHEDULE", line 291
ORA-06512: at line 1
Wed Dec 13 09:05:33 2023
Errors in file D:\ORACLE\ORASERV\diag\rdbms\leger\leger\trace\leger_j000_38996.trc:
ORA-12012: error on auto execute of job 126
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
KUP-11024: This external table can only be accessed from within a Data Pump job.
ORA-06512: at "SUPERMAG.SCHEDULE", line 291
ORA-06512: at line 1
Wed Dec 13 09:06:55 2023
Errors in file D:\ORACLE\ORASERV\diag\rdbms\leger\leger\trace\leger_j000_41912.trc:
ORA-12012: error on auto execute of job 126
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
KUP-11024: This external table can only be accessed from within a Data Pump job.
ORA-06512: at "SUPERMAG.SCHEDULE", line 291
ORA-06512: at line 1
Wed Dec 13 09:09:27 2023
Thread 1 cannot allocate new log, sequence 5056
Private strand flush not complete
Current log# 3 seq# 5055 mem# 0: D:\ORACLE\ORADATA\LEGER\REDO03.LOG
Thread 1 advanced to log sequence 5056 (LGWR switch)
Current log# 1 seq# 5056 mem# 0: D:\ORACLE\ORADATA\LEGER\REDO01.LOG
Wed Dec 13 09:15:16 2023
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Wed Dec 13 09:15:42 2023
Stopping background process QMNC
Wed Dec 13 09:15:42 2023
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 117
Stopping Job queue slave processes, flags = 7
Job queue slave processes stopped

***********************************************************************

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
Time: 13-ДЕК-2023 08:57:56
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:таймаут операции
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.106.204)(PORT=54263))
WARNING: inbound connection timed out (ORA-3136)
Wed Dec 13 08:58:20 2023


***********************************************************************

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
Time: 13-ДЕК-2023 08:58:20
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:таймаут операции
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.106.204)(PORT=54267))
WARNING: inbound connection timed out (ORA-3136)
Wed Dec 13 09:00:52 2023
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Wed Dec 13 09:01:04 2023
kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
Wed Dec 13 09:01:17 2023
kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
Stopping background process CJQ0
Wed Dec 13 09:01:26 2023
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
License high water mark = 138
Stopping Job queue slave processes, flags = 7
Job queue slave processes stopped
Wed Dec 13 09:01:40 2023
ALTER DATABASE CLOSE NORMAL
Wed Dec 13 09:01:40 2023
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Dec 13 09:01:42 2023
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 5055
Successful close of redo thread 1
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Wed Dec 13 09:01:44 2023
Stopping background process VKTM
Wed Dec 13 09:01:52 2023
Instance shutdown complete
Wed Dec 13 09:03:21 2023
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 16
Number of processor cores in the system is 16
Number of processor sockets in the system is 8
Picked latch-free SCN scheme 3
Wed Dec 13 09:03:34 2023
Using LOG_ARCHIVE_DEST_1 parameter default value as D:\ORACLE\ORASERV\11.2.0.4\RDBMS
Autotune of undo retention is turned on.
IMODE=BR
ILAT =249
LICENSE_MAX_USERS = 0
SYS auditing is disabled
NUMA system with 2 nodes detected
Starting up:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production.
Windows NT Version V6.1 Service Pack 1
CPU : 16 - type 8664, 16 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:85263M/153599M, Ph+PgF:318855M/389117M
VM name : VMWare Version (6)
Using parameter settings in server-side spfile D:\ORACLE\ORASERV\11.2.0.4\DATABASE\SPFILELEGER.ORA
System parameters with non-default values:
processes = 1500
sessions = 2272
nls_language = "RUSSIAN"
nls_territory = "RUSSIA"
sga_target = 41600M
control_files = "D:\ORACLE\ORADATA\LEGER\CONTROL01.CTL"
control_files = "D:\ORACLE\ORADATA\LEGER\CONTROL02.CTL"
db_block_size = 8192
db_cache_size = 35G
compatible = "11.2.0.4.0"
undo_tablespace = "UNDOTBS1"
O7_DICTIONARY_ACCESSIBILITY= TRUE
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
audit_file_dest = "D:\ORACLE\ORASERV\ADMIN\LEGER\ADUMP"
audit_trail = "DB"
db_name = "LEGER"
open_cursors = 300
pga_aggregate_target = 13846M
diagnostic_dest = "D:\ORACLE\ORASERV"