Home / Oracle Database (page 2)

Oracle Database

Start/Stop Oracle as a service with linux boot

Hi! If you have a Oracle database, and want to start it and shut it down, together wit the start/shutdown of the OS, follow the steps below. In my case, i am using Oracle Linux. Create a file, for example “ora_start_sid” in the folder “/etc/init.d”: vim /etc/init.d/ora_start_sid Enter the content …

Read More »

SAP Note 1171650 Application

SAP Note 1171650 1171650 – Automated Oracle DB parameter check Sometimes it’s necessary to do some maintenance in old databases. And in this particular case I needed to do an Oracle Database Parameter Check from SAP Note 1171650. Database Version: Oracle 10.2 Script: parameter_check_102.txt for Oracle release 10.2 I tried …

Read More »

Trigger Trick

Today more and more SAP on oracle systems are integrated with SAP SLT. SLT creates lots of oracle triggers to do the data replication, but previously database trigger was not often used in SAP oracle environment, so things changed. Common errors caused by primary sql (sql not in trigger) can …

Read More »

System copy-import fails with error ORA-01452

Hi Folks,   When doing system copy import for oracle database, sometime we are hitting error “ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found”.   The description of  ORA-01452 clearly tells us there are duplicate keys in the table, you cannot create unique index. As the name “unique index” means …

Read More »

Oracle12c Upgrade

SAP has certified Oracle12c for Business Suite and present DB’s now can be upgraded to Oracle12c. To upgrade to Oracle12c in your environment you need to go through below phases for smooth upgrade . Documents have been published for each phase so that it’s easy to identify all the phases …

Read More »

Best Practices for SAP on Oracle

 Oracle Installation and Upgrade SAP Installation on Oracle In the Installation central page you can find several comprehensive technical documents organized by area and release. Master, Installation, Upgrade Configuration and System Copy Guides are available. Note that whenever an SAP Installation takes place there are several pre-requirements that should be …

Read More »

Upgrade Methods for Upgrading to Oracle Database 11g Release 2

Database Upgrade Assistant (DBUA) Manual Upgrade Oracle Data Pump Export Standard Import / Original Export and Import Oracle Transportable Tablespaces Oracle Data Guard SQL Apply (Logical Standby) Each method has its pros and cons, which are described in detail in the Oracle White paper 486336 (http://www.oracle.com/technetwork/database/upgrade/11gr2-upgrade-methods-wp-2011-486336.pdf). For low and medium …

Read More »

user is not must for 12.1c single instance

Hi Folks, Migrate to <oracle> user is seemingly a mandatory step in current version of SAP oracle 12c upgrade guide, but still some people do not want to migrate to oracle user for reasons. SAP note 1915323 clearly mentions <orasid> is still supported in oracle 12.1 version, it is not …

Read More »

MISSING9999 datafile is found in v$datafile

There is one case which took me even more than 1 hour to find correct way to fix it. The symptom is quite simple: – We found there is one datafile in v$datafile has name of ‘MISSING9999’. – DBA_DATA_FILES shows following: FILE_NAME FILE_ID TABLESPACE_NAME BYTES STATUS ONLINE_STATUS /oracle/SID/102_64/dbs/MISSING00054 54 PSAPSR3 …

Read More »

Block corruption – Tool

Hello all, I recently released a tool in a shell script that aims to help with corrupted blocks. Of course it can only help with the recovery process itself, as it will still need a good backup of the database. To identify corrupted blocks and recover them is both critical …

Read More »

Audit log in DBACOCKPIT

Some customers contacting SAP asking for the entry in Audit log. They found in DBACOCKPIT->Diagnostics->Audit log there is no entry. It is a little bit confusing as this audit ONLY audit DBACOCKPIT database configuration change. In online help you can get the detail information: http://help.sap.com/saphelp_nw73/helpdata/en/86/b9650db8c140829b2a5479ecb97088/content.htm?frameset=/en/9d/dc5196ea63429894807646bad3ca9c/frameset.htm For example if you created …

Read More »

Oracle client upgrade on SAP

Hi, This document expains the step by step procedure to upgrade oracle client on SAP. Platform: Source OS- AIX 7.1 Oracle client- 10. Target ORACLE Client- 11.2.0.4 V3 Media Used- 51049326 for ORACLE Client 11.2.0.4 V3 1. create a   dir 11x_64 in /oracle/client os> mkdir -p /oracle/client/11x_64 2. dump the …

Read More »