Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
Топик располагается на нескольких страницах: [1] 2   вперед  Ctrl      все
 Восстановление из бекапа на новый релиз Oracle  [new]
Chilik
Member

Откуда:
Сообщений: 107
Доброго времени суток.
Подскажи пожалуйста и возможно ли вообще так сделать?

Есть холодный бэкап базы, который был сделан с Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod. OS
SunOS 5.10 Generic_118855-33 i86pc i386 i86pc

Хочу поднять на машине на которой установлен Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod. OS SunOS 5.10 Generic_137138-09 i86pc i386 i86pc

Файлы данных расскладываю по новым каталогам (новое расположение).
Все по faq из форума.
Есть трейс control файла ( alter database backup controfile to trace).
Создал файл паролей. Пересоздал контрол файл с указанием нового размещения файлов данных. Вообщем вроде все как полагается до:
(тут я еще не видел релизы оракла разные)
alter database open resetlogs
Thu Apr 2 03:48:03 2009
ORA-1507 signalled during: alter database open resetlogs...
Thu Apr 2 03:54:20 2009
Shutting down instance: further logons disabled

После просмотра многочисленных форумов и документации понял, что нужно делать upgrade, правда в доке говорят, что это нужно делать после наката патча. Но я подумал может прокатит, так как не могу проводить эксперимент на рабочей

SQL> STARTUP UPGRADE;
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1281648 bytes
Variable Size 125829520 bytes
Database Buffers 478150656 bytes
Redo Buffers 7106560 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u02/oradata/db/system01.dbf'
SQL> RECOVER DATABASE;
Media recovery complete.

Далее делал как говорят в доке Database Upgrade Guide, но в основном только ошибки получаю в результате

SQL> @utlu102s.sql
ERROR:
ORA-06553: PLS-801: internal error [56319]
DECLARE
*
ERROR at line 1:
ORA-06553: PLS-801: internal error [56319]
ERROR:
ORA-06553: PLS-801: internal error [56319]

Результат catupgrd.sql
SQL> @catupgrd.sql
......

CREATE OR REPLACE FUNCTION version_script
*
ERROR at line 1:
ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [],
[]
ORA-06553: PLS-801: internal error [56319]
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning and Data Mining options


Знающие люди, подскажите, что можно сделать?
3 апр 09, 00:22    [7014977]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление из бекапа на новый релиз Oracle  [new]
сиська
Member [заблокирован]

Откуда:
Сообщений: 434
попробуй сначала эту БД открыть в той версии в которой она сохранена и согласованно закрыть (shutdown immediate)
потом поднимать новым релизом
3 апр 09, 00:48    [7015042]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление из бекапа на новый релиз Oracle  [new]
сиська
Member [заблокирован]

Откуда:
Сообщений: 434
через dbua не пробовал делать?
3 апр 09, 00:54    [7015062]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление из бекапа на новый релиз Oracle  [new]
Chilik
Member

Откуда:
Сообщений: 107
сиська,

Холодный бэкап был сделал после того как быза была закрыта в согласованном режиме (shutdown immediate)
3 апр 09, 00:57    [7015073]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление из бекапа на новый релиз Oracle  [new]
Chilik
Member

Откуда:
Сообщений: 107
сиська,

незнаю как его на солярке запустить
3 апр 09, 00:59    [7015077]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление из бекапа на новый релиз Oracle  [new]
Вячеслав Любомудров
Member

Откуда: Владивосток
Сообщений: 18482
Ты бы полный порядок привел, а то у тебя получается:
startup upgrade -> error
recover database -> Ok
@utlu102s.sql -- А где открытие (alter database open upgrade)? Да и почему ты этот скрипт вызываешь до catupgrd? Он вызывается после

PS. Если ты имел ввиду utlu102i, то он должен запускаться на старой версии
3 апр 09, 01:35    [7015142]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление из бекапа на новый релиз Oracle  [new]
сиська
Member [заблокирован]

Откуда:
Сообщений: 434
Вячеслав Любомудров
Да и почему ты этот скрипт вызываешь до catupgrd? Он вызывается после

разве
3 апр 09, 02:18    [7015174]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление из бекапа на новый релиз Oracle  [new]
Chilik
Member

Откуда:
Сообщений: 107
Вячеслав Любомудров,
Вячеслав Любомудров
Ты бы полный порядок привел, а то у тебя получается:
startup upgrade -> error
recover database -> Ok
@utlu102s.sql -- А где открытие (alter database open upgrade)? Да и почему ты этот скрипт вызываешь до catupgrd? Он вызывается после

