ITPub博客

好几个DB 连续几天了TSM 备份都失败,IBM 去查了..原因主要有如下: TAPE 不够 由于有备粉有问题的客户端,造成其他客户端 也失败 DRIVER 坏了或者不够用的.[@more@]RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03009: failure of backup command on t1 channel at 03/06/2007 20:42:29ORA-19502: write error on file "dbfull_616537622_1116_

....[@more@]今天忽然发现我的PC XMANAGER 怎么也不能使用了,删掉重装,也是不可以了,同时实验,联每一台UNIX SERVER 都不可以,由次可以判定问题可能出在我的PC 上, 经过检查,是XP 起用了WINDOWS 防火墙,并且起用了"不允许例外) ,原来没起用"不允许例外",现在去掉后,恢复正常..

... .....[@more@]由于做EXPDP 的目录空间不足,ALERT 里面出现如下的2个600 错误,不知道是否是BUG Errors in file /oracle/app/oracle/admin/testdb/bdump/testdb_dw01_557302.trc:ORA-00600: internal error code, arguments: [kghstack_underflow_internal_3], [0x1118375E0], [rpi role space], [], [], [], [], []ORA-19502: write error on file "/exp_back/exp_imp/testdb.full_0703042100.dmp", blockno 3126214 (blocksize=4096)ORA-27063: number of bytes read/written is incorrectIBM AIX RISC System/6000 Error:

.....[@more@]关于10.2.0.2中使用start with connect by 报ORA-00600错误的问题 情况如下：建立视图的sql查询包括start with,connect by,然后再查询这个视图，查询也用到了start with和connect by，在9i中查询这个视图没问题，在10.2.0.1测试环境下也没有问题，就是在10.2.0.2中报如下错误ORA-00600: 内部错误代码, 参数: [kkqcbydrv:1], [], [], [], [], [], [], []解决方法:*._optimizer_connect_by_cost_based=FALSE

收藏...[@more@]一. 视图说明:1. SYS.AUD$审计功能的底层视图,如果需要对数据进行删除,只需要对aud$视图进行删除既可,其他视图里的数据都是由aud$所得.2. DBA_AUDIT_EXISTS列出audit not exists和audit exists产生的审计跟踪,我们默认的都是audit exists.3. DBA_AUDIT_TRAIL可以在里面查处所有审计所跟踪的信息.4. DBA_AUDIT_OBJECT可以查询所有对象跟踪信息.(例如,对grant,revoke等不记录),他的信息完全包含于dba_audit_trail5. DBA_AUDIT_SESSION所得到的数据都是有关logon或者logoff的信息.6. DBA_AUDIT_STATEMENT列出grant ,revoke ,a

....[@more@]error 信息Errors in file /oracle/app/oracle/admin/prd/bdump/prd_j000_688158.trc:ORA-12012: error on auto execute of job 8897ORA-20000: ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalidORA-06512: at "SYS.PRVT_ADVISOR", line 1624ORA-06512: at "SYS.DBMS_ADVISOR", line 186ORA-06512: at "SYS.DBMS_SPACE", line 1344ORA-06512: at "SYS.DBMS_SPACE", line 1560The issue was noticed because of repeated occurence o

...........[@more@]News & NotesOracle终生支持政策还让客户将产品的升级策略控制在自己手中。通过Oracle灵活的支持政策，客户可以针对Oracle产品，从容地制定出自己的升级规划和预算，而不必时刻担心自己运行的版本失去支持。一旦出现升级的需要，客户无需花费任何额外成本，即可获得最新版本的产品，充分享受Oracle领先技术所带来的好处，确保自己的发展与世界的同步。 Oracle终生支持政策：从5年到永远 标准支持服务(Premium Support)：最新业界支持标准 Oracle标准支持服务(Premium Support)是一项获奖的支持服务计划，代表着下一

以前,很少安装这些Sample Sechemas ,也没研究过这些东西是干吗的,[@more@]Sample SchemasMost of the included accounts are administrative accounts, but Sample Schema accounts are also present. The Oracle Database Sample Schemas are a set of interlinked schemas that enable Oracle documentation, and Oracle by Example Series, to illustrate common database tasks:The human resources (hr) schema is useful for introducing basic topics. An extension to this schema supports Oracle Internet Directory demos.The

只是在别人没有恢复成功的基础上,自己随便测试再次恢复,请在生产系统,慎重考虑[@more@][test:oratest] /oratest/home>[test:oratest] /oratest/home> sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.2.0 - Production on Wed Feb 14 13:34:31 2007Copyright (c) 1982, 2005, Oracle. All Rights Reserved.Connected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 1241513984 bytesFixed Size 2070912 bytesVariable Size 318768768 bytesDatabase Buffers 905969664 bytesRedo B

..........[@more@]ComponentUNIX ToolCPUsar, vmstat, mpstat, iostatMemorysar, vmstatDisksar, iostatNetworknetstatThe awrrpt.sql SQL script generates an HTML or text report that displays statistics for a range of snapshot Ids.The awrrpti.sql SQL script generates an HTML or text report that displays statistics for a range of snapshot Ids on a specified database and instance.The awrsqrpt.sql SQL script generates an HTML or text report that displays statistics of a particular SQL statement for a rang

