dnf11.0.28.0升级补丁下载 2015最新补丁40.49M_寻乐游戏网
&&&&&&&&&&&&
&|&&|&&|&&|&&|&&|&&|&&|&&|&&|&&|&&|&&|&
您现在的位置：&&>>&&>>&&>>&攻略秘籍正文
正在载入中，请耐心等待...
dnf11.0.28.0升级补丁下载&2015最新补丁40.49M
&&&&&&&&&&★★★
【字体： 】
dnf11.0.28.0升级补丁下载&2015最新补丁40.49M
作者：seekfun&&&&攻略秘籍来源：.cn&&&&点击数：&&&&更新时间：&&&&
dnf11.0.28.0升级补丁下载 2015最新补丁40.49M
当前版本： 11.0.28.0
文件大小： 40.49M
上传时间：
为了给各位勇士带来更优质的游戏体验，进一步加强游戏的安全性，dnf地下城于日(周四)03:00-06:00对所有大区进行停机维护，整个维护过程预计需要3个小时，因开机顺序以及数据维护内容差异，部分大区会提前开放。因停机给大家带来的不便，我们深表歉意。
&&& 因开机有效性确认的需要，第二批大区会根据第一批的测试情况而提前或延后开启，请各位相互转告！
&&& 维护期间，欢迎进入DNF官方论坛，官方微博参与讨论更新内容以及相关精彩活动。
&&& 停机时间：1月1日(周四)03:00-06:00
湖南、湖北03:00-04:30
其它大区 04:30-06:00
停机原因：1、安全组件更新
&&&&&&&&& 2、修复穿戴sao礼包武器装扮时使用技能有几率导致掉线。
&&&&&&&&& 3、修复无法完成远古门票任务。
&&&&&&&&& 4、其他功能优化。
下载地址：/dnf/dltools/DNF_SEASON4_V11.28_Pack_XFDL_signed.exe
攻略秘籍录入：playboy&&&&责任编辑：playboy&
上一个攻略秘籍： 下一个攻略秘籍：
【】【】【】【】【】
没有相关攻略秘籍
网友评论：（只显示最新
10条。评论内容只代表网友观点，与本站立场无关！）
| 香港著名娱乐网站寻乐网升级到11.2.0.4的一些发现-2-其他发现 - 推酷
升级到11.2.0.4的一些发现-2-其他发现
作者：Lunar&版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]
1，如果当前连接的用户不是SYS，那么会报ORA-01722: invalid number错误：
SQL& conn / as sysdba
Connected.
SQL& show user
USER is &SYS&
SQL& SELECT TO_NUMBER('MUST_BE_AS_SYSDBA') FROM DUAL
WHERE USER != 'SYS';
no rows selected
SQL& conn lunar/lunar
Connected.
SQL& show user
USER is &LUNAR&
SQL& SELECT TO_NUMBER('MUST_BE_AS_SYSDBA') FROM DUAL
WHERE USER != 'SYS';
SELECT TO_NUMBER('MUST_BE_AS_SYSDBA') FROM DUAL
ERROR at line 1:
ORA-01722: invalid number
那么判断是否当前连接用户为LUNAR，就可以使用下面的语句：
SQL& conn lunar/lunar
Connected.
SQL& show user
USER is &LUNAR&
SQL& SELECT TO_NUMBER('MUST_BE_AS_LUNAR') FROM DUAL
WHERE USER != 'LUNAR';
no rows selected
同样道理，判断当前数据库版本是否为11.2.0.4:
SQL& SELECT TO_NUMBER('MUST_BE_11_2_0_3') FROM v$instance
WHERE substr(version,1,8) != '11.2.0.4';
no rows selected
2,利用11.2 的新特性，记录SQLPLUS错误日志：
CREATE TABLE sys.registry$error(username
VARCHAR(256),
TIMESTAMP,
VARCHAR(1024),
identifier VARCHAR(256),
DELETE FROM sys.registry$
set errorlogging on table sys.registry$error identifier 'RDBMS';
然后，通过下面的命令查看sqlplus的错误日志：
col timestamp format a15
col username format a15
col script format a10
col identifier format a15
col statement format a20
col message format a20
select * from REGISTRY$ERROR;
SQL& CREATE TABLE LUNAR.registry$error(username
VARCHAR(256),
TIMESTAMP,
VARCHAR(1024),
identifier VARCHAR(256),
Table created.
SQL& DELETE FROM LUNAR.registry$
0 rows deleted.
SQL& set errorlogging on table LUNAR.registry$error identifier 'RDBMS';
SQL& COMMIT;
Commit complete.
SQL& conn lunar/lunar
Connected.
SQL& select * from REGISTRY$ERROR;
no rows selected
SQL& insert into REGISTRY$ERROR as select * from dba_
insert into REGISTRY$ERROR as select * from dba_users
ERROR at line 1:
ORA-00926: missing VALUES keyword
SQL& select count(*) from REGISTRY$ERROR;
----------
这里我们看到，并没有记录下来sqlplus的操作错误，仔细看一下，原来set errorlogging on table命令必须在当前用户下执行，例如：
SQL& set errorlogging on table LUNAR.registry$
SQL& insert into REGISTRY$ERROR as select * from dba_
insert into REGISTRY$ERROR as select * from dba_users
ERROR at line 1:
ORA-00926: missing VALUES keyword
SQL& set linesize 167
SQL& set pages 999
SQL& col timestamp format a15
SQL& col username format a15
SQL& col script format a10
SQL& col identifier format a15
SQL& col statement format a20
SQL& col message format a20
select * from REGISTRY$ERROR;
IDENTIFIER
--------------- --------------- ---------- --------------- -------------------- --------------------
03-AUG-14 05.45
ORA-00926: missing V insert into REGISTRY
.13.000000 PM
ALUES keyword
$ERROR as select * f
rom dba_users
03-AUG-14 05.50
SP2-0042: unknown co g
.25.000000 PM
mmand &g& - rest of
line ignored.
看，错误信息，一目了然
3, auto-bulkification by setting event 10933
Bug:6275368 PL/SQL FOR UPDATE cursor may be positioned on wrong row
Component: RDBMS
Fixed Ver(s):
Symptom(s):
- If a FOR LOOP iterates over a cursor declared in a different package, auto-bulkification occurs. This
may be inappropriate if the cursor's SQL statement (which would appear in the package body) contains
a FOR UPDATE clause as the &CURRENT OF& may then be incorrect.
Available Workaround(s):
Manually turn off auto-bulkification by setting event 10933, level 16384
and recompiling affected library units.
4，catupgrd.sql会调用catupstr.sql， 这个脚本执行过程中中，还需要依次调用：
catupses.sql
i0902000.sql----重整 props$，dependency$，mon_mods$。之后，该脚本还调用i1001000.sql。i1001000调用i1002000.sql。
在i1002000.sql有有一个有意思的操作：
Rem clear 0& (read-only table flag) in trigflag during upgrade
update tab$ set trigflag = trigflag - 2097152
where bitand(trigflag, 2097152)&& 0;
-- 0&转换成10进制是2097152
---bitand，顾名思义，就是按位与操作，即：
SQL& select bitand(1,0)
BITAND(1,0)
-----------
1 row selected.
SQL& select bitand(0,1)
BITAND(0,1)
-----------
1 row selected.
SQL& select bitand(1,1)
BITAND(1,1)
-----------
1 row selected.
SQL& select bitand(trigflag, 2097152) ,trigflag,count(*) from tab$ group by bitand(trigflag, 2097152) ,
BITAND(TRIGFLAG,2097152)
------------------------ ---------- ----------
2 rows selected.
SQL& alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
Session altered.
select object_id,SUBOBJECT_NAME,object_name,CREATED,LAST_DDL_TIME,STATUS from dba_objects
where object_id in(select obj# from tab$ where TRIGFLAG=) order by object_
SQL& select object_id,SUBOBJECT_NAME,object_name,CREATED,LAST_DDL_TIME,STATUS from dba_objects
where object_id in(select obj# from tab$ where TRIGFLAG=) order by object_
OBJECT_ID SUBOBJECT_NAME
OBJECT_NAME
LAST_DDL_TIME
---------- ------------------------------ ---------------------------------------- ------------------- ------------------- -------
SCHEDULER$_EVENT_QTAB
21:24:04 VALID
SCHEDULER$_REMDB_JOBQTAB
21:24:06 VALID
SCHEDULER_FILEWATCHER_QT
21:24:07 VALID
21:24:12 VALID
AQ$_MEM_MC
21:24:38 VALID
AQ_EVENT_TABLE
21:24:44 VALID
AQ_PROP_TABLE
21:24:44 VALID
DEF$_AQCALL
12:52:19 VALID
DEF$_AQERROR
21:25:46 VALID
WM$EVENT_QUEUE_TABLE
21:28:38 VALID
MGMT_TASK_QTABLE
21:29:50 VALID
MGMT_NOTIFY_QTABLE
21:30:29 VALID
MGMT_NOTIFY_INPUT_QTABLE
21:30:31 VALID
MGMT_PAF_MSG_QTABLE_1
21:37:13 VALID
MGMT_PAF_MSG_QTABLE_2
21:37:13 VALID
MGMT_LOADER_QTABLE
21:37:26 VALID
KUPC$DATAPUMP_QUETAB
12:52:03 VALID
SYS$SERVICE_METRICS_TAB
12:52:21 VALID
18 rows selected.
SQL& select obj#,name from obj$ where obj# in (select obj# from tab$ where TRIGFLAG=) order by obj#;
---------- ------------------------------
12590 SCHEDULER$_EVENT_QTAB
12617 SCHEDULER$_REMDB_JOBQTAB
12651 SCHEDULER_FILEWATCHER_QT
12710 ALERT_QT
12911 AQ$_MEM_MC
12937 AQ_EVENT_TABLE
12949 AQ_PROP_TABLE
13218 DEF$_AQCALL
13229 DEF$_AQERROR
13778 WM$EVENT_QUEUE_TABLE
14042 MGMT_TASK_QTABLE
14359 MGMT_NOTIFY_QTABLE
14395 MGMT_NOTIFY_INPUT_QTABLE
17415 MGMT_PAF_MSG_QTABLE_1
17425 MGMT_PAF_MSG_QTABLE_2
17512 MGMT_LOADER_QTABLE
19620 KUPC$DATAPUMP_QUETAB
19667 SYS$SERVICE_METRICS_TAB
18 rows selected.
5,从前，有个朋友问过，如何修改ORACL的banner，现在看来，还是可以研究一下的：
SQL& SET LINESIZE 167
SQL& SET PAGES 999
SQL& SELECT * FROM X$VERSION;
INST_ID BANNER
---------------- ---------- ---------- --------------------------------------------------------------------------------
00007F8DDEA8B140
1 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
00007F8DDEA8B140
1 PL/SQL Release 11.2.0.4.0 - Production
00007F8DDEA8B140
11.2.0.4.0
Production
00007F8DDEA8B140
1 TNS for Linux: Version 11.2.0.4.0 - Production
00007F8DDEA8B140
1 NLSRTL Version 11.2.0.4.0 - Production
6，很多基于 C 函数的外部调用，例如：
CREATE OR REPLACE LIBRARY DBMS_SCN_LIB TRUSTED AS STATIC; -- 包含在 dbmsscnc.sql中，是2012年名操一时的SCN Headroom问题后，加入到11.2.0.4的
其他的，还有很多，例如：
c1001000.sql:CREATE OR REPLACE LIBRARY UPGRADE_LIB TRUSTED AS STATIC
catexf.sql:CREATE OR REPLACE LIBRARY EXFTLIB TRUSTED AS STATIC;
catfusrg.sql:CREATE OR REPLACE LIBRARY DBMS_STORAGE_TYPE_LIB TRUSTED AS STATIC;
catmacc.sql:CREATE OR REPLACE LIBRARY DVSYS.KZV$UTL_LIBT TRUSTED IS STATIC
catmacc.sql:CREATE OR REPLACE LIBRARY DVSYS.KZV$FAC_LIBT TRUSTED IS STATIC
catmacc.sql:CREATE OR REPLACE LIBRARY DVSYS.KZV$RUL_LIBT TRUSTED AS STATIC
catmacc.sql:CREATE OR REPLACE LIBRARY DVSYS.KZV$ADM_LIBT TRUSTED AS STATIC
catmacc.sql:CREATE OR REPLACE LIBRARY DVSYS.KZV$RSRC_LIBT TRUSTED AS STATIC
catqm.sql:CREATE OR REPLACE LIBRARY DBMS_XSU_LIB TRUSTED AS STATIC;
catqm.sql:CREATE OR REPLACE LIBRARY DBMS_XSH_LIB TRUSTED AS STATIC;
catqueue.sql:CREATE OR REPLACE LIBRARY dbms_aq_lib trusted as static
catqueue.sql:CREATE OR REPLACE LIBRARY dbms_aqadm_lib trusted as static
catqueue.sql:CREATE OR REPLACE LIBRARY dbms_aq_ldap_lib trusted as static
catqueue.sql:CREATE OR REPLACE LIBRARY dbms_aqelm_lib trusted as static
catrelod.sql:CREATE OR REPLACE LIBRARY UPGRADE_LIB TRUSTED AS STATIC
catrm.sql:CREATE OR REPLACE LIBRARY dbms_rmgr_lib TRUSTED as STATIC
………………
7,升级后，很多时候，fixed view的统计信息是不对的，需要手工收集：
[oracle@lunar ~]$ ss
SQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 4 00:30:01 2014
Copyright (c) , Oracle.
All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL& select OWNER, TABLE_NAME, LAST_ANALYZED
from dba_tab_statistics where table_name='X$KGLDP';
TABLE_NAME
------------------------------ ------------------------------ ---------
SQL& exec dbms_stats.gather_fixed_objects_stats();
PL/SQL procedure successfully completed.
SQL& select OWNER, TABLE_NAME, LAST_ANALYZED
from dba_tab_statistics where table_name='X$KGLDP';
TABLE_NAME
------------------------------ ------------------------------
LAST_ANALYZED
-------------------
d[oracle@lunar ~]$ date
4 00:34:57 CST 2014
[oracle@lunar ~]$
已发表评论数()
请填写推刊名
描述不能大于100个字符!
权限设置： 公开
仅自己可见
正文不准确
标题不准确
排版有问题
主题不准确
没有分页内容
图片无法显示
视频无法显示
与原文不一致503: Service Unavailable
503: Service Unavailable
访问太频繁了，服务器要炸。升级步骤：
（1）&&&&备份数据库
（2）&&&&运行patchset，升级oracle&软件
（3）&&&&准备新的ORACLE_HOME
（4）&&&&运行dbua&或者脚本升级实例
（5）&&&&检查升级后的版本信息和无效对象
备份数据库
升级数据库是一个十分危险的事情，在生产库上，升级之前最好做一个全库的备份，以便在升级失败时可以还原数据库。
停掉所有与这个数据库相关的业务系统，如中间件。确定没有业务在运行。在数据库正常关闭后，还需要备份Oracle主目录，目的还是为了升级失败时，能够还原出数据库软件到升级前的版本。备份如下：tar&-xcvf&oracle11201_bak.tar.gz&$ORACLE_BASE。
我这里是测试环境，就不进行备份，如果是生产环境，切记要先备份，后操作。
如果是In-Place&Upgrade，同时备份一下整个ORACLE_HOME目录。&如果升级有问题，还可以还原回来。
重点是如下目录：
ORACLE_HOME/dbs
ORACLE_HOME/network/admin
ORACLE_HOME/hostname_dbname
ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_hostname_dbname
chmod&777&p040_Linux-x86-64_* p040_Linux-x86-64.zip&p000_Linux-x86-64.zip&
一、原始状态
SQL&set&linesize&150
SQL&set&pagesize&9999
SQL&&col&comp_name&format&a40
SQL&&SELECT&COMP_NAME,&VERSION,&STATUS&FROM&SYS.DBA_REGISTRY;
关闭***、关闭数据实例
二、把所有补丁软件都拷贝到/tmp，补丁包一共7个，只需要前2个就成
解压：unzip&p040_Linux-x86-64_1of7.zip&-d&/tmp&&&&unzip&p040_Linux-x86-64_2of7.zip&-d&/tmp
cd&/tmp/database
运行Patchset&的runInstaller
注意这里，我们选择第三个选项，skip&software&update，因为我们的patchset已经下载过了，如果选择第二个选项，会遇到如下错误，
INS-20704&Thelocation&provided&is¬&in&the&expected&directory&structure
Oracle&给的解决方式是用如下命令来执行：
./runInstaller&&downloadUpdates
但是这个命令需要收费的Metalink帐号。&MOS&的相关文档：
How&To&Download&The&Latest&Updates&AndPatches&Using&11.2.0.2&OUI&[ID&]
Error:&INS-20704&While&Installing&11.2.0.2with&"Use&pre-downloaded&software&updates"&Option&[ID&]
这里要注意，我们之前讲过11gR2的Patchset&可以直接用来***。在这个界面就可以选择操作类型，这个功能比较方便，从而也导致patchset&越来越大，我们这里选择upgrade&an&existing&database。
注意这里的***位置，我之前的***目录是11.2.0，我新目录是11.2.0.4&即将oracle&***到其他位置，这样可以减少宕机时间，也是oracle&推荐的方法。
执行到76%的时候弹出如下窗口：
下面就是一个配置***的过程
随后就是&会自动调用DBUA&来升级我们的实例(1---7步)
三、然后，再修改oracle用户的.bash_profile
ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/db_1
然后source&~/.bash_profile
四、查看&cat&/etc/oratab&&&【内容应该是新目录】
五、登录查看，升级后版本
[oracle@DB200&~]$&sqlplus&/&as&sysdba
SQL*Plus:&Release&11.2.0.1.0&Production&on&Mon&May&25&22:00:21&2015
Copyright&(c)&,&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
六、11.2.0.4.0升级到11.2.0.4.7（打patch，关闭实例与***）
1、解压***包自定义存放路径为/home/oracle/psucd /home/oracle/psumv p000_04-SEP-2015_Linux-x86-64.zip p030_15_Linux-x86-64.zip /home/oracle/psuunzip p000_04-SEP-2015_Linux-x86-64.zipunzip p030_15_Linux-x86-64.zip -d 112047
2、检查psu补丁是否有冲突/home/oracle/psu/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir
/home/oracle/psu/96923
3、信息收集--查看组件信息set linesize 500 pagesize 600col COMP_NAME for a30select COMP_ID,COMP_NAME,VERSION,STATUS from DBA_REGISTRY;--查看补丁情况set linesize 500 pagesize 600col ACTION_TIME for a30col COMMENTS for a30select ACTION_TIME, ACTION, COMMENTS from sys.DBA_REGISTRY_HISTORY;--查看无效对象select count(*) from dba_objects where status&&'VALID';
4、停止数据库--停止数据库外部进程ps -ef|grep -v grep |grep LOCAL=NO|awk '{print $2}'|xargs kill -9 --停库alter system checkpointshutdown immediate--停***lsnrctl stop
--查看启停日志/home/oracle/diag/rdbms/sccp/sccp/trace/alert*.log
5、备份使用root用户备份oracle_home （将#ORACLE_HOME上级目录整个备份）tar -zcvpf
db_.tar.gz
6、打PSUsu - oracle cd /home/oracle/psu/82
---为压缩包解压出的二级目录（不进入该目录apply会报错）/home/oracle/psu/OPatch/opatch apply
----如果补丁过程中出现以下错误OPatch报错 Prerequisite check "CheckActiveFilesAndExecutables" failedFollowing executables are active :/opt/oracle/product/10.2.0/bin/oracleApplySession failed during prerequisite checks: Prerequisite check "CheckActiveFilesAndExecutables" failed.
通过以下命令找到正在占用文件的进程，然后kill进程fuser /opt/oracle/product/10.2.0/bin/oracle
7、检查数据库su & oracle$ORACLE_HOME/OPatch/opatch lsinv
8、更新数据字典、编译失效对象su - oraclecd $ORACLE_HOME/rdbms/adminSQL& CONNECT / AS SYSDBASQL& STARTUPSQL& @catbundle.sql psu applySQL& @utlrp.sql
9、重启数据库shutdown immediatestartup
10、检查数据库状态--查看组件信息set linesize 500 pagesize 600col COMP_NAME for a30select COMP_ID,COMP_NAME,VERSION,STATUS from DBA_REGISTRY;--查看补丁情况set linesize 500 pagesize 600col ACTION_TIME for a30col COMMENTS for a30select ACTION_TIME, ACTION, COMMENTS from sys.DBA_REGISTRY_HISTORY;--查看无效对象select count(*) from dba_objects where status&&'VALID';
11、启动***lsnrctl
start ps -ef|grep -v grep |grep LOCAL=NO|wc -lSQL& CONNECT / AS SYSDBASQL&alter system register；
若***启动失败cd $ORACLE_HOME/network/adminmv sqlnet.ora sqlnet.orabaklsnrctl
start ps -ef|grep -v grep |grep LOCAL=NO|wc -lSQL& CONNECT / AS SYSDBASQL&alter system regiterSQL&exitmv sqlnet.orabak sqlnet.ora
七、实验中遇到的报错
1、----如果补丁过程中出现以下错误OPatch报错 Prerequisite check "CheckActiveFilesAndExecutables" failedFollowing executables are active :/opt/oracle/product/10.2.0.4/bin/oracleApplySession failed during prerequisite checks: Prerequisite check "CheckActiveFilesAndExecutables" failed.
通过以下命令找到正在占用文件的进程，然后kill进程fuser /opt/oracle/product/10.2.0.4/bin/oracle
2、INS-32025报错the chosen installation conflicted with software already installed in the given Oracle home.所选***与指定 Oracle 主目录中已***的软件冲突
解决方法：vi /home/oracle/oraInventory/ContentsXML/inventory.xml
[root@db 桌面]# more /home/oracle/oraInventory/ContentsXML/inventory.xml &?xml version="1.0" standalone="yes" ?&&!-- Copyright (c) , Oracle and/or its affiliates.All rights reserved. --&&!-- Do not modify the contents of this file by hand. --&&INVENTORY&&VERSION_INFO&
&S***ED_WITH&11.2.0.4.0&/S***ED_WITH&
&MINIMUM_VER&2.1.0.6.0&/MINIMUM_VER&&/VERSION_INFO&&HOME_LIST&&HOME NAME="OraDb11g_home1" LOC="/home/oracle/app/oracle/product/11.2.0/dbhome_1" TYPE="O" IDX="1"/&&/HOME_LIST&&COMPOSITEHOME_LIST&&/COMPOSITEHOME_LIST&&/INVENTORY&[root@db 桌面]#
删除其中的HOME_NAME信息&HOME NAME="OraDb11g_home1" LOC="/home/oracle/app/oracle/product/11.2.0/dbhome_1" TYPE="O" IDX="1"/&
三、ORA-00845: MEMORY_TARGET not supported on this system报错解决在oracle 11g中新增的内存自动管理的参数MEMORY_TARGET,它能自动调整SGA和PGA，这个特性需要用到/dev/shm共享文件系统，而且要求/dev/shm必须大于MEMORY_TARGET，如果/dev/shm比MEMORY_TARGET小就会报错解决方案
1.初始化参数MEMORY_TARGET或MEMORY_MAX_TARGET不能大于共享内存(/dev/shm),为了解决这个问题，可以增大/dev/shm
# mount -t tmpfs shmfs -o size=7g /dev/shm
2.为了确保操作系统重启之后能生效，需要修改/etc/fstab文件
shmfs /dev/shm tmpfs size=7g 0
3.如果/dev/shm没有挂载也会报上面的错，所认需要确保已经挂载
oracle@aaaprod-db ~]$ df -h
16G 8.9G 7.2G 56% /dev/shm
阅读(...) 评论()
