Encounters of an Enterprise DB Architect

I'm back after a long hiatus! Hopefully, with stuff that you will all appreciate and use, in your day to day activities. So, here goes. Objective To find the maximum number of datafiles for a given instance (instance = database, both are interchangeable, unless we are talking of RAC). Options 1. Using init file: Check the parameter db_files. e.g: SQL> show parameter db_files 2. Using control file: Check the parameter MAXDATAFILES after generating the controlfile trace. eg: CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS ARCHIVELOG MAXLOGFILES 64 MAXLOGMEMBERS 5 MAXDATAFILES 512 MAXINSTANCES 8 MAXLOGHISTORY 14607 3. Execute the below query in sqlplus: SQL> select records_total from v$controlfile_record_section where type='DATAFILE';

I am sure you all know this but this is for those who do not! :) For those who think that the flash version of MOS is slow (including yours truly), Oracle provides the html version of MOS. For those who were accustomed to using the Metalink (when MOS was Metalink and George W Bush was the president of the US of A - not the father, I'm talking about the son) patch search and download page, do not fret. You can use the classic patches window to get the old page (and a lot of memories) back! To open any MOS note id, you can use this link . Only substitute Note ID 221211.1 with the note id that you want to open.

What I have to offer this time is a script using which you can download patches using WGET from Meta.....oops, from My Oracle Support, I should say! This script needs (or accepts) the following parameters: 1. Me...oops...MOS Username 2. MOS (I got it right this time!) password 3. Patch file name 4. ARU Number You can get 3 and 4 in the following way: Using MOS: Query for the particular patch, click on the download link, click on WGET Options on the left side bottom corner and then copy the WGET script to clipboard. That script will have both the patch name and the ARU number. Using HTML (supporthtml.oracle.com): Query for the particular patch, click on the patch, then RIGHT CLICK on the patch zip file link and click on copy shortcut in IE (or copy link location in Mozilla Firefox). This link will have both the patch file name and the ARU number. Using the classic patches window: Query for the particular patch, then RIGHT CLICK on the DOWNLOAD button and click on copy shortcut in IE (or...

In one of my previous posts , I had spoken about creating a reporting database that is editable at the same time, though the edits are transient. The last month, I faced an interesting situation wherein we had to rebuild this reporting database. In this post, I'll talk about rebuild the reporting database when it is corrupted. Context The standby database has been corrupted due to a server crash and needs to be rebuilt from the primary database. Solution I followed the steps mentioned in this post about creating a physical standby database. The steps in the pre-requisites can be skipped because they are already existing. The rest of the steps hold good!

Requirement Create a standby database for the primary production database. Pre-requisites 1. The primary database is in archive log mode. 2. Primary and standby database names: Primary DB Name: PRIM Primary DB Host: primary.hostname.com Standby DB Name: STBY Standby DB Host: standby.hostname.com 3. Initialization parameters required for enabling standby instance to be set on the primary: *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRIM,STBY)' *.LOG_ARCHIVE_DEST_2='SERVICE=STBY LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STBY' *.log_archive_dest_state_2='ENABLE' *.log_file_name_convert='/u001/app/oracle/stby/data/','/opt/apps/prim/data/' *.standby_file_management='auto' *.db_file_name_convert='/u001/app/oracle/stby/data/','/opt/apps/prim/data/' *.fal_client='PRIM' *.fal_server='STBY' *.db_name='PRIM' *.db_unique_name='PRIM' 4. The listener and tnsnames to be modified on the pr...

I am writing this blog entry to share an interesting error with you. There is a parameter ORA_NLS10 without setting which, the database was throwing a lot of ORA-07445 errors. I spoke about the ORA_NLS10 parameter in a previous post. A related issue was occuring here too. Issue Unable to submit concurrent requests. Receiving the below error: APP-FND-01564: ORACLE error 3113 in FDFDDS_RAISE_DFF_COMPILED Also, receiving ORA-07445 errors in the alert log. Mon May 17 05:54:00 2010 Completed: ALTER DATABASE OPEN Mon May 17 05:57:12 2010 Errors in file /u005/app/oracle/cpe2eprd/cpe2eprddb/10.2.0/admin/cpe2eprd_cpeidb/udump/cpe2eprd_ora_1094.trc: ORA-07445: exception encountered: core dump [lfilic()+328] [SIGSEGV] [Address not mapped to object] [0x000000040] [] [] Mon May 17 06:03:18 2010 Errors in file /u005/app/oracle/cpe2eprd/cpe2eprddb/10.2.0/admin/cpe2eprd_cpeidb/udump/cpe2eprd_ora_2966.trc: ORA-07445: exception encountered: core dump [kopxccc()+124] [SIGSEGV] [Address not mapped to obj...

Yesterday, I faced an issue while starting WF Mailer in a development instance. It was a clone from production and was recently patched, during the course of which, autoconfig was also run. Without further ado, let me explain the problem and the solution: Issue Receiving below error while trying to start WF Mailer: [Mar 30, 2010 4:22:44 AM CDT]:1269940964344:Thread[BES Dispatch Thread,5,main]:0:-1:suomt32l:10.6.71.100:-1:-1:ERROR:[SVC-GSM-WFMLRSVC-801965 : oracle.apps.fnd.cp.gsc.SvcComponentContainer.handleComponentEvent(int, String, String)]:Could not start component; performing rollback -> oracle.apps.fnd.cp.gsc.SvcComponentException: Validation failed for the following parameters -> >>>>>>>>>>>>>>{FRAMEWORK_USER=Unable to make a connection with the user and responsibility}.<<<<<<<<<<<<<< Parameters were -> {INBOUND_MAX_IGNORE_SIZE=1000, INBOUND_MAX_LOOKUP_CACHE_SIZE=100, ATTACH_IMAGES=Y, ALL...