Форум OlegON > Ресурсы OlegON > Вопросы сервера > Программы OlegON

Оптимайзер - 7 (вопросы и обсуждения) часть вторая

03.04.2020 20:41


11.07.2018 09:24
Stels
 
вылезло там, где 10
на 11 не вылезло

базы ребутяться не все
11.07.2018 09:34
Stels
 
на одной базе дополнительно вылезло:

Код:
11.07.18 05:54:16 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:16 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:16 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:16 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:16 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:16 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:16 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:16 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:16 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:16 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:16 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:16 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:16 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:16 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:16 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:16 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:16 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:16 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:16 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:16 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:16 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:16 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:16 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:16 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:16 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:16 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:16 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:16 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:16 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:16 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:16 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:16 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:16 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:16 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:17 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:17 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:17 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:17 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:17 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:17 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:17 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:17 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:17 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:17 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SYSTEM"
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.18 05:54:18 --  ORA-00604: error occurred at recursive SQL level 2
11.07.18 05:54:18 --  ORA-01000: maximum open cursors exceeded
11.07.2018 09:46
OlegON
 
Цитата:
Stels ORA-01000: maximum open cursors exceeded
елки-палки... забыл, что неклиентские запускаются сервисом... поправлю.
11.07.2018 09:51
Stels
 
ждать?
или делать по рекомендациям из этого топика?

Цитата:
OlegON как править - здесь : https://olegon.ru/showthread.php?t=29667
11.07.2018 10:06
OlegON
 
больше никто не жалуется, но, скорее, сделаю. у тебя сколько баз?
11.07.2018 10:18
Stels
 
всего 3 базы... по остальным вроде нормально

пока сделал
exec dbms_aqadm.start_queue('ALERT_QUE');
у меня вышло:
Процедура PL/SQL успешно завершена.

и послал сервера в перезагруз ... жду
11.07.2018 10:21
OlegON
 
Цитата:
OlegON больше 10 хостов
Цитата:
Stels всего 3 базы
:) видимо, это из тех, кого ребутили нагорячую...
давай тогда лучше руками по доке... лучше поправить, но мне боязно с запуском внешних скриптов заморачиваться...
11.07.2018 15:08
Propil
 
Цитата:
OlegON Блин, у кого еще 10ка, может вылезти баг
ORA-0 encountered when generating server alert SMG-4121
На одной из трех баз сегодня весь день ругалась, пока я в отъезде был.

Выполнил скрипты рекомендованные - вроде перестало письма слать.
11.07.2018 15:52
OlegON
 
Спасибо за отклик, тогда забиваем. У меня тоже из нескольких десятков вылезло всего на паре...
11.07.2018 22:10
OlegON
 
Поработал еще, теперь отключается журнал листенера, который иначе раздувается до неприличных размеров и вызывает глюки.
Кстати, рекомендую переводить базу в ручной режим запуска. Целее будет. Бот ее запустит... А дергания вверх-вниз по питанию достаточно часто приводят к полному уничтожению.

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