ITPub博客

....[@more@]问题描述: 偶尔发现生产系统上会出现如下的错误.ORA-00054: resource busy and acquire with NOWAIT specified*** 2007-07-04 22:33:05.097GATHER_STATS_JOB: GATHER_TABLE_STATS('"TEST"','"TESTTAB"','""', ...)ORA-00054: resource busy and acquire with NOWAIT specified针对这个环境的解决方法: 把TEST 用户的物化视图的刷新时间和做SCHEMAS 的统计 的时间,严格分开.不让他们有可能在同一个时间跑的情况

前些日子,在自己的笔记本上安装了2 个VMWARE SERVER ,想模拟安装一下LINUX 的RAC +ASSM ...结果失败了...呵呵[@more@]使用 VMware Server 在 Oracle Enterprise Linux 上安装 Oracle RAC 10g 发现一些问题1.由于机器性能不太好,2个VMWARE SERVER 的时间好同步不一致,造成安装失败多次2.还是由于机器性能不好,安装RAC SW的时候失败.3.最后,都失败了.也不再做了..呵呵总结经验,选择好的机器做实验,否则,会害死人的..呵呵

..............[@more@]1 .产看OERR 的位置$ which oerr/oradev2/app/oracle/product/10.2.0/bin/oerr2.看OERR 的使用方法$ oerrUsage: oerr facility errorFacility is identified by the prefix string in the error message.For example, if you get ORA-7300, "ora" is the facility and "7300"is the error. So you should type "oerr ora 7300".If you get LCD-111, type "oerr lcd 111", and so on.$ oerr ora 73003.随便测试一个ORA 的错误$ oerr ora 320003200, 00000, "the segm

...........[@more@]临时接到公司的要求帮助,很紧急要一个很详细的ORACLE 11I 的优化方案,虽然在项目已经很累很忙了,再说也没义务和责任帮他们写这些东西.但谁让自己比较"好"说话呢,尽管是100个不乐意,不过,还是答应尽力写了,经过1天和半个晚上的努力,终于写了出来. TMD ,写文档比做事还累的.文档将包括如下主要内容：l 系统基本架构情况掌握及初步的建议l Oracle Database 性能数据收集、分析和调优方法l Application 性能数据收集、分析和调优方法l Disk Storage I/O 性能数据收集、分析和调优方法l HW(Server) 性能数据收集、

................[@more@] 项目中，要用到一个上传文档的功能，用一个orcale的的存储过程去调用 java 类，再由java类调用系统指指令，但始终报一个这样的错误 dbms_java.grant_Permissio('SCOTT','java.io.FilePermission','/tmp/inbound/**','read,write,execute,delete'); ORA-29532: Java call terminated by uncaught Java exception:oracle.aurora.vm.IdNotFoundException: my_user is not a user or role，ORA-29532: Java call terminated by uncaught Java exception:java.lang.SecurityException: policy table update SYS:java.

..............[@more@]SymptomsWhile applying one-off patch you may hit with the following error:The following warnings has happened during OPatch execution: 1) OUI-67003:File not backed up from /home/oracle/db10g/lib/libserver10.a to /home/oracle/db10g/.patch_storage/5036588_Feb_26_2006_22_46_11/files/lib/libserver10.a/kewm.o... 'ar: 0707-109 Member name kewm.o does not exist. CauseThis error is occuring because on AIX when we archive an object in the library, we need to specify the format using

AIX53+10.2.0.2 RAC[@more@]DescriptionIf different schemas have objects (tables / views / synonyms etc..) with identical names and sessions from different schemas execute IDENTICAL SQL statements then it is possible for such SQL sentences to get executed against the wrong schema objects if a cursor gets reloaded in a certain manner.eg: Consider USER1 and USER2 both with their own table MYTAB.If sessions are concurrently executing "SELECT col FROM MYTAB" then it is possible, under certai

AIX5.3+1O.2.0.2 Oracle[@more@]IMPDP BUG .10.2.0.3 上才得到修补

环境:AIX5.3+10.2.0.2 RAC [@more@]ERROR :ORA-29701: unable to connect to Cluster ManagerTRACE FILE:clsc_connect: (10674fa30) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_ein_crs))2006-09-05 22:00:24.614: [ CSSCLNT]clsssInitNative: connect failed, rc 9kgxgncin: CLSS init failed with status 3kjfmsgr: unable to connect to NM for reg in shared groupORA-29701: unable to connect to Cluster ManagerCauseThe hidden directory '/var/tmp/.oracle' was removed while instances & the CRS stack were u

