|
|
|
ORA-04030
|
|||
|---|---|---|---|
|
#18+
Вот такая проблемка. Делаю запрос Код: plaintext 1. код вьюшки Код: plaintext 1. Запрос "висит" около получаса и выдает ошибку Код: plaintext запись в alert.log после этого Код: plaintext тоже происходит когда я пытають посмотреть план выполнения запроса Экпериментально я дошел до того, что когда во время выполнения запроса дропнуть вьюшку oracle выдает Код: plaintext После этого я вновь создаю вьюшку Код: plaintext 1. запрос Код: plaintext 1. выполняется успешно. Таблица большая и разбита на партиции. Ошибка появляется вновь после того как я добавляю еще одну партицию (возможно и не только после этого). Такая ошибка проявляется при запросах из вьюшек построеных на этой таблице. О сервере: Oracle 9.2.0.0 Linux SuSE 8.0 Memory 2GB Есть у кого-то идеи как бороться с этой ошибкой ??? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 05.04.2003, 13:00 |
|
||
|
ORA-04030
|
|||
|---|---|---|---|
|
#18+
>О сервере: >Oracle 9.2.0.0 думаю патч поможет. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 05.04.2003, 15:48 |
|
||
|
ORA-04030
|
|||
|---|---|---|---|
|
#18+
Можег дать линк? А то я в жизни не устанавливал патчи. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 05.04.2003, 19:55 |
|
||
|
ORA-04030
|
|||
|---|---|---|---|
|
#18+
>Можег дать линк? А то я в жизни не устанавливал патчи. все здесь - metalink.oracle.com - только для доступа надо иметь саппорт контракт. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 05.04.2003, 20:06 |
|
||
|
ORA-04030
|
|||
|---|---|---|---|
|
#18+
Вот что дал поверхностный поиск в металинке. Там есть еше несколько страниц про похожие ситуации. ЙЙ <metalink> Subject: Re : ORA-00600: internal error code, arguments: [17059], [2689504388] Hi, The [17059] is caused by cursor authorization table overflows due to duplicate cursor entries. It's a PROCESS FAILURE and it's NON CORRUPTIVE - No underlying data corruption. The [14500] is issued when the lookup of an encrypted password (at login time) returns false because of an invalid parent object. It's Non-corruptive and you should repeat the login operation. This can happen if during the Oracle initialization phase someone else tries to connect as sys or internal. The problem is that the database is not yet initialized and the second login attempt can't forward the passsword information to the correect cursor (because the database is still being initialized), and gives you the errors you see. =============== Bookmark Fixed font Go to End Doc ID: Note:212071.1 Subject: ALERT: ORA-00600 or ORA-04030 installing iFS on 9.0.1 or 9.2 database Type: ALERT Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 25-SEP-2002 Last Revision Date: 12-FEB-2003 ORA-00600 or ORA-04030 installing iFS on 9.0.1.3+ or 9.2 database ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Versions Affected ~~~~~~~~~~~~~~~~~ Internet File System 1.1.10.x, 9.0.1, 9.0.2 Oracle Database 9.0.1 or 9.2 Enterprise Edition Platforms Affected ~~~~~~~~~~~~~~~~~~ GENERIC. All platforms. Description ~~~~~~~~~~~ After installation, attempting to bring up iFS for the first time using ifsstartdomain fails with an error reported in the node.log: ORA-04030 or ORA-00600 internal error code, arguments: [17059]. When the iFS schema is created by the iFS Configuration Assistant (CA), the iFS CA creates a partitioned table odm_publicobject (if partitioning is available, by default the Enterprise Edition of the database has partitioning). Then the configuration assistant adjusts the classids which are in each partition. Views which are based on this partition get into a bad state because of the adjustments to the classids in the partitions, and when queries are issued against these views during ifsstartdomain, the database spins attempting to recompile the views and consumes memory until the ORA-00600 or ORA-04030 failure. This does not affect CMSDK 9.0.3 or Oracle Files 9.0.3, as they no longer use partitioning by default. Likelihood of Occurrence ~~~~~~~~~~~~~~~~~~~~~~~~ Anyone using Enterprise Edition may run into this. More likely with 9.2 database. Reported on 9.0.1.3 and 9.0.1.4 database. Possible Symptoms ~~~~~~~~~~~~~~~~~ After installation, attempting to bring up iFS for the first time using ifsstartdomain fails with an error reported in the node.log: ORA-04030 or ORA-00600 internal error code, arguments: [17059]. This error could occur on an existing system if new subclasses are created and the odm_publicobject table is repartitioned. Workaround ~~~~~~~~~~ Execute the following SQL IN ORDER as the iFS schema owner (typically IFSSYS): alter view ODMV_PUBLICOBJECT compile; alter view ODBV_PUBLICOBJECT compile; alter view ODMBS_PUBLICOBJECT compile; alter view ODMS_PUBLICOBJECT compile; alter view ODUS_PUBLICOBJECT compile; alter view ODUV_PUBLICOBJECT compile; These must be executed in order because there's a dependency among these views. The first two views depend on odm_publicobject, and then the second set of views depend on the first set of views. Patches ~~~~~~~ Please contact Oracle Worldwide Support to find out if a patch is available. Planned to be patched in Oracle database 9.2.0.2. References ~~~~~~~~~~ 9.2.0.1 WINDOWS DB - ORA-00600 ERROR ON GET PREPARED STATEMENT [BUG:2407382] VIEW ON PARTITIONED TABLE AFTER ADDING VALUE TO UNDERLYING PARTITION HANGS [BUG:2208882] ______________________________________________________________________________ Oracle Support Services . -------------------------------------------------------------------------------- Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use. </metalink> ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 06.04.2003, 00:51 |
|
||
|
|

start [/forum/topic.php?fid=52&msg=32134158&tid=1991146]: |
0ms |
get settings: |
7ms |
get forum list: |
10ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
164ms |
get topic data: |
10ms |
get forum data: |
3ms |
get page messages: |
40ms |
get tp. blocked users: |
1ms |
| others: | 237ms |
| total: | 476ms |

| 0 / 0 |
