Oracle - RakDBA

Instance Status and his startup time:

SELECT INSTANCE_NAME,STATUS,
TO_CHAR(STARTUP_TIME,'DD MM YYYY, HH24:MM:SS') STARTUP_TIME FROM V$INSTANCE;

List all database parameters.

SET PAGESIZE 60
SET LINESIZE 300
 
COLUMN name  FORMAT A30
COLUMN value FORMAT A70
COLUMN ses_mod FORMAT a10
COLUMN sys_mod FORMAT a10
COLUMN ins_mod FORMAT a10
 
SELECT p.name,
       p.type,
       p.value,
       p.isses_modifiable as SES_MOD,
       p.issys_modifiable as SYS_MOD,
       p.isinstance_modifiable as INS_MOD
FROM   v$parameter p
ORDER BY p.name
/

ISSES_MODIFIABLE Indicates whether the parameter can be changed with ALTER SESSION (TRUE) or not (FALSE)

ISSYS_MODIFIABLE

Indicates whether the parameter can be changed with ALTER SYSTEM and when the change takes effect:

IMMEDIATE – Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect immediately.
DEFERRED – Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect in subsequent sessions.
FALSE – Parameter cannot be changed with ALTER SYSTEM unless a server parameter file was used to start the instance. The change takes effect in subsequent instances.

ISINSTANCE_MODIFIABLE For parameters that can be changed with ALTER SYSTEm, indicates whether the value of the parameter can be different for every instance (TRUE) or whether the parameter must have the same value for all Real Application Clusters instances (FALSE). If the ISSYS_MODIFIABLE column is FALSE, then this column is always FALSE.

-- Remove the instance
Command: srvctl remove instance -d db_name -i inst_name
Example: srvctl remove instance -d db_rac -i rac01

-- Start the instance
Command: srvctl start instance -d db_name -i inst_names [-o start_options] [-c connect_str|-q]
Command: srvctl start instance -d db_name -i inst_names -o open
Command: srvctl start instance -d db_name -i inst_names -o nomount
Command: srvctl start instance -d db_name -i inst_names -o mount
Example: srvctl start instance -d db_rac -i rac02

-- Start the instance (Oracle 11g):
Command: srvctl start instance -d db_unique_name {-n node_name -i "instance_name_list"} [-o start_options]
Example: srvctl start instance -d db_rac -n node2
Example: srvctl start instance -d db_rac -i "rac02,rac03"

-- Stop the instance
Command: srvctl stop instance -d db_name -i inst_names [-o stop_options] [-c connect_str|-q]
Command: srvctl stop instance -d db_name -i inst_names [-o normal]
Command: srvctl stop instance -d db_name -i inst_names -o transactional
Command: srvctl stop instance -d db_name -i inst_names -o immediate
Command: srvctl stop instance -d db_name -i inst_names -o abort
Example: srvctl stop instance -d db_rac -i rac03

-- Stop the instance (Oracle 11g):
Command: srvctl stop instance -d db_unique_name {[-n node_name]|[-i "instance_name_list"]} [-o stop_options] [-f]
Example: srvctl stop instance -d db_rac -n node1
Example: srvctl stop instance -d db_rac -i rac01

-- Check the status of the instance
Command: srvctl status instance -d db_name -i inst_names [-f] [-v] [-S level]
Example: srvctl status instance -d db_rac -i rac02

-- Check the status of the instance (Oracle 11g):
Command: srvctl status instance -d db_unique_name {-n node_name | -i "instance_name_list"} [-f] [-v]
Example: srvctl status instance -d db_rac -i "rac01,rac02" -v

-- Enable/disable the instance
Command: srvctl enable instance -d db_name -i inst_names
Example: srvctl enable instance -d db_rac -i "rac01,rac02"

Command: srvctl disable instance -d db_name -i inst_names
Example: srvctl disable inst -d db_rac -i "rac01,rac03"

-- Set dependency of instance to ASM
Command: srvctl modify instance -d db_name -i inst_name {-s asm_inst_name|-r} 
Command: srvctl modify instance -d db_unique_name -i instance_name {-n node_name|-z}
Example: srvctl modify instance -d db_rac -i rac01 -n node1
Example: srvctl modify instance -d db_rac -i rac01 -z

