ITPub博客

在工作中，使用sqlplus连接数据库SQL> conn system/oracle@depdb1ERROR:ORA-21561: OID generation failed出现该错误后，查看metalinkConnection Via 10.2.0.3 SQL*Net Fails With Error ORA-21561: OID Generation Failed [ID 559981.1]Cause Incorrect /etc/hosts mapping for the client machine or no mapping at all. Solution Check the client's /.../hosts file and verify that the local node is correctly identified with a mapping for both the short and fully qualified name of the host.同时检查自己的/etc/ho

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jun 9 14:32:37 2008Copyright (c) 1982, 2007, Oracle. All Rights Reserved.SQL> conn /as sysdbaConnected to an idle instance.SQL> STARTUPORA-27126: unable to lock shared memory segment in coreIBM AIX RISC System/6000 Error: 1: Not ownerChanges The Oracle Home binaries have been patched to 10.2.0.4.0. Cause "oracle" user does not have the required OS capabilities. When LOCK_SGA is set to TRUE in 10.2.0.4, "oracle" user

Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.3 to 11.1.0.7HP-UX ItaniumSymptomssyslog.16:Aug 16 16:55:46 s51uf33 vmunix: kthread: table is fullsyslog.16:Aug 16 16:56:09 s51uf33 vmunix: kthread: table is fullsyslog.16:Aug 16 16:58:46 s51uf33 vmunix: kkthread: table is fullsyslog.16:Aug 16 16:58:46 s51uf33 vmunix: kthread: tablket hirse afdu:l ltsyslog.16:Aug 16 16:58:46 s51uf33 vmunix: kthread: table is fullsyslog.16:Aug 16 16:58:46 s51uf33 vmunix: kthread: table is fullsyslog.

针对latch:library cache,首先我们先来看看具体这种等待事件的概念针对工作过程中最常见的library cache,针对其他的等待，在以后可以做实验模拟出来主要有library cachelibrary cache pinlibrary cache lock等我们这次主要讨论library cacheLIBRARY CACHE Library cache latch:The library cache latches protect the cached SQL statements and objects definitions held in the library cache within the shared pool. The library cache latch must be acquired in order toadd a new statement to the library cache. During a parse,

参考http://christianbilien.wordpress.com/2007/05/01/two-useful-hidden-parameters-_smm_max_size-and-_pga_max-size/9i (and probably 10gR1, which I did not test): _pga_max_size: default value is 200MB._smm_max_size : default value is the least of 5% of pga_aggregate_target and of 50% of _pga_max_size. A ceiling of 100MB also applies. The ceiling is hit when the pga_aggregate_target exceeds 2GB (5% of 2GB = 10MB) or when_pga_max_size is set to a higher value than the default AND pga_aggregate_target

TRACE_LEVEL_<listenername> = 16 TRACE_FILE_<listenername> = listenerTRACE_DIRECTORY_<listenername> = <any valid directory path> TRACE_TIMESTAMP_<listenername> = ON TRACE_FILELEN_listenername = 102400TRACE_FILENO_listenername = 2TRACE_LEVEL_LISTENER_SERVER1 = 16 TRACE_FILE_LISTENER_SERVER1 = LISTENER_SERVER1.trcTRACE_DIRECTORY_LISTENER_SERVER1 = /oracle/app/oracle/product/10.2.0/db_1/network/log/ TRACE_TIMESTAMP_LISTENER_SERVER1 = ON TRACE_FILELEN_LISTENER_SERVER1 =

Installing Csscan参考文档[ID 745809.1], [ID 754425.1]set oracle_sid=<your SID>sqlplus /nologSQL>conn / as sysdbaSQL>set TERMOUT ONSQL>set ECHO ONSQL>spool csminst.logSQL>@?/rdbms/admin/csminst.sqlnohup csscan system/sys FULL=y TOCHAR=zhs32gb18030 ARRAY=1024000 PROCESS=3 > csscan.log &生成下面几个文件，scan.txt,scan.out,scan.err，我们主要关注scan.err判断那些表数据在做字符集合转换过程中会出现乱码[@more@]

First of all the problem with the destination being stuck at the OS level should be resolved. Secondly you can change the above outlined archiver behavior, to make sure the local destination is archived first, causing the OPTIONAL destination to behave really optional. If the following parameter is set then the ARCH process will begin archiving to the local destination first. Once the redo log has been completely and successfully archived to at least one local destination. For 9iR2 (

Unicode Character Sets In The Oracle DatabaseOverview Oracle started supporting Unicode based character sets in Oracle7. Here is a summary of the Unicode character sets supported in Oracle:Characterset Name RDBMS version Unicode versionAL24UTFFSS 7.2-8.1 1.1UTF8 8.0-11g 2.1 (8.0-8.1.6) , 3.0 (8.1.7-11g) UTFE 8.0-11g 2.1 (8.0-8.1.6) , 3.0 (8.1.7-11g) AL32UTF8* 9.0-11g 3.0 (9.0), 3.1 (9.2), 3.2 (10.1), 4.01 (10.2), 5.0 (11.1).AL16UTF16** 9.0-11g 3.0 (9.0), 3.1