Гость
Войти | Профиль | Очистить
Целевая тема:
Создать новую тему:
Автор:
Действия ...
Форумы / Oracle [игнор отключен] [закрыт для гостей] / После миграции 10g2(x32) -> 10g2(x64) перестала работать v$session / 6 сообщений из 6, страница 1 из 1
01.10.2016, 09:53:43
    #39319063
GunPowder
GunPowder
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
После миграции 10g2(x32) -> 10g2(x64) перестала работать v$session
Всем привет!
"Смигрировал" 10g2(x32) -> 10g2(x64):

установил ОРУ на новый сервер
перенёс файлы БД
создал инстанс
стартанул startup UPGRADE
выполнил utlirp
перестартовал обычно
выполнил utlrp
таблицы целые, полные
инвалидов нет

Толстый клиент валится на первом же селекте из паккаджа:

Код: plsql
1.
2.
3.
4.
5.
6.
rENV_SESSION      V$SESSION%rowtype;

select *
into rENV_SESSION
from V$SESSION
where AUDSID = userenv('SESSIONID');



ORA-06502: PL/SQL: numeric or value error

простой селект из V$SESSION из-под пользователя работает

ничего не понимаю..
прошу помощи зала.
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
01.10.2016, 10:14:28
    #39319065
компилируй это
компилируй это
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
После миграции 10g2(x32) -> 10g2(x64) перестала работать v$session
GunPowder,

по паре строк не понятно кто-кого вызывает и причем тут "клиент".
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
01.10.2016, 10:56:18
    #39319070
GunPowder
GunPowder
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
После миграции 10g2(x32) -> 10g2(x64) перестала работать v$session
хотел как лучше, обрезал всё лишнее, оставил кусок кода на котором валится

валится на "select * from v$session" в переменную, которая была инициализирована с типом "строка из v$session"

незнаю, как ещё объяснить
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
01.10.2016, 11:28:12
    #39319075
AlexFF__|
AlexFF__|
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
После миграции 10g2(x32) -> 10g2(x64) перестала работать v$session
GunPowder,
Тупо создай свой тип на основе V$SESSION%rowtype, поля SADDR, PADDR, SQL_ADDRESS, PREV_SQL_ADDR определи как RAW(8).
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
01.10.2016, 12:17:48
    #39319081
рекомпилька
рекомпилька
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
После миграции 10g2(x32) -> 10g2(x64) перестала работать v$session
GunPowder,

перекомпиляй пакет, если desc v_$session рав4, сначала весь словарь.
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
01.10.2016, 14:04:17
    #39319098
GunPowder
GunPowder
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
После миграции 10g2(x32) -> 10g2(x64) перестала работать v$session
Прогнал АпгрейдАссистант, результат не очень:

 
Код: xml
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
Upgrade Details
The following is a summary of the steps performed during the database upgrade. Log files for all the steps, as well as this summary, are available at "C:\oracle\ora102\cfgtoollogs\dbua\LEG1\upgrade2".
Step Name Log File Name Status 
Pre Upgrade PreUpgrade.log Successful 
Oracle Server Oracle_Server.log Successful* 
Post Upgrade PostUpgrade.log Successful* 
Generate Summary generateSummary.log Successful 

