AskDBA.org Forum » Recent Topics

AskDBA.org Forum » Recent Topics http://www.forum.askdba.org/ Forum for Oracle DBA's en Thu, 09 Feb 2012 22:00:28 +0000 e303868 on "ORACLE_HOME/(server_dbname)/sysman/recv/errors" http://www.forum.askdba.org/topic/oracle_homeserver_dbnamesysmanrecverrors#post-305 Sat, 14 Jan 2012 17:41:30 +0000 e303868 305@http://www.forum.askdba.org/ Hi I have recently installed oracle application server on windows server 2003. and I also configured our system on this application and working fine with no problem. The problem is that there are many errors generated under ORACLE INFRA_HOME/(server_dbname)/sysman/recv/errors filling up my hard disk. The Files like A0000000064.err_2007_06_29_17_45_53. The content of the files are similar, and begin with:- ============================= Time: 2011-12-17 16:53:49 From: <a href="http://testapp:1830/emd/main" rel="nofollow">http://testapp:1830/emd/main</a> --> <UPLOAD OMS_PROTOCOL_VERSION="10.1.0.2.0" UPLOAD_TYPE="metadata" EMD_URL="http://testapp:1830/emd/main" MERGE_TIMESTAMP="2011-12-17 16:53:49"> <ROWSET OMS_PROTOCOL_VERSION="10.1.0.2.0" TABLE="MGMT_TARGET_PROP_DEFS"> <ROW> <TARGET_TYPE>oracle_database</TARGET_TYPE> <TYPE_META_VER>3.1</TYPE_META_VER> <PROPERTY_NAME>OracleHome</PROPERTY_NAME> <PROPERTY_TYPE>INSTANCE</PROPERTY_TYPE> <PROPERTY_DISPLAY_NAME>Oracle home path</PROPERTY_DISPLAY_NAME> <PROPERTY_DISPLAY_NLSID>OracleHome_iprop</PROPERTY_DISPLAY_NLSID> <REQUIRED_FLAG>0</REQUIRED_FLAG> <CREDENTIAL_FLAG>0</CREDENTIAL_FLAG> <DEFAULT_VALUE/> =================================== What can I do to stop these generated files? Thank you. Pankaj Sharma on "Lost all voting disk on ASM in oracle 11gr2" http://www.forum.askdba.org/topic/lost-all-voting-disk-on-asm-in-oracle-11gr2#post-301 Tue, 20 Dec 2011 11:56:14 +0000 Pankaj Sharma 301@http://www.forum.askdba.org/ Hi, This is regarding Oracle 11gR2 RAC. I have a 2 node RAC on RHEL5. I have my voting file on ASM diskgroup named "+DATA1", which is created on device "/dev/sdc1". Below is the details: [root@rac1 ~]# oracleasm querydisk -p ASMDISK2 Disk "ASMDISK2" is a valid ASM disk /dev/sdc1: LABEL="ASMDISK2" TYPE="oracleasm" I was just want to test the scenario when I lost my all voting disk, then what happens actually. So I make the zero space the partition using below command: [root@rac1 ~]# dd if=/dev/zero of=/dev/sdc1 dd: writing to `/dev/sdc1': No space left on device 10474318+0 records in 10474317+0 records out 5362850304 bytes (5.4 GB) copied, 161.053 seconds, 33.3 MB/s My disktimeout was 200 seconds. But I waited for approx 8-10 minutes. Then I query the votedisk, but still it is showing ONLINE on DATA1 diskgroup. [root@rac1 ~]# crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 06d8300bb6af4fd3bfa2e1e5cda9c440 (ORCL:ASMDISK2) [DATA1] Located 1 voting disk(s). Also below are some findings in this situation: 1) ASMCA is not showing the diskgroup DATA1, it is deleted. 2) Cluster alert log is not displaying any message regarding the lost of voting disk. 3) cssd.log also not displaying any message regarding the lost of voting disk. 4) Cluster is still running and up. Also its working properly. As per documentation, oracle 11g r2 provide "rebootless node fencing" in case of all voting disk failure. But atleast it must display any message in log files or how the "crsctl query css votedisk" is still giving that voting disk is ONLINE ? I am not able to understand this situation. Please explain me the reason ? Thanks in advanced. Amit Bansal on "User Registrations" http://www.forum.askdba.org/topic/user-registrations#post-299 Wed, 16 Nov 2011 04:02:10 +0000 Amit Bansal 299@http://www.forum.askdba.org/ To tackle lot of spam being generated on this forum, I have modified the user registration process. Now when a user registers, he/she will not get immediate login and it will be stored in a moderation queue. Only once moderators approve, user will be able to login. In case registration is not approved for some time or password is not working, then send mail to <a href="mailto:amit.bansal@askdba.org">amit.bansal@askdba.org</a> Pankaj Sharma on "Voting Disk Location in Oracle 11gR2" http://www.forum.askdba.org/topic/voting-disk-location-in-oracle-11gr2#post-291 Fri, 04 Nov 2011 11:01:31 +0000 Pankaj Sharma 291@http://www.forum.askdba.org/ Hi All, Could you please tell me that in Oracle 11g, information regarding voting disk location is stored in which file ? I know that we can use "crsctl query css votedisk" to see the location of voting disk, but from which file or place this command pick the information ? Pankaj Sharma on "Regarding RAC concepts" http://www.forum.askdba.org/topic/regarding-rac-concepts#post-262 Mon, 17 Oct 2011 07:58:42 +0000 Pankaj Sharma 262@http://www.forum.askdba.org/ I also have some questions regarding RAC concepts: 1) As per my understanding, ocrconfig commands only updates the ocr.loc file on all the available nodes. Does it updates anywhere else also ? 2) As per my understanding, while clusterware is running, if we lost all OCR, then crsd.bin would be stopped and it won’t be restart automatically again due to unavailability of OCR. In this case we won’t be able to use commands like srvctl, crsctl, and ocrconfig which interact with OCR using crsd.bin process. But how will it affect other resources like database instance, listeners, scan, vips ? These all are still keep on running after losing all OCR and stopping the crsd.bin. Does all the nodes are still a part of the cluster or they behave as individually ? Thanks in advance. kyrool on "Problem Tracing Data" http://www.forum.askdba.org/topic/problem-tracing-data#post-277 Fri, 28 Oct 2011 11:11:57 +0000 kyrool 277@http://www.forum.askdba.org/ Hi, I just doing final year project, I just want to know from your opinion, what is problem you are facing when tracing data from audit trail? kyrool on "Database Security" http://www.forum.askdba.org/topic/database-security#post-282 Mon, 31 Oct 2011 03:06:57 +0000 kyrool 282@http://www.forum.askdba.org/ Hi, What type of security can implement in database level? shashikiran on "Creating One Node RAC using SAN replication" http://www.forum.askdba.org/topic/creating-one-node-rac-using-san-replication#post-263 Thu, 20 Oct 2011 07:23:49 +0000 shashikiran 263@http://www.forum.askdba.org/ Hi We have the following set up : 2 node 11gr2 (11.2.0.1) RAC using ASM. Business requirement is to have a DR site. SAN replication is used to replicate the data to the DR storage ie, the underling disks are replicated to DR site. On the SR site , we have only one server on which Both the Grid Infrastructure and oracle home will be installed. Is it possible to bring up the RAC DB on a single node . I haven't tried this before . Could you help me on this . Pankaj Sharma on "Oracle 11g R2 - CRS is not starting" http://www.forum.askdba.org/topic/oracle-11g-r2-crs-is-not-starting#post-259 Fri, 14 Oct 2011 04:53:54 +0000 Pankaj Sharma 259@http://www.forum.askdba.org/ Hi, I am getting problem while starting the CRS. Below is the necessary details: 1) I am using oracle 11g R2 RAC, with 2 node named RAC1 and RAC2 2) I have 3 diskgroup named DATA, DATA1, DATA2 3) OCR and voting disks are stored on ASM diskgroup On node RAC1, CRS is started and /etc/oracle/ocr.loc is having the below entry: ocrconfig_loc=+DATA ocrmirrorconfig_loc=+DATA1 On node RAC2, CRS is stopped and /etc/oracle/ocr.loc is having the below entry: ocrconfig_loc=+DATA ocrmirrorconfig_loc=+DATA2 Please note the difference in "ocrmirrorconfig_loc". The difference was occured because I updated the OCR location on RAC1 when RAC2 was down. Now I am trying to repair the OCR on the RAC2 using below command. This command must be run as root user when HA service is started but CRS must be stopped. ocrconfig -repair -replace +DAT2 -replacement +DATA1 but this showing error "PROT-21: Invalid parameter", because to run this command diskgroup must be mounted. But diskgroup cannot be mounted until the CRS start. SO this is a conflicting situation. Please suggest how to overcome from this problem ? Please let me know if you required any other details. daniesh on "ora.asm connection is not failing on another node" http://www.forum.askdba.org/topic/oraasm-connection-is-not-failing-on-another-node#post-251 Sun, 25 Sep 2011 18:43:00 +0000 daniesh 251@http://www.forum.askdba.org/ Hi , I have successfully installed oracle 11gR2 on IBX AIX. When i run the crsctl crs res -t command to check the status. I can see that ora.asm process is coming up on either of the node. ora.asm ONLINE ONLINE t24db1 Started ONLINE ONLINE t24db2 I dont know what is the problem if i start the cluster from node 2 then ora.asm service will start on node 2 and vice versa. Everything is running fine. I can connect to asm instance and database. All are up and running fine. Same problem is with my TNS. I am using the below TNS entry to connect to the database. T24PROD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = t24db_scan.cbe.local)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = T24PROD) ) ) The same problem whichever instance will start last. The connection will failover only to that instances.Suppose I last started the instance 2 and i will try to connect remotely.The connection will failover to instance 2. I tried the 20-30 using tns connection it fails to instance 2 or instance 1 whichver is started last. I check the scan and scan listener they are running fine. Do you have any idea on this? Your help is much appreciated in this regards, Awaiting for your response. Thanks and Regards, Daniesh Amit Bansal on "Startup Force DBA" http://www.forum.askdba.org/topic/startup-force-dba#post-247 Wed, 10 Aug 2011 08:22:11 +0000 Amit Bansal 247@http://www.forum.askdba.org/ Came across this option today of starting up database. I was aware that startup force does a shutdown abort and then starts database normally. But if you issue 'startup force dba' , it will restrict access to users with the RESTRICTED SESSION privilege. Docs link - <a href="http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta060.htm" rel="nofollow">http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta060.htm</a> Amit Bansal on "11g Useful Sql" http://www.forum.askdba.org/topic/11g-useful-sql#post-245 Fri, 22 Jul 2011 08:43:05 +0000 Amit Bansal 245@http://www.forum.askdba.org/ In 11g, we can flush a particular sql out of shared pool (also available in 10.2.0.4 by applying patch) select 'exec dbms_shared_pool.purge('''||ADDRESS||','||HASH_VALUE||''',''C'')' from V$SQLAREA where SQL_ID='&sqlid'; In a RAC environment, you optionally specify the INST_ID, shown when querying the GV$SESSION view. This allows you to kill a session on different RAC node. ALTER SYSTEM KILL SESSION 'sid,serial#,@inst_id'; ALTER SYSTEM KILL SESSION 'sid,serial#,@inst_id' immediate; Amit Bansal on "Script to generate oracle add service commands" http://www.forum.askdba.org/topic/script-to-generate-oracle-add-service-commands#post-243 Thu, 14 Jul 2011 07:51:16 +0000 Amit Bansal 243@http://www.forum.askdba.org/ Suppose you have 10g database which you are trying to migrate to 11g. You wish to create a file to generate command for adding services. You can use below script to do same <pre> srvctl config service -d db_name >services.lst cat services.lst|while read ln do echo $ln|sed 's/PREF//'|sed 's/AVAIL//'|awk -F : '{print "-s " $1 "-r" $2 "-a" $3}'|sed 's/ /,/g'|sed 's/-r,/-r/'|sed 's/,-a/ -a/'|sed 's/-a,/ -a / '|sed 's/-s,/ -s / '|sed 's/,-r/ -r / '|sed 's/-a$/ /'|sed 's/^/srvctl add service -d db_name/' done </pre> Thanks to Alok Kumar orabcn on "Disaster recovery scenarios of RAC 11gR2" http://www.forum.askdba.org/topic/disaster-recovery-scenarios-of-rac-11gr2#post-217 Tue, 28 Jun 2011 12:33:30 +0000 orabcn 217@http://www.forum.askdba.org/ Hello, I need your advice about a project I am doing now: I have 7 RAC 11gR2 nodes on Redhat Linux. We are backing up the database (one instance node) using incremental updated backups via RMAN, and then we move the backups to tape. I autobackup the controlfile and spfile with RMAN and my retention window is 60 days. I am also, running md_backup every night to backup ASM metadata. until now everything is ok. But, what happens if I completely loose the 7 nodes RAC? if all the servers are down and completely lost? I am backing up the archive log files also using RMAN. My database is in archivelog mode and block change tracking is enabled also, I am using control file instead of recovery catalogue. And, I am saving the DBID of the instances. And I am backing up the FRA to tape. I have to think about the best, easier solution to restore from tapes and then restore/recover my database (database + ASM) to a dedicated single instance on a separated server located in another data center. could you share your experience and advice the step by step of doing it? thank you ksingh25 on "CRS and ORACLE_HOME wiped out accidentally on node1" http://www.forum.askdba.org/topic/crs-and-oracle_home-wiped-out-accidentally-on-node1#post-215 Mon, 27 Jun 2011 18:20:48 +0000 ksingh25 215@http://www.forum.askdba.org/ Hi there, Just wanted to check with DBA buddies here, on our QA node1 some one deleted most of the executable files from CRS and ORACLE_HOME which brought down CRS and instances. We do have file systems backups running on this node which backs up data to tape. So we were thinking to have our CRS and 3 ORACLE HOMEs restored from full tape backup which happened more than 2 weeks from now. Has anyone faced such issue before where they had to restore CRS and $OH from backup? Do you think we will be able to bring up CRS and instances on node 1 after both these homes are restored and CRS on node 1 should be able to talk to node 2? Thanks Ashish on "Pre Installation Reqrtment" http://www.forum.askdba.org/topic/pre-installation-reqrtment#post-207 Sat, 11 Jun 2011 17:58:09 +0000 Ashish 207@http://www.forum.askdba.org/ kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 # semaphores: semmsl, semmns, semopm, semmni kernel.sem = 250 32000 100 128 fs.file-max = 65536 net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default=262144 net.core.rmem_max=262144 net.core.wmem_default=262144 net.core.wmem_max=262144 oraraj on "package running slowly" http://www.forum.askdba.org/topic/package-running-slowly#post-204 Thu, 09 Jun 2011 05:05:43 +0000 oraraj 204@http://www.forum.askdba.org/ Hi, We have a unix script which calls a package and that in turns loads 2 materialzed views. For the past 2 months the job is exceeding the normal loading time...It was running for 3 to 4 hrs initially and now it is running for 9 to 10 hrs. I am a developer and I want to know what are the measures that I can do from my end in order to first find out what is the reason why it is taking long time. The log does not say anything since this is a package. Thanks daniesh on "RMAN Backup" http://www.forum.askdba.org/topic/rman-backup#post-190 Mon, 20 Dec 2010 13:04:15 +0000 daniesh 190@http://www.forum.askdba.org/ Hi, I am a bit confused. When we take a rman backup.Suppose the rmnan backup is in progress. At the same user is executing any update query and the update query is in progress and he has not committed. What will happen internally in this case like the transaction which is in progress will get backed up or the oracle will wait for the transaction to get committed after that it will backed up the transaction. If the update query ia taking 4-5 hrs to get complete. what will happen is this case. Your views on this is much appreciated. Thanks and Regards, Dan Ajgarcia11 on "Upgrade Oracle Database 10.1 to 11g" http://www.forum.askdba.org/topic/upgrade-oracle-database-101-to-11g#post-203 Thu, 10 Mar 2011 12:27:08 +0000 Ajgarcia11 203@http://www.forum.askdba.org/ A client has some applications developed in. NET running on an Oracle database version 10.1, and want to know the impact is to make the upgrade to version 10.2 and / or 11g. The idea is to get a guideline of things that will not work, or will have to be revised / modified, etc. Now, if the jump is from 10.1 to 11g, there may be an issue because older versions of Oracle worked for Rules (and still holding potential for 10), newer versions now working for Costs (11g only works for costs .) So depending on how the current basis are 10.1 (Rules or costs), the upgrade may be more transparent, or review the queries require that the costs you can change rules by having a big performance problem. faizal on "stop listener but permission is denied" http://www.forum.askdba.org/topic/stop-listener-but-permission-is-denied#post-202 Wed, 09 Mar 2011 08:40:58 +0000 faizal 202@http://www.forum.askdba.org/ Hi , I have created two dbs(many instances) , the first db ive created, i have brought up the listener first.But the second one I have not. The first db I have created can also stop the instance one the 2nd db. Please help where I stumbled. Here is the scenario: [oraisuztxn@scymesstg2 tmp]$ lsnrctl stop LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 09-MAR-2011 16:30:41 Copyright (c) 1991, 2008, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) The command completed successfully [oraisuztxn@scymesstg2 tmp]$ lsnrctl stop LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 09-MAR-2011 16:31:18 Copyright (c) 1991, 2008, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) TNS-01190: The user is not authorized to execute the requested listener command Peter P on "Orcale 11g and Solaris Containers/Zones" http://www.forum.askdba.org/topic/orcale-11g-and-solaris-containerszones#post-198 Tue, 15 Feb 2011 09:38:22 +0000 Peter P 198@http://www.forum.askdba.org/ Hi everyone, We are looking at using Solaris 10 Containers on a Sun M4000 to create a discrete database zone allocating one of the two CPUs to this zone. (The plan is to install Oracle 11g into this zone and deploy the other application components across a number of other Sun boxes.) Has anyone else experience of containers/zones and are there any issues or concerns with these when running an Oracle Database? nazeemodba on "RAC - Oracle Grid Infrastructure configure failed" http://www.forum.askdba.org/topic/rac-oracle-grid-infrastructure-configure-failed#post-199 Tue, 15 Feb 2011 19:57:41 +0000 nazeemodba 199@http://www.forum.askdba.org/ Hi, am trying to install 2 node RAC on Oracle VMs. Before the installation during the -preinst check there were few issues which were resolved (ex user equivalence). After that during the installation process of the Grid it failed at step "Configure Oracle Grid Infrastructure for a cluster". After it failed at this step, subsequent steps too failed which I asked OUI to ignore and then I ran both the post installation scripts. And then ran post crsinst which failed. Pasting below the output of the root.sh script, post crsinst and other checks. ************************************* [root@bsfrac01 grid]# sh root.sh Running Oracle 11g root.sh script... The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/11.2/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Creating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. 2011-02-13 00:11:55: Parsing the host name 2011-02-13 00:11:55: Checking for super user privileges 2011-02-13 00:11:55: User has super user privileges Using configuration parameter file: /u01/app/11.2/grid/crs/install/crsconfig_params Creating trace directory LOCAL ADD MODE Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. root wallet root wallet cert root cert export peer wallet profile reader wallet pa wallet peer wallet keys pa wallet keys peer cert request pa cert request peer cert pa cert peer root cert TP profile reader root cert TP pa root cert TP peer pa cert TP pa peer cert TP profile reader pa cert TP profile reader peer cert TP peer user cert pa user cert Adding daemon to inittab CRS-4123: Oracle High Availability Services has been started. ohasd is starting CRS-2672: Attempting to start 'ora.gipcd' on 'bsfrac01' CRS-2672: Attempting to start 'ora.mdnsd' on 'bsfrac01' CRS-2676: Start of 'ora.mdnsd' on 'bsfrac01' succeeded CRS-2676: Start of 'ora.gipcd' on 'bsfrac01' succeeded CRS-2672: Attempting to start 'ora.gpnpd' on 'bsfrac01' CRS-2676: Start of 'ora.gpnpd' on 'bsfrac01' succeeded CRS-2672: Attempting to start 'ora.cssdmonitor' on 'bsfrac01' CRS-2676: Start of 'ora.cssdmonitor' on 'bsfrac01' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'bsfrac01' CRS-2672: Attempting to start 'ora.diskmon' on 'bsfrac01' CRS-2676: Start of 'ora.diskmon' on 'bsfrac01' succeeded CRS-2676: Start of 'ora.cssd' on 'bsfrac01' succeeded CRS-2672: Attempting to start 'ora.ctssd' on 'bsfrac01' CRS-2676: Start of 'ora.ctssd' on 'bsfrac01' succeeded ASM created and started successfully. DiskGroup DATA1 created successfully. clscfg: -install mode specified Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. CRS-2672: Attempting to start 'ora.crsd' on 'bsfrac01' CRS-2676: Start of 'ora.crsd' on 'bsfrac01' succeeded CRS-4256: Updating the profile Successful addition of voting disk 0ea2052d8a714fd7bf46d9d5c785483e. Successfully replaced voting disk group with +DATA1. CRS-4256: Updating the profile CRS-4266: Voting file(s) successfully replaced ## STATE File Universal Id File Name Disk group -- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------- 1. ONLINE 0ea2052d8a714fd7bf46d9d5c785483e (ORCL:DISK1) [DATA1] Located 1 voting disk(s). Failed to rmtcopy "/tmp/filekRIMbG" to "/u01/app/11.2/grid/gpnp/manifest.txt" for nodes {bsfrac01,bsfrac02}, rc=256 Failed to rmtcopy "/u01/app/11.2/grid/gpnp/bsfrac01/profiles/peer/profile.xml" to "/u01/app/11.2/grid/gpnp/profiles/peer/profile.xml" for nodes {bsfrac01,bsfrac02}, rc=256 rmtcopy aborted Failed to promote local gpnp setup to other cluster nodes CRS-2673: Attempting to stop 'ora.crsd' on 'bsfrac01' CRS-2677: Stop of 'ora.crsd' on 'bsfrac01' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'bsfrac01' CRS-2677: Stop of 'ora.asm' on 'bsfrac01' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'bsfrac01' CRS-2677: Stop of 'ora.ctssd' on 'bsfrac01' succeeded CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'bsfrac01' CRS-2677: Stop of 'ora.cssdmonitor' on 'bsfrac01' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'bsfrac01' CRS-2677: Stop of 'ora.cssd' on 'bsfrac01' succeeded CRS-2673: Attempting to stop 'ora.gpnpd' on 'bsfrac01' CRS-2677: Stop of 'ora.gpnpd' on 'bsfrac01' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'bsfrac01' CRS-2677: Stop of 'ora.gipcd' on 'bsfrac01' succeeded CRS-2673: Attempting to stop 'ora.mdnsd' on 'bsfrac01' CRS-2677: Stop of 'ora.mdnsd' on 'bsfrac01' succeeded Initial cluster configuration failed. See /u01/app/11.2/grid/cfgtoollogs/crsconfig/rootcrs_bsfrac01.log for details [root@bsfrac01 grid]# *************************************** [oracle@bsfrac01 bin]$ ./cluvfy stage -post crsinst -n bsfrac01,bsfrac02 -verbose Performing post-checks for cluster services setup Checking node reachability... Check: Node reachability from node "bsfrac01" Destination Node Reachable? -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- bsfrac01 yes bsfrac02 yes Result: Node reachability check passed from node "bsfrac01" Checking user equivalence... Check: User equivalence for user "oracle" Node Name Comment -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- bsfrac01 passed bsfrac02 passed Result: User equivalence check passed for user "oracle" ERROR: PRKC-1094 : Failed to retrieve the active version of crs: {0} Checking time zone consistency... Time zone consistency check passed. ERROR: PRKC-1093 : Failed to retrieve the version of crs software on node "java.io.IOException: /u01/app/11.2.0/grid/bin/crsctl: not found " : {1} ERROR: Cluster manager integrity check failed PRVF-5434 : Cannot identify the current CRS software version UDev attributes check for OCR locations started... Result: UDev attributes check passed for OCR locations UDev attributes check for Voting Disk locations started... ERROR: PRVF-5197 : Failed to retrieve voting disk locationsPRKC-1092 : Failed to retrieve the location of votedisks: java.io.IOException: /u01/app/11.2.0/grid/bin/crsctl: not found Result: UDev attributes check failed for Voting Disk locations Check default user file creation mask Node Name Available Required Comment -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- bsfrac01 0022 0022 passed bsfrac02 0022 0022 passed Result: Default user file creation mask check passed Checking cluster integrity... Node Name -------------------------------------------------------------------------------- bsfrac01 Cluster integrity check failed This check did not run on the following node(s): bsfrac02 Checking OCR integrity... Checking the absence of a non-clustered configuration... All nodes free of non-clustered, local-only configurations ERROR: PRKC-1094 : Failed to retrieve the active version of crs: {0} ERROR: PRVF-5300 : Failed to retrieve active version for CRS on this node OCR integrity check failed Checking CRS integrity... ERROR: PRKC-1094 : Failed to retrieve the active version of crs: {0} ERROR: PRVF-5300 : Failed to retrieve active version for CRS on this node CRS integrity check failed OCR detected on ASM. Running ACFS Integrity checks... Starting check to see if ASM is running on all cluster nodes... PRVF-5137 : Failure while checking ASM status on node "bsfrac01" PRVF-5137 : Failure while checking ASM status on node "bsfrac02" Starting Disk Groups check to see if at least one Disk Group configured... PRVF-5112 : An Exception occurred while checking for Disk Groups PRVF-5114 : Disk Group check failed. No Disk Groups configured Task ACFS Integrity check failed Checking Oracle Cluster Voting Disk configuration... ERROR: PRKC-1093 : Failed to retrieve the version of crs software on node "java.io.IOException: /u01/app/11.2.0/grid/bin/crsctl: not found " : {1} ERROR: PRVF-5434 : Cannot identify the current CRS software version PRVF-5431 : Oracle Cluster Voting Disk configuration check failed Checking to make sure user "oracle" is not in "root" group Node Name Status Comment -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- bsfrac01 does not exist passed bsfrac02 does not exist passed Result: User "oracle" is not part of "root" group. Check passed Post-check for cluster services setup was unsuccessful on all the nodes. ******************* [oracle@bsfrac01 bin]$ /u01/app/11.2/grid/bin/ocrcheck Status of Oracle Cluster Registry is as follows : Version : 3 Total space (kbytes) : 262120 Used space (kbytes) : 408 Available space (kbytes) : 261712 ID : 1671840043 Device/File Name : +DATA1 Device/File integrity check succeeded Device/File not configured Device/File not configured Device/File not configured Device/File not configured Cluster registry integrity check succeeded Logical corruption check bypassed due to non-privileged user ******************************* ASM looks to be up and running.. [oracle@bsfrac01 bin]$ /usr/sbin/oracleasm listdisks DISK1 DISK2 DISK3 DISK4 DISK5 DISK6 [oracle@bsfrac01 bin]$ /usr/sbin/oracleasm status Checking if ASM is loaded: yes Checking if /dev/oracleasm is mounted: yes ****************************** Please help. daniesh on "master node configuration on surviving nodes" http://www.forum.askdba.org/topic/master-node-configuration-on-surviving-nodes#post-194 Wed, 02 Feb 2011 09:14:51 +0000 daniesh 194@http://www.forum.askdba.org/ Hi Which node will become master if the master node goes down? In the 4 node rac environment if node 1 is the master and node1 goes down. From the 3 surviving nodes which nodes will become master. Your help is much appreciated. Thanks daniesh on "register standby database in recovery catalog." http://www.forum.askdba.org/topic/register-standby-database-in-recovery-catalog#post-184 Thu, 07 Oct 2010 17:27:36 +0000 daniesh 184@http://www.forum.askdba.org/ Hi, Can we register the standby database in recovery catalog. I know that if the catalog database is same for both the standby and primary then both will have same dbid and we can use unique dbid. However in our case, Catalog is different for primary and standby whenever i try to register the standby database. I am getting the below error. RMAN> register database; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of register command at 10/07/2010 18:26:04 RMAN-08040: full resync skipped, control file is not current or backup Can you please let me know your view on this? Thanks in advance. taraldesai on "ASM DiskGroup" http://www.forum.askdba.org/topic/asm-diskgroup#post-179 Sun, 29 Aug 2010 18:52:22 +0000 taraldesai 179@http://www.forum.askdba.org/ Hi Amit/Saurabh, I have question regarding adding diskgroup. Let's say if we add any diskgroup with normal redundancy without using failgroup it will create diskgroup. So, how redundancy is maintained. Where would it write block image on same disk. Amit Bansal on "Checking Listener log in 11g" http://www.forum.askdba.org/topic/checking-listener-log-in-11g#post-173 Thu, 12 Aug 2010 12:51:29 +0000 Amit Bansal 173@http://www.forum.askdba.org/ Starting Oracle 11g, architecture for trace file and log files have changed. Alert.log and listener.log files are now XML based. To check listener log in 11g, following steps need to be done $adrci adrci> show homes ADR Homes: diag/tnslsnr/orcl11/listener adrci> set home diag/tnslsnr/orcl11/listener adrci> show tracefile diag/tnslsnr/orcl11/listener/trace/listener.log adrci> show trace listener.log Anonymous on "tns issue / sqlnet issue" http://www.forum.askdba.org/topic/tns-issue-sqlnet-issue#post-169 Mon, 09 Aug 2010 19:20:59 +0000 Anonymous 169@http://www.forum.askdba.org/ In 11gR2 RAC, the alert log keeps showing the below errors, the ticket has opened to Oracle support for 1 week. No any progress. Thanks in advance. ---------------------------------------------------------- Fatal NI connect error 12533, connecting to: (DESCRIPTION=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rss-db205-vip.mtnk)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=RSSDB)(INSTANCE_NAME=RSSDB1)(CID=(PROGRAM=oracle)(HOST=rss-db205.mtnk)(USER=oracle)))) VERSION INFORMATION: TNS for Linux: Version 11.2.0.1.0 - Production Time: 09-AUG-2010 18:55:19 Tracing not turned on. Tns error struct: ns main err code: 12533 TNS-12533: TNS:illegal ADDRESS parameters ns secondary err code: 12560 nt main err code: 503 TNS-00503: Illegal ADDRESS parameters nt secondary err code: 0 nt OS err code: 0 Amit Bansal on "Monitoring archive generation for every hour" http://www.forum.askdba.org/topic/monitoring-archive-generation-for-every-hour#post-170 Tue, 10 Aug 2010 07:13:38 +0000 Amit Bansal 170@http://www.forum.askdba.org/ You can use following query for monitoring archive generation on hourly basis <pre> set linesize 140 set feedback off set timing off set pagesize 1000 col ARCHIVED format a8 col ins format 99 heading "DB" col member format a80 col status format a12 col archive_date format a20 col member format a60 col type format a10 col group# format 99999999 col min_archive_interval format a20 col max_archive_interval format a20 col h00 heading "H00" format a3 col h01 heading "H01" format a3 col h02 heading "H02" format a3 col h03 heading "H03" format a3 col h04 heading "H04" format a3 col h05 heading "H05" format a3 col h06 heading "H06" format a3 col h07 heading "H07" format a3 col h08 heading "H08" format a3 col h09 heading "H09" format a3 col h10 heading "H10" format a3 col h11 heading "H11" format a3 col h12 heading "H12" format a3 col h13 heading "H13" format a3 col h14 heading "H14" format a3 col h15 heading "H15" format a3 col h16 heading "H16" format a3 col h17 heading "H17" format a3 col h18 heading "H18" format a3 col h19 heading "H19" format a3 col h20 heading "H20" format a3 col h21 heading "H21" format a3 col h22 heading "H22" format a3 col h23 heading "H23" format a3 col total format a6 col date format a10 -- select * from v$logfile order by group#; -- select * from v$log order by SEQUENCE#; select max( sequence#) last_sequence, max(completion_time) completion_time, max(block_size) block_size from v$archived_log ; SELECT instance ins, log_date "DATE" , lpad(to_char(NVL( COUNT( * ) , 0 )),6,' ') Total, lpad(to_char(NVL( SUM( decode( log_hour , '00' , 1 ) ) , 0 )),3,' ') h00 , lpad(to_char(NVL( SUM( decode( log_hour , '01' , 1 ) ) , 0 )),3,' ') h01 , lpad(to_char(NVL( SUM( decode( log_hour , '02' , 1 ) ) , 0 )),3,' ') h02 , lpad(to_char(NVL( SUM( decode( log_hour , '03' , 1 ) ) , 0 )),3,' ') h03 , lpad(to_char(NVL( SUM( decode( log_hour , '04' , 1 ) ) , 0 )),3,' ') h04 , lpad(to_char(NVL( SUM( decode( log_hour , '05' , 1 ) ) , 0 )),3,' ') h05 , lpad(to_char(NVL( SUM( decode( log_hour , '06' , 1 ) ) , 0 )),3,' ') h06 , lpad(to_char(NVL( SUM( decode( log_hour , '07' , 1 ) ) , 0 )),3,' ') h07 , lpad(to_char(NVL( SUM( decode( log_hour , '08' , 1 ) ) , 0 )),3,' ') h08 , lpad(to_char(NVL( SUM( decode( log_hour , '09' , 1 ) ) , 0 )),3,' ') h09 , lpad(to_char(NVL( SUM( decode( log_hour , '10' , 1 ) ) , 0 )),3,' ') h10 , lpad(to_char(NVL( SUM( decode( log_hour , '11' , 1 ) ) , 0 )),3,' ') h11 , lpad(to_char(NVL( SUM( decode( log_hour , '12' , 1 ) ) , 0 )),3,' ') h12 , lpad(to_char(NVL( SUM( decode( log_hour , '13' , 1 ) ) , 0 )),3,' ') h13 , lpad(to_char(NVL( SUM( decode( log_hour , '14' , 1 ) ) , 0 )),3,' ') h14 , lpad(to_char(NVL( SUM( decode( log_hour , '15' , 1 ) ) , 0 )),3,' ') h15 , lpad(to_char(NVL( SUM( decode( log_hour , '16' , 1 ) ) , 0 )),3,' ') h16 , lpad(to_char(NVL( SUM( decode( log_hour , '17' , 1 ) ) , 0 )),3,' ') h17 , lpad(to_char(NVL( SUM( decode( log_hour , '18' , 1 ) ) , 0 )),3,' ') h18 , lpad(to_char(NVL( SUM( decode( log_hour , '19' , 1 ) ) , 0 )),3,' ') h19 , lpad(to_char(NVL( SUM( decode( log_hour , '20' , 1 ) ) , 0 )),3,' ') h20 , lpad(to_char(NVL( SUM( decode( log_hour , '21' , 1 ) ) , 0 )),3,' ') h21 , lpad(to_char(NVL( SUM( decode( log_hour , '22' , 1 ) ) , 0 )),3,' ') h22 , lpad(to_char(NVL( SUM( decode( log_hour , '23' , 1 ) ) , 0 )),3,' ') h23 FROM ( SELECT thread# INSTANCE , TO_CHAR( first_time , 'DD-MON-YY' ) log_date , TO_CHAR( first_time , 'hh24' ) log_hour FROM v$log_history ) GROUP BY INSTANCE , log_date ORDER BY INSTANCE , to_date(log_date,'DD-MON-YY'); </pre> 11g introduces PIVOT function which lets you write cross-tabulation queries that rotate rows into columns, aggregating data in the process of the rotation. For 11g it can be re-written as <pre> col 00 heading "00" format 999 col 01 heading "01" format 999 col 02 heading "02" format 999 col 03 heading "03" format 999 col 04 heading "04" format 999 col 05 heading "05" format 999 col 06 heading "06" format 999 col 07 heading "07" format 999 col 08 heading "08" format 999 col 09 heading "09" format 999 col 10 heading "10" format 999 col 11 heading "11" format 999 col 12 heading "12" format 999 col 13 heading "13" format 999 col 14 heading "14" format 999 col 15 heading "15" format 999 col 16 heading "16" format 999 col 17 heading "17" format 999 col 18 heading "18" format 999 col 19 heading "19" format 999 col 20 heading "20" format 999 col 21 heading "21" format 999 col 22 heading "22" format 999 col 23 heading "23" format 999 select * from ( SELECT thread# INSTANCE , TO_CHAR( first_time , 'DD-MON-YY' ) log_date , TO_CHAR( first_time , 'hh24' ) log_hour ,count(*) num_arch FROM v$log_history where first_time >sysdate -7 group by thread# ,TO_CHAR( first_time , 'DD-MON-YY' ),TO_CHAR( first_time , 'hh24' ) ) pivot (sum (num_arch) for log_hour in (00,01,02,03,04,05,06,07,08,09,10,11,12,13,14,15,16,17,18,19,20,21,22,23)) order by log_date,instance; </pre> Amit Bansal on "NO SPAM Entertained on this forum" http://www.forum.askdba.org/topic/no-spam-entertained-on-this-forum#post-167 Tue, 29 Jun 2010 12:58:47 +0000 Amit Bansal 167@http://www.forum.askdba.org/ Hi All, For past few days, I am observing spam ( some exams site) posting content on the forum. Tried deleting the content for 2-3 times so that concerned person desist from doing again but I have today finally deleted the user. Any kind of spam will not be entertained on this forum. Regards Amit bhatia.ish@gmail.com on "What are the pre-requisites of ASM on AIX 6.1?" http://www.forum.askdba.org/topic/what-are-the-pre-requisites-of-asm-on-aix-61#post-164 Tue, 22 Jun 2010 11:29:28 +0000 bhatia.ish@gmail.com 164@http://www.forum.askdba.org/ Hi, What are the pre-requisites of ASM on AIX 6.1? Regards, Bhatia bhagirathipatra on "how to connect 11gR2 RAC db using sql" http://www.forum.askdba.org/topic/how-to-connect-11gr2-rac-db-using-sql#post-141 Sat, 20 Mar 2010 03:17:15 +0000 bhagirathipatra 141@http://www.forum.askdba.org/ Hi, Our product support 11gR2 DB or higher.in my installation of the product my product installer need DB configuration parameter. i have a 11gR2 RAC setup. when my prod ask for db, i choose the RAC config and next screen it ask “provide RAC db in host1:port1:sid1,host2:port2:sid2″. Is it the right behavior of the installer or it should ask the SCAN parameter ? plz suggest daniesh on "PKRS-1009 failed to start ASM instance" http://www.forum.askdba.org/topic/pkrs-1009-failed-to-start-asm-instance#post-97 Mon, 12 Oct 2009 06:01:09 +0000 daniesh 97@http://www.forum.askdba.org/ Hi , I have installed RAC on AS-4 platform. cluster and database s/w is installed successfully however when i try to install ASM i am getting an following error. PKRS-1009 : failed to start ASM instance. CRS-1005: failed to get required resources. CRS:0223: node 1 has placement erro. could you please help me on this? Thanks, dinilocp on "ORA-16055" http://www.forum.askdba.org/topic/ora-16055#post-86 Fri, 11 Sep 2009 07:18:15 +0000 dinilocp 86@http://www.forum.askdba.org/ how can we solve this error: regularly comes in alertlog file of primary database: ora-19502 write error on file"",blockno(blocksize=) ora-16055: FAL REQUEST REJECT Arch: FAL Archive Failed,Archiver continuing. Database : 10g RAC with two nodes. egotah on "Datapump dumpfile with dates" http://www.forum.askdba.org/topic/datapump-dumpfile-with-dates#post-148 Thu, 13 May 2010 20:05:34 +0000 egotah 148@http://www.forum.askdba.org/ Can some one direct me how to generate Datapump Export Dump with Dumpfile name Containing Current Date and Time. I tried this format with error.. dumpfile=myexport-<code>date '+%d%m%Y_%H%M%S'</code>.dmp logfile=myexport-<code>date '+%d%m%Y_%H%M%S'</code>.log rbaclagan on "Oracle RAC OVM image" http://www.forum.askdba.org/topic/oracle-rac-ovm-image#post-146 Mon, 29 Mar 2010 21:47:41 +0000 rbaclagan 146@http://www.forum.askdba.org/ Does anyone know if it is possible to take a snapshot of an existing RAC environment running on OVM and redeploy this as a new RAC cluster with minor tweaks such as ip addresses, OCR, Vote disks, etc?