Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [oracle-asm]

Oracle ASM is a storage management solution for Oracle databases and clusters providing volume management and a filesystem,

22 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5 votes
1 answer
827 views

Oracle ASM vs RAID 10

I have oracle ASM 11gR2 on oracle linux 5.8 and i want to install oracle database. I have some disks and i want to use the redundancy strategies of oracle ASM or RAID 10 . I do not know which one is ...
user avatar
  • 116
1 vote
0 answers
31 views

Naming a datafile with spaces in the name

I would like to know if there could be a problem when naming a datafile with spaces in the name, I have an Oracle 11gR2 database, using ASM as storage, a datafile was created, belonging to an ...
user avatar
1 vote
0 answers
134 views

RMAN corrupts passwordfile

please, can you clarify this? My configuration is RAC 12c on ASM on SLES 11 SP 4 on SystemZ. The nodes rac11 and rac12 are the server nodes of the primary database, named "primdb", uniq_name is "...
user avatar
  • 21
1 vote
1 answer
40 views

Migration query - Oracle

I have two physical servers, hosting 6 two node RAC databases running in 11.2.0.3 version (both grid and database). I'm told to have the grid software in 11.2.0.4 version and the databases in the ...
user avatar
  • 1,814
1 vote
1 answer
57 views

ASM and IPv6 Compatibility

In the whitepaper mentioned below, Under 'Limitations' it says ASM and fan based notifications are not supported by IPv6 in Oracle. I'm just curious what ASM has to do with ipv4 or ipv6 or ipv4? ASM ...
user avatar
  • 1,814
0 votes
0 answers
13 views

Some easy way to list OS disks used by ASM without use asmcmd or sqlplus?

For example: I can list the disks with kfod: [root@rac1 bin]# ./kfod op=disks status=true disks=all dscvgroup=true -------------------------------------------------------------------------------- ...
user avatar
  • 506
0 votes
0 answers
163 views

I/O connection lost on Oracle VM (KVM)

This is the situation: 2 nodes RAC with ASM. Both nodes are VM based on OVM. At some point, we observed one node losing connection with 4 disks (/dev/... etc etc). Every db on the node, goes down. ...
user avatar
0 votes
0 answers
15 views

The doubt about the relationship ASM service resources within the Cluster Startup

There are two ASM service resources underlying both the OHASD oraagent and the CRSD oraagent. So what is the relationship between the two ASM service resources ? Reference links: https://docs.oracle....
user avatar
  • 11
0 votes
0 answers
294 views

diskgroup "DATA" space exhausted, but disk space is available from asm_diskgroup query

I'm trying to restore database, and it failed due to disk space issue: rman> restore database ... ORA-19504: failed to create file "+DATA" ORA-17502: ksfdcre:4 Failed to create file +DATA ...
user avatar
  • 1,198
0 votes
1 answer
670 views

Oracle - Delete dmp files from ASM diskgroup

I want to delete my export files daily from ASM diskgroup with a crontab job. I want to prepare a script for it. ASMCMD> ls exp1.dmp exp2.dmp exp3.dmp exp4.dmp ASMCMD> pwd +DATA/EXP How ...
user avatar
  • 25
0 votes
1 answer
221 views

ORACLE ASM present one or more LUNs?

I have the following question regarding the allocation of disks or LUNs to ASM in Oracle, specifically, I have an Oracle 18c DB in Cluster and I have created several diskgroups, now, I need to ...
user avatar
0 votes
0 answers
254 views

ACFSLOAD STOP not stoping - Device busy

When I try to stop the acfs I get the following error (all volumes was already disabled with voldisable -G diskgroup_name volume_name) server03:/>acfsload stop server03:/>(ucfgacfsctl): ACFS-...
user avatar
  • 506
0 votes
0 answers
996 views

ASM filter drive not starting automatically

After migrate from asmlib to asm filter drive using the Doc ID 2172754.1 the ASM Filter drive not start automatically and I always need configure again using asmcmd afd_configure command to start it ...
user avatar
  • 506
0 votes
1 answer
500 views

Direct, simple SQL query results in "ORA-01406: fetched column value was truncated"

All the information I've seen on this issue is always in regards to running a query via some other utility (e.g. TOAD); however, I am seeing this issue when I simply try to select * from v$asm_disk; ...
user avatar
0 votes
1 answer
184 views

Dataguard the datafiles are created in another diskgroup

I have a recently made physical dataguard configuration and everything works correctly so far, but I've noticed that the datafiles that are created in the primary are created in the standby in a ...
user avatar
0 votes
0 answers
458 views

Dropping database in RAC

I need a drop a database which is a 2 node RAC configuration and I will also be drooping the disk groups as well completely. What is the right way to drop the database + diskgroups? Will it be ok to ...
user avatar
  • 1,814
0 votes
0 answers
619 views

ASM Query on Diskgroups

Platform - RHEL. Database - 11.2.0.3. I have a diskgroup name TEST with AU as 1. I need to have the diskgroup with AU as 4 therefore I decided to drop the existing DG and recreate the new one with ...
user avatar
  • 1,814
0 votes
1 answer
137 views

Backup files not found in ASM

I have an Oracle database 11gr2 and I have installed Oracle Grid on Oracle Linux 5.9. I have two disk groups. /etc/init.d/oracleasm listdisks : flash_recovery_area DATA The first disk group is ...
user avatar
  • 116
0 votes
1 answer
225 views

Cannot install Oracle Grid on Oracle Linux 6.4

I have an Oracle database 11gr2 and I want to install Oracle Grid on Oracle Linux 6.4. At first, I have installed Oracle Grid with the tutorial on this website: https://eudba.wordpress.com/2012/08/...
user avatar
  • 116
0 votes
0 answers
9k views

ASM drop disk hangs (STATE DROPPING)

I have added disk into the RAC system by the following way: I have disk /dev/sdh1. Marked it as an ASM disk: --On node 1 oracleasm createdisk DISK7 '/dev/sdh1'; --On node 2 oracleasm createdisk ...
user avatar
  • 1,667
-1 votes
2 answers
407 views

ASM Diskgroup Creation Issue

I have 6, two node RAC databases running in the two physical servers. While I try to create new diskgroup, I get the following error: ORA-15018: diskgroup cannot be created ORA-04031: unable to ...
user avatar
  • 1,814
-1 votes
1 answer
286 views

ASM Query - Oracle 11gR2

I have two node RAC servers hosting 4 databases running on 11.2.0.3 version in RHEL OS. The underlying LUNs assigned to the ASM is not currently multipathed, meaning the disk sequence would change ...
user avatar
  • 1,814