*Some information about the step is available.
Step Execution Information:
Oracle Server
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."AQ$_REG_INFO" has errors. PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."AQ$_REG_INFO" has errors. PLS-00305: previous use of 'AQ$_REG_INFO' (at line 8) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."AQ$_SRVNTFN_MESSAGE" has errors. PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."XMLGENFORMATTYPE" has errors. PLS-00305: previous use of 'CREATEFORMAT2' (at line 49) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."XMLGENFORMATTYPE" has errors. PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."LCR$_ROW_UNIT" has errors. PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."LCR$_ROW_UNIT" has errors. PLS-00305: previous use of 'LCR$_ROW_UNIT' (at line 9) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."LCR$_ROW_RECORD" has errors. PLS-00305: previous use of 'GET_VALUES' (at line 159) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."LCR$_ROW_RECORD" has errors. PLS-00305: previous use of 'GET_EXTRA_ATTRIBUTE' (at line 223) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."LCR$_ROW_RECORD" has errors. PLS-00305: previous use of 'SET_EXTRA_ATTRIBUTE' (at line 227) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."LCR$_ROW_RECORD" has errors. PLS-00305: previous use of 'GET_COMPATIBLE' (at line 233) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."LCR$_ROW_RECORD" has errors. PLS-00305: previous use of 'GET_LONG_INFORMATION' (at line 83) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."LCR$_ROW_RECORD" has errors. PLS-00305: previous use of 'CONVERT_LONG_TO_LOB_CHUNK' (at line 237) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."LCR$_DDL_RECORD" has errors. PLS-00305: previous use of 'GET_EXTRA_ATTRIBUTE' (at line 140) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."LCR$_DDL_RECORD" has errors. PLS-00305: previous use of 'SET_EXTRA_ATTRIBUTE' (at line 145) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."LCR$_DDL_RECORD" has errors. PLS-00305: previous use of 'GET_COMPATIBLE' (at line 151) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."WRI$_ADV_ABSTRACT_T" has errors. PLS-00305: previous use of 'SUB_IMPLEMENT' (at line 43) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."WRI$_ADV_SQLACCESS_ADV" has errors. PLS-00305: previous use of 'SUB_IMPLEMENT' (at line 40) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."WRI$_ADV_TUNEMVIEW_ADV" has errors. PLS-00305: previous use of 'SUB_IMPLEMENT' (at line 35) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."MSG_PROP_T" has errors. PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."AQ$_SRVNTFN_MESSAGE" has errors. PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-23292: The constraint does not exist
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."AQ$_REG_INFO" has errors. PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."AQ$_REG_INFO" has errors. PLS-00305: previous use of 'AQ$_REG_INFO' (at line 17) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."AQ$_REG_INFO" has errors. PLS-00305: previous use of 'AQ$_REG_INFO' (at line 25) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."AQ$_EVENT_MESSAGE" has errors. PLS-00719: only widening of attribute 'SUB_NAME' constraints is allowed ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."AQ$_SRVNTFN_MESSAGE" has errors. PLS-00719: only widening of attribute 'QUEUE_NAME' constraints is allowed ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."AQ$_DESCRIPTOR" has errors. PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."LCR$_ROW_RECORD" has errors. PLS-00305: previous use of 'GET_SOURCE_TIME' (at line 241) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."LCR$_DDL_RECORD" has errors. PLS-00305: previous use of 'GET_SOURCE_TIME' (at line 154) conflicts with this use ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated
Error ignored: ORA-22324: altered type has compilation errors ORA-22328: object "SYS"."DBMS_XPLAN_TYPE" has errors. PLS-00719: only widening of attribute 'PLAN_TABLE_OUTPUT' constraints is allowed ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated



но первоначальная ошибка касаемо v$session ушла.

Нужно что-то делать с это кучкой новых ошибок?
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
Форумы / Oracle [игнор отключен] [закрыт для гостей] / После миграции 10g2(x32) -> 10g2(x64) перестала работать v$session / 6 сообщений из 6, страница 1 из 1
Найденые пользователи ...
Разблокировать пользователей ...
Читали тему (0):
Читали форум (0):
Пользователи онлайн (0):
Польз. соглашение  
Полит. конфиден.  
созд. / загр.: 463ms
Закрыть
start [/forum/topic.php?fid=52&mobile=1&tid=1887344]:
 0ms
get settings:
 6ms
get forum list:
 12ms
check forum access:
 2ms
check topic access:
 2ms
track hit:
 177ms
get topic data:
 8ms
get forum data:
 2ms
get page messages:
 29ms
get tp. blocked users:
 1ms
others: 224ms
total:  463ms
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]