Questions tagged [oracle-asm]
Oracle ASM is a storage management solution for Oracle databases and clusters providing volume management and a filesystem,
64
questions
0
votes
1
answer
33
views
Grid 19c: Purpose of QUORUM FAILGROUP on shared NFS mountpoint when you already have an +OCRDG diskgroup
I'm working somewhere now where every ASM diskgroup has been made with an extra disk under the QUORUM FAILGROUP option, and is built with the following pattern:
CREATE DISKGROUP stuffdg NORMAL ...
- 31
1
vote
1
answer
188
views
It's possible share a disk between two diskgroups after limit the disk space in ASM?
I am not able to get a new disk in the moment and I was woldering if it's possible to share a disk between two diskgroup.
I have a FRA diskgroup with a disk of 200gb and I need to add 100gb in DATA ...
- 630
1
vote
1
answer
95
views
Oracle ASM for data files - "not recommended" - why not
I've been supporting a lot of Oracle databases (not full-time; I'm a programmer 90% of the time) and I just happened to see in the Oracle 19 Linux Installation document that storing Oracle data files ...
- 1,133
0
votes
1
answer
178
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? ...
- 69
1
vote
0
answers
77
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 ...
- 149
0
votes
1
answer
1k
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 ...
- 998
1
vote
1
answer
2k
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 can I ...
- 55
0
votes
1
answer
606
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 ...
- 149
0
votes
1
answer
865
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
762
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:
...
- 630
0
votes
1
answer
1k
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 ...
- 630
0
votes
1
answer
328
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
...
- 421
1
vote
2
answers
1k
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/...
- 630
1
vote
1
answer
3k
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 ...
- 630
1
vote
2
answers
6k
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 ...
- 11
0
votes
1
answer
435
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 ...
- 135
0
votes
4
answers
740
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
votes
1
answer
1k
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
1
answer
47
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 ...
- 669
0
votes
1
answer
1k
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 ...
- 305
2
votes
3
answers
3k
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 ...
- 99
1
vote
0
answers
146
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 "...
- 21
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 ...
- 21
2
votes
1
answer
704
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 ...
- 216
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 (...
- 1,569
0
votes
2
answers
799
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 ...
- 1,707
0
votes
1
answer
2k
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 ...
- 194
0
votes
1
answer
4k
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 ...
- 194
1
vote
1
answer
993
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 ...
- 279
-1
votes
2
answers
480
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,886
-1
votes
1
answer
311
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,886
1
vote
1
answer
44
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 ...
- 1,886
0
votes
1
answer
102
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,886
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 ...
- 194
1
vote
1
answer
438
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
1
answer
6k
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 ...
- 1
0
votes
1
answer
1k
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 ...
- 1,873
0
votes
1
answer
9k
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 ...
- 1,886
3
votes
2
answers
12k
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 ...
- 552
1
vote
3
answers
8k
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:
...
- 194
0
votes
1
answer
5k
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 ...
- 216
0
votes
1
answer
592
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,886
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?
- 1,886
1
vote
1
answer
59
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 ...
- 1,886
5
votes
1
answer
926
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 ...
- 216
1
vote
3
answers
3k
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-...
- 552
0
votes
1
answer
167
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 ...
- 216
0
votes
1
answer
254
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/...
- 216
0
votes
1
answer
927
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 ...
- 15
5
votes
1
answer
15k
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 ...
- 51