-- Move the database instance
Command: srvctl modify instance -d db_name -i inst_name -n node_name 
Example: srvctl modify instance -d db_rac -i rac02 -n node1

-- Remove the database instance
Command: srvctl modify instance -d db_name -i inst_name -r 
Example: srvctl modify instance -d db_rac -i rac01 -r

-- Get/set/unset environment 
Command: srvctl getenv instance -d db_name -i inst_name [-t name_list]
Example: srvctl getenv instance -d db_rac -i rac01

Command: srvctl setenv instance -d db_name [-i inst_name] {-t "name=val[,name=val,...]" | -T "name=val"}
Example: srvctl setenv instance -d db_rac -i rac01 [options]

Command: srvctl unsetenv instance -d db_name [-i inst_name] [-t name_list]
Example: srvctl unsetenv instance -d db_rac -i rac01 [-t options]

COL USERNAME FOR A15
COL PRIVILEGE FOR A25
COL OWNER FOR A15
COL TABLENAME FOR A30
COL COLUMN_NAME FOR A25
COL ADMIN_OPTION FOR A15
SET LINESIZE 200

SELECT A.*
    FROM (SELECT GRANTEE          USERNAME,
                 GRANTED_ROLE     PRIVILEGE,
                 '--'             OWNER,
                 '--'             TABLENAME,
                 '--'             COLUMN_NAME,
                 ADMIN_OPTION     ADMIN_OPTION,
                 'ROLE'           ACCESS_TYPE
            FROM DBA_ROLE_PRIVS RP JOIN DBA_ROLES R ON RP.GRANTED_ROLE = R.ROLE
           WHERE GRANTEE IN (SELECT USERNAME FROM DBA_USERS)
          UNION
          SELECT GRANTEE          USERNAME,
                 PRIVILEGE        PRIVILEGE,
                 '--'             OWNER,
                 '--'             TABLENAME,
                 '--'             COLUMN_NAME,
                 ADMIN_OPTION     ADMIN_OPTION,
                 'SYSTEM'         ACCESS_TYPE
            FROM DBA_SYS_PRIVS
           WHERE GRANTEE IN (SELECT USERNAME FROM DBA_USERS)
          UNION
          SELECT GRANTEE        USERNAME,
                 PRIVILEGE      PRIVILEGE,
                 OWNER          OWNER,
                 TABLE_NAME     TABLENAME,
                 '--'           COLUMN_NAME,
                 GRANTABLE      ADMIN_OPTION,
                 'TABLE'        ACCESS_TYPE
            FROM DBA_TAB_PRIVS
           WHERE GRANTEE IN (SELECT USERNAME FROM DBA_USERS)
          UNION
          SELECT DP.GRANTEE      USERNAME,
                 PRIVILEGE       PRIVILEGE,
                 OWNER           OWNER,
                 TABLE_NAME      TABLENAME,
                 COLUMN_NAME     COLUMN_NAME,
                 '--'            ADMIN_OPTION,
                 'ROLE'          ACCESS_TYPE
            FROM ROLE_TAB_PRIVS RP, DBA_ROLE_PRIVS DP
           WHERE     RP.ROLE = DP.GRANTED_ROLE
                 AND DP.GRANTEE IN (SELECT USERNAME FROM DBA_USERS)
          UNION
          SELECT GRANTEE         USERNAME,
                 PRIVILEGE       PRIVILEGE,
                 GRANTABLE       ADMIN_OPTION,
                 OWNER           OWNER,
                 TABLE_NAME      TABLENAME,
                 COLUMN_NAME     COLUMN_NAME,
                 'COLUMN'        ACCESS_TYPE
            FROM DBA_COL_PRIVS
           WHERE GRANTEE IN (SELECT USERNAME FROM DBA_USERS)) A
ORDER BY USERNAME,
         A.TABLENAME,
         CASE
             WHEN A.ACCESS_TYPE = 'SYSTEM' THEN 1
             WHEN A.ACCESS_TYPE = 'TABLE' THEN 2
             WHEN A.ACCESS_TYPE = 'COLUMN' THEN 3
             WHEN A.ACCESS_TYPE = 'ROLE' THEN 4
             ELSE 5
         END,
         CASE
             WHEN A.PRIVILEGE IN ('EXECUTE') THEN 1
             WHEN A.PRIVILEGE IN ('SELECT', 'INSERT', 'DELETE') THEN 3
             ELSE 2
         END,
         A.COLUMN_NAME,
         A.PRIVILEGE;

