ITPub博客

最早参考了http://www.dbanotes.net/ 中相关文件[@more@]Oracle 10g 关于 NLS 的环境变量发生了一点变化:For RDBMS 7.2.x version the variable is called ORA_NLS. For version 7.3.x the variable is called ORA_NLS32.For Oracle 8, 8i and 9 variable is called ORA_NLS33.For Oracle 10g the variable is called ORA_NLS10.ORA_NLS33 的设置值:ORA_NLS33 = $ORACLE_HOME/ocommon/nls/admin/data而 ORA_NLS10 只需要设置:ORA_NLS10 = $ORACLE_HOME/nls/data定义了 ORA_NLS10 则不需要单独定义 ORA_NLS33 等参数了。目前应该仍然是向后

10g,无论怎么该LOG_BUFFER ,都是保持14242816,估计是BUG 10g,中用了自动内存管理,在INIT.ORA 文件手动设置了LOG_BUFFER = 4194304 ,但不关是去掉哪个参数,还是加上,DB 启动以后看到的结果都是14242816..我已经提交给METALINK 了,已经3天了,他们一直在"Work in process" .感觉是BUG 的可能性很大..[@more@]Subject: The Log_buffer Cannot be Changed In 10g R2 Doc ID: Note:351857.1Type: PROBLEM Last Revision Date: 14-MAR-2006Status: MODERATEDIn this Document Symptoms Cause Solution ReferencesThis document is

..............[@more@]Subject: Alert Log Messages: Private Strand Flush Not Complete Doc ID: Note:372557.1Type: PROBLEM Last Revision Date: 07-JUN-2006Status: MODERATEDIn this Document Symptoms Cause SolutionThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.2.0This problem can occur on any platf

收藏[@more@]关于Oracle10g - Private Strand Flush Not Complete今天抽空做了一下Oracle 10gR2的Data Guard测试，结果在Alert Log中发现了“Private Strand Flush Not Complete”信息，感觉有点怪。 先描述一下系统环境，1>服务器 IBM p55A上的两个LAPR# oslevel -s5300-04-00 2>数据库 Oracle 10gR2SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64biPL/SQL Release 10.2.0.1.0 - ProductionCORE 10.

今天发现ALERT.LOG 中一些莫名其妙的信息,于是发TAR 给ORACLE ,终于明白了什么原因了The meaning of alert.log entries:HS: Created new FDS class definition in server DDHS: Class id = 21, class name = ODBC10.1.0.4.0_177HS: Created new FDS class definition in server DDHS: Class id = 22, class name = ODBCHS: Created new FDS instance definition in server DDHS: Instance id = 1, instance name = DB2 (class ODBC10.1.0.4.0_177)HS: Error in server DD access for FDS capabilitiesFri Jan 26 17:00:06 2007HS: Created

.....[@more@]Connections that Used to Work in Oracle 10.1 Now Intermittently Fail with ORA-3113,ORA-3106 or ORA-3136 in 10.2 Doc ID: Note:345197.1Type: PROBLEM Last Revision Date: 20-NOV-2006Status: PUBLISHEDIn this Document Symptoms Cause SolutionApplies to: Oracle Net Services - Version: 10.2.0.1.0This problem can occur on any platform.SymptomsThe Oracle Net 10g parameters SQLNET.INBOUND_CONNECT_TIMEOUT and INBOUND_CONNECT_TIMEOUT_listenername default to 0 (indefinite) in 10.1. To address

...[@more@]Subject: Repca: Error -Sqlexception On Getting Sid And Systemname Information Doc ID: Note:388445.1Type: PROBLEM Last Revision Date: 29-JAN-2007Status: MODERATEDIn this Document Symptoms Cause Solution ReferencesThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.Applies to: Oracle Application Server 10g Enterprise Edition - Version: 10.1.2.0.2This

..................[@more@]今天在创建TABLESPACE 时,出现ORA-01144, 好在创建的最大的LV 裸设备为32G ,maximum file size = db_block_size * 4194303Cause: Specified file size is larger than maximum allowable size value.Action: Specify a smaller size.

