Settings and Parameters Flashcards by Grant Willey

FRA Defaults

Location: $ORACLE_BASE/fast_recovery_area
Size: 2,048mb

How well did you know this?

Not at all

Perfectly

DB_BLOCK_SIZE

Defaults to 8kb
Can’t modify after DB creation
Options: 2kb, 4kb, 8kb, 16kb, 32kb

How well did you know this?

Not at all

Perfectly

CLUSTER_DATABASE

Requires bounce

Tells instance whether it’s part of a cluster DB

How well did you know this?

Not at all

Perfectly

COMPATIBLE

Requires bounce

Release level and feature set to be active in this instance.

How well did you know this?

Not at all

Perfectly

CONTROL_FILES

Requires bounce

Designates physical location of ctl files.

How well did you know this?

Not at all

Perfectly

DB_CREATE_FILE_DEST

Dynamic

Specifies location for data files if using Managed Files feature.

How well did you know this?

Not at all

Perfectly

DB_CREATE_ONLINE_LOG_DEST_n

Dynamic
Specifies location(s) for redo log files if using Managed Files feature.

How well did you know this?

Not at all

Perfectly

DB_DOMAIN

Requires bounce

Logical location of DB on network

How well did you know this?

Not at all

Perfectly

DB_NAME

Requires Bounce

Name of DB mounted by this instance

How well did you know this?

Not at all

Perfectly

DB_RECOVERY_FILE_DEST

Dynamic

Location for recovery files if using flash recovery.

How well did you know this?

Not at all

Perfectly

DB_RECOVERY_FILE_DEST_SIZE

Dynamic

Amount of disk space available for recovery files.

How well did you know this?

Not at all

Perfectly

DB_UNIQUE_NAME

Requires bounce

Specifies unique name for DB within enterprise.

How well did you know this?

Not at all

Perfectly

INSTANCE_NUMBER

Requires Bounce

Identifies instance if in a RAC environment.

How well did you know this?

Not at all

Perfectly

LDAP_DIRECTORY_SYSAUTH

Requires bounce

Enables or disables LDAP for SYSDBA and SYSOPER connections.

How well did you know this?

Not at all

Perfectly

LOG_ARCHIVE_DEST_n

Dynamic

Specifies up to 9 locations for redo log file archives.

How well did you know this?

Not at all

Perfectly

LOG_ARCHIVE_DEST_STATE_n

Dynamic

Indicates how the specified locations should be used for archiving log files.

How well did you know this?

Not at all

Perfectly

NLS_LANGUAGE

Requires bounce

Specifies default language of DB

How well did you know this?

Not at all

Perfectly

NLS_TERRITORY

Requires bounce

Specifies default region or territory of DB.

How well did you know this?

Not at all

Perfectly

OPEN_CURSORS

Dynamic

Max number of cursors for any open session.

PGA_AGGREGATE_TARGET

Dynamic

Sets overall PGA size

PROCESSES

Requires bounce
Defaults to 300
Max OS processes that can connect to instance.

REMOTE_LISTENER

Dynamic

Network name that points to address (or list of addresses) of remote listeners.

REMOTE_LOGIN_PASSWORDFILE

Requires bounce

Determines whether the instance uses a password file and what type.

SESSIONS

Requires bounce

Max sessions that can connect to DB

SGA_TARGET

Dynamic | Sets max SGA when using Automatic Memory Management.

SHARED_SERVERS

Dynamic | Number of shared server processes to start when instance is started.

STAR_TRANSFORMATION_ENABLED

Dynamic | Determines whether the optimizer will consider star transformations when executing queries.

UNDO_TABLESPACE

Dynamic | Specifies which tablespace stores undo segments if using Automatic Undo Management.

Default parameter file location is:

$ORACLE_HOME/dbs | %ORACLE_HOME%\database

If no parameter file specified, Oracle looks for these file names in sequence in the default directory:

spfile$ORACLE_SID.ora spfile.ora init$ORACLE_SID.ora

STARTUP syntax

STARTUP [NOMOUNT|MOUNT|OPEN] [PFILE=] [RESTRICT] [FORCE] {QUIET]

SHUTDOWN syntax

SHUTDOWN [NORMAL | TRANSACTIONAL | IMMEDIATE | ABORT]

DIAGNOSTIC_DEST

Location of diagnostic directory. Defaults to the ORACLE_BASE value. If ORACLE_BASE not set, defaults to ORACLE_HOME/rdbms/log.

Alert log file

Always named alert_.log XML version in DIAGNOSTIC_DEST/rdbms/dbname/instancename/alert Text version in DIAGNOSTIC_DEST/rdbms/dbname/instancename/trace V$DIAG_INFO view shows location of all diag files.

Automatic Diagnostic Repository tool

$ adrci | ADRCI> show homes | alerts (etc.)

What files are affected by ALTER SYSTEM?

Spfile and by default also affects pfile if used.

What view shows current parameter values:

V$PARAMETER

What view shows parameters as read from spfile?

V$SPPARAMETER

What functions can be done with DBCA?

Create DBs, manage templates, add DB options, delete DBs. | Can NOT change init params on an existing DB with DBCA.

catalog.sql

Script that creates data dictionary views, dynamic performance views and synonyms.

What will happen if STARTUP FORCE is used on a running DB?

Forces SHUTDOWN ABORT and then STARTUP

orainstRoot.sh

On *nix systems, orainstRoot.sh creates a file named /etc/orainst.loc which has info about the Oracle Inventory location and software installation owner name.

Common OFA mount points

``` /u01 /mnt01 /du01 /d01 *Windows assigns a drive name. ```

Oracle Install Prerequisites

``` 1GB RAM (2 recommended) 1.5GB Swap space on HDD (or equal to RAM) 1GB of free space in /tmp (*nix) 6.4GB disk space Create user and group to be Oracle owner Create mount points (*nix) ```

Job separation roles

OSDBA - OS users with DBA priv Priv = SYSDBA OS Group Name: ORA__DBA or OSDBA Operator - Limited admin Priv = SYSOPER OS Group Name: ORA__OPER or OSOPER Backup/Recovery Admin Priv = SYSBACKUP OS Group Name: ORA__SYSBACKUP or OSBACKUPDBA DG Admin Priv = SYSDG OS Group Name: ORA__SYSDG or OSDGDBA Encryption Key Mgmt Priv = SYSKM OS Group Name: ORA__SYSKM or OSKMDBA