Добрый день!
Господа подскажите, в какой то момент пользователи перестали конектится к БД с ошибкой
Код:
сообщение: "ORA-00604: error occurred at recursive SQL level %s
"
hResult: 80004005h; доп. код: 604
источник: Microsoft OLE DB Provider for Oracle
исключение: System.Runtime.InteropServices.COMException
метод: Boolean Login(System.String, System.String, System.String, System.String, Int32 ByRef)
at Sm.Interfaces.INativeHostConfig.Login(String pDbaseName, String pUserLogin, String pPassword, String pInstaller, Int32& pProcessHandle)
at Sm.Main.LocalServer.MainLocalServer.Sm.Main.Link.IMainServer.OpenServer(String databaseName, String userLogin, String password, ITaskBreaker breaker)
at Sm.Main.LocalConnector.OpenMainServer(String databaseName, String userLogin, String password, ITaskBreaker breaker)
в Алерт логе все вроде нормально, но смутил выделенный фрагмент
Код:
Current log# 4 seq# 3558 mem# 0: D:\ORACLE\ORADATA\BLDBERCO\REDO04.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
[10216] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:1129119 end:1129306 diff:187 (1 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is CL8MSWIN1251
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Thu Jan 29 14:29:56 2015
QMNC started with pid=22, OS id=10228
Completed: alter database open
Thu Jan 29 14:30:01 2015
db_recovery_file_dest_size of 4977 MB is 0.00% 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.
Starting background process SMCO
Thu Jan 29 14:31:46 2015
SMCO started with pid=32, OS id=3080
Thu Jan 29 14:31:55 2015
Thread 1 cannot allocate new log, sequence 3559
Private strand flush not complete
Current log# 4 seq# 3558 mem# 0: D:\ORACLE\ORADATA\BLDBERCO\REDO04.LOG
Thread 1 advanced to log sequence 3559 (LGWR switch)
Current log# 5 seq# 3559 mem# 0: D:\ORACLE\ORADATA\BLDBERCO\REDO05.LOG
Thu Jan 29 14:34:52 2015
Starting background process CJQ0
Thu Jan 29 14:34:52 2015
CJQ0 started with pid=34, OS id=10060
Thu Jan 29 14:34:55 2015
Errors in file D:\ORACLE\diag\rdbms\bldberco\bldberco\trace\bldberco_j000_8392.trc:
ORA-12012: error on auto execute of job 62
ORA-20500: ACCESS DENIED!
ORA-06512: at line 17
Thu Jan 29 14:34:55 2015
Errors in file D:\ORACLE\diag\rdbms\bldberco\bldberco\trace\bldberco_j001_9964.trc:
ORA-12012: error on auto execute of job 82
ORA-20500: ACCESS DENIED!
ORA-06512: at line 17
Thu Jan 29 14:35:25 2015
Thread 1 advanced to log sequence 3560 (LGWR switch)
Current log# 6 seq# 3560 mem# 0: D:\ORACLE\ORADATA\BLDBERCO\REDO06.LOG
Thu Jan 29 14:38:31 2015
Thread 1 advanced to log sequence 3561 (LGWR switch)
Current log# 4 seq# 3561 mem# 0: D:\ORACLE\ORADATA\BLDBERCO\REDO04.LOG
к слову сказать под supermagом все нормально подключается.
Подскажите в чем может быть проблема?