Shulou(Shulou.com)06/02 Report--

Today, colleagues in other provinces said that the disk of the database server was full, so I asked me to take a look at it. I went into the server and put all the data files in the oracle directory. 25 pieces of storage have not been used yet, and they have done RAC. Another server has not been used since 2012, so it has been used as a stand-alone machine.

I started to create a DATA group, then COPY to ASM, went to oracle instance and modified the path. Alter database open reported the following error.

First of all, I alter all the paths back, and the alter database open is normal.

1 Test to create a tablespace on ASM disk

Create tablespace test datafile'+ DATA/evsoft/datafile/test.dbf' size 10m*ERROR at line 1:ORA-01119: error in creating database file'+ DATA/evsoft/datafile/test.dbf'ORA-15012: ASM file 'evsoft/datafile/test.dbf' does not existORA-17502: ksfdcre:5 Failed to create file + DATA/evsoft/datafile/test.dbfORA-15081: failed to submit an Imax O operation to a disk

Also reported an error. First of all, I wonder if oracle is not different from the asm instance.

It may be that the ASM is not recognized, just enter a disk group at random. The results indicate that the disk group does not exist. Then ASM should be normal. SQL > create tablespace test datafile'+ AA/evsoft/datafile/test.dbf' size 10m Create tablespace test datafile'+ AA/evsoft/datafile/test.dbf' size 10m*ERROR at line 1:ORA-01119: error in creating database file'+ AA/evsoft/datafile/test.dbf'ORA-17502: ksfdcre:4 Failed to create file + AA/evsoft/datafile/test.dbfORA-15001: diskgroup "AA" does not exist or is not mountedORA-15001: diskgroup "AA" does not exist or is not mounted found relevant articles on the Internet and said that disk permissions were not enough, but there was no permission to view them in the DEV directory. Modify and solve [root@sjbbdb2 dev] # chmod 775 sddlmab [root@sjbbdb2 dev] # chmod 775 sddlmac [root@sjbbdb2 dev] # chmod 775 sddlmad [root@sjbbdb2 dev] # chmod 775 sddlmae [root@sjbbdb2 dev] # chmod 775 sddlmaf

It's finally done.

Finally, before it is found that the permissions to restart the server will be automatically restored, before

/ etc/rc.d/rc.local file add command, run automatically at startup

Chmod 775 / dev/sddlmaachmod 775 / dev/sddlmab..

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.