08.05.2018 05:35
Nik_75
 
2018.05.08 (Tuesday) 11:28:49 1.36.1.0 sp4 Sm.AppServer.Admin
----- Прерывание работы программы -----
сообщение: "ORA-06575: Package or function CORE is in an invalid state"
исключение: Sm.Core.WcfErrorHandler+ServerException
источник: Сервер приложений
данные: исключение на сервере: System.Data.OracleClient.OracleException
источник на сервере: System.Data.OracleClient
соединено с: База даных=PRIVOZKA; Пользователь=Supermag
текст команды: Select Supermag.Core.GetSessionID from dual
тип команды: Text
метод: Void miDatabaseListLastError_Click(System.Object, System.EventArgs)
в System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
в System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
в System.Data.OracleClient.OracleCommand.ExecuteScalarInternal(Boolean needCLStype, Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
в System.Data.OracleClient.OracleCommand.ExecuteScalar()
в Sm.Server.Database.OracleSafeCommand.ExecuteScalar[TResult]()
в Sm.Server.Database.OracleRunner.ExecuteScalar[TResult](String commandText, OracleTransConn connection)
в Sm.AppServer.DatabaseHost.KillAllSessions(OracleTransConn connection)
в Sm.AppServer.DatabaseHost.KillOldSessions()
в Sm.AppServer.DatabaseHost.CreateDatabaseConnection()
в Sm.AppServer.DatabaseHost.GetDatabaseStateInternal(Boolean checkDatabaseVersion, Exception& error)


Проблема появилась после заливки дампа. Сама база открывается. Вот данные из alert_log:
Tue May 08 11:17:19 2018
ALTER DATABASE CLOSE NORMAL
Tue May 08 11:17:19 2018
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue May 08 11:17:19 2018
Shutting down archive processes
Archiving is disabled
Tue May 08 11:17:24 2018
ARCH shutting down
ARC1: Archival stopped
Tue May 08 11:17:29 2018
ARCH shutting down
ARC0: Archival stopped
Tue May 08 11:17:30 2018
Thread 1 closed at log sequence 877
Successful close of redo thread 1
Tue May 08 11:17:31 2018
Completed: ALTER DATABASE CLOSE NORMAL
Tue May 08 11:17:31 2018
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue May 08 11:17:51 2018
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
Tue May 08 11:17:51 2018
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 394264576
__large_pool_size = 8388608
__java_pool_size = 16777216
__streams_pool_size = 0
sga_target = 1786773504
control_files = D:\ORACLE\ORADATA\PRIVOZKA\PRIVOZKA\CONTROL01.CTL, D:\ORACLE\ORADATA\PRIVOZKA\PRIVOZKA\CONTROL02.CTL, D:\ORACLE\ORADATA\PRIVOZKA\PRIVOZKA\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 1358954496
compatible = 10.2.0.3.0
log_archive_format = ARC%S_%R.%T
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\oracle\product\10.2.0\flash_recovery_area
db_recovery_file_dest_size= 629145600000
undo_management = AUTO
undo_tablespace = UNDOTBS1
O7_DICTIONARY_ACCESSIBILITY= TRUE
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=PRIVOZKAXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PRIVOZKA\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PRIVOZKA\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PRIVOZKA\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PRIVOZKA\CDUMP
db_name = PRIVOZKA
open_cursors = 300
pga_aggregate_target = 209715200
PMON started with pid=2, OS id=34128
PSP0 started with pid=3, OS id=34464
MMAN started with pid=4, OS id=34692
DBW0 started with pid=5, OS id=33484
LGWR started with pid=6, OS id=33972
CKPT started with pid=7, OS id=32296
SMON started with pid=8, OS id=33512
RECO started with pid=9, OS id=29876
CJQ0 started with pid=10, OS id=33880
MMON started with pid=11, OS id=34152
Tue May 08 11:17:51 2018
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=33632
Tue May 08 11:17:51 2018
starting up 1 shared server(s) ...
Tue May 08 11:17:52 2018
ALTER DATABASE MOUNT
Tue May 08 11:17:56 2018
Setting recovery target incarnation to 2
Tue May 08 11:17:56 2018
Successful mount of redo thread 1, with mount id 1519689888
Tue May 08 11:17:56 2018
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue May 08 11:17:57 2018
ALTER DATABASE OPEN
Tue May 08 11:17:57 2018
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=16, OS id=34048
Tue May 08 11:17:57 2018
ARC0: Archival started
ARC1 started with pid=17, OS id=33388
Tue May 08 11:17:58 2018
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 opened at log sequence 877
Current log# 1 seq# 877 mem# 0: D:\ORACLE\ORADATA\PRIVOZKA\PRIVOZKA\REDO01.LOG
Successful open of redo thread 1
Tue May 08 11:17:58 2018
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue May 08 11:17:58 2018
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Tue May 08 11:17:58 2018
ARC1: Becoming the heartbeat ARCH
Tue May 08 11:17:58 2018
SMON: enabling cache recovery
Tue May 08 11:17:59 2018
Successfully onlined Undo Tablespace 1.
Tue May 08 11:17:59 2018
SMON: enabling tx recovery
Tue May 08 11:17:59 2018
Database Characterset is CL8MSWIN1251
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 8
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=31684
Tue May 08 11:18:01 2018
db_recovery_file_dest_size of 600000 MB is 6.65% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Tue May 08 11:18:02 2018
Completed: ALTER DATABASE OPEN
08.05.2018 06:45
Mtirt
 
Все плохо.
Проверяй инвалидные объекты в базе и пытайся их перекомпилировать...
08.05.2018 07:18
OlegON
 
Цитата:
Nik_75 Проблема появилась после заливки дампа
Гранты раздал? В журнале заливки ошибок нет? (только не надо его сюда целиком постить)
08.05.2018 08:00
Nik_75
 
Гранты раздал. Ошибка выходит при создании SVJOBS. Вот такая ORA-00942 table or view does not exist.
08.05.2018 08:04
OlegON
 
Криво экспорт сделал, наверное.
08.05.2018 14:59
Nik_75
 
Помогла проверка raid массива, после нее дамп залился нормально.

Форум на базе vBulletin®
Copyright © Jelsoft Enterprises Ltd.
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.