Home > Administration with ASM, ASM, ORA-XXX > ORA-19504: failed to create file “+VOPDATA”

ORA-19504: failed to create file “+VOPDATA”

September 5, 2013 Leave a comment Go to comments

Today, when I created a new database in silent mode, it failed and showed the messages below from ./dbca/voppro/voppro.log file

Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 3%
DBCA_PROGRESS : 9%
DBCA_PROGRESS : 15%
ORA-19624: operation failed, retry possible
ORA-19870: error while restoring backup piece /opt/oracle/product/11.2/db_2/assistants/dbca/templates/Seed_Database.dfb
ORA-19504: failed to create file “+VOPDATA”
ORA-15045: ASM file name ‘+VOPDATA’ is not in reference form
ORA-17502: ksfdcre:5 Failed to create file +VOPDATA
ORA-15081: failed to submit an I/O operation to a disk
ORA-06512: at “SYS.X$DBMS_BACKUP_RESTORE”, line 5827
ORA-06512: at line 20

DBCA_PROGRESS : 21%
DBCA_PROGRESS : 30%
Creating and starting Oracle instance
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file ‘+VOPDATA/voppro/system01.dbf’
ORA-17503: ksfdopn:2 Failed to open file +VOPDATA/voppro/system01.dbf
ORA-15173: entry ‘voppro’ does not exist in directory ‘/’

ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file ‘+VOPDATA/voppro/system01.dbf’
ORA-17503: ksfdopn:2 Failed to open file +VOPDATA/voppro/system01.dbf
ORA-15173: entry ‘voppro’ does not exist in directory ‘/’

DBCA_PROGRESS : 100%

Cause

After checking, there was no permission on raw disks for oracle account to access  (For my case, the raw disks are /dev/rdsk/emcpower*)

Fix

1. Login all nodes as root

2. Change permission on all /dev/rdsk/emcpower* to 775

# cd /dev/rdsk

# chmod 775 emcpower*

 

 

 

 

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: