Time Zone
SQL> create table registry_backup as select * from registry$database;
SQL> INSERT into registry$database (platform_id, platform_name, edition, tz_version) VALUES ((select platform_id from v$database), (select platform_name from v$database),NULL,(select version from v$timezone_file));
1 row created.
SQL> select * from sys.registry$database;
PLATFORM_ID PLATFORM_NAME EDITION TZ_VERSION
----------- ------------------------------ ------------------------------ ----------
13 Linux x86 64-bit
13 Linux x86 64-bit 14
SQL> delete from sys.registry$database where TZ_VERSION is NULL;
1 row deleted.
SQL> select * from registry_backup;
PLATFORM_ID PLATFORM_NAME EDITION TZ_VERSION
----------- ------------------------------ ------------------------------ ----------
13 Linux x86 64-bit
SQL> commit;
Commit complete.
SQL> select * from sys.registry$database;
PLATFORM_ID PLATFORM_NAME EDITION TZ_VERSION
----------- ------------------------------ ------------------------------ ----------
13 Linux x86 64-bit 14
Timezone issue resolved with above solution.
--1
create table registry_backup as select * from registry$database;
--2
INSERT into registry$database (platform_id, platform_name, edition, tz_version) VALUES ((select platform_id from v$database), (select platform_name from v$database),NULL,(select version from v$timezone_file));
--3
delete from sys.registry$database where TZ_VERSION is NULL;
--4
commit;
--5
select * from sys.registry$database;
SQL> select * from sys.registry$database;
PLATFORM_ID PLATFORM_NAME EDITION TZ_VERSION
----------- ------------------------------ ------------------------------ ----------
13 Linux x86 64-bit
@$ORACLE_HOME/rdbms/admin/catalog.sql;
@$ORACLE_HOME/rdbms/admin/catproc.sql;
@$ORACLE_HOME/rdbms/admin/utlrp.sql
沒有留言:
張貼留言