..........[@more@]在static end to end data load时抛异常：<entry TxnId="20019281" ThreadName="Asynch Thread-10" Time="01/31/2007 00:36:58:421" Level="Exception" ParentTxnId="29822636" Service="E2E" > <msg><![CDATA[Exception in ExecProcCommand: ]]></msg> <stackTrace><![CDATA[java.sql.SQLException: ORA-01536: space quota exceeded for tablespace 'TESTTBS'ORA-06512: at "TEST.START_NET_CHANGE",

....[@more@]1 .昨天更换了PFILE ，忘了增加ARCHIVE 的部分了############################################ Archive###########################################log_archive_dest_1='LOCATION=/testarch2'log_archive_format=%t_%s_%r.dbf2.晚上备份出现如下错误sql statement: alter system archive log currentreleased channel: t1released channel: t2RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ==============

.....[@more@]14-DEC-06 05:15:35 GMTHi,There is no patch available for the bug 4483084.You need to Ignore this error, as there is absolutely no impact to the database due to this error.Thanks,Ram14-DEC-06 05:16:03 GMTEmail Update button has been pressed: Sending email to longchun.zhu@gmail.com. 15-DEC-06 06:17:59 GMT.ISSUE CLARIFICATION====================Database closed.Database dismounted.ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [],[], [], [], [], [], []eos (end

...........[@more@]Subject:　 Direct I/O (DIO) and Concurrent I/O (CIO) on AIX 5L Doc ID:　 Note:257338.1 Type:　 BULLETIN 　Last Revision Date:　 13-SEP-2005 Status:　 PUBLISHED PURPOSE-------To discuss the use of Direct I/O (DIO) and Concurrent I/O (CIO) on AIX 5L　SCOPE & APPLICATION-------------------System Administrators managing AIX 5L that has Oracle RDBMS on top.DIRECT I/O (DIO) AND CONCURRENT I/O (CIO) on AIX------------------------------------------------If you use a Journaled Fil

.....[@more@]Starting iSQL*PlusiSQL*Plus is the Web version of SQL*Plus. Before you can connect to it with a URL, you must start the iSQL*Plus application server. To do so, enter the following at the command line:isqlplusctl start After the server is started, you can connect to iSQL*Plus with a URL such ashttp://machine_name:5560/isqlplus

....[@more@]To access the Oracle Enterprise Manager Console from a client browser, the dbconsole process needs to be running on the server. The dbconsole process is automatically started after installation.However, in the event of a system restart, you can start it manually at the command line or start it as a service in Windows.To start the dbconsole process from the command line:Navigate into your ORACLE_HOME/bin directory.Run the following statement:./emctl start dbconsole Additionally, yo

....[@more@]环境:AIX5.3+Oracle 10g R2问题:alert.logWARNING: inbound connection timed out (ORA-3136)SQLNET.LOG error Fatal NI connect error 12637, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production Time: 25-JAN-2007 13:39:03 Tracing not turned on.

......................[@more@]As an Oracle DBA, you can expect to be involved in the following tasks:- 安装Oracle Software- Creating Oracle Databases- Performing Upgrades of the database and software to new release levels- Starting up and shutting down the database-Managing the database's storage stuctures- Managing users and security- Managing schema objects,such as tables,index,and views- Making database backups and performing recovery when necessary- Proactively monitoring the database's hea

dd命令[@more@]dd命令功能很强大的，对于一些比较底层的问题，使用dd命令往往可以得到出人意料的效果。用的比较多的还是用dd来备份裸设备。但是不推荐，如果需要备份oracle裸设备，可以使用rman备份，或使用第三方软件备份，使用dd的话，管理起来不太方便。 建议 在有需要的时候使用dd 对物理磁盘操作，如果是文件系统的话还是使用tar backup cpio等其他命令更加方便。 另外，使用dd对磁盘操作时，最好使用块设备文件。 Description The dd command reads the InFile parameter or standard input, does the specified con

/...[@more@]OS: AIX5.3CLUSTER:HACMP5.3DB:9.2.0.8 + RACEXP 导出时: EXP-00091: Exporting questionable statistics.解决:SQL> select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET' 2 ;PARAMETER------------------------------VALUE--------------------------------------------------------------------------------NLS_CHARACTERSETAL32UTF8ORACLE 用户 .profile 中增加:export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

...[@more@][TEST:oradev] /devTESTarch1/flash_back/TEST/onlinelog> as sysdba" <SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 5 16:28:55 2007Copyright (c) 1982, 2005, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> alter system set db_recovery_file_dest='/devTESTarch1/flash_back' scope=both;System altered.SQL> alter system set db_recovery_fil

...[@more@]UNDO表空间用于存放UNDO数据,当执行DML操作(INSERT,UPDATE和DELETE)时,oracle会将这些操作的旧数据写入到UNDO段,在oracle9i之前,管理UNDO数据时使用(Rollback Segment)完成的.从oracle9i开始,管理UNDO数据不仅可以使用回滚段,还可以使用UNDO表空间.因为规划和管理回滚段比较复杂,所有oracle database 10g已经完全丢弃用回滚段.并且使用UNDO表空间来管理UNDO数据.UNDO数据也称为回滚(ROLLBACK)数据,它用于确保数据的一致性.当执行DML操作时,事务操作前的数据被称为UNDO记录.UNDO段用于保存事务所修改数据的旧值,其中存储着被修改