ReSQL.ru
     
powered by simpleCommunicator - 2.0.61     © 2026 Programmizd 02
Мобильная версия    Контакт    Правила    FAQ    Помощь
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Доб. в избранное | Игнор. тему | Прикреп. тему | Пометить прочит. / непрочит. | Фильтр
Форумы / Oracle [игнор отключен] [закрыт для гостей] / После миграции 10g2(x32) -> 10g2(x64) перестала работать v$session
6 сообщений из 6, страница 1 из 1
После миграции 10g2(x32) -> 10g2(x64) перестала работать v$session
    #39319063
GunPowder
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
GunPowder
Гость
Всем привет!
"Смигрировал" 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, 09:53
| Ответить | Цитировать | Написать  
После миграции 10g2(x32) -> 10g2(x64) перестала работать v$session
    #39319065
компилируй это
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
компилируй это
Гость
GunPowder,

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

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

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

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

 
Код: 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
01.10.2016, 14:04
| Ответить | Цитировать | Написать  
6 сообщений из 6, страница 1 из 1
Форумы / Oracle [игнор отключен] [закрыт для гостей] / После миграции 10g2(x32) -> 10g2(x64) перестала работать v$session
Найденые пользователи ...
Разблокировать пользователей ...
Читали тему (0):
Читали форум (0):
Пользователи онлайн (0):
Польз. соглашение   Полит. конфиден.  
NoSQL.ru       Кролег: Проекты, Новости, Чат       РЕД ФОРУМ       Фотоальбом: Участники, Встречи
Закрыть
start [/forum/topic.php?fid=52&fpage=198&tid=1887344]:
 0ms
get settings:
 7ms
get forum list:
 16ms
check forum access:
 3ms
check topic access:
 3ms
track hit:
 57ms
get topic data:
 9ms
get forum data:
 3ms
get page messages:
 33ms
get tp. blocked users:
 1ms
others: 211ms
total:  343ms
созд. / загр.: 343ms
x
x
Закрыть


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