RESIZING DATAFILE IN ASM

Re-sizing  datafiles in ASM is very simple. +ASM oracle@akyaka:/home/oracle>sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 26 14:53:56 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved.   Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application … Continue reading RESIZING DATAFILE IN ASM

Advertisements

INS-30510 reported while installing GridInfrastructure for Cluster or Single DB

Hello, For storing Voting disks in ASM,we require minimum of three disks or three failgroups for Normal Redundancy diskgroup. The number of voting files you can store in a particular Oracle ASM disk group depends upon the redundancy of the disk group. ASM puts each voting disk in its own failure group within the disk … Continue reading INS-30510 reported while installing GridInfrastructure for Cluster or Single DB

Oracle Grid installation: roothas.pl fails with “Oracle Restart stack is not act

root.sh fails during execution for an Oracle Grid Infrastructure 11.2 installation with following messages . "Oracle Grid installation: roothas.pl fails with “Oracle Restart stack is not act" Solution 1: Clead up the ASM Disks Once you attempt an installation, your ASM disks are marked as being used, so they can no longer be used as … Continue reading Oracle Grid installation: roothas.pl fails with “Oracle Restart stack is not act

ADDING DATAFILE TO TABLESPACE IN ASM

Datafile scripts : CREATE TABLESPACE USERS DATAFILE '+DATA' SIZE 33511680K AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED, '+DATA' SIZE 32724M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED, '+DATA' SIZE 33554416K AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED, '+DATA' SIZE 30040M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED, '+DATA' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED, '+DATA' SIZE 100M … Continue reading ADDING DATAFILE TO TABLESPACE IN ASM