..牛人马云[@more@]马云语录 ● 我就是戴着望远镜也找不到对手。 ● 与众不同不是我做出来的，而是我的本能。 ● 一个男人的才华与其容貌往往是成反比的。 ● 侠之大者，为国为民。企业家 -->之大者，为国为民。马云，企业家之大者。 ● 男人的胸怀是委屈撑大的。 ● 免费是世界最昂贵的东西。 ● 做企业千万别把灾难当公关。 ● 这个时代需要雷锋，但不能让雷锋穿补丁衣服上街。

...........[@more@]bug:4690794

转贴,收藏[@more@]SVRMGR> select * from dba_jobs;初始化相关参数job_queue_processesalter system set job_queue_processes=39 scope=spfile;//最大值不能超过1000 ;job_queue_interval = 10 //调度作业刷新频率秒为单位DBA_JOBS describes all jobs in the database. USER_JOBS describes all jobs owned by the current user1 select job,what,to_char(last_date,'yyyy-mm-dd HH24:mi:ss'),to_char(next_date,'yyyy-mm-dd HH24:m),interval from dba_jobs where job in (325,295)2 select job,what,last_date,next_date,interva

Bug 4383811 [@more@]With the Partitioning, OLAP and Data Mining options Master table "SYSTEM"."SYS_IMPORT_TABLE_03" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_TABLE_03": system/******** DUMPFILE=test.dmp.dmp directory=EXP_IMP_DUMP LOGFILE=test.log REMAP_SCHEMA=testuser:prdspuser TABLES=xi_adp_marc1 CONTENT=DATA_ONLY Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

ORA-00600: internal error code, arguments: [17281], [1001], [0x7000002286E6130],[], [], [], [], []ORA-01001: invalid cursor[@more@]You are seeing the following error message when running queries.:ORA-00600: internal error code, arguments: [17281], [1001], [0x18E3EE690], [], [], [], [], []You may or may not see this error message as well.:ORA-01001: invalid cursor CauseThis issue can be related to running SQL through TOAD. You can check if TOAD was the client that resulted in the error from the

..............[@more@]- 恢复重做日志重做日志用于记录数据库变化。当执行了DML /DDL 操作之后，后台进程LGWR 会将这些操作的信息记载到重做日志中。- 日志组的某个日志成员损坏 如果某个日志组的一个日志成员出现介质失败，数据库仍然可以正常工作。- 增加日志MEMBER ，以方便可以模拟 故障SQL> desc v$logfile Name Null? Type ----------------------------------------- -------- ---------------------------- GROUP# NUMBER STATUS

..........[@more@]是因为做EXPDP 的时候.目录空间满了..报的错..估计是BUG ,但无关紧要..

..............[@more@]RESEARCH=========Bug 4964703 OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind namesFixed-Releases: 9208 A203.CAUSE DETERMINATION====================OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind namesCAUSE JUSTIFICATION====================Bug 4964703 OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names.PROPOSED SOLUTION(S)======================1.Applying patch 49647032.Replacing Bind Variable 'n'

...[@more@]- 在NOARCHIVELOG 模式下 用户管理的备份与恢复 NOARCHIVELOG 主要用于DSS- 改变为NOARCHIVELOG 模式Microsoft Windows XP [版本 5.1.2600](C) 版权所有 1985-2001 Microsoft Corp.C:Documents and Settingsnaonao>sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 5月 22 21:05:25 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.连接到:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsS

昨天一个生产系统,暂时有1个节点运行,结果超过了最到PROCESSES 数,出现如下错误环境:AIX5.3ML03+Oracle 10.2.0.2 RAC [@more@]alert.log 出现如下错误Process P045 died, see its trace fileProcess P045 died, see its trace fileProcess P045 died, see its trace fileProcess P045 died, see its trace filetestdb2_ora_1089710.trc/oracle/app/oracle/admin/testdb/bdump/testdb2_ora_1089710.trcOracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OL

环境:AIX5.3ML03+Oracle 10.2.0.2+TSM 5.2[@more@]- RMAN 配置 情况注意:CONFIGURE CONTROLFILE AUTOBACKUP ON;[testdb:oradev] /oradev1/home/rman> rman target /Recovery Manager: Release 10.2.0.2.0 - Production on Tue May 22 12:54:50 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.connected to target database: testdb (DBID=3996427334)RMAN> show all;using target database control file instead of recovery catalogRMAN configuration parameters are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; #