Define your 'user_name' at the line 1

DEFINE USER_NAME=ZABBIX

COL USERNAME FOR A15
COL PRIVILEGE FOR A25
COL OWNER FOR A15
COL TABLENAME FOR A30
COL COLUMN_NAME FOR A25
COL ADMIN_OPTION FOR A15
SET LINESIZE 200

SELECT A.*
    FROM (SELECT GRANTEE          USERNAME,
                 GRANTED_ROLE     PRIVILEGE,
                 '--'             OWNER,
                 '--'             TABLENAME,
                 '--'             COLUMN_NAME,
                 ADMIN_OPTION     ADMIN_OPTION,
                 'ROLE'           ACCESS_TYPE
            FROM DBA_ROLE_PRIVS RP JOIN DBA_ROLES R ON RP.GRANTED_ROLE = R.ROLE
           WHERE GRANTEE IN (SELECT USERNAME FROM DBA_USERS WHERE USERNAME = UPPER('&USER_NAME'))
          UNION
          SELECT GRANTEE          USERNAME,
                 PRIVILEGE        PRIVILEGE,
                 '--'             OWNER,
                 '--'             TABLENAME,
                 '--'             COLUMN_NAME,
                 ADMIN_OPTION     ADMIN_OPTION,
                 'SYSTEM'         ACCESS_TYPE
            FROM DBA_SYS_PRIVS
           WHERE GRANTEE IN (SELECT USERNAME FROM DBA_USERS WHERE USERNAME = UPPER('&USER_NAME'))
          UNION
          SELECT GRANTEE        USERNAME,
                 PRIVILEGE      PRIVILEGE,
                 OWNER          OWNER,
                 TABLE_NAME     TABLENAME,
                 '--'           COLUMN_NAME,
                 GRANTABLE      ADMIN_OPTION,
                 'TABLE'        ACCESS_TYPE
            FROM DBA_TAB_PRIVS
           WHERE GRANTEE IN (SELECT USERNAME FROM DBA_USERS WHERE USERNAME = UPPER('&USER_NAME'))
          UNION
          SELECT DP.GRANTEE      USERNAME,
                 PRIVILEGE       PRIVILEGE,
                 OWNER           OWNER,
                 TABLE_NAME      TABLENAME,
                 COLUMN_NAME     COLUMN_NAME,
                 '--'            ADMIN_OPTION,
                 'ROLE'          ACCESS_TYPE
            FROM ROLE_TAB_PRIVS RP, DBA_ROLE_PRIVS DP
           WHERE     RP.ROLE = DP.GRANTED_ROLE
                 AND DP.GRANTEE IN (SELECT USERNAME FROM DBA_USERS WHERE USERNAME = UPPER('&USER_NAME'))
          UNION
          SELECT GRANTEE         USERNAME,
                 PRIVILEGE       PRIVILEGE,
                 GRANTABLE       ADMIN_OPTION,
                 OWNER           OWNER,
                 TABLE_NAME      TABLENAME,
                 COLUMN_NAME     COLUMN_NAME,
                 'COLUMN'        ACCESS_TYPE
            FROM DBA_COL_PRIVS
           WHERE GRANTEE IN (SELECT USERNAME FROM DBA_USERS WHERE USERNAME = UPPER('&USER_NAME'))) A
ORDER BY USERNAME,
         A.TABLENAME,
         CASE
             WHEN A.ACCESS_TYPE = 'SYSTEM' THEN 1
             WHEN A.ACCESS_TYPE = 'TABLE' THEN 2
             WHEN A.ACCESS_TYPE = 'COLUMN' THEN 3
             WHEN A.ACCESS_TYPE = 'ROLE' THEN 4
             ELSE 5
         END,
         CASE
             WHEN A.PRIVILEGE IN ('EXECUTE') THEN 1
             WHEN A.PRIVILEGE IN ('SELECT', 'INSERT', 'DELETE') THEN 3
             ELSE 2
         END,
         A.COLUMN_NAME,
         A.PRIVILEGE;

Architecture & instance

ASM

Locks

Objects

RAC - CRSCTL

RAC - SRVCTL

Redologs & Archivelogs

RMAN

Schemas

Sessions

Tablespaces

Users & account