All posts by Muhammad Rawish Siddiqui

Oracle Database Upgrade – from 11.2.0.3 to 12c –

  Last Week I performed Oracle Database Upgrade from 11.2.0.3 to 12c and would like to share Upgrade document. This upgrade document does not include prerequisite and post requisite, which I would try to compile and upload soon. Document Link is as under: Oracle Database 12c Upgrade with screenshots  

Read More

ORA-19566: exceeded limit of 0 corrupt blocks for file ….. found same corrupt data (r12)

ORA-19566: exceeded limit of 0 corrupt blocks for file ….. found same corrupt data Yesterday, during RMAN (11g) backup the aforementioned issue was raised and resolved by following the enclosed Document. Error: ORA-19566: exceeded limit of 0 corrupt blocks for file /oracle/PROD/db/apps_st/data/system09.dbf Alert Log Entry: Reread of blocknum=165656, file=/oracle/PROD/db/apps_st/data/system09.dbf. found same corrupt data Dont forget to […]

Read More

Oracle eBusiness Export Function Stopped Working (11i export report to Excel)

Everything was okayed before and now the aforesaid issue occurs. Login to SQL*Plus as apps user and run the following: set serveroutput on declare db_file NUMBER; mime_type VARCHAR2(255) := ‘text/plain’; out_string VARCHAR2(32767) := ‘Just some plain text that is stored.’; web_server_prefix VARCHAR2(500); url VARCHAR2(500); begin db_file := fnd_gfm.file_create(content_type => mime_type, program_name =>’export’); fnd_gfm.file_write_line(db_file, out_string); db_file := fnd_gfm.file_close(db_file); […]

Read More

eBusiness 11i/R12 – Daily Checks (for Apps. DBA) – Admin Node

For daily checks ( Health Check on Admin/Concurrent Manager Node click on this link eBusiness 11i/R12 – Daily Checks (for Apps. DBA) – Admin Node .

Read More

eBusiness NLS Patch u6678700.drv (12.1.1) Takes Too Much Time as compare to u6078836.drv (12.0.4) – Oracle Bug

Bug 8520057 – 12.1.1 NLS PATCHING HAS INCREASED IN TIME OVER 12.0.4  Follow the Note : 839978.1 (12.1.1 NLS Upgrade Patch 6678700 : Performance Installation Issues With XLIFFImporter Java Jobs)  The issue is caused by the time delay spent in connection time within each Java job.  Abort the session and apply the patch : 8576725 […]

Read More

File Attachment in Linux using MAIL/SENDMAIL – How to Send eBusiness 11i/r12 DB Status on Daily Basis

Assumption The rpm sharutils-4.2.1-17.i386.rpm is already there. Verify the same, as followed: rpm –qa sharutil*  If not, download and install sharutils-4.2.1-17.i386.rpm by the following, as it is mandatory: rpm -ivh sharutils-4.2.1-17.i386.rpm. DB Check Script is already implemented and scheduled. As root user, schedule the following script: #!/bin/bash FILE=dbchk.doc FILE2=output.html RECIPIENT=rawishsiddiqui@yahoo.ca RECIPIENTCC=oracle@******.com RECIPIENTBCC=rsiddiqui@*****.com ( echo “Dear […]

Read More

File in patch is not a known Oracle Applications file: NLS Patching Issue

Follow the Subsequent in order to avoid the aforementioned Error: 1. License Language from OAM – Login with User, having SYSADMIN Responsibility – Oracle Application Manager (Under System Administration)  – License Manager- Under Application Dashboard/Site Map (License Manager) -> . . . Languages -> Edit- Choose Required Language -> Next -> Next . . When you get the message […]

Read More

Listener Security – Important Tips

Turn on Logging In order to know, which listener commands were executing, one should enable the logging by the following: LSNRCTL> set log_directory  …/log LSNRCTL> set log_file Listener_<sid name>.log LSNRCTL> set log_status on LSNRCTL> save_config Set the Listener Password Setting Listener Password is strongly recommended in order to prevent the distinct attacks. There are two […]

Read More

Steps / How to Migrate Non ASM Instance Database to ASM Instance

NOTE: Always Do Exercise on Test Environment, First.  Assumptions :  1. ASM Instance is already Created and Ready to Use. 2. DB Instance was Started using ‘spfile’ 3. Disk Group Name : ‘+DGDATA’  – Set the Parameter ‘db_create_file_dest’ to ‘+DGDATA’   alter system set db_create_file_dest=’+DGDATA’ scope=spfile; – Set the Parameter ‘control_file’ to the destination in ASM […]

Read More

Error: ORA-00354 – (Oracle Hidden Parameter : _allow_resetlogs_corruption)

NOTE: This is One of the Hidden Oracle Parameters. DO NOT use it until and unless instructed by Oracle Support. You are trying to start your DATABASE, you found the aforementioned error i.e. ORA-00354. . Required Action: Perform recovery with a good version of the redo log file or perform cancel-based recovery up to, but […]

Read More
Not found