AskDba.org Weblog » Archive
ORA-27146 Errors while starting up Database
Short post on a issue faced by me, while starting up a cloned database SQL> startup nomount ORA-24323: value not allowed ORA-27146: post/wait initialization failed This database environment was cloned and was being started for first time after cloning. Running hcve scripts on system indicated that OS kernel parameters were adequately sized. SHMMNI set to 1000 is adequate SHMSEG set to 120 is adequate SEMMNI set to 700 is adequate SEMMNS set to 2000 is adequate MAX_THREAD_PROC set to 256 is adequate NFLOCKS set to 1450 is adequate My Oracle Support articles suggested this issue is related to semaphores setting. As settings were correct, I attempted to start instance by commenting processes parameter in init.ora (setting was 1000). This time database started. I modified the processes parameter back to 1000 and attempted to restart the Database. It started again!! I am clueless … Read entire article »
Don’t blindly implement Blog suggestions on your Production Servers
Don’t blindly implement Blog suggestions on your Production Servers. This post is prompted by a recent issue where in DBA had modified racgvip script based on suggestion on one of blog (won’t name it). Any such suggestions or similar to these which involve modification of oracle provided scripts should always be verified with Oracle Support. Anyways I have put comment on the blog entry to correct or put a disclaimer … Read entire article »
Oracle Patch Set update (PSU 2) released for 10.2.0.4 and 11.1.0.7
Oracle has recently released Oracle Patch Set update (PSU 2) along with CPU October 2009. As informed earlier , PSU are released quarterly along with CPU patches. If you are running 10.2.0.4 RAC database, you need to apply following patches 1) Apply Patch 8833280 (10.2.0.4.2 PSU 2) on Oracle Database 10.2.0.4 2) Apply Patch 8436582 (10.2.0.4 CRS Bundle Patch #4) on Oracle Clusterware 10.2.0.4 3) Apply Patch 8705958 (10.2.0.4 CRS PSU 2 ) on Oracle Clusterware 10.2.0.4 1) Patch 8833280 (10.2.0.4.2 PSU 2) for Oracle Database 10.2.0.4 2) Patch 8436582 (10.2.0.4 CRS Bundle Patch #4) for Oracle Clusterware 10.2.0.4 CRS PSU2 patch contains fixes for bugs fixed in Bundle patch 4 3) Patch 8705958 (10.2.0.4 CRS PSU 2 ) for Oracle Clusterware 10.2.0.4 Critical Patch Update (CPU) are released each quarter and contain security fixes identified by … Read entire article »
Wishing all a hApPy DiWaLi
Wishing you all a Happy and Prosperous Diwali - Amit & Saurabh … Read entire article »
Filed under: Random
Sqlplus connection on AIX taking too long
Recently we faced a performance issue, where in sqlplus connection from application server A (AIX 5.3) to Database server DB (different physical server,10gR2 on AIX 5.3) was taking nearly 1-2 minutes. We did some quick check’s to narrow down the problematic area.i.e Is it network or database server or some issue with application server? 1)Vmstat output reported Normal Run queue’s/memory utilisation/idle cpu on Application server A and Database Server DB . Rules out resource issue. 2) Connections from other application server B was taking normal time. Rules out Database server issue 3) If incorrect password was entered in connection details, second attempt resulted in normal quick response time. Indicates some network issues. 4) System Admin checked for network issues with traceroute command and reported normal results. Even though SA confirmed that there was no network … Read entire article »
Link:11gR2 RAC installation steps on OEL4
If you are looking for steps for 11gR2 RAC installation, you can refer to this article by Rajeev Ramdas at Dbastreet.com. Article lists down steps for installing 11gR2 RAC on 64 bit Oracle Enterprise Linux 4 (OEL4) using ASM for storage. As Raw devices are no longer supported, OCR and Voting Disks are also stored on ASM. Yes, this is one more cool New Feature available in 11gR2. … Read entire article »
Subscribe To Feed
License
AskDba.org Forum
- Mahesh.G on "DR rebuild- Data restore issue" March 11, 2010
- Saurabh Sood on "DR rebuild- Data restore issue" March 11, 2010
- sunkkuma on "DR rebuild- Data restore issue" March 11, 2010
- Amit Bansal on "DB and Listener availability monitoring script" March 11, 2010
- animesh on "DR rebuild- Data restore issue" March 11, 2010
Recent Comments