Oracle RMAN Backup Script In Oracle Linux

This is rman.sh And this is RMAN configuration,

Oracle Database in Oracle Linux Cannot Start / Open

Today I mess around with the Oracle database that can not start and open. I get some error messages from various places such as alert.log, sqlplus, rman. These errors are, I have do this step : 1. replace the  current spfile with the old one 2. startup with pfile 3. restore and recover database using [...]

Oracle Parameter optimizer_index_cost_adj Performance

From Oracle Documentation, Default value 100 Modifiable ALTER SESSION, ALTER SYSTEM Range of values 1 to 10000 OPTIMIZER_INDEX_COST_ADJ lets you tune optimizer behavior for access path selection to be more or less index friendly—that is, to make the optimizer more or less prone to selecting an index access path over a full table scan. The [...]

Oracle Parameter db_block_checksum Performance

From Oracle Documentation, Default value TYPICAL Modifiable ALTER SYSTEM Range of values OFF | TYPICAL | FULL DB_BLOCK_CHECKSUM determines whether DBWn and the direct loader will calculate a checksum (a number calculated from all the bytes stored in the block) and store it in the cache header of every data block when writing it to [...]

Cannot Compile Oracle Function ORA-04021

I was get this error when I alter and compile one function ORA-04021: timeout occurred while waiting to lock object First try, I use this query to find what cause this error SELECT p.spid “Thread”, s.sid “SID-Top Sessions”, SUBSTR (s.osuser, 1, 15) “OS User”, SUBSTR (s.program, 1, 25) “Program Running”, s.username FROM v$process p, v$session [...]

How To See Oracle Database Parameter

You can run this sql to see Oracle Database Parameter : SELECT name, value, isdefault default_value, description, isses_modifiable session_modifiable, issys_modifiable system_modifiable, isdeprecated deprecated, update_comment FROM v$parameter ORDER BY name ISDEFAULT Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE) ISSES_MODIFIABLE Indicates whether [...]

Create Oracle Schedule Backup Script on Oracle Linux :

create backup directory for USERME CREATE OR REPLACE DIRECTORY BCK_DIR AS ‘/home/oracle/bck’; GRANT READ, WRITE ON DIRECTORY SYS.BCK_DIR TO EXP_FULL_DATABASE; GRANT READ, WRITE ON DIRECTORY SYS.BCK_DIR TO IMP_FULL_DATABASE; using vi to create script #!/bin/bash clear #echo “Hello, linux world from pandazen world.” echo “backup pandazen data with script on Oracle Linux” NOW=$(date +”%Y%m%d”) FILE=”pandazen$NOW” echo [...]