utworzone przez | paź 13, 2009 | Oracle
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...
utworzone przez | paź 1, 2009 | Oracle
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...
utworzone przez | wrz 28, 2009 | Oracle
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...
utworzone przez | wrz 28, 2009 | Oracle
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
utworzone przez | wrz 9, 2009 | Oracle
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...
utworzone przez | sie 3, 2009 | Oracle
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...
