Step-by-Step Oracle notes

Step-by-Step Oracle part of Notes 1. Do not use the user name/password directly/as sysdba is the operating system authentication method, change the security method sqlnet. SQLNET. AUTHENTICATION_SERVICES = (ETS) indicates that operating system authentication is enabled. When this parameter is commented out or set to NONE: SQLNET. AUTHENTICATION_SERVICES = (NONE) then the operating system authentication will be disabled; 2. If you want to move the index of the AUD $ table to another tablespace to move the index of the AUD $ table to the same table space as the index of the mobile LOB type, statement cannot use alter index index_name rebuild tablespace new_tablespace; error: ORA-02327: Unable to create index with expression of Data Type LOB (ORA-02327: cannot create index on expression with datatype LOB) should use Syntax:

ALTER TABLE table_name MOVE    TABLESPACE new_tbsp    STORAGE(new_storage)    LOB (lobcol)    STORE AS lobsegment    (TABLESPACE new_tbsp    STORAGE (new_storage));

Example: alter table aud $ move tablespace seven lob (SQLBIND, SQLTEXT) store as (TABLESPACE seven); (table Name) (tablespace name) (LOB field name) 3. Audit function: audit all by access whenever not successful; 1. sys user behavior AUDIT:

Audit_sys_operations = true: Check adump file sid and pid in v $ process and v $ session select. spid, B. sid from v $ process a, v $ session B where. addr = B. paddr and B. sid = (select sid from v $ mystat where rownum = 1 );

2. user behavior audit: audit all by seven by access; audit select table, update table, insert table, drop table by seven by access; audit execute procedure by seven by access; view the dba_audit_trail table and view the specific information:

select username,extended_timestamp,owner,obj_name,action_name                      from dba_audit_trail                      where owner='SEVEN' order by timestamp;

3. FGA (fine-grained auditing) Refined audit: View dba_fga_audit_trail 4. Audit the OS Operating System. Modify the two parameters audit_trail = OS audit_syslog_level. 5. Audit the DB: audit_trail = DB audit information is recorded in SYS. AUD $ medium; 4. A segment cannot span one tablespace, but can span the tablespace File 5. Modify the parameters after the database is installed:

SQL> alter profile DEFAULT limit FAILED_LOGIN_ATTEMPTS UNLIMITED; FAILED_LOGIN_ATTEMPTScontrol_file_record_keep_time 7 days DB_FILES 8GOPEN_LINKSOPEN_LINKS_PER_INSTANCE

RBA: rba = redo byte address consists of three parts: 4 byte + 4 byte + 2 byte: logfile sequence number, logfile block number, byte offsetinto the block, that is, redo serial number, redo block number and offset. And use hexadecimal notation. To set archive logs to be stored in the flash back area, run the following command:

SQL>alter system set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST';

Main files stored in the flash back area: 1. control files; 2. archive log files; 3. Flash back logs; 4. Automatic Backup of control files and spfiles; 5. RMAN backup sets; 6. Copy data files. Comment: This book was read last year. At that time, there were few notes, but I had to say that this master eygle's masterpiece contains many experiment operations and summaries, involving a lot of basic knowledge, it is a good book that can consolidate your knowledge. I will try again later, and I will try again later.