To assist in the rollout process, build a list of tasks that—if performed correctly—will increase the chance of optimal performance in production and—if there is a problem—enable rapid debugging of the application:[@more@]1.When you create the control file for the production database, allow for growth by setting MAXINSTANCES, MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, and MAXLOGHISTORY to values higher than what you anticipate for the rollout. This results in more disk space usage and bigger

...[@more@]Table 2-6 Administrative User Accounts Provided by Oracle DatabaseUsernamePasswordDescriptionSee AlsoCTXSYSCTXSYSThe Oracle Text accountOracle Text ReferenceDBSNMPDBSNMPThe account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the databaseOracle Enterprise Manager Grid Control Installation and Basic ConfigurationLBACSYSLBACSYSThe Oracle Label Security administrator accountOracle Label Security Administrator's GuideMDDATAMDDATAThe schema used

.........[@more@]ViewDescriptionV$SGADisplays summary information about the system global area (SGA).V$SGAINFODisplays size information about the SGA, including the sizes of different SGA components, the granule size, and free memory.V$SGASTATDisplays detailed information about the SGA.V$SGA_DYNAMIC_COMPONENTSDisplays information about the dynamic SGA components. This view summarizes information based on all completed SGA resize operations since instance startup.V$SGA_DYNAMIC_FREE_MEMORYDisplays

B19306_01[@more@]Step 1: Decide on Your Instance Identifier (SID)Step 2: Establish the Database Administrator Authentication MethodStep 3: Create the Initialization Parameter FileStep 4: Connect to the InstanceStep 5: Create a Server Parameter File (Recommended)Step 6: Start the InstanceStep 7: Issue the CREATE DATABASE StatementStep 8: Create Additional TablespacesStep 9: Run Scripts to Build Data Dictionary ViewsStep 10: Run Scripts to Install Additional Options (Optional)Step 11: Back Up the

B19306_01 阅读笔记(character set)[@more@]Caution: AL32UTF8 is the Oracle Database character set that is appropriate for XMLType data. It is equivalent to the IANA registered standard UTF-8 encoding, which supports all valid XML characters.Do not confuse Oracle Database database character set UTF8 (no hyphen) with database character set AL32UTF8 or with character encoding UTF-8. Database character set UTF8 has been superseded by AL32UTF8. Do not use UTF8 for XML data. UTF8 supports only Unicode v

今天看到一个ORA-00610:Internal error code错误,[@more@]ORA-00610:Internal error codeCause:Oracle process started too lateAction:This error should never be seen by the customer. Contact Oraclce Support

.....[@more@]今天随便打开一个trace file 的时候，发现里面有大量的“AUTO SGA: Not free ”于是，检查SGA/内存使用情况等等，没发现任何异常，最后向METALINK 发TAR ，发现是个BUG ，并不是因为SGA 真的不够了。*** 2007-02-06 21:00:04.582*** SERVICE NAME:(SYS$BACKGROUND) 2007-02-06 21:00:04.577*** SESSION ID:(388.1) 2007-02-06 21:00:04.577AUTO SGA: Not free 0x70000016df8dc18, 1, 1, 1AUTO SGA: Not free 0x70000016df8dc18, 1, 1, 1AUTO SGA: Not free 0x70000016df8dd18, 1, 1, 1AUTO SGA: Not free 0x70000016df8de18,

....[@more@]今天客户说FTP 上面的文件权限不够,默认的FTP 权限是027 ,根据需要更改为002 .1 .查看帮助ftpd DaemonPurpose Provides the server function for the Internet FTP protocol.Syntax Note: The ftpd daemon is usually started by the inetd daemon. It can also be controlled from the command line, using SRC commands. /usr/sbin/ftpd [ -d ] [ -f ] [ -ff ] [ -k ] [ -l ] [ -U ] [ -t TimeOut ] [ -T MaxTimeOut ] [ -s ] [ -u OctalVal ] [-q [-C]]Description The /us

收藏..[@more@]IBM ThinkPad 随机软件的介绍说明1. Battery MaxiMiser Wizard 按装性:必装这个软件按字面来看是”电池最大化向导”,它是通过电池中的一块芯片来查看电池的健康情况以及电池的充电次数和剩余电量等等一些相关参数的.它还可以自己定义电源管理模式,比如用电池时屏幕是4格亮度,CPU按最小的频率使用等.2. IBM PM驱动 按装性:必装PM的意为Power Management Driver,也就是电源管理驱动,它是十分重要的一个软件,它可以来控制当本本在市电与电池之间切换时,CPU与主板PCI总线频率的控制,也就是我们所说的CPU降频使用,当然

记录一下[@more@]今天发现RMAN 中V$ARCHIVED_LOG 中STATUS 为"X" 的文件,想起是因为手动删掉错几个日志造成的,通过如下的方法把RMAN 中的记录也删掉test:oracle] /oracle/home> rman target /Recovery Manager: Release 10.2.0.2.0 - Production on Wed Feb 7 14:31:47 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.connected to target database: PRD (DBID=2733534212)RMAN> crosscheck archivelog all;using target database control file instead of recovery catalogallocated channel: ORA_DISK_1c