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

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

21.11.2024 22:11


« 1221 22 2332
█ 11.07.2018 09:24
вылезло там, где 10
на 11 не вылезло

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

Код:
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
Цитата:
Stels ➤ ORA-01000: maximum open cursors exceeded
елки-палки... забыл, что неклиентские запускаются сервисом... поправлю.
█ 11.07.2018 09:51
ждать?
или делать по рекомендациям из этого топика?

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

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

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

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

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