Questions tagged [oracle-asm]

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

Filter by
Sorted by
Tagged with
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 -------------------------------------------------------------------------------- ...
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 ...
0 votes
1 answer
497 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; ...
0 votes
1 answer
217 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 ...
0 votes
1 answer
664 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 ...
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/...
0 votes
1 answer
182 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 ...
0 votes
1 answer
2k views

Oracle ASM: Freeing up space

Oracle RAC 11.2 with asm storage, all type = EXTERN redundancy. I've been cleaning up some tablespaces and shrinking datafiles back down to sizes that they're not likely to grow much larger than (...
0 votes
0 answers
158 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. ...
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....
0 votes
1 answer
70 views

Oracle RAC 18c Patching - datapatch

After patching GI Home and DB Home simultaneously using command: .oraenv +ASM1 opatchauto apply /patchlocation Should i run ./datapatch from DB home or GI home? Or it doesn't matter from which home? ...
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 ...
0 votes
1 answer
382 views

Changing the grid listener port of an Oracle Database Appliance X8-2M

I need to add an extra Port: 1522 Listener Parameter File /u01/app/19.0.0.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/xxxx/listener/alert/log.xml Listening ...
2 votes
3 answers
2k views

Empty v$asm_diskgroup with sqlplus

I have an Oracle Database instance installed under an OL7. It is a 12c2. Oracle GI also installed and my database has some files stored in ASM. I am using sqlplus to connect to the database instance ...
0 votes
0 answers
291 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 ...
0 votes
0 answers
250 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-...
0 votes
0 answers
978 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 ...
0 votes
1 answer
349 views

Can't start asm filter driver

I'm trying to install oracle grid with asm filter driver. I've already installed grid software only. As root, I can't start asm. Actually, I don't have any answer from asmcmd filter driver commands: ...
0 votes
1 answer
687 views

ASM trying to mount droped diskgroup

In my envoriment I am getting the following erro: ORA-15032: not all alterations performed ORA-15017: diskgroup "OCR" cannot be mounted ORA-15040: diskgroup is incomplete The problem is: I already ...
0 votes
1 answer
153 views

Define block device of an ASM disk

I have a bunch of asmdisks: /dev/oracleasm/disks/DATA01 /dev/oracleasm/disks/DATA02 .. /dev/oracleasm/disks/DATA07 Probably, they were created as: oracleasm createdisk DATA01 /dev/sda1 ...
0 votes
1 answer
96 views

Query on Asmlib

I have Oracle Linux running on vmware hosting an Oracle database with ASM (single instance). There isn't any operating system device persistence and therefore whenever my OS reboots, the disk number ...
1 vote
2 answers
4k views

Oracle 19c GI Install on OL7 : ASM disks stamped via AsmLib not getting discovered via GridSetup.sh

I am trying to install GI 19c on Oracle Linux 7 (required for 19c), and have used AsmLib to try to achieve device persistence (owner,group) for ASM devices/disks. Prior to that I used udev rules for ...
-1 votes
1 answer
975 views

ASM Space Usage

Oracle Version: 12.1.0.2 I had about 100 GB freespace on my +ASM diskgroup on Friday. When I came back on Monday, I see only 45 gigs. How can I find what consumed my space? Or is there a SQLPlus ...
8 votes
2 answers
230k views

How to monitor space usage on ASM diskgroups

Last night the recovery area on one of our Oracle Database Appliances went full. This was reported in one of the database alert logs, and we were able to clear out some space before the next log ...
-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 ...
0 votes
1 answer
2k views

ASMCMD doesn't return any result

I'm trying to use ASMCMD but it doesn't return any result in the command line ASMCMD> ls ASMCMD> ASMCMD> ASMCMD> ASMCMD> lsdg ASMCMD> ASMCMD> pwd ASMCMD> The version of ...
1 vote
2 answers
549 views

RMAN restoring datafile out of ASM

Why is RMAN restoring the datafiles out of ASM and how to restore a backup into ASM? Here is one output. The tablespace triscaltb was restored in /u01/app/oracle/product/12.1.0/dbhome_1/dbs/...
1 vote
3 answers
2k views

Is using ASM a pre-requisite for RAC?

I am about to build our first RAC development environment, and as I'm new to RAC and have not used ASM I wanted to keep things as simple as possible. I was under the impression that ASM is a pre-...
0 votes
4 answers
430 views

Need to choose ASM performance for production database

We have a 1.5 TB of data (nonasm) and we plan to move into ASM by choose normal redundancy. Normal Redundancy ==> Two Way Mirroring , So we need 3TB data storage for 1.5TB data including mirroring(...
1 vote
3 answers
43k views

Oracleasm deletedisk failed Unable to clear disk

I have dropped the disk from ASM diskgroup: > ALTER DISKGROUP DATA01 DROP DISK DISK1; Oracle did a rebalance operation and then dropped the disk. Now, I want to delete the disk from ASM library ...
0 votes
1 answer
40 views

RMAN or Fresh install

I'm trying to reduce the time to install Oracle on a pipeline we have. At the moment, it's installed using dbca in silent mode with a database template file. The majority of the time seems to be ...
1 vote
3 answers
7k views

Problem Installing 11.2.0 on RHEL 7 64 Bit

I have problem in stalling Oracle ASM on RHEL 7, Please advice [root@localhost grid]# ./root.sh Performing root user operation for Oracle 11g The following environment variables are set as: ...
1 vote
1 answer
2k views

Flash Recovery Area full

I have oracle 11g that runs on Linux serve. I have a Flash Recovery Area, I backup my archive logs to another location. presently I have very little space left in my Flash Recovery Area (FRA) thereby ...
0 votes
1 answer
899 views

ASMCA(ASM Configuration Assistant) GUI is not rendering properly

Hi Gurus, While running ASMCA utility on OEL 7.5, Oracle is not able to render the GUI of the tool. I clicked on exit button and next screen comes as a vertical line (Screen attached above).No option ...
-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 ...
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 "...
1 vote
2 answers
6k views

ASM 12c compatibility

Can I use ASM 12c version with database 11g? This link and MOS Doc ID 337737.1 says I cannot use 12c version of ASM with a lower database version. Am I right? Or is it otherwise?
3 votes
2 answers
11k views

Unable to turn off automatic memory management (AMM)

i am running oracle 11.2.0.4 SE RAC on Red Hat linux 6, the database is using ASM for datafile management i have been experimenting with turning on AMM and set the following parameters alter system ...
2 votes
1 answer
490 views

Mount ASM Disks To New Host

I have oracle 11.2.0.4 installed on Red Hat Linux 6. I have an RMAN full backup from database that size is 20TB . This backup is created on ASM disks with different diskgroup from DATA. I want to ...
0 votes
2 answers
703 views

Recover disk in NORMAL redundancy

As we know NORMAL redundancy means 2 copies of each block. I have created diskgroup: CREATE DISKGROUP FG NORMAL REDUNDANCY FAILGROUP controller1 DISK 'ORCL:DISK3' NAME disk3 FAILGROUP ...
0 votes
1 answer
1k views

Oracle asm disk string profile string vs param string

Oracle Database ASM disk string profile string vs param string ? ASMCMD [+] > dsget profile: /dev/disk* parameter: /dev/disk* Do we need to set both of them ? what is consequence of setting one ...
5 votes
3 answers
4k views

How many control files should I have?

On the Oracle Database Appliance, the default deployment only gives you a single control file. I find this a little puzzling. The single control file causes a policy violation in the automatically ...
0 votes
1 answer
3k views

How to clean Archive logs

Oralce 12c ASM How to clean Archive logs. Oracle Instance is NOT starting since Archive disk group is full, This is my TEST DB I don't want to extend the diskgroup so instead I would like to DELETE ...
1 vote
1 answer
785 views

Map ASM files to physical Linux Devices

We are having problems with log file sync waits periodically. We have a 2 node RAC cluster using ASM. I'd like to monitor the physical device(s) containing the REDO log files using iostat, but I'm ...
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 ...
0 votes
1 answer
5k views

Cannot startup Oracle due to ORA-15041

I'm troubleshooting an Oracle instance that won't startup due to ORA-15041. The trc file shows this error: Failed to create file '+FRA_DATA' (file not accessible?) ORA-19816: WARNING: Files may ...
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 ...
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 ...
0 votes
2 answers
1k views

Oracle ASM : Alter asm_diskstring when ASM Instance is Down,

I am beginner for Oracle ASM I know we can alter asm_diskstring with following ways SqlPlus ASMCA but these requires +ASM to be UP and running. Is there way to set asm_diskstring when +ASM instance ...
1 vote
1 answer
348 views

Is there any trick to Resize LVM online that raw by UDEV rule without filesystem?

Here is the Logic Volume for example: lvcreate -L2G -n Lv_OraD1 vg_db lvcreate -L180G -n Lv_OraD2 vg_db lvdisplay /dev/mapper/Lv_OraD* UDEV rule to raw the LV: vi /etc/udev/rules.d/...