PS. Если ты имел ввиду utlu102i, то он должен запускаться на старой версии


startup upgrade -> error был только раз, затем после RECOVER DATABASE открывается нормально, т/е сейчас открывается номально

Да и почему ты этот скрипт вызываешь до catupgrd?
потому что может прочел не правильно.Run the Pre-Upgrade Information Tool.
В одном из очередных случаях, когда я повторял все действия занова, только запустил сразу не utlu102i, а @catupgrd.sql то ошибка была таже самая
CREATE OR REPLACE FUNCTION version_script
*
ERROR at line 1:
ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [],
[]
3 апр 09, 02:45    [7015184]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление из бекапа на новый релиз Oracle  [new]
Chilik
Member

Откуда:
Сообщений: 107
Вячеслав Любомудров,

полный порядок
SQL> STARTUP UPGRADE;
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1281648 bytes
Variable Size 125829520 bytes
Database Buffers 478150656 bytes
Redo Buffers 7106560 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u02/oradata/db/system01.dbf'
SQL> RECOVER DATABASE;
Media recovery complete.
shutdown;
SQL> STARTUP UPGRADE;
SQL> @catupgrd.sql
......

CREATE OR REPLACE FUNCTION version_script
*
ERROR at line 1:
ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [],
[]
ORA-06553: PLS-801: internal error [56319]
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning and Data Mining options
3 апр 09, 02:47    [7015187]     Ответить | Цитировать Сообщить модератору
 Re: Восстановление из бекапа на новый релиз Oracle  [new]
Вячеслав Любомудров
Member

