AskDba.org Weblog » Archive for June 2008
New ASM Background Processes in 11G
Few hours back I installed Oracle Database 11g(Though still DB is yet to be created), so I started playing with the ASM instance. First thing I did was to check ASM alert.log. I used ADRCI (11g) to see it adrci> show incident ADR Home = /u03/app/oracle/diag/asm/+asm/+ASM: ********************************************************* 0 rows fetched adrci> show alert ADR Home = /u03/app/oracle/diag/asm/+asm/+ASM: ********************************************************** Output the results to file: /tmp/alert_9572_1_+ASM_1.ado "/tmp/alert_9572_1_+ASM_1.ado" 48 lines, 1964 characters PMON started with pid=2, OS id=3672 DIAG started with pid=4, OS id=3678 VKTM started with pid=3, OS id=3674 VKTM running at (100ms) precision 2008-06-24 15:24:12.425000 +05:30 PSP0 started with pid=5, OS id=3680 DSKM started with pid=6, OS id=3682 DIA0 started with pid=7, OS id=3684 MMAN started with pid=6, OS id=3686 DBW0 started with pid=8, OS id=3689 LGWR started with pid=9, OS id=3691 CKPT started with pid=10, OS id=3694 SMON started with pid=11, OS id=3700 RBAL started with pid=12, OS id=3702 GMON started with pid=13, OS … Read entire article »
11.1.0.6 ASM installation on Solaris fails -II
Some time back, I had written about CSS service not starting in my post 11.1.0.6 ASM installation on Solaris fails -I After doing some research, I came across Metalink Document Note:397238.1 – How to Convert init.cssd as a SMF service for Solaris 10 This document talks about using Service Management Facility (SMF) which was introduced in Solaris 10. To configure it we have to download a zip file from the note and copy two files called initcssd to /lib/svc/method/initcssd and copy the second file initcssd.xml to /var/svc/manifest/site and some other steps (as listed in doc) 1) Install Oracle Software on Solaris 10 2) Download files from Note: 397238.1. Once done, modify the files accordingly and copy to the required location. 3) Do the configuration and then enable the service. # svcadm -v enable initcssd After doing this, … Read entire article »
ORA- 4031 – A Case Study
Today I will be taking up one ORA-4031 issue we faced on one of our client database. Please note that SQL statements mentioned below have been changed and does not reveal any confidential information. Our client was facing ORA-4031 on a 9.2 database.This was a new Database which had gone Live recently. Following error messages were recorded in alert log. ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","select owner#,name,namespace...","sga heap(1,0)","library cache") Initial shared pool at time of failure was 160 Mb. After the failure the shared_pool_size was increased to 1 Gb. We did not have any other information and were asked to perform RCA for the same. Luckily we had Statspack configured on the server, so we took … Read entire article »
Can ASM DiskGroup Be Renamed?
This was actually a question on Oracle forum which I had replied to. Basically the Poster, wanted to know if he could rename the ASM Diskgroup name by renaming/editing ASM Disk header. He had also mentioned that he had heard about this being done by Oracle for its few customers using kfed. Answer is NO. It is not possible to rename the diskgroup by editing the ASM disk header. kfed is known to be used for patching ASM disk headers for corruption (only oracle support can do it) and for viewing ASM header contents. Only way to change this by dropping and recreating the diskgroup. In case you wish to create a new diskgroup with a name say +DG1 which was being used by a Diskgroup which is not mounted (Have some … Read entire article »
kfed in 11g
While carrying out Oracle Database 11g install, I noticed that kfed is automatically created. This is in contrast to 10.2 where you had to create it using “make” command. In case you are looking for 10.2 method, you can find it in my previous post ORA-15063 – ASM Discovered Insufficient amount of Disks … Read entire article »
11.1.0.6 ASM installation on Solaris fails -I
Looks like that there is no easy way for me to install/configure Oracle components. And every install/configuration leads me to some or the other problems. Anyways I was trying to install Oracle Database 11g on a Solaris 10 but the CSS does not seems to come up. While issuing localconfig add as root user it gives following message and fails -bash-3.00# ./localconfig add Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. Configuration for local CSS has been initialized Cleaning up Network socket directories Setting up Network socket directories Adding to inittab Startup will be queued to init within 30 seconds. Checking the status of new Oracle init process... Expecting the CRS daemons to be up within 600 seconds. Giving up: Oracle CSS stack appears NOT to be running. Oracle CSS service would not start … 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