Database Experts

Oracle 8i:Standby Database for Disaster recovery solution. Here is the simple steps for creating standby database in oracle 8i. This is testing purpose,So do the all steps from creating primary to real time sync of standby database. 1.Create/Configure Primary Database. a)Create primary database pfile. db_name = "primary" instance_name = primary service_names = primary control_files = ("/oracle/primary/stdby1.ctl","/oracle/primary/stdby2.ctl") control_file_record_keep_time=30 open_cursors = 100 max_enabled_roles = 30 db_block_buffers = 40000 db_block_lru_latches=4 cursor_space_for_time=true session_cached_cursors=40 shared_pool_size = 71680000 shared_pool_reserved_size=9216000 large_pool_size = 10485760 java_pool_size = 10485760 log_checkpoint_interval = 1048576 processes = 300 log_buffer = 163840 l og_archive_start = true log_archive_dest_1 = "location=/oracle/primary/arc/"...

Automate Automatic Workload Repository Report in a mail Every time go to database and collect reports is old fashioned way.Now, Lets do some automated work for oracle workload reports. This is required when number of databases and also we all lazy to avoid see reports everyday.So it is better to make one schedule who will send us yesterdays all working day awr report in one single mail where just need to see if anything problematic in off -office hours. Simple and easy way creating one single procedure and schedule by scheduler. lets do some coding. 1.Create directory for parameters file for awrpt input parameters. --Report Type, --Num days --Begin snapshot id --End snapshot id --Reporrt Name This is the mandatory report parameter needs to generate awr report. 2.Create stored procedure. --Change directory name  --Get host_command from one of blog post. --set report path CREATE OR REPLACE PROCEDURE SYSTEM.USP_AUTOMATE...

Oracle 10g Upgrade 10.2.0.1.0 to 10.2.0.4.0 into solaris. 1.Download file p6810189_10204_Solaris-64.zip for upgrade patch. 2.Copy file to one location and unzip. mkdir -p /oracle1/10204 unzip p6810189_10204_Solaris-64.zip 3.Create one response.rsp file for input parameter. Sample file, Copyright (c) 1999, 2004 Oracle. All rights reserved.          ## ##                                                                ## ## Specify values for the variables listed below to customize     ## ## your installation.                                             ## ##                        ...