Tagged: Asm

Oracle Database

Oracle 12C – Password File in ASM

Prior to Oracle Database 12c, the password file was always located under $ORACLE_HOME/dbs file structure, even for RAC instances and for RAC ASM cluster. For RAC the DBA had to managed to keep the password file in sync on each node. Now , in Oracle 12c, it is possible to store the password file on ASM. This means a shared password file for Oracle RAC databases , it is shared for all instances in the cluster. The command utility to create the password file is still the same: “orapwd” Oracle 11g file – name of password file (required), password –...

Oracle Database

Creating Tablespaces in ASM

When ASM creates a datafile for a permanent tablespace (or a temporary file for a temporary tablespace), the datafile is set to auto-extensible with an unlimited maximum size and 100 MB default size. You can use the AUTOEXTEND clause to override this default extensibility and the SIZE clause to override the default size. ASM applies attributes to the datafile, as specified in the system default template for a datafile as shown in the table in “Managing Disk Group Templates”. You can also create and specify your own template. Files in a tablespace might be in both ASM files and non-ASM...

Oracle Database

Creating Tablespaces in ASM

  When ASM creates a datafile for a permanent tablespace, the datafile is set to auto-extensible with an unlimited maximum size and 100 MB default size. You can use the AUTOEXTEND clause to override this default extensibility and the SIZE clause to override the default size. ASM applies attributes to the datafile, as specified in the system default template for a datafile as shown in the table in Managing disk group templates If there is a disk group named DATA, you can create a tablespace TBSLAVORO in that disk group with the following SQL statement: CREATE TABLESPACE TBSLAVORO DATAFILE ‘+DATA’;...