||'connect to ' || L.USERID || ' identified by '''
||L.PASSWORD||''' using ''' || L.host || ''''
||chr(10)||';' TEXT
FROM sys.link$ L,
sys.user$ U
WHERE L.OWNER# = U.USER# ;
?
####升级
SQL> alter database open resetlogs upgrade;
Database altered.
SQL>
SQL> spool upgrade.log
SQL> @catupgrd.sql
=====这个时间比较长，需要耐心等待
#### 完成后
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
运行以下检查再次进行检查
SQL> @$ORACLE_HOME/rdbms/admin/utlu112s.sql
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
####下面是相关DST版本
SQL> l
? 1? SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
? 2? FROM DATABASE_PROPERTIES
? 3? WHERE PROPERTY_NAME LIKE 'DST_%'
? 4* ORDER BY PROPERTY_NAME
SQL> /
PROPERTY_NAME? ? ? ? ? ? ? ? ? VALUE
------------------------------ ------------------------------------------------------------
DST_PRIMARY_TT_VERSION? ? ? ? 4
DST_SECONDARY_TT_VERSION? ? ? 0
DST_UPGRADE_STATE? ? ? ? ? ? ? NONE
####具体升级DST，可以分手工和自动，我是通过自动方式升级的，请参考以下文档。
Updating the RDBMS DST version in 11g Release 2 (11.2.0.1 and up) using DBMS_DST (Doc ID 977512.1)
下面是相关日志：
[oracle@ora11 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 12 11:38:12 2014
Copyright (c) 1982, 2013, Oracle.? All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME;? 2? ? 3? ? 4
PROPERTY_NAME
------------------------------
VALUE
------------------------------------------------------------
DST_PRIMARY_TT_VERSION
4
DST_SECONDARY_TT_VERSION
DST_UPGRADE_STATE
NONE
SQL> set linesize 2000
SQL> /
PROPERTY_NAME? ? ? ? ? ? ? ? ? VALUE
------------------------------ ------------------------------------------------------------
DST_PRIMARY_TT_VERSION? ? ? ? 4
DST_SECONDARY_TT_VERSION? ? ? 0
DST_UPGRADE_STATE? ? ? ? ? ? ? NONE
SQL> l
? 1? SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
? 2? FROM DATABASE_PROPERTIES
? 3? WHERE PROPERTY_NAME LIKE 'DST_%'
? 4* ORDER BY PROPERTY_NAME
SQL> /
PROPERTY_NAME? ? ? ? ? ? ? ? ? VALUE
------------------------------ ------------------------------------------------------------
DST_PRIMARY_TT_VERSION? ? ? ? 4
DST_SECONDARY_TT_VERSION? ? ? 0
DST_UPGRADE_STATE? ? ? ? ? ? ? NONE
SQL> select VERSION from v$timezone_file;
select TZ_VERSION from registry$database;
? VERSION
----------
? ? ? ? 4
SQL>
TZ_VERSION
----------
? ? ? ? 4
SQL>
SQL> SELECT version FROM v$timezone_file;
? VERSION
----------
? ? ? ? 4
SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME;? 2? ? 3? ? 4
PROPERTY_NAME? ? ? ? ? ? ? ? ? VALUE
------------------------------ ------------------------------------------------------------
DST_PRIMARY_TT_VERSION? ? ? ? 4
DST_SECONDARY_TT_VERSION? ? ? 0
DST_UPGRADE_STATE? ? ? ? ? ? ? NONE
SQL>
SQL>
SQL>
SQL> @?/rdbms/admin/upg_tzv_check.sql
SP2-0310: unable to open file "/home/oracle/app/oracle/product/11.2.0/db_1/rdbms/admin/upg_tzv_check.sql"
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ora11 ~]$ vi check.sql
[oracle@ora11 ~]$ sqlplus "/as sysdba"
SQL*Plus: R