ITPub博客

结合metalink文档454678.1 和在网上看到别人 How to deal with SYSAUX tablespace 100% full ?The statistics used by Oracle Optimizer inside the Oracle Database Unit (DBU) are updated daily and stored for 31 days by default. For large tables, the statistics can use a significant amount of space in the SYSAUX tablespace So you have to purge the data manually.but the purge procedure will fail in most of the situation .because during the period , it will use up t

一次做DATAGUARD的时候恢复数据文件restore database出现下列错误Restore and recovery returns error:RMAN-03002: failure of restore command at 08/24/2007 11:47:27ORA-01861: literal does not match format string单独回复前几个文件可以restore database 1,2,3但是在恢复第60个文件的时候还是同样的错误，考虑可能是文件头有问题做了下列操作dd if=/dev/zero of=/dev/....filename... bs=8k count=8 conv=notrunc再做restore ok[@more@]

Customer may receive the below error messages on Linux Machines ::SQL> connect sys as sysdbaEnter password:Connected to an idle instance.SQL> STARTUP NOMOUNT PFILE="/opt/oracle/admin/day/pfile/day2.ini";ORA-00845: MEMORY_TARGET not supported on this system Solution Increase the /dev/shm mountpoint size. For example:# mount -t tmpfs shmfs -o size=7g /dev/shmAlso, to make this change persistent across system restarts, add an entry in /etc/fstab similar to the following:shmfs /

create database with US7ASCII is created using DBCA , perform the following steps : SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER SYSTEM ENABLE RESTRICTED SESSION; ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; ALTER SYSTEM SET AQ_TM_PROCESSES=0; ALTER DATABASE OPEN; ALTER DATABASE CHARACTER SET ZHS32GB18030;SHUTDOWN;Note 458122.1 about how to use CSSCANNote 306411.1[@more@]

oracle10g引入了mutexes的概念mutexes和latch有部分相似处latch 和 mutexes在机制上都是一个串行概念，但是mutex在使用上比latch更加轻量级别简单理解latch可以保护多个对象，当要访问latch保护的对象时，latch本身也有可能成为一个争用的对象mutexes相对来说处理比较灵活，在访问对应对象时，mutexes会衍生一个新的mutex针对要保护的对象多个session可以共享的使用一个mutex(Shared),单个session也可以独占的使用一个mutex(eXclusive)In 10.2, the only client of mutexes is kks (Kernel Kompile Shared) i.e. the shared cursor compon

[root@server ~]# lsof |grep 1521sendmail 1977 root mem REG 8,2 15216 225096 /usr/lib/sasl2/libcrammd5.so.2.0.19tnslsnr 3579 oracle 8u IPv4 9264 TCP server:1521 (LISTEN)tnslsnr 3579 oracle 11u IPv4 30797 TCP server:1521->server:37406 (ESTABLISHED)oracle 7637 oracle 16u IPv4 30796 TCP server:37406->server:1521 (ESTABLISHED)oracle 7686 oracle 12u IPv4 30953

备份users表空间RMAN> run {2> backup datafile 4;3> }Starting backup at 04-APR-09allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=140 devtype=DISKchannel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00004 name=/u01/app/oracle/oradata/db10g/users01.dbfchannel ORA_DISK_1: starting piece 1 at 04-APR-09RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STA

select file_id, block_id from dba_extents where segment_name = 'TEST' AND OWNER='APPS';FILE_ID BLOCK_ID4 336094 336174 336254 336334 336414 336494 336574 336654 336734 336814 336894 336974 337054 337134 337214 337294 338014 339294 340574 341854 34313bbed parfile=par.bbd blocksize=8192 copy file 2 block 17 to file 4 block 33617copy file 2 block 17 to file 4 block 33804[oracle@server ~]$ dbv file=/u01/app/oracle/oradata/db10g/use

cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk ikfedLinking KFED utility (kfed)rm -f /oracle/app/oracle/product/10.2.0/db_1/rdbms/lib/kfedgcc -o /oracle/app/oracle/product/10.2.0/db_1/rdbms/lib/kfed -L/oracle/app/oracle/product/10.2.0/db_1/rdbms/lib/ -L/oracle/app/oracle/product/10.2.0/db_1/lib/ -L/oracle/app/oracle/product/10.2.0/db_1/lib/stubs/ -L/usr/lib -lirc /oracle/app/oracle/product/10.2.0/db_1/lib/s0main.o /oracle/app/oracle/product/10.2.0/db_1/rdbms/lib/sskfeded.o /oracle/app/oracle/pr

