ORACLE BINARY CLONE

How to copy binaries to other server:1. turn off database and all services2. make backup ORACLE_HOME in new server:3. make dir ORACLE_HOME 4. set other system variables5. put ORACLE_HOME from previous backup6. set user and group ORACLE_HOME dir7. remove .ora files...

ORACLE SCRIPTS

podane za Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-04Table B-1 Creating the Data Dictionary Scripts Script Name Needed For Description catalog.sql All databases Creates the data dictionary and public synonyms for many of its viewsGrants...

ORACLE RMAN CLONE

how to clone database by RMAN:it depends on recovering files from previous backupcreate PFILE for new database based on PFILE from source databaseinit[db_new].oramain changes:db_namecontrol_filesaudit_file_destbackground_dump_destuser_dump_destcore_dump_destcreate...

ORACLE DBCA

how to add database to DBCA:if you want to add database, which was made by hand „create database etc.” not automatically by dbca, you should update /etc/oratab

ORACLE JOBS

check:SELECT * FROM dba_jobs;SELECT * FROM dba_jobs_running;SELECT schema_user,job,what,last_date,this_date,next_date,total_time/3600 hours,failures,broken FROM dba_jobs;column TOTAL_TIME determine the time which system spend run this job from first initialization, it...

ORACLE WAITS

TIME_STATISTICS = truev$event_name #describe events with parameters P and share to 12 wait_classv$system_event #based on events which was collected when instance was started for all sessions (please check TIME_WAITED regard to  STARTUP_TIME.v$instance)TOTAL_WAITS...