Settings and Parameters Flashcards Preview

Oracle DB12c > Settings and Parameters > Flashcards

Flashcards in Settings and Parameters Deck (45):
1

FRA Defaults

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

2

DB_BLOCK_SIZE

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

3

CLUSTER_DATABASE

Requires bounce
Tells instance whether it's part of a cluster DB

4

COMPATIBLE

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

5

CONTROL_FILES

Requires bounce
Designates physical location of ctl files.

6

DB_CREATE_FILE_DEST

Dynamic
Specifies location for data files if using Managed Files feature.

7

DB_CREATE_ONLINE_LOG_DEST_n

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

8

DB_DOMAIN

Requires bounce
Logical location of DB on network

9

DB_NAME

Requires Bounce
Name of DB mounted by this instance

10

DB_RECOVERY_FILE_DEST

Dynamic
Location for recovery files if using flash recovery.

11

DB_RECOVERY_FILE_DEST_SIZE

Dynamic
Amount of disk space available for recovery files.

12

DB_UNIQUE_NAME

Requires bounce
Specifies unique name for DB within enterprise.

13

INSTANCE_NUMBER

Requires Bounce
Identifies instance if in a RAC environment.

14

LDAP_DIRECTORY_SYSAUTH

Requires bounce
Enables or disables LDAP for SYSDBA and SYSOPER connections.

15

LOG_ARCHIVE_DEST_n

Dynamic
Specifies up to 9 locations for redo log file archives.

16

LOG_ARCHIVE_DEST_STATE_n

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

17

NLS_LANGUAGE

Requires bounce
Specifies default language of DB

18

NLS_TERRITORY

Requires bounce
Specifies default region or territory of DB.

19

OPEN_CURSORS

Dynamic
Max number of cursors for any open session.

20

PGA_AGGREGATE_TARGET

Dynamic
Sets overall PGA size

21

PROCESSES

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

22

REMOTE_LISTENER

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

23

REMOTE_LOGIN_PASSWORDFILE

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

24

SESSIONS

Requires bounce
Max sessions that can connect to DB

25

SGA_TARGET

Dynamic
Sets max SGA when using Automatic Memory Management.

26

SHARED_SERVERS

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

27

STAR_TRANSFORMATION_ENABLED

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

28

UNDO_TABLESPACE

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

29

Default parameter file location is:

$ORACLE_HOME/dbs
%ORACLE_HOME%\database

30

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

31

STARTUP syntax

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

32

SHUTDOWN syntax

SHUTDOWN [NORMAL | TRANSACTIONAL | IMMEDIATE | ABORT]

33

DIAGNOSTIC_DEST

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

34

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.

35

Automatic Diagnostic Repository tool

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

36

What files are affected by ALTER SYSTEM?

Spfile and by default also affects pfile if used.

37

What view shows current parameter values:

V$PARAMETER

38

What view shows parameters as read from spfile?

V$SPPARAMETER

39

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.

40

catalog.sql

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

41

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

Forces SHUTDOWN ABORT and then STARTUP

42

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.

43

Common OFA mount points

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

44

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)

45

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