Откуда: Владивосток
Сообщений: 18482
Есть подозрение, что это может быть связано с пересозданием контрола из скрипта
Если есть бинарный бэкап контрола, то стоит попробовать использовать его, а поменять расположение файлов с помощью команды alter database rename file в режиме mount (или, если есть возможность, создать символические ссылки на старые пути)
Тогда действия:
  • Положить все файлы (включая контролы) по нужным путям
  • startup mount
  • Если нельзя обеспечить соответствие старым путям, выполнить alter database rename file...
  • recover database
  • alter database open upgrade resetlogs;
  • @?/rdbms/admin/catupgrd
  • shutdown immediate
  • startup
  • @?/rdbms/admin/utlrp

    PS. А не меняется ли заодно и битность (32 <-> 64)?
  • 3 апр 09, 03:56    [7015205]     Ответить | Цитировать Сообщить модератору
     Re: Восстановление из бекапа на новый релиз Oracle  [new]
    Chilik
    Member

    Откуда:
    Сообщений: 107
    Вячеслав Любомудров,

    как проверить битность
    рекомендацию уже утром попробую сделать
    3 апр 09, 05:06    [7015221]     Ответить | Цитировать Сообщить модератору
     Re: Восстановление из бекапа на новый релиз Oracle  [new]
    Вячеслав Любомудров
    Member

    Откуда: Владивосток
    Сообщений: 18482
    file $ORACLE_HOME/bin/oracle
    3 апр 09, 06:37    [7015251]     Ответить | Цитировать Сообщить модератору
     Re: Восстановление из бекапа на новый релиз Oracle  [new]
    Chilik
    Member

    Откуда:
    Сообщений: 107
    Вячеслав Любомудров,

    -bash-3.00$ ls -l $ORACLE_HOME/bin/oracle
    /bin/oracle: No such file or directory
    3 апр 09, 12:05    [7016708]     Ответить | Цитировать Сообщить модератору
     Re: Восстановление из бекапа на новый релиз Oracle  [new]
    MacDuck
    Member

    Откуда: Москва-Подольск
    Сообщений: 6387
    Chilik

    -bash-3.00$ ls -l $ORACLE_HOME/bin/oracle
    /bin/oracle: No such file or directory


    :-) Пятница...
    3 апр 09, 12:11    [7016766]     Ответить | Цитировать Сообщить модератору
     Re: Восстановление из бекапа на новый релиз Oracle  [new]
    tru55
    Member

    Откуда: СПб
    Сообщений: 19790
    MacDuck
    Chilik

    -bash-3.00$ ls -l $ORACLE_HOME/bin/oracle
    /bin/oracle: No such file or directory


    :-) Пятница...


    По пятницам исчезают файлы и директории? Ужос
    3 апр 09, 12:13    [7016779]     Ответить | Цитировать Сообщить модератору
     Re: Восстановление из бекапа на новый релиз Oracle  [new]
    Вячеслав Любомудров
    Member

    Откуда: Владивосток
    Сообщений: 18482
    env
    И проверяешь правильную установку переменных окружения
    3 апр 09, 12:17    [7016808]     Ответить | Цитировать Сообщить модератору
     Re: Восстановление из бекапа на новый релиз Oracle  [new]
    Chilik
    Member

    Откуда:
    Сообщений: 107
    Вячеслав Любомудров,

    )) сорри.

    Содержимое файла матрица )

    Лучше бы была тяпница. ))
    3 апр 09, 12:38    [7017009]     Ответить | Цитировать Сообщить модератору
     Re: Восстановление из бекапа на новый релиз Oracle  [new]
    Chilik
    Member

    Откуда:
    Сообщений: 107
    Вячеслав Любомудров,

    create or replace package body dbms_swrf_report_internal wrapped
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","update procedure$ set audit$...","sga heap(1,0)","kglsim object batch")


    No errors.

    Package body created.

    No errors.
    CREATE OR REPLACE PACKAGE dbms_swrf_internal wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim heap")


    CREATE OR REPLACE PACKAGE BODY dbms_swrf_internal wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim heap")


    No errors.
    BEGIN
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","BEGIN
    dbms_swrf_internal....","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE prvt_hdm wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE LIBRARY dbms_hdm_lib wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE BODY prvt_hdm wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    No errors.
    CREATE OR replace TYPE BODY sys.wri$_adv_hdm_t wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE BODY dbms_undo_adv wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    No errors.
    CREATE OR REPLACE PACKAGE prvt_uadv wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    No errors.
    CREATE OR REPLACE PACKAGE BODY prvt_uadv wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    No errors.
    CREATE OR replace TYPE BODY sys.wri$_adv_undo_adv wrapped
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","select audit$,properties fro...","sga heap(1,0)","kglsim heap")


    No errors.
    CREATE OR REPLACE TYPE BODY sqlset_row wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    No errors.
    CREATE OR REPLACE TYPE BODY sqlset_row wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE dbms_sqltune_internal wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    No errors.
    CREATE OR REPLACE PACKAGE dbms_sqltune_internal wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE BODY dbms_sqltune_internal wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    No errors.
    CREATE OR REPLACE PACKAGE BODY dbms_sqltune_internal wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE TYPE BODY sys.wri$_adv_sqltune wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    No errors.
    CREATE OR REPLACE TYPE BODY sys.wri$_adv_sqltune wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE BODY dbms_sqltune wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim heap")


    No errors.
    CREATE OR REPLACE PACKAGE BODY dbms_sqltune wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim heap")


    CREATE OR REPLACE PACKAGE dbms_feature_usage_report AS
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    No errors.
    CREATE OR REPLACE PUBLIC SYNONYM dbms_feature_usage_report
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    GRANT EXECUTE ON dbms_feature_usage_report TO dba
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","GRANT
    EXECUTE ON dbms_featur...","sga heap(1,0)","kglsim heap")


    CREATE OR REPLACE PACKAGE dbms_feature_usage wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE BODY dbms_feature_usage wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE dbms_feature_usage_internal wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE BODY dbms_feature_usage_internal wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    No errors.
    CREATE OR REPLACE PACKAGE BODY dbms_feature_usage_report wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim heap")


    No errors.
    CREATE OR REPLACE PROCEDURE dbms_feature_partition_user
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PROCEDURE dbms_feature_partition_system
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PROCEDURE dbms_feature_plsql_native (
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PROCEDURE dbms_feature_rac
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    create or replace procedure DBMS_FEATURE_TEST_PROC_1
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim heap")


    create or replace procedure DBMS_FEATURE_TEST_PROC_2
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    create or replace procedure DBMS_FEATURE_TEST_PROC_3
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    create or replace procedure DBMS_FEATURE_TEST_PROC_4
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    create or replace procedure DBMS_FEATURE_TEST_PROC_5
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    create or replace procedure DBMS_FEATURE_REGISTER_ALLFEAT
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim heap")


    create or replace procedure DBMS_FEATURE_REGISTER_ALLHWM
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    begin
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","begin
    DBMS_FEATURE_REGISTE...","sga heap(1,0)","kglsim object batch")


    create or replace package body dbms_space wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    No errors.
    BEGIN
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","BEGIN
    EXECUTE IMMEDIATE 'd...","sga heap(1,0)","kglsim object batch")


    create role OEM_ADVISOR
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","select user#,type# from user...","sga heap(1,0)","kglsim object batch")


    grant ADVISOR to OEM_ADVISOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    grant CREATE JOB to OEM_ADVISOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    grant ADMINISTER SQL TUNING SET to OEM_ADVISOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim heap")


    create role OEM_MONITOR
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","select user#,type# from user...","sga heap(1,0)","kglsim object batch")


    grant CREATE SESSION to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    grant SELECT ANY DICTIONARY to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    grant execute on SYS.DBMS_SYSTEM to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    grant execute on SYS.DBMS_MONITOR to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    grant execute on dbms_workload_repository to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    grant ADVISOR to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","select user#,type# from user...","sga heap(1,0)","kglsim object batch")


    grant CREATE JOB to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    grant execute on SYS.DBMS_DRS to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    grant analyze any to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    grant analyze any dictionary to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim heap")


    grant EXECUTE on DBMS_AQADM to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    grant EXECUTE on DBMS_AQ to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    grant EXECUTE on DBMS_SERVER_ALERT to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim heap")


    begin
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim heap")


    create user DBSNMP identified by DBSNMP DEFAULT TABLESPACE SYSAUX PASSWORD EXPIRE ACCOUNT LOCK
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","select user#,type# from user...","sga heap(1,0)","kglsim object batch")


    grant select any dictionary to DBSNMP
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","grant
    select any dictionary ...","sga heap(1,0)","kglsim object batch")


    grant OEM_MONITOR to DBSNMP
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","grant
    OEM_MONITOR to DBSNMP","sga heap(1,0)","kglsim object batch")


    grant create table to DBSNMP
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","grant
    create table to DBSNMP","sga heap(1,0)","kglsim object batch")


    grant create procedure to DBSNMP
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","grant
    create procedure to DB...","sga heap(1,0)","kglsim object batch")


    grant unlimited tablespace to DBSNMP
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","grant
    unlimited tablespace t...","sga heap(1,0)","kglsim object batch")


    GRANT EXECUTE ON DBMS_SERVER_ALERT TO DBSNMP
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","GRANT
    EXECUTE ON DBMS_SERVER...","sga heap(1,0)","kglsim object batch")


    ALTER SESSION SET CURRENT_SCHEMA = DBSNMP
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","ALTER
    SESSION SET CURRENT_SC...","sga heap(1,0)","kglsim object batch")


    CREATE TABLE dbsnmp.mgmt_snapshot(
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","CREATE TABLE dbsnmp.mgmt_sna...","sga heap(1,0)","kglsim object batch")


    CREATE TABLE dbsnmp.mgmt_snapshot_sql(
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","CREATE TABLE dbsnmp.mgmt_sna...","sga heap(1,0)","kglsim heap")


    CREATE TABLE dbsnmp.mgmt_baseline(
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","CREATE TABLE dbsnmp.mgmt_bas...","sga heap(1,0)","kglsim object batch")


    CREATE TABLE dbsnmp.mgmt_baseline_sql(
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","CREATE TABLE dbsnmp.mgmt_bas...","sga heap(1,0)","kglsim object batch")


    CREATE TABLE dbsnmp.mgmt_capture(
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","CREATE TABLE dbsnmp.mgmt_cap...","sga heap(1,0)","kglsim object batch")


    CREATE TABLE dbsnmp.mgmt_capture_sql(
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","CREATE TABLE dbsnmp.mgmt_cap...","sga heap(1,0)","kglsim object batch")


    CREATE TABLE dbsnmp.mgmt_response_config(
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","CREATE TABLE dbsnmp.mgmt_res...","sga heap(1,0)","kglsim object batch")


    CREATE TABLE dbsnmp.mgmt_latest(
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","CREATE TABLE dbsnmp.mgmt_lat...","sga heap(1,0)","kglsim object batch")


    CREATE TABLE dbsnmp.mgmt_latest_sql(
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","CREATE TABLE dbsnmp.mgmt_lat...","sga heap(1,0)","kglsim heap")


    CREATE TABLE dbsnmp.mgmt_history(
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","CREATE TABLE dbsnmp.mgmt_his...","sga heap(1,0)","kglsim object batch")


    CREATE TABLE dbsnmp.mgmt_history_sql(
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","CREATE TABLE dbsnmp.mgmt_his...","sga heap(1,0)","kglsim heap")


    CREATE GLOBAL TEMPORARY TABLE dbsnmp.mgmt_tempt_sql(
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","CREATE GLOBAL TEMPORARY TABL...","sga heap(1,0)","kglsim object batch")


    CREATE sequence dbsnmp.mgmt_response_capture_id
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","select user#,type# from user...","sga heap(1,0)","kglsim object batch")


    CREATE sequence dbsnmp.mgmt_response_snapshot_id
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","select user#,type# from user...","sga heap(1,0)","kglsim object batch")


    AND s.hash_value = v.hash_value
    *
    ERROR at line 5:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","select user#,type# from user...","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE dbsnmp.mgmt_response wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim heap")


    CREATE OR REPLACE PACKAGE BODY dbsnmp.mgmt_response wrapped
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","select user#,type# from user...","sga heap(1,0)","kglsim object batch")


    No errors.
    create type bsln_interval_t as object
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    create type bsln_interval_set as table of bsln_interval_t;
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    create type bsln_observation_t as object
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    create type bsln_observation_set as table of bsln_observation_t;
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    create type bsln_statistics_t as object
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    create type bsln_statistics_set as table of bsln_statistics_t;
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim heap")


    create table mgmt_bsln_datasources
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","create table mgmt_bsln_datas...","sga heap(1,0)","kglsim object batch")


    create table mgmt_bsln_baselines
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","create table mgmt_bsln_basel...","sga heap(1,0)","kglsim object batch")


    create table mgmt_bsln_intervals
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","create table mgmt_bsln_inter...","sga heap(1,0)","kglsim object batch")


    create table mgmt_bsln_metrics
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","create table mgmt_bsln_metri...","sga heap(1,0)","kglsim object batch")


    create table mgmt_bsln_statistics
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","create table mgmt_bsln_stati...","sga heap(1,0)","kglsim object batch")


    create table mgmt_bsln_threshold_parms
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","create table mgmt_bsln_thres...","sga heap(1,0)","kglsim object batch")


    create table mgmt_bsln_rawdata
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","create table mgmt_bsln_rawda...","sga heap(1,0)","kglsim object batch")


    create or replace
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    create or replace
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    create or replace
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim heap")


    create or replace
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim heap")


    insert into mgmt_bsln_metrics
    *
    ERROR at line 17:
    ORA-06550: line 17, column 19:
    PL/SQL: ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","declare
    -----------------...","sga heap(1,0)","kglsim object batch")
    ORA-06550: line 17, column 7:
    PL/SQL: SQL Statement ignored


    grant EXECUTE on dbsnmp.mgmt_response to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    grant select on dbsnmp.mgmt_baseline to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","grant
    select on dbsnmp.mgmt_...","sga heap(1,0)","kglsim object batch")


    grant select on dbsnmp.mgmt_baseline_sql to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","select user#,type# from user...","sga heap(1,0)","kglsim object batch")


    grant select on dbsnmp.mgmt_latest to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","grant
    select on dbsnmp.mgmt_...","sga heap(1,0)","kglsim object batch")


    grant select on dbsnmp.mgmt_latest_sql to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","grant
    select on dbsnmp.mgmt_...","sga heap(1,0)","kglsim object batch")


    grant select on dbsnmp.mgmt_history to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","grant
    select on dbsnmp.mgmt_...","sga heap(1,0)","kglsim object batch")


    grant select on dbsnmp.mgmt_history_sql to OEM_MONITOR
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","grant
    select on dbsnmp.mgmt_...","sga heap(1,0)","kglsim object batch")


    create global temporary table mgmt_db_file_gtt (
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","create global temporary tabl...","sga heap(1,0)","kglsim object batch")


    create global temporary table mgmt_db_size_gtt (
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","create global temporary tabl...","sga heap(1,0)","kglsim object batch")


    ALTER SESSION SET CURRENT_SCHEMA = SYS
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","ALTER
    SESSION SET CURRENT_SC...","sga heap(1,0)","kglsim heap")


    CREATE OR REPLACE LIBRARY DBMS_LDAP_API_LIB wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE DBMS_LDAP AS
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE DBMS_LDAP_UTL AS
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE dbms_ldap_api_ffi wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE BODY DBMS_LDAP wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE BODY DBMS_LDAP_UTL wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE BODY dbms_ldap_api_ffi wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PUBLIC SYNONYM dbms_ldap FOR sys.dbms_ldap
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    GRANT EXECUTE ON DBMS_LDAP TO PUBLIC
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","GRANT
    EXECUTE ON DBMS_LDAP ...","sga heap(1,0)","kglsim heap")


    CREATE OR REPLACE PUBLIC SYNONYM dbms_ldap_utl FOR sys.dbms_ldap_utl
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    GRANT EXECUTE ON DBMS_LDAP_UTL TO PUBLIC
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","GRANT
    EXECUTE ON DBMS_LDAP_U...","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE utl_match IS
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    No errors.
    GRANT EXECUTE ON utl_match TO PUBLIC
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","GRANT
    EXECUTE ON utl_match T...","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PUBLIC SYNONYM utl_match FOR sys.utl_match
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    create or replace package dbms_db_version is
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    create or replace public synonym dbms_db_version for dbms_db_version
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    grant execute on dbms_db_version to public
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","grant
    execute on dbms_db_ver...","sga heap(1,0)","kglsim object batch")


    CREATE TABLE recent_resource_incarnations$
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","CREATE TABLE recent_resource...","sga heap(1,0)","kglsim object batch")


    comment on column recent_resource_incarnations$.STARTUP_TIME is
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","comment on column recent_res...","sga heap(1,0)","kglsim object batch")


    comment on column recent_resource_incarnations$.SHUTDOWN_TIME is
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","comment on column recent_res...","sga heap(1,0)","kglsim object batch")


    from RECENT_RESOURCE_INCARNATIONS$
    *
    ERROR at line 5:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    comment on table DBA_RESOURCE_INCARNATIONS is
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","comment on table DBA_RESOURC...","sga heap(1,0)","kglsim object batch")


    comment on column DBA_RESOURCE_INCARNATIONS.RESOURCE_TYPE is
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","comment on column DBA_RESOUR...","sga heap(1,0)","kglsim object batch")


    comment on column DBA_RESOURCE_INCARNATIONS.RESOURCE_NAME is
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","comment on column DBA_RESOUR...","sga heap(1,0)","kglsim heap")


    comment on column DBA_RESOURCE_INCARNATIONS.DB_UNIQUE_NAME is
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","comment on column DBA_RESOUR...","sga heap(1,0)","kglsim object batch")


    comment on column DBA_RESOURCE_INCARNATIONS.DB_DOMAIN is
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","comment on column DBA_RESOUR...","sga heap(1,0)","kglsim object batch")


    comment on column DBA_RESOURCE_INCARNATIONS.INSTANCE_NAME is
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","comment on column DBA_RESOUR...","sga heap(1,0)","kglsim object batch")


    comment on column DBA_RESOURCE_INCARNATIONS.HOST_NAME is
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","comment on column DBA_RESOUR...","sga heap(1,0)","kglsim object batch")


    comment on column DBA_RESOURCE_INCARNATIONS.STARTUP_TIME is
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","comment on column DBA_RESOUR...","sga heap(1,0)","kglsim object batch")


    create or replace public synonym DBA_RESOURCE_INCARNATIONS
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    grant select on DBA_RESOURCE_INCARNATIONS to select_catalog_role
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","grant
    select on DBA_RESOURCE...","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE LIBRARY DBMS_HA_ALERT_LIB wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE dbms_ha_alerts wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim heap")


    CREATE OR REPLACE PACKAGE BODY dbms_ha_alerts wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE dbms_ha_alerts_prvt wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE PACKAGE BODY dbms_ha_alerts_prvt wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    CREATE OR REPLACE LIBRARY DBMS_HAEVENTNOT_PRVT_LIB TRUSTED AS STATIC;
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    create or replace function haen_txfm_text(
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    begin
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","begin
    sys.dbms_transform.c...","sga heap(1,0)","kglsim heap")


    declare
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","declare
    subscriber sys.aq$_a...","sga heap(1,0)","kglsim heap")


    CREATE OR REPLACE PACKAGE BODY dbms_tde_toolkit_ffi wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    No errors.
    CREATE OR REPLACE PACKAGE BODY dbms_tde_toolkit wrapped
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","unknown object","sga heap(1,0)","kglsim object batch")


    ERROR:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","BEGIN
    DBMS_OUTPUT.ENABLE(NUL...","sga heap(1,0)","kglsim object batch")


    BEGIN
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","BEGIN
    dbms_registry.updat...","sga heap(1,0)","kglsim object batch")


    ERROR:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","BEGIN
    DBMS_OUTPUT.DISABLE; END;","sga heap(1,0)","kglsim object batch")


    SELECT dbms_registry_sys.time_stamp('CATPROC') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim object batch")


    SELECT dbms_registry_sys.time_stamp('RDBMS_END') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim object batch")


    SELECT dbms_registry_sys.patch_script('JAVAVM') AS patch_name FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.pat...","sga heap(1,0)","kglsim object batch")


    Enter value for patch_file: 10.2.0.2.0
    SP2-0310: unable to open file "10.2.0.2.0"
    SELECT dbms_registry_sys.time_stamp('JAVAVM') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim object batch")


    SELECT dbms_registry_sys.patch_script('XML') AS patch_name FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.pat...","sga heap(1,0)","kglsim object batch")


    Enter value for patch_file:

    SELECT dbms_registry_sys.time_stamp('XML') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim object batch")


    SELECT dbms_registry_sys.patch_script('CATJAVA') AS patch_name FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.pat...","sga heap(1,0)","kglsim object batch")


    Enter value for patch_file: SELECT dbms_registry_sys.time_stamp('CATJAVA') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim object batch")


    SELECT dbms_registry_sys.patch_script('CONTEXT') AS patch_name FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.pat...","sga heap(1,0)","kglsim object batch")


    Enter value for patch_file:
    SELECT dbms_registry_sys.time_stamp('CONTEXT') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim heap")


    SELECT dbms_registry_sys.patch_script('XDB') AS patch_name FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.pat...","sga heap(1,0)","kglsim object batch")


    Enter value for patch_file:
    SELECT dbms_registry_sys.time_stamp('XDB') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim object batch")


    SELECT dbms_registry_sys.patch_script('RAC') AS patch_name FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.pat...","sga heap(1,0)","kglsim object batch")


    Enter value for patch_file:
    SELECT dbms_registry_sys.time_stamp('RAC') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim object batch")


    SELECT dbms_registry_sys.patch_script('ODM') AS patch_name FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.pat...","sga heap(1,0)","kglsim object batch")


    Enter value for patch_file:
    SELECT dbms_registry_sys.time_stamp('ODM') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim heap")


    SELECT dbms_registry_sys.patch_script('APS') AS patch_name FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.pat...","sga heap(1,0)","kglsim object batch")


    Enter value for patch_file:
    SELECT dbms_registry_sys.time_stamp('APS') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim object batch")


    SELECT dbms_registry_sys.patch_script('AMD') AS patch_name FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.pat...","sga heap(1,0)","kglsim object batch")


    Enter value for patch_file:
    SELECT dbms_registry_sys.time_stamp('AMD') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim object batch")


    SELECT dbms_registry_sys.patch_script('XOQ') AS patch_name FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.pat...","sga heap(1,0)","kglsim object batch")


    Enter value for patch_file:
    SELECT dbms_registry_sys.time_stamp('XOQ') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim object batch")


    SELECT dbms_registry_sys.patch_script('ORDIM') AS patch_name FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.pat...","sga heap(1,0)","kglsim heap")


    Enter value for patch_file:
    SELECT dbms_registry_sys.time_stamp('ORDIM') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim heap")


    SELECT dbms_registry_sys.patch_script('SDO') AS patch_name FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.pat...","sga heap(1,0)","kglsim object batch")


    Enter value for patch_file:
    SELECT dbms_registry_sys.time_stamp('SDO') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim object batch")


    SELECT dbms_registry_sys.patch_script('WK') AS patch_name FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.pat...","sga heap(1,0)","kglsim object batch")


    Enter value for patch_file:
    SELECT dbms_registry_sys.time_stamp('WK') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim object batch")


    SELECT dbms_registry_sys.patch_script('OLS') AS patch_name FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.pat...","sga heap(1,0)","kglsim object batch")


    Enter value for patch_file:
    SELECT dbms_registry_sys.time_stamp('OLS') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim object batch")


    SELECT dbms_registry_sys.patch_script('EXF') AS patch_name FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.pat...","sga heap(1,0)","kglsim object batch")


    Enter value for patch_file:
    SELECT dbms_registry_sys.time_stamp('EXF') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim object batch")


    SELECT dbms_registry_sys.patch_script('EM') AS patch_name FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.pat...","sga heap(1,0)","kglsim object batch")


    Enter value for patch_file:
    SELECT dbms_registry_sys.time_stamp('EM') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim object batch")


    SELECT dbms_registry_sys.patch_script('RUL') AS patch_name FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.pat...","sga heap(1,0)","kglsim object batch")


    Enter value for patch_file:
    SELECT dbms_registry_sys.time_stamp('RUL') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim object batch")


    ERROR:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","BEGIN
    DBMS_OUTPUT.DISABLE; END;","sga heap(1,0)","kglsim object batch")


    ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT OFF'
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","ALTER
    SESSION SET EVENTS '10...","sga heap(1,0)","kglsim object batch")


    declare
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","declare
    rowcnt number;
    beg...","sga heap(1,0)","kglsim object batch")



    BEGIN
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","BEGIN
    dbms_registry_sys.r...","sga heap(1,0)","kglsim object batch")


    SELECT dbms_registry_sys.time_stamp('UPGRD_END') AS timestamp FROM DUAL
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared
    pool","SELECT dbms_registry_sys.tim...","sga heap(1,0)","kglsim object batch")


    ERROR:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","BEGIN
    DBMS_OUTPUT.ENABLE(NUL...","sga heap(1,0)","kglsim object batch")


    DECLARE
    *
    ERROR at line 1:
    ORA-04031: unable to allocate 4064 bytes of shared memory ("shared
    pool","DECLARE
    display_mode VAR...","sga heap(1,0)","kglsim heap")


    ERROR:
    ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","BEGIN
    DBMS_OUTPUT.DISABLE; END;","sga heap(1,0)","kglsim object batch")


    DOC>#######################################################################
    DOC>#######################################################################
    DOC>
    DOC> The above PL/SQL lists the SERVER components in the upgraded
    DOC> database, along with their current version and status.
    DOC>
    DOC> Please review the status and version columns and look for
    DOC> any errors in the spool log file. If there are errors in the spool
    DOC> file, or any components are not VALID or not the current version,
    DOC> consult the Oracle Database Upgrade Guide for troubleshooting
    DOC> recommendations.
    DOC>
    DOC> Next shutdown immediate, restart for normal operation, and then
    DOC> run utlrp.sql to recompile any invalid application objects.
    DOC>
    DOC>#######################################################################
    DOC>#######################################################################
    DOC>#
    SQL> SQL>
    SQL>
    SQL>
    SQL>
    SQL>
    SQL>
    SQL>
    SQL>
    3 апр 09, 12:50    [7017124]     Ответить | Цитировать Сообщить модератору
     Re: Восстановление из бекапа на новый релиз Oracle  [new]
    Chilik
    Member

    Откуда:
    Сообщений: 107
    Что делать с этими ошибками?
    3 апр 09, 13:02    [7017222]     Ответить | Цитировать Сообщить модератору
     Re: Восстановление из бекапа на новый релиз Oracle  [new]
    Вячеслав Любомудров
    Member

    Откуда: Владивосток
    Сообщений: 18482
    Ну, очевидно, увеличить параматры памяти (например, SGA_TARGET, или, более тонко, (а оно надо?), SHARED_POOL_SIZE)
    3 апр 09, 13:06    [7017251]     Ответить | Цитировать Сообщить модератору
     Re: Восстановление из бекапа на новый релиз Oracle  [new]
    Chilik
    Member

    Откуда:
    Сообщений: 107
    Вячеслав Любомудров,

    Нет это понятно, скипт повторно нужно запустить?
    3 апр 09, 13:08    [7017272]     Ответить | Цитировать Сообщить модератору
     Re: Восстановление из бекапа на новый релиз Oracle  [new]
    Chilik
    Member

    Откуда:
    Сообщений: 107
    И в скрипте возникает запрос
    Enter value for patch_file:
    что нужно вводить?
    3 апр 09, 13:09    [7017287]     Ответить | Цитировать Сообщить модератору
     Re: Восстановление из бекапа на новый релиз Oracle  [new]
    Вячеслав Любомудров
    Member

    Откуда: Владивосток
    Сообщений: 18482
    Я бы повторил с нуля
    3 апр 09, 13:15    [7017332]     Ответить | Цитировать Сообщить модератору
     Re: Восстановление из бекапа на новый релиз Oracle  [new]
    Chilik
    Member

    Откуда:
    Сообщений: 107
    Помоги выставить правильно размеры памяти
    сейчас так
    SQL> show parameter SGA_TARGET

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    sga_target big integer 584M
    SQL> show parameter SHARED_POOL_SIZE

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    shared_pool_size big integer 112M
    SQL> show parameter JAVA_POOL_SIZE

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    java_pool_size big integer 4M


    Чтобы избавиться от ошибок такого рода


    ERROR at line 1:
    ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","unknown
    object","joxlod exec hp","SGAClass")


    PL/SQL: ORA-04031: unable to allocate 1040 bytes of shared memory
    ("shared pool","IND$SYS","PL/SQL DIANA","PAR.C:parchk:page")


    -bash-3.00$ /usr/sbin/prtconf | grep "Memory size"
    Memory size: 2046 Megabytes
    3 апр 09, 15:11    [7018492]     Ответить | Цитировать Сообщить модератору
     Re: Восстановление из бекапа на новый релиз Oracle  [new]
    недо scna
    Member

    Откуда:
    Сообщений: 762
    пытался я как-то такой фигней пострадать, даже макдака по аське мучал. имхо стандартных путей под такое извращение не существует. потом забил и сначала заапгрейдил, а потом уже пересоздавал контрольники.
    3 апр 09, 15:20    [7018603]     Ответить | Цитировать Сообщить модератору
    Топик располагается на нескольких страницах: [1] 2   вперед  Ctrl      все
    Все форумы / Oracle Ответить