RAC & Failsafe :: ORA-15080 / Synchronous I / O Operation To A Disk Failed
Aug 1, 2013
I am getting below errors on one of the node of my RAC server while starting the database. how to get the rsolution.
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
Solaris-AMD64 Error: 5: I/O error
Additional information: 4
Additional information: 331776
Additional information: -1
Thu Aug 1 22:29:42 2013
Errors in file /software/oracle/admin/dixie/udump/dixie1_ora_23644.trc:
ORA-00202: control file: '+DGDIXIE/dixie/controlfile/current.265.647198019'
[code].....
View 4 Replies
ADVERTISEMENT
Aug 21, 2012
I am getting the below exception when i access the WebPage.This only happens sometimes, so if i try again to hit the URL, it works. Not getting why this is behaving unusual.
StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception
(wt.fc.fcResource/0) wt.util.WTException: The operation: "getPrincipal" failed.
Nested exception is: wt.util.WTRemoteException: Unable to invoke remote method; nested exception is:
java.lang.OutOfMemoryError
View 1 Replies
View Related
May 3, 2011
My Login is System
Already created Directory MY_DIR in c:mydir
Showing Following error
1 DECLARE
2 src_lob BFILE := BFILENAME('MY_DIR','C:
mi2Blue.jpg');
3 dest_lob BLOB;
4 BEGIN
5 INSERT INTO lob_table VALUES(2, EMPTY_BLOB())
6 RETURNING doc INTO dest_lob;
[code].....
View 21 Replies
View Related
Dec 10, 2012
I have a DB on my local machine and it was working fine till yesterday.Today suddenly I started receiving error "IO Error : The Network Adapter Could not establish the connection".
1) My first question is that is there some log entry corresponding to this failed connection attempt in listener.log or alert.log ? If yes, how to identify it ?
2) My second question is : What to deduct from listener logs pasted below?I know about "service_update" messages, but what about others (having CONNECT_DATA in them) ? Also, what is "WARNING: Subscription for node down event still pending" in below logs ?
......
10-DEC-2012 12:48:18 * (CONNECT_DATA=(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=B_ADMIN))(SERVER=dedicated)(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=58460)) * establish * orcl * 0
10-DEC-2012 12:48:20 * service_update * orcl * 0
10-DEC-2012 12:51:35 * (CONNECT_DATA=(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=B_ADMIN))
[code]...
View 4 Replies
View Related
Dec 23, 2012
I have DB on cluster and it set to active/active. ASM disk currently using raw device and connect to SAN storage. So i want to add new ASM disk on current environment.
Does oracle have this doc? What i can see from their said just show adding new ASM to new installation. Does it same as adding new ASM disk to current system? Does it success on implementation?
View 1 Replies
View Related
Apr 18, 2011
in the following program i am submitting a request and sending concurrent program log file (.REQ file)as an attachment but getting following error
ORACLE error 29277 in FDPSTP
Cause: FDPSTP failed due to ORA-29277: invalid SMTP operation
ORA-06512: at "SYS.UTL_SMTP", line 44
ORA-06512: at "SYS.UTL_SMTP", line 150
ORA-06512: at "SYS.UTL_SMTP", line 383
ORA-06512: at "SYS.UTL_SMTP", line 399
[code]....
View 3 Replies
View Related
Jul 13, 2012
We are about to undertake a storage migration of our RAC environment from EMC to XIV storage.
The migration method we are using means that we will be presented with identical disks post the migration, however the UNIX paths to the disk devices will be changing. Using our migration method it is not possible to present the old and new devices at the same time.
Therefore once the migration is complete i need to update the device configuration to reflect the new paths. I believe this is done using the following techniques but I am unsure as some of the documentation is ambiguous and I have not done this before
Changing path to Voting Disks
crsctl add css votedisk <new_path_to_disk> -force
crsctl delete css votedisk <old_path_to_disk> -force
Changing path to OCR Disks
ocrconfig repair ocr <new_path_to_ocr>
ocrconfig repair ocrmirror <new_path_to_ocrmirror>
Changing paths to ASM disks
alter system set asm_diskstring='<new_device_path>' scope=both;
View 3 Replies
View Related
Jun 19, 2013
SQL*Plus: Release 11.2.0.3.0Solaris 10 SPARC I get the following error when trying to make an HTTP request. Below is the snippet of code I run. I get the error after exactly 60 seconds(default timeout?). The problem does not exist in the rest of our environments, only our test environment.
DECLARE
p_mid_tier VARCHAR2 (500);
responsestr VARCHAR2 (500);
BEGIN
[code]...
View 3 Replies
View Related
Nov 4, 2011
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 ?
View 6 Replies
View Related
Oct 25, 2012
I am using 11.2.0.1.0 on RHEL 5.4ASM is properly working on my machine. database is running from ASM. I want to configure additional oracleasm devices.command fails saying:
$ oracleasm createdisk ASMDISK08 /dev/xvd8
Writing disk header: done
Instantiating disk: failed
Clearing disk header: done
I am creating asm diskgroup on loopback devicesHere are the configured loopback devices.
[root@host1 ~]# ls -l /dev/loop[1-9]
brw-rw-rw- 1 oracle oinstall 7, 1 Oct 25 14:42 /dev/loop1
brw-rw-rw- 1 oracle oinstall 7, 2 Oct 25 14:42 /dev/loop2
brw-rw-rw- 1 oracle oinstall 7, 3 Oct 25 14:42 /dev/loop3
brw-rw-rw- 1 oracle oinstall 7, 4 Oct 25 14:42 /dev/loop4
[code]...
I am unable to understand where is the problem.
View 11 Replies
View Related
Mar 27, 2013
My cluster have two node.Data diskgroup uses normal redundancy.Priamry disks are located in one storage.Fail group disks are located in another storage.When we close the failgroup disks' storage the 2nd instance restart.After automatically restarted everything goes well.I want to know why does the 2nd instance restart?Is it normal?
View 2 Replies
View Related
Mar 4, 2011
I am installing 11gr2 11.2.0.2 grid infrastructure software. while running root.sh on node1 it got failed.
Start of resource "ora.crsd" failed
CRS-2672: Attempting to start 'ora.crsd' on 'rac1'
CRS-5017: The resource action "ora.crsd start" encountered the following error:
Start action for daemon aborted
CRS-2674: Start of 'ora.crsd' on 'rac1' failed
CRS-2679: Attempting to clean 'ora.crsd' on 'rac1'
CRS-2681: Clean of 'ora.crsd' on 'rac1' succeeded
CRS-4000: Command Start failed, or completed with errors.
Clusterware exclusive mode start of Clusterware Ready Services failed at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 6475.
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl execution failed
View 2 Replies
View Related
Sep 28, 2011
What could be the reason for Such Errors.?OCR Integrity was Successful on one node and on the cloned node it was failed.
View 8 Replies
View Related
Jun 21, 2012
I have installad oracle 10g RAC on centos properly and it was running properly few days before.
But today when I am trying to start oracle RAC services. it is showing error. and VIP service is not starting.
[root@rac1 racg]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....C1.inst application ONLINE OFFLINE
ora....C2.inst application ONLINE OFFLINE
ora.RAC.db application ONLINE UNKNOWN rac1
ora....SM1.asm application ONLINE UNKNOWN rac1
[code].....
After google this I found an error in vip log file which is as follows
2012-06-21 13:16:36.720: [ RACG][3067987648] [5015][3067987648][ora.rac2.vip]: clsrcexecut: env ORACLE_CONFIG_HOME=/u01/app/crs/product/10.2.0/crs
2012-06-21 13:16:36.720: [ RACG][3067987648] [5015][3067987648][ora.rac2.vip]: clsrcexecut: cmd = /u01/app/crs/product/10.2.0/crs/bin/racgeut -e _USR_ORA_DEBUG=0 54 /u01/app/crs/product/10.2.0/crs/bin/racgvip start rac2
2012-06-21 13:16:36.720: [ RACG][3067987648] [5015][3067987648][ora.rac2.vip]: clsrcexecut: rc = 1, time = 5.910s
[code].....
View 4 Replies
View Related
Feb 15, 2011
i 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
[code]....
View 1 Replies
View Related
Jun 20, 2011
Every time interconnect IP ping failed between RAC servers,CRS causing reboot to the server. As documented,it is of 3 sec. Can we alter this setting to increase the ping failed (private IP) by more than 3secs.
View 4 Replies
View Related
Sep 18, 2008
The installation of CRS is successfull & at end it ask to execute 2 scripts on both nodes i.e. orainstRoot.sh and root.sh
When the scripts are executed,the execution of orainstRoot.sh is successfull , but root.sh give following error:
[root@rac2host crs]# ./root.sh
WARNING: directory '/home/oracle/product' is not owned by root
WARNING: directory 'home/oracle' is not owned by root
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.
[code]....
Is this concerned with permissions on OCR, Voting Disk.
the ./cluvy shows the cluster is valid.
View 1 Replies
View Related
Nov 19, 2011
RAC installation on vmware is failing with following errors. I followed below link for installation. URL..... Found the following errors:
[root@rac2 ~]# cd /crs/oracle/bin/
[root@rac2 bin]# ./vipca
PRKR-1062 : Failed to find configuration for node rac1
PRKR-1062 : Failed to find configuration for node rac1
[code]....
The "/crs/oracle/cfgtoollogs/configToolFailedCommands" script contains all commands that failed, were skipped or were cancelled. This file may be used to run these configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.The "/crs/ oracle/cfgtoollogs/configToolAllCommands" script contains all commands to be executed by the configuration assistants. This file may be used to run the configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.
[root@rac2 bin]# /crs/oracle/bin/racgons add_config rac1.localdomain:6200 rac2.localdomain:6200
[root@rac2 bin]# /crs/oracle/bin/oifcfg setif -global eth0/192.168.2.0:public eth1/192.168.0.0:cluster_interconnect
PRIF-10: failed to initialize the cluster registry
[root@rac2 bin]# /crs/oracle/bin/oifcfg setif -global eth0/192.168.2.0:public eth1/192.168.0.0:cluster_interconnect
PRIF-10: failed to initialize the cluster registry
View 8 Replies
View Related
Aug 26, 2010
We have a Production Oracle 10g R2 RAC on HP-UX v2 IA64 servers.We have Two Disk Groups one for Archive (ARC_DISK - 100 GB) and other for Database(DATA_DISK - 1 TB]. We wanted to add more space to the DATA_DISK disk group.Unix admin configured 200 GB from SAN and changed the ownership of the Disk to oracle and permissions to 775 on 1st Node.I opended DBCA from 1st Node and was able to see the disk in 'Show Candidate'.
I added this disk to the DATA_DISK disk group and clicked OK but got ORA- error with some message like some operations could not be performed. I exited DBCA.We realized that we had forgotten to change the ownerhip and permission from the 2nd Node.Unix admin changed the ownership of the Disk to oracle and permissions to 775 on the 2nd Node.
I opened DBCA again from 1st Node and selected the DATA_DISK disk group but could not find the Disk in 'Show Candiate' open. I clicked on 'Show All' and this disk was shown with Header_Status - MEMBER but not allocated to DATA_DISKGROUP. When I clicked the 'Show Member' option, this disk is not shown for DATA_DISK disk group. I exited DBCA at this point.As this is a critcal Production database I didnt proceed any further and exited DBCA.
Now I need to add this Disk to the DATA_DISK disk group but not sure which option to select. I got one reply from another forum to run DBCA select the DATA_DISK Disk Group and then click 'Show All' and select this Disk (which already has MEMBER as Header Status) and select Force Option and click OK to continue.
View 4 Replies
View Related
Jan 16, 2013
I Configured an ASM instance and a disk group with two disk for normal redundancy.
> Here .. each disk is 2gb
The disk group has two disks...
SQL> select group_number, name, type, total_mb, free_mb
2 from v$asm_diskgroup;
GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ ------------------------------ ------ ---------- ----------
1 DATA NORMAL 4000 3898
as the group has two way mirroring (Normal redundancy) How much data (2 GB or 4 GB) can i keep in the disk group? My conception is I can keep 2 GB data in the disk group... (as the disk group keeps every extent in another disk as mirror)
View 3 Replies
View Related
Feb 17, 2011
I have 2 servers both having windows server 2008 64 bit as operating system installed on both I need to install oracle clusterware 11g r1 on both servers with clustering on external storage. I have configured the network(private,public and virtual) for both servers and have started the installation.
In the installation of oracle I add both servers but then I reach to a point where they ask me for voting disk or ocr disk in the cluster configuration storage but no disk is present how can i create ocr disk or voting disk on windows server 2008? And the external storage should I buy a special type of storage that supports clustering to continue my work?
View 2 Replies
View Related
May 9, 2011
Is there any way to add one disk group space to another disk group. Because One of my disk group is full i want to add space in to that group.
View 1 Replies
View Related
Sep 8, 2011
run down of the implications of MERGE by ROWID in such a fashion:
CODE MERGE
INTO XXWT_AP_ACCRUALS_RECEIPT_F EXT
USING (
SELECT PO_DISTRIBUTION_ID,
[code]...
Can this lead to an "Unstable Set of Rows?". Is it possible for the ROWID's to change during the execution of this statement - meaning certain ROWIDs identified in the SELECT will not actually be updated when it comes to the MERGE operation?
Basically, is it sound practice to use ROWID to merge on - in cases where you dont have a WHEN NOT MATCHED condition?
View 8 Replies
View Related
Jun 12, 2013
I am using the dblink to merge the data. I am using the following merge statement.
merge into APP_USER.USR_NEW_RIGHTS@NEW_RIGHTS t
Using (select 'test' GRANTEE,'TESTxxx'ROLE from dual ) s
on (t.GRANTEE = s.GRANTEE and t.ROLE = s.ROLE)
when not matched then
insert (ID,GRANTEE,ROLE,XRIGHT,COMPANY,OWNER,TABLENAME)
values ('','test','TESTxxx',null, null, null, null);
I know that I have to set a commit and it's working when I insert information's with a normal insert statement via database link, but it seems that merging doesn't work.
View 1 Replies
View Related
Apr 29, 2010
What are all the DML operation can be done in DUAL table.?
View 5 Replies
View Related
Jun 12, 2013
I have a source view where I have some invalid records and those should be found based on codes present in another table.
For eg. from source the records come like
****************SIINNSFDFD****FDFDF2******8
**********TABLE****************FDFSFSSFASFAS********
and if my reference table has values
SIINNSFDFD
TABLE
then these values are present as substring in the particular column in the source view. So I need to flag those records. For every record, I need to check whether all the values present in the reference table matches or not. If it matches then it should be flagged.
I can use in operator as we are not checking for the exact match and we are checking whether that value is present anywhere in that column record.
Looping results in performance issue. We can use PL/SQL for this. As the source view is put into a ETL internal file.
View 2 Replies
View Related
May 5, 2010
i have created an file in my local system (sys name : System1). i have created a directory as below
SQL>CREATE DIRECTORY test_dir AS '\System1TEMP';
I gave rights as
SQL>GRANT ALL ON DIRECTORY TEST_DIR TO PUBLIC;
DECLARE
fileHandler UTL_FILE.FILE_TYPE;
BEGIN
IF utl_file.is_open(fileHandler) THEN
utl_file.fclose_all;
END IF;
[code]......
but while executing the above procedure, Invalid File Operation error occurs.
View 10 Replies
View Related
Dec 2, 2011
I want to create one sql script with the followings-
1.Show the values before the operation is performed
2.Display the values after the operation is performed.
How it can be done in a proper sql script format.
View 10 Replies
View Related
Apr 26, 2013
Frequently getting below error in alert log file. to sort out this issue.
Database: Active standby database
OS: Windows Server
Db Version: 11.2.0.2
Error:
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
[code]...
View 1 Replies
View Related
Jul 25, 2012
I have a car table with the following attribute sale_code,model_car etc. the format of sale_code is year/number example when a client buy a car(model_car=mercedes) her code is 2012/0125.
I want to calculate the number of cars that were sold in the year of 2011 grouped by the model_car attribute.
select count (sale_code),model_car
from car
where sale_code like '2011%'
when I tested this query i received an error.
My question is :
how to resolve the issue when we use an attribute in where and we use the same attribute in count operation ?
View 9 Replies
View Related
