Reason: there is one BUG with Time Zone(TZ or DST_PRIMARY_TT_VERSION) and Oracle Streams technology. Well between two databases should be the same TZ version.
In my case on one DB there was TZ 11 and on another 14 and there was ORA-600. Oracle server versions and editions are the same 11.2.0.2 x64 on RHEL 5. Information applies to any platform.
So how to update TZ from 11 to 14:
My ENV
USERNAME
HOST_NAME VERSION
-------------- ----------------- ------------
SYS
lv-oracle-test1
11.2.0.2.0
SQL >
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME;
PROPERTY_NAME
VALUE
------------------------------
------------------------------
DST_PRIMARY_TT_VERSION
11
DST_SECONDARY_TT_VERSION
0
DST_UPGRADE_STATE
NONE
SQL> alter session set "_with_subquery"=materialize;
Session altered.
SQL> exec DBMS_DST.BEGIN_PREPARE(14);
PL/SQL procedure successfully completed.
SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME;
PROPERTY_NAME
VALUE
------------------------------
------------------------------
DST_PRIMARY_TT_VERSION
11
DST_SECONDARY_TT_VERSION
14
DST_UPGRADE_STATE
PREPARE
TRUNCATE TABLE SYS.DST$TRIGGER_TABLE;
TRUNCATE TABLE sys.dst$affected_tables;
TRUNCATE TABLE sys.dst$error_table;
Table truncated.
SQL>
Table truncated.
SQL>
Table truncated.
set serveroutput on
BEGIN
DBMS_DST.FIND_AFFECTED_TABLES
(affected_tables => 'sys.dst$affected_tables',
log_errors => TRUE,
log_errors_table => 'sys.dst$error_table');
END;
SQL> 2 3
4 5 6 7 /
PL/SQL procedure successfully completed.
SQL> SQL> SQL> SELECT * FROM
sys.dst$affected_tables;
no rows selected
SQL> SELECT * FROM sys.dst$error_table;
no rows selected
SQL> EXEC DBMS_DST.END_PREPARE;
A prepare window has been successfully ended.
PL/SQL procedure successfully completed.
SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME;
PROPERTY_NAME
VALUE
------------------------------
------------------------------
DST_PRIMARY_TT_VERSION
11
DST_SECONDARY_TT_VERSION
0
DST_UPGRADE_STATE
NONE
SQL>
SQL>
SQL> shutdown immediate
startup upgrade;
set serveroutput on
SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME;
Database closed.
Database dismounted.
purge dba_recyclebin;
ORACLE instance shut down.
SQL> ORACLE instance started.
Total System Global Area 1043886080 bytes
Fixed
Size
2233088 bytes
Variable
Size
784338176 bytes
Database
Buffers 251658240 bytes
Redo
Buffers
5656576 bytes
Database mounted.
Database opened.
SQL> SQL> 2
3 4
PROPERTY_NAME
VALUE
------------------------------
------------------------------
DST_PRIMARY_TT_VERSION
11
DST_SECONDARY_TT_VERSION
0
DST_UPGRADE_STATE
NONE
SQL>
DBA Recyclebin purged.
SQL> SQL> SQL> SQL> SQL> SQL> SQL>
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
TRUNCATE TABLE SYS.DST$TRIGGER_TABLE;
TRUNCATE TABLE sys.dst$affected_tables;
Table truncated.
SQL>
Table truncated.
SQL> TRUNCATE TABLE sys.dst$error_table;
Table truncated.
SQL> EXEC DBMS_DST.BEGIN_UPGRADE(14);
An upgrade window has been successfully started.
PL/SQL procedure successfully completed.
SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME;
PROPERTY_NAME
VALUE
------------------------------
------------------------------
DST_PRIMARY_TT_VERSION
14
DST_SECONDARY_TT_VERSION
11
DST_UPGRADE_STATE
UPGRADE
SQL> SELECT OWNER, TABLE_NAME, UPGRADE_IN_PROGRESS FROM
ALL_TSTZ_TABLES where UPGRADE_IN_PROGRESS='YES';
OWNER
TABLE_NAME
UPG
------------------------------
------------------------------ ---
SYSMAN
AQ$_MGMT_LOADER_QTABLE_L YES
SYSMAN
AQ$_MGMT_LOADER_QTABLE_S YES
SYSMAN
AQ$_MGMT_NOTIFY_QTABLE_L YES
SYSMAN
AQ$_MGMT_NOTIFY_QTABLE_S YES
SYSMAN
MGMT_PROV_ASSIGNMENT
YES
SYSMAN
MGMT_PROV_BOOTSERVER
YES
SYSMAN
MGMT_PROV_CLUSTER_NODES YES
SYSMAN
MGMT_PROV_DEFAULT_IMAGE YES
SYSMAN
MGMT_PROV_IP_RANGE
YES
SYSMAN
MGMT_PROV_NET_CONFIG
YES
SYSMAN
MGMT_PROV_OPERATION
YES
SYSMAN
MGMT_PROV_RPM_REP
YES
SYSMAN
MGMT_PROV_STAGING_DIRS YES
SYSMAN
MGMT_PROV_SUITE_INST_MEMBERS YES
STREAMADMIN
AQ$_DST_BOOK_ENTRIES_T_L YES
STREAMADMIN
AQ$_DST_BOOK_ENTRIES_T_S YES
STREAMADMIN
AQ$_DST_MSGLOG_MESSAGES_T_L YES
STREAMADMIN
AQ$_DST_MSGLOG_MESSAGES_T_S
YES
18 rows selected.
SQL>
SQL>
shutdown immediate
startup
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> ORACLE instance started.
Total System Global Area 1043886080 bytes
Fixed
Size
2233088 bytes
Variable
Size
784338176 bytes
Database
Buffers 251658240 bytes
Redo
Buffers
5656576 bytes
Database mounted.
Database opened.
SQL> SQL> SQL>
SQL>
SQL>
SQL>
SQL> alter session set
"_with_subquery"=materialize;
Session altered.
SQL> set serveroutput on
VAR numfail number
log_errors_table => 'SYS.DST$ERROR_TABLE',
BEGIN
DBMS_DST.UPGRADE_DATABASE(:numfail,
parallel => TRUE,
log_errors => TRUE,
log_errors_table => 'SYS.DST$ERROR_TABLE',
log_triggers_table => 'SYS.DST$TRIGGER_TABLE',
error_on_overlap_time => FALSE,
error_on_nonexisting_time => FALSE);
DBMS_OUTPUT.PUT_LINE('Failures:'|| :numfail);
END;
SQL> SQL> 2
3 4 5 6
7 8 9 10 11 /
Table list:
"SYSMAN"."MGMT_PROV_SUITE_INST_MEMBERS"
Number of failures: 0
Table list:
"SYSMAN"."MGMT_PROV_STAGING_DIRS"
Number of failures: 0
Table list: "SYSMAN"."MGMT_PROV_RPM_REP"
Number of failures: 0
Table list:
"SYSMAN"."MGMT_PROV_OPERATION"
Number of failures: 0
Table list:
"SYSMAN"."MGMT_PROV_NET_CONFIG"
Number of failures: 0
Table list:
"SYSMAN"."MGMT_PROV_IP_RANGE"
Number of failures: 0
Table list:
"SYSMAN"."MGMT_PROV_DEFAULT_IMAGE"
Number of failures: 0
Table list:
"SYSMAN"."MGMT_PROV_CLUSTER_NODES"
Number of failures: 0
Table list:
"SYSMAN"."MGMT_PROV_BOOTSERVER"
Number of failures: 0
Table list:
"SYSMAN"."MGMT_PROV_ASSIGNMENT"
Number of failures: 0
Table list:
"SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_S"
Number of failures: 0
Table list: "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_L"
Number of failures: 0
Table list:
"SYSMAN"."AQ$_MGMT_LOADER_QTABLE_S"
Number of failures: 0
Table list:
"SYSMAN"."AQ$_MGMT_LOADER_QTABLE_L"
Number of failures: 0
Table list:
"STREAMADMIN"."AQ$_DST_MSGLOG_MESSAGES_T_S"
Number of failures: 0
Table list:
"STREAMADMIN"."AQ$_DST_MSGLOG_MESSAGES_T_L"
Number of failures: 0
Table list:
"STREAMADMIN"."AQ$_DST_BOOK_ENTRIES_T_S"
Number of failures: 0
Table list:
"STREAMADMIN"."AQ$_DST_BOOK_ENTRIES_T_L"
Number of failures: 0
Failures:0
PL/SQL procedure successfully completed.
VAR fail number
BEGIN
DBMS_DST.END_UPGRADE(:fail);
DBMS_OUTPUT.PUT_LINE('Failures:'|| :fail);
END;
/
An upgrade window has been successfully ended.
Failures:0
PL/SQL procedure successfully completed.
SQL>
SQL>
SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME;
PROPERTY_NAME
VALUE
------------------------------
------------------------------
DST_PRIMARY_TT_VERSION
14
DST_SECONDARY_TT_VERSION
0
DST_UPGRADE_STATE
NONE
SQL> SELECT * FROM v$timezone_file;
FILENAME
VERSION
-------------------- ----------
timezlrg_14.dat
14
more [ID 977512.1]
This post is an excellent, TI keep returning to read the content that is always updated.hanks!I am interested in reading more of your stuf ptrl hd
ReplyDeleteGreat Article Cyber Security Projects projects for cse Networking Security Projects JavaScript Training in Chennai JavaScript Training in Chennai The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training
DeleteMoistening through to a fire as well toasty smoking causes some of the gasoline to break
ReplyDeleteout and can even lead to acute compensation for injuries.
The particular natural stone increase your the very dome can be substituted with ideal means.
As an example ,, Volvo focuses developing careful motorcars, your "positioning" of which is on the entity
quantity and also in marketing , which is persistently
suggestions for while her marketing communications.
Here is my webpage ... oven heating element replacement kenmore
baby oil
ReplyDeletepan
plate
rice ladle
bucket
glass
basin
powder
lotion
spoon
watch
shoe
slippers
tire
egg
hat
cigarette
hangers
veil
strange people
crazy
dish rack
helmets
doll
shampoo
soap
bread
cake
cheese
chicken
bra
shorts
bag
book
scissors
knife
towel
cable
roof tile
flower
balm
light
car
scissors
ashtray
fan
stove
sheath
broom
duster
baby oil
pan
plate
rice ladle
bucket
glass
basin
powder
lotion
spoon
watch
shoe
20150717wanglili
ReplyDeletecoach outlet
louis vuitton outlet
louis vuitton
abercrombie
louis vuitton
fitflop footwear
retro jordans
hollister clothing
louis vuitton uk
hollister kids
christian louboutin
hollister
coach outlet
abercrombie & fitch
lululemon
christian louboutin sale
mont blanc
football shoes
louis vuitton handbags
juicy couture
louis vuitton
tory burch
coach outlet
air jordan 11
celine outlet
kate spade handbags
oakley sunglasses wholesale
tods outlet
louis vuitton outlet
burberry outlet online
jordan 13
tory burch outlet, nike air max, uggs on sale, longchamp, nike air max, ray ban sunglasses, tiffany and co, tiffany jewelry, oakley sunglasses, louis vuitton, ugg boots, oakley sunglasses, ugg boots, louboutin outlet, ray ban sunglasses, prada handbags, michael kors, burberry, oakley sunglasses, nike outlet, louis vuitton outlet, louis vuitton, replica watches, michael kors outlet, michael kors outlet, michael kors outlet, nike free, kate spade outlet, chanel handbags, oakley sunglasses, longchamp outlet, longchamp outlet, polo ralph lauren outlet, replica watches, burberry outlet online, prada outlet, ugg boots, louis vuitton, gucci outlet, louboutin, michael kors outlet, louis vuitton outlet, jordan shoes, ugg boots
ReplyDeletelacoste pas cher, nike air max, vans pas cher, replica handbags, mulberry, michael kors, true religion jeans, air jordan pas cher, north face, air max, ralph lauren uk, oakley pas cher, coach outlet, north face, louboutin pas cher, tn pas cher, sac guess, michael kors, coach purses, nike roshe run, hogan, coach outlet, nike free run uk, sac longchamp, hermes, ray ban pas cher, hollister pas cher, kate spade handbags, nike free, vanessa bruno, timberland, nike air max, michael kors, ray ban uk, lululemon, ralph lauren pas cher, burberry, hollister, nike blazer, michael kors, true religion outlet, longchamp pas cher, nike roshe, true religion jeans, new balance pas cher, air force, converse pas cher, nike air max, abercrombie and fitch, true religion jeans
ReplyDeletebottega veneta, ferragamo shoes, timberland boots, oakley, soccer jerseys, wedding dresses, herve leger, nike air max, chi flat iron, instyler, mcm handbags, lululemon, nike huarache, baseball bats, ralph lauren, hollister, asics running shoes, iphone cases, mac cosmetics, hollister, insanity workout, ipad cases, valentino shoes, iphone 6s cases, jimmy choo shoes, north face outlet, nfl jerseys, iphone 6 plus cases, iphone 6s plus cases, ghd, iphone 6 cases, babyliss, nike roshe, abercrombie and fitch, soccer shoes, celine handbags, north face outlet, giuseppe zanotti, nike trainers, louboutin, beats by dre, new balance, mont blanc, s5 cases, vans shoes, birkin bag, iphone 5s cases, longchamp, p90x workout, reebok shoes
ReplyDeletemoncler, juicy couture outlet, thomas sabo, swarovski crystal, barbour jackets, canada goose outlet, karen millen, canada goose, replica watches, pandora jewelry, ugg,ugg australia,ugg italia, vans, marc jacobs, louis vuitton, louis vuitton, supra shoes, moncler, canada goose, barbour, bottes ugg, ugg pas cher, doudoune canada goose, links of london, moncler, ray ban, louis vuitton, coach outlet, converse outlet, moncler, montre pas cher, sac louis vuitton pas cher, hollister, moncler, lancel, canada goose outlet, pandora charms, louis vuitton, canada goose uk, hollister, moncler outlet, canada goose, doke gabbana outlet, ugg,uggs,uggs canada, pandora jewelry, moncler, moncler, gucci, ugg boots uk, juicy couture outlet, pandora charms, converse, swarovski, wedding dresses
ReplyDeleteomega outlet
ReplyDeleteferragamo outlet
ferragamo shoes sale
kate spade uk
kate spade uk outlet
true religion jeans
true religion outlet
true religion uk outlet
oakley sunglasses wholesale
tory burch outlet online
burberry outlet store
burberry outlet store
burberry outlet sale
tory burch outlet online
hollister clothing store
cheap replica watches
ralph lauren polo
nba jerseys
ralph lauren outlet
ralph lauren outlet
ralph lauren outlet
hollister shirts
oakley sunglasses
oakley sunglasses wholesale
oakley sunglasses
cheap oakley sunglasses
discount oakley sunglasses
mont blanc pens
oakley canada
iphone case
lululemon pants
ghd uk
rolex watches,rolex watches,swiss watches,watches for men,watches for women,omega watches,replica watches,rolex watches for sale,rolex replica,rolex watch,cartier watches,rolex submariner,fake rolex,rolex replica watches,replica rolex
hollister clothing store
ralph lauren outlet
lllllyuan20160601
chenlili20160627
ReplyDeletenike roshe one
coach outlet
kobe 9
basketball shoes
oakley sunglasses outlet
coach outlet store online
ray ban sunglasses
louis vuitton purses
christian louboutin
michael kors outlet
tiffany jewelry
louboutin
toms outlet
giuseppe zanotti outlet
louis vuitton
longchamp le pliage
jordan 11
coach outlet
true religion outlet
lebron shoes for kids
coach outlet canada
michael kors outlet online
cheap rolex watches
cheap jordans
adidas originals shoes
michael kors outlet clearance
louis vuitton outlet
nike blazers shoes
pandora outlet
true religion outlet
michael kors outlet
coach outlet store online
ralph lauren outlet
ralph lauren outlet
toms wedges
fitflop shoes
supra shoes
ray ban sunglasses
zhengjx20160816
ReplyDeletechristian louboutin sale
adidas superstar
polo ralph lauren
retro jordan shoes
mont blanc pen
ugg boots
hermes outlet
cheap toms shoes
michael kors outlet clearance
cheap ray ban sunglasses
ghd hair straighteners
coach outlet
canada goose pas cher
louis vuitton handbags
miami heat jerseys
jordan femme pas cher
gucci handbags
coach factory outlet
ray ban outlet
true religion uk
louboutin shoes
golden state warriors jerseys
polo ralph lauren
toms shoes
coach outlet store online clearances
canada goose jackets
coach factory outlet online
asics running shoes
oakley sunglasses
jordan 3s
coach outlet
toms shoes outlet
ray ban sunglasses
adidas stan smith
oakley outlet
coach factory outlet online
jordan retro 4
christian louboutin pas cher
coach factory outlet
new england patriots jerseys
20160914 junda
ReplyDeletelebron james shoes
michael kors handbags
canada goose
louis vuitton
mac cosmetics
oakley sunglasses
air jordan 13
prada sunglasses
cartier watches
uggs outlet
coach outlet clearance
jordan shoes
longchamp pliage
ferragamo shoes
michael kors handbags
louis vuitton handbags
ugg australia
rolex watches
rolex outlet
michael kors handbags
celine outlet
michael kors outlet online
louis vuitton outlet stores
futbol baratas
fitflop clearance
oakley sunglasses
tods outlet
mbt shoes
adidas wings
calvin klein underwear
tiffany outlet
ugg boots
cheap michael kors handbags
canada goose outlet
nike outlet
air jordan 4
moncler coats
coach outlet clearance
michael kors outlet online
replica watches
burberry outlet
ReplyDeletered bottom shoes for women
ray ban glasses
uggs outlet
pandora charms sale clearanc
coach outlet online
coach outlet store online
true religion outlet store
true religion jeans outlet
longchamp bag
zhi20161126
indianapolis colts jerseys
ReplyDeletegucci sito ufficiale
chaussure louboutin
miami heat jersey
cheap nike shoes
air max 90
los angeles clippers jerseys
under armour shoes
kobe 9
the north face
gucci handbags
ReplyDeletepolo ralph lauren outlet
louis vuitton outlet
polo outlet
adidas uk
nike air force 1
ugg outlet store
michael kors outlet clearance
fitflops sale clearance
hollister kids
20170223caiyan
true religion jeans
ReplyDeletenike air zoom
air yeezy
roshe run
yeezy boost 350
jordans for cheap
adidas tubular sale
adidas nmd online
michael kors handbags
michael kors outlet store
This bad kid offers a jimdo.com/ premium shower at a great cost It's suggested that Link you replace the interior filter pass through the nozzle But do The Best Showerhead Reviews - 2016-2017 you understand just how much is that quantity of water.
ReplyDeleteAre you looking to dough into a checking account, the wholequantitytypically cannot be instantlyopened; there may be a waiting era for the check to clear? We are the company www.unitedcheckcashing.com providing
ReplyDeletecheck cashing Bridgeport
cheap eyeglasses
ReplyDeletegiuseppe zanotti
uggs outlet
red bottoms
louboutin
jordan
nike air max
louboutin
michael kors outlet
coach outlet
2018.2.5xukaimin
ReplyDeleteشركة غسيل خزانات بالمدينة المنورة شركة غسيل خزانات بالمدينة المنورة
افضل شركة تنظيف منازل بالمدينة المنورة شركة تنظيف بيوت بالمدينة المنورة
ReplyDeleteشركة غسيل خزانات بالمدينة المنورة شركة غسيل خزانات بالمدينة المنورة
افضل شركة تنظيف منازل بالمدينة المنورة شركة تنظيف بيوت بالمدينة المنورة
supreme clothing
ReplyDeletekd shoes
jordan shoes
supreme hoodie
jordan shoes
nike air force
golden goose mid star
yeezy 700
goyard
air jordans
see this replica designer bags explanation try these out read the article website link
ReplyDeleteu1m62l5y12 k3a42y3l36 n5u54s2p13 m1k59t5o65 a9j95r6x73 k8b86y2j16
ReplyDelete