ITPub博客

当你有需求将一个进程放在后台跑时，切忌使用nohup or screen.screen需要在你run脚本之前运行，nohup可以修改已经运行的进程。 /usr/bin/nohup command [argument...] /usr/bin/nohup -p [-Fa] pid [pid...] /usr/bin/nohup -g [-Fa] gpid [gpid...] /usr/xpg4/bin/nohup command [argument...][@more@]We can try to use solaris dtrace to check what happens internally.bash-3.00# cat sig.d#!/usr/sbin/dtrace -sproc:::signal-send/args[1]->pr_fname == $$1/{printf("%s(pid:%d ) is sending signal %d to

如果使用ssh而不是rshFailed to upgrade Oracle Cluster Registry configuration 防火墙最好关闭VIPCA报错SWAP不足VIP添加过程中不断offlineDBCA无法在节点2创建数据库[@more@]如果使用ssh而不是rsh：需要确保/usr/local/bin/ssh存在，可以使用softlink。否则runcluvfy.sh会识别不出ssh连通性，不能通过。mkdir -p /usr/local/binln -s -f /usr/bin/ssh /usr/local/bin/sshln -s -f /usr/bin/scp /usr/local/bin/scpexec /usr/bin/ssh-agent $SHELLFailed to upgrade Oracle Cluster Registry configuration具体原因参照metalink note: ID

SQLSERVER PLUGIN:1 介质准备1.1 从ORACLE官方主页下载OEM agent. http://www.oracle.com/technology/software/products/oem/index.html1.2 下载SYSTEM MONITOR PLUGINShttp://www.oracle.com/technology/software/products/oem/htdocs/system-monitoring-connectors.html2 介质安装2.1 在将要监控的SQLSERVER端，安装最新的OEM agent. (确保OS版本和介质版本符合)安装之前，在/etc/system下面添加OEM的服务器地址 安装完成之后，OEM监控端应该可以看到新的host.2.2 SQLSERVER建立用户名和密码：1. 新建管理用户，具有sysadm权限。2. 确认

result_cache_max_size can't be set to big than 0, reason could be:1. make sure you're using enterprise edition2. set memory parameter(at least shared_pool_size), sga_target or memory target also helps.[@more@]

Modified 06-JAN-2010 Type BULLETIN Status PUBLISHEDIn this DocumentPurposeScope and Application11g MEMORY_TARGET Parameter DependencyReferencesApplies to: Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.1.0.6Information in this document applies to any platform.PurposeAutomatic memory management can be configured using a target memory size initialization parameter MEMORY_TARGET and a maximum memory size initialization parameter MEMORY_MAX_TARGET. Oracle Database then tunes to the tar

RMAN> duplicate target database for standby nofilenamecheck ......Errors in file /u01/app/oracle/admin/stdby/udump/stdby_ora_794674.trc:ORA-00600: internal error code, arguments: [krbvalunused_badfno], [64], [85], [], [], [], [], [][@more@]RMAN> duplicate target database for standby nofilenamecheck ......Errors in file /u01/app/oracle/admin/stdby/udump/stdby_ora_794674.trc:ORA-00600: internal error code, arguments: [krbvalunused_badfno], [64], [85], [], [], [], [], []到主库validate backups

Are they the same? Based on documents, the second one will call "checkpoint" so does this mean alter system switch logfile contains alter system checkpoint?The answer is NO.Try to test on a busy system, alter system switch logfile several times until it rounds to the logfile that is still active, and you will hung at switch logfile. Check the v$Logfile you will see that your next logfile is active.Solution is to alter system checkpoint and all uncurrent logfile will be inactive.This de

报错："Central Inventory /etc/oracle/oraInventory is on a shared drive, each node among rac1,rac2 should have its own Central Inventory. Central Inventory cannot be shared, this is not supported"根据604513.1， 尝试修改地址没有效果。oraInventory的目录是在本地磁盘，按道理不应该出现这样的问题。最终解决方法：/u01/crs/oracle/product/10/app/oui/bin/attachHome.sh -silent -local -cfs CRS=true -invPtrLoc /u01/crs/oracle/product/10/app/oraInst.loc 检查版本：crsctl query crs softwareversion[@more

alter session set sort_area_size没用，session的pga只能用到系统级别的设置。这个bug是10203引进的，下面是相关链接：https://metalink2.oracle.com/metalink/plsql/f?p=130:14:6981579750773090559::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,452466.1,1,1,1,helveticahttp://oracle-randolf.blogspot.com/2008/02/nasty-bug-introduced-with-patch-set.htmlhttp://jonathanlewis.wordpress.com/2008/11/25/sas-bug/[@more@]1. 从JL的blog可以看到我们可以临时这样解决，就是设置两次。

2 cases to recover standby after primary open resetlogs:It's supported by oracle:http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/manage_ps.htm#i1026480If the standby database. . .Then. . .Perform these steps. . .Has not applied redo data past the new resetlogs SCN (past the start of the new branch of redo data)Redo Apply automatically takes the new branch of redo.No manual intervention is necessary. The MRP automatically resynchronizes the standby database with the new branch of r

We've got a interesting problem today, a simple explain plan will take more than 1mins.[@more@]From oracle Document:========================================================================================================================================================== * Level 0: Do not use dynamic sampling. * Level 1: Sample all tables that have not been analyzed if the following criteria are met: (1) there is at least 1 unanalyzed table in the query; (2) this unanalyzed table is joined

1. ORA-01009: missing mandatory parameter2. ORA-16055: FAL request rejected3. ORA-01034: ORACLE not available[@more@]1. ORA-01009: missing mandatory parameterIn metalink, we have this url may related:https://metalink2.oracle.com/metalink/plsql/f?p=130:15:9790252599340919149::::p15_database_id,p15_docid,p15_show_header,p15_show_help,p15_black_frame,p15_font:BUG,5929647,1,1,1,helveticaActually this was cause by missing parameter fal_server or fal_client. We need to set both FAL_CLIENT and FAL_SERV