Author: mac

Advise required on inbound paramters , prespawn servers and db resident connection Question: The application does not support persistent connection. currently we find time out errors. In order to fix the issue we seek your advise on the following: currently all of the following are default values SQLNET.INBOUND_CONNECT_TIMEOUT, — can we make it 10 seconds…

Question: Oracle Support on the note “Lun Size And Performance Impact With Asm [ID 373242.1]” and on the note “How to Prepare Storage for ASM [ID 452924.1]” say that in other things: – Maximize the number of disks in a disk group for maximum data distribution and higher I/O bandwidth – Size alone should not…

Customer is running 10.2.0.2 RAC on Solaris 10. Final objective is to upgrade to RAC 10.2.0.4. Requirement is as below; 1) Upgrade Solaris 10 patches from Generic_118833-03 to 142909-17 2) Upgrade RAC to 10.2.0.4 Question1: Customer is thinking of performing the OS patch upgrade via the below strategy; Night1: 1. Shutdown node2. 2. Shutdown crs/db…

一套Itanium HP-UX上的9.2.0.5系统最近出现了ORA-00600: internal error code, arguments: [kgskdecrstat1], [], [], [], [], [],内部错误，其错误日志如下: Mon Apr 18 12:32:20 2011 ORA-00600: internal error code, arguments: [kgskdecrstat1], [], [], [], [], [], [], [] ARC0: Completed archiving log 6 thread 1 sequence 831803 Mon Apr 18 12:32:22 2011 ORA-00600: internal error code, arguments: [kgskdecrstat1], [], [], [], [], [], [],…

一套10.2.0.4的单节点数据库在恢复数据文件时出现了ORA-00600: internal error code, arguments: [2608], [1], [0], [690423], [0], [690425], [], []内部错误，其日志如下:   如果自己搞不定可以找ASKMACLEAN专业ORACLE数据库修复团队成员帮您恢复!     Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /s01/db_1 System name: Linux Node name: rh2.oracle.com Release: 2.6.18-194.el5 Version: #1 SMP Mon Mar 29…

ORA-01189错误常见于使用Create Controlfile命令时发现OFFLINE的数据文件或者备份文件生成于上一次的RESETLOGS之前，一般来说如果是在RESETLOGS前offline的数据文件，可以在CREATE CONTROLFILE命令中省略该offline datafile，在打开数据库后使用rename file命令修复其丢失的数据文件名，之后再将数据文件online；若不是offline datafile所造成的ORA-01189错误，就必须要找出与其他数据文件版本一致的数据文件或其备份才能解决该问题。 设想存在这样一个场景：数据库处于非归档无备份的状态，在周日使用shutdown immediate命令干净地关闭了数据库,到周一发现因为磁盘故障丢失了所有的控制文件，不得不使用Create Controlfile RESETLOGS重建控制文件，而在重建过程中又漏输了某条数据文件的记录，之后又使用alter database open resetlogs重置日志文件并打开数据库，此时发现丢失了一个数据文件，尝试使用针对offline datafile的处理方法将丢失的数据文件重命名(rename)，并尝试online该数据文件，毫无疑问我们会遇到ORA-01190 “control file or data file %s is from before the last RESETLOGS”错误，这时虽然我们手上有该”干净”的数据文件，却也没有办法使之online了。     如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!   诗檀软件专业数据库修复团队   服务热线 ： 13764045638   QQ号:47079569    邮箱：[email protected]     这里我介绍一种使用bbed修改数据文件头的方法来解决该ORA-01189错误:     [oracle@rh2 controlfile]$ oerr ora 1189 01189, 00000, “file is from a different…

内部视图x$ksqst记录了以enqueue type分类的队列管理统计信息(Enqueue management statistics by type)，ksqstwat列反映了等待次数，而ksqstwtim列反映了累积等待时间，实际上v$enqueue_stat动态性能视图的CUM_WAIT_TIME列数据也来源于ksqstwtim: SQL> select * from v$fixed_view_definition where view_name=upper(‘gv$enqueue_stat’); VIEW_NAME —————————— VIEW_DEFINITION ——————————————————————————– GV$ENQUEUE_STAT select inst_id, ksqsttyp, sum(ksqstreq), sum(ksqstwat), sum(ksqstsgt), sum(ksqstfgt), sum(ksqstwtm)    from X$KSQST group by inst_id, ksqsttyp having sum(ksqstreq) > 0 SQL> desc X$KSQST Name Null? Type —————————————– ——– —————————- ADDR RAW(8) INDX NUMBER INST_ID NUMBER KSQSTTYP VARCHAR2(2) KSQSTREQ NUMBER…

Oracle中很多SQL操作都会使用Temp Space临时空间，理想状况下OLTP环境中自动/手动管理的PGA总是能在私有内存中满足这些操作的空间需求，而在Data Warehouse数据仓库中往往我们需要配置一个巨大的临时表空间(组)来满足海量的维护/查询对临时空间的需求，那么到底有哪些SQL操作时需要用到临时空间的呢？Google了一下，似乎没有一张非常完整的列表，这里由我抛砖引玉地列出一些，当然这远远不够全面: SQL CODE Type CREATE INDEX DDL REBUILD INDEX DDL ANALYZE DDL CREATE PRIMARY KEY CONSTRAINT DDL ENABLE CONSTRAINT DDL CREATE TABLE AS SELECT(use permanet TBS) DDL SELECT DISTINCT QUERY ORDER BY Clause GROUP BY Clause UNION ALL Clause UNION Clause MINUS Clause INTERSECT Clause ROLLUP() FUNCTION FUNCTION RANK() FUNCTION FUNCTION CONNECT BY…

  Oracle Server – Enterprise Edition – Version: 11.1.0.6 to 11.1.0.7 – Release: 11.1 to 11.1 Symptoms   /dev/shm is being filled up with files in the format JOXSHM_EXT_???_SID_???? and eventually causing the DB to restart. Oracle is not automatically cleaning those files. Please note that it is OS specific whether such segments are visible…

经常有网友在构建10g/11g中ASM存储环境的时候遇到ASM磁盘无法识别的问题，虽然已经为存储设备赋予了适当的权限，也为ASM实例修改了asm_diskstring初始化参数，可是在DBCA的ASM Diskgroup创建页面里就是无法显示候选的ASM Disk磁盘。 实际上因为ASM存储方式比起裸设备或GPFS来说更为黑盒，我们也无法利用ASM instance中的一些动态性能视图或内部视图来排查造成这一问题的原因，使得这类问题显得十分棘手。 下面我来介绍一种使用操作系统调用追踪工具来排查ASM无法找到磁盘问题的方法。 [oracle@vrh1 raw]$ cd /dev/rdsk /* 演示中我们要用到的三个裸设备位于/dev/rdsk下 */ [oracle@vrh1 rdsk]$ ls hdisk1 hdisk2 hdisk3 [oracle@vrh1 rdsk]$ sqlplus / as sysdba SQL> select * from v$version; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – Prod PL/SQL Release 10.2.0.4.0 – Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 -…