Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [oracle-asm]

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

0
votes
0answers
38 views

Unable to start database through Oracle Restart but works with SQLPlus. Restart seems to be trying to use an unkown and non-existent PFILE

ENVIRONMENT INFO: [oragrid@condor ~]$ uname -a Linux condor 3.10.0-862.14.4.el7.x86_64 #1 SMP Wed Sep 26 15:12:11 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux New installation of Oracle Database 11gR2 ...
0
votes
1answer
67 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 ...
0
votes
1answer
29 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 ...
0
votes
0answers
29 views

Migrate R12.2 EBS database from file system to ASM

I need help in migrating R12.2 database to ASM. There is an EBS r12.2 setup on Linux 7. Datafiles are on file system. DB version is 12.1.0.2 Grid version is 12.1.0.2 ASM is started and diskgroups ...
0
votes
1answer
166 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
vote
2answers
316 views

Empty v$asm_diskgroup with sqlplus

I have a Oracle Database instance installed under a OL7. It is a 12c2. Oracle GI also installed and my database have some files stored in ASM. I am using sqlplus to connect to the database instance ...
1
vote
0answers
60 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
1answer
722 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 ...
3
votes
1answer
327 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
1answer
700 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
2answers
321 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
1answer
840 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 ...
0
votes
1answer
1k 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 ...
3
votes
0answers
725 views

Oracle ASM I/O Error [closed]

I have oracle 11.2.0.4 and this database has a active data guard . Yesterday, i had this error in alert.log of active data guard : ERROR: unrecoverable error ORA-29701 raised in ASM I/O path;...
1
vote
1answer
437 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
0answers
416 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 ...
-1
votes
2answers
272 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 ...
0
votes
0answers
436 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 ...
0
votes
1answer
131 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 ...
1
vote
1answer
32 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
1answer
56 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 ...
0
votes
2answers
811 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
1answer
163 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/...
0
votes
1answer
3k 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
1answer
570 views

How is the password file accessed when it's on an ASM diskgroup and required to connect to ASM?

When a RAC is turned on, it will try to accessing the OCR registry which is located on ASM. ASM also holds the asm password file. However to open ASM, it needs to access the password file. If the ...
0
votes
1answer
6k views

Non-RAC single instance with ASM startup query

How to start a non-rac single instance with ASM file system. As in the case of RAC after reboot of server, the ASM and CRS resources startup automatically.. but with non-RAC but with ASM storage, what ...
2
votes
2answers
7k 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 ...
1
vote
3answers
5k 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: ...
0
votes
1answer
4k views

oracle cannot start

I have oracle database 11.2.0.4 on oracle linux 6.7 . I have install oracle database single instance with asm option . I have 2 users : oracle and grid My database is open and all of things are ...
0
votes
1answer
195 views

Mirror copies of redo logs

I'm running an two node RAC database with ASM having two DGs one for data and one for redo. I have only one copy of redo and I have the need to have another copy of redo logs. 1. How to go ahead with ...
1
vote
2answers
5k 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?
1
vote
1answer
45 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 ...
5
votes
1answer
570 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 ...
0
votes
3answers
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
1answer
81 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
1answer
188 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
1answer
638 views

ASM File System type

What is the underlying file system in ASM if exists? I have gone through many sites but neither of them answers my question directly rather each site I visisted raises a different point like 'ASM uses ...
4
votes
1answer
7k views

du of directories in a diskgroup in Oracle ASM

In Linux, you could run the below on a directory to find the size of each sub-directory: du -sh * When you're in asmcmdin the +FRA disk group for example, how can I retrieve the size of each ...
0
votes
2answers
97 views

Reinstall Oracle 11G2

Running Oracle 11GR2 instance (non-ASM). Plan to set it up again from the scratch(this time using ASM, Grid infrastructure). And I need the present database. I am thinking of the simple plan: 1) ...
0
votes
1answer
340 views

Striping IO with datafiles on different physical mounts

I have a server with three directly attached disk controllers. Each of these can provide internal redundancy and IO-striping accross disks, but I'm wondering what is the best way to configure the ...
1
vote
2answers
31k 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
0answers
7k 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 ...
0
votes
1answer
232 views

Kerne module for Oracle 11gR2 RAC on Linux

As per Oracle, it requires three Linux packages to run ASMLib: oracleasm - kernel module oracleasmlib-2.0 - ASMLib libraries oracleasm-support-2.0 - Admin for ASMLib This library versions are OS ...
0
votes
1answer
3k views

determine redo log size, number of redo log files

Having 2 node RAC instance using ASM Log switches happening are too high about 100 per hour causing db to hang for few minutes sometimes GROUP# THREAD# MEMBER ...
0
votes
1answer
2k views

How to migrate old Oracle ASM disks

We have EMC CLARiiON disks that are near their end of support, so we need to move Oracle ASM disks to a new sets disks. We are trying to minimize the database down time, so I am trying to find ways ...
2
votes
1answer
843 views

Migrating a tablespace to a different database on the same ASM

How might one go about copying or moving tablespaces between databases that uses the same ASM instances? Might it be possible to cut some corners in RMAN or have ASM remap files belonging to a ...
0
votes
2answers
3k views

How restore from ASM to a new server?

We have a machine that crashed completely. The ASM disks are fine. Is it possible to mount the old ASM disks to a new machine and then restore the datafiles/redo files/ control files/everything to ...
6
votes
2answers
142k 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 ...
4
votes
2answers
19k views

Add additional disks to FRA diskgroup in ASM

We're running Oracle 11.2.0.3 with a two node RAC and our FRA diskgroup is running low on space. I need to allocate some more disks to it through ASM. I'm not sure how to go about doing this. I can ...
5
votes
3answers
3k 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 ...