CREATE DISKGROUP DSKGRP2 EXTERNAL REDUNDANCY DISK '/oracle/oradata/asmdisk03', '/oracle/oradata/asmdisk07'; create tablespace testasm datafile '+DSKGRP2' size 100M autoextend off extent management local uniform size 1M segment space management auto; RMAN> BACKUP FORMAT '/oracle/rman/bk_%s_%p_%t' tablespace testasm;Starting backup at 22-APR-09using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput data

下午装了一套10g RAC环境,装完后第二个节点ASM和数据库实例都可以通过srvctl正常启动，但是在第二个节点通过sqlplus死活连接不到数据库,连接直接出现下列提示Connected to idle instance后来检查第一个节点export ORACLE_HOME=/oracle/app/oracle/product/10g第二个节点export ORACLE_HOME=/oracle/app/oracle/product/10g/修改ORACLE_HOME，就是多了"/"惹的祸参考metalink doc 728895.1[@more@]

dul 10g版本的使用在自己的测试环境下（linux平台）测试下10g dul工具的使用数据库表空间使用的有ASM管理的磁盘组，也有一般的数据文件1)创建表空间create tablespace TBSDATA3 datafile '+DSKGRP1' size 100M;create table testdul (name varchar2(20)) tablespace TBSDATA3;select name,path,total_mb,free_mb,failgroup from v$asm_diskNAME PATH TOTAL_MB FREE_MB FAILGROUP-------------------- ---------------------------------------- ---------- ---------- --------

SQL> startup nomount;ORA-00845: MEMORY_TARGET not supported on this system[root@server ~]# df -k /dev/shmFilesystem 1K-blocks Used Available Use% Mounted onnone 517896 0 517896 0% /dev/shm[root@server ~]# umount /dev/shm[root@server ~]# mount -t tmpfs shmfs -o size=1024m /dev/shm[root@server ~]# df -k /dev/shmFilesystem 1K-blocks Used Available Use% Mounted onshmfs 1048576 0 1048576 0% /dev/shm[@more@]

最近同事去客户现场，一启动ASM，HP主机就重新启动后来检查ASM启动文件中的disk_string参数,发现该通过该参数扫描root盘disk_string=/dev/....修改该参数不扫描根盘，操作系统不在重新启动[@more@]

针对该问题，参考metalink Doc ID: 452341.1Solution1. Run the following script against the LOB tables in order to check for corruption:set serverout onexec dbms_output.enable(100000);declare pag number; len number; c varchar2(10); charpp number := 8132/2;begin for r in (select rowid rid, dbms_lob.getlength (<your_clob_column>) len from <your_table_with_clcob_column>) loop if r.len is not null then for page in 0..r.len/charpp loop begin

<2009-3-18 上午03时50分52秒 CST> <Critical> <WebLogicServer> <BEA-000362> <Serve r failed. Reason: [Management:141266]Parsing Failure in config.xml: java.lang.Il legalArgumentException: In production mode, it's not allowed to set a clear text value to the property: PasswordEncrypted of ServerStartMBean> <2009-3-18 上午03时50分52秒 CST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FAILED> <2009-3-18 上午03时5

[oracle@server1 ~]$ ./server103_linux32.bin ** The directory "/tmp" does not have enough space for extraction.Please input another directory or [Exit]: /oracle/tmpExtracting 0%....................................................................................................100%Unable to instantiate GUI, defaulting to console mode.<-------------------------------------- Oracle Installer - WebLogic Platform 10.3.0.0 ------------------------------------->Welcome:--------This insta

今天没什么事情，把笔记本上的10.2.0.3 rac升级到10.2.0.4,简单描述下升级过程第一步修改两个节点上的数据库启动方式把相关数据库及crs停掉$srvctl modify database -d orcl -y manual$srvctl stop asm -n server1$srvctl stop asm -n server2$srvctl stop instance -d orcl -i orcl1$srvctl stop instance -d orcl -i orcl2$srvctl stop nodeapps -n server1$srvctl stop nodeapps -n server2# crsctl stop crs第二步升级rac crs软件，10g的crs补丁和db补丁都在一个盘里，只是在升级的时候选不同的安装路径而已，注意安装界面选择对应的安

shell will time out in 60 secondsksh: timed out waiting for input在工作过程中，经常连接到客户的服务器上后，出现上述连接中断，通过设置export TMOUT=0解决该问题[@more@]

参考 metalink 754305.1,578455.1 两篇文章在11g release 2版本图形界面不再支持使用裸设备，在12g中，完全不支持使用裸设备oracle开始全面强迫推行ASM[@more@]