Home / Oracle Database (page 3)

Oracle Database

Rename temporary tablespace with running SAP system

Introduction Sometimes, it is necessary to rename the temporary tablespace. Unfortunately the  temporary tablespace is used by the processes of a sap system. This short blog shows you how to change the temporary tablespace online, without disturbing the sap-system. Scenario The system consists of one database server and 2 application …

Read More »

Oracle and Golden Gate : Oracle Golden gate – Part 1

                                                                                     Oracle Golden Gate Oracle GoldenGate enables the exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms across the enterprise1. Its modular architecture gives you the flexibility to extract and replicate selected data records, transactional changes, and changes to DDL (data definition language2) across a variety …

Read More »

RoadMap to SAP on Exadata

The instalation of SAP Netweaver products, in some situations, could be a little bit hard. Tier 3 instalations must be planned hard before installed.My mentor always says to me: spend 90% of the time planning and 10% of the time executing what you´ve been planned. Then, to help you on …

Read More »

SAP Oracle upgrade 11G to 12C on AIX

                                 SAP Oracle Upgrade 11G to 12C on AIX Summary:- This document contains the steps that how to do the oracle upgrade 11 G to 12 C.  I have gathered the information from some SAP Notes and upgrade document from SAP site.  The following method will reduce the downtime of …

Read More »

ORACLE12C Upgrade: Updating the Oracle Instant Client

Updating the Oracle Instant Client After the upgrade to Oracle 12.1.0.2, it is strongly recommended to install an Oracle client supported for Oracle 12c. If it is not possible to install Oracle client 12.1.0.2 (for example, due to SAP limitations or hardware restrictions), you need at least Oracle client 11.2.0.4. …

Read More »

ORACLE12C Upgrade: Preupgrade steps

ORACLE 12C Pre Upgrade steps 1.0  Extracting Oracle Software 1. mkdir -p /oracle/stage/12102 chmod 755 /oracle/stage/12102 2. To upgrade a single instance database on the file system, you only need to extract the database software that is contained in the first 2 SAR  files OR112164.SAR and OR212164.SAR   Move these …

Read More »

ORACLE12C Upgrade: Post Upgrade Tasks

Post-Upgrade Steps 1. Updating the SQL*Net Configuration Files    Copy back the content from old sqlnet file as per the parameters set in original file   2. Checking the Symbolic Link for Runtime Oracle Home    Procedure Change to the required directory:   cd /oracle/<DBSID>    Check that the following …

Read More »

ORACLE12C Upgrade: Database Upgrade

Oracle Database Upgrade 1. Backing up the Oracle Database    As per your backup strategy take the backup of DB   2. Shutting Down the SAP System stopsap r3 3. Upgrading the Database Structure with the Database Upgrade Assistant    To upgrade the database structure, you need to start the …

Read More »

ORACLE 12C upgrade Prerequisites and Checklist

Prerequisites to upgrade to ORACLE 12c 1. Your DB should have minimum release Oracle Database 10.2.0.5 or higher to upgrade to Oracle Database  12c, any other release less than Oracle Database 10.2.0.5 cannot be directly upgraded to Oracle Database 12c 2. Only Oracle Database 12c Release 1 (12.1.0.2) is supported …

Read More »

Oracle 12c upgrade guides are available from SAP service market place

Hi Folks, The oracle 12c upgrade guides are available from SAP service market place: https://websmp202.sap-ag.de/~sapidb/012002523100005235232015E/Ora_DB_Upgr_UX_121__00.pdf https://websmp202.sap-ag.de/~sapidb/012002523100005235242015E/Ora_DB_Upgr_Win_121__00.pdf Or you can try to access them via root: service.sap.com/swdcinstallation and upgradeinstallation and upgrade guides Database UpgradeOracle Best regards,James

Read More »

Oracle Database Dictionary Statistics Taking Long Time

Performed oracle database upgrade to 11.2.0.4. I was asked to analyze the database dictionary statistics that was taking long during post processing. Customer was not happy that dictionary statistics was taking long time after database upgrade. When executing dictionary statistics using the command below brconnect -u / -c -f stats …

Read More »

Table Data Export With Oracle Tool EXPDP on Windows

Preparations on Oracle 1. Logon to Operating System with SIDADM on Windows, or ORASID on Linux/Unix Systems. 2. Create a logical directory definition where Oracle EXPSP tool will export Table Data sqlplus “/as sysdba” SQL> CREATE OR REPLACE DIRECTORY test_dir AS ‘d:‘; 3. Grant permission to AS Java Schema User …

Read More »

How to recreate PSAPTEMP Tablespace on Oracle

You may find it useful. I did need it for once in my 15 years of Basis Life. 1. Create a new TEMP Tablespace SQL> CREATE TEMPORARY TABLESPACE temp2   2  TEMPFILE ‘/u02/oradata/TESTDB/temp2_01.dbf’ SIZE 5M REUSE   3  AUTOEXTEND ON NEXT 1M MAXSIZE unlimited   4  EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M; Tablespace …

Read More »

SAP Backup restore in symantec netbackup

As i mentioned in the last post, now i share the restore procedure of sap backups that took from symantec netbackup. My environment: OS – HP-UX DB – oracle Backup type – offline restored system – restored in the same system where the backup was performed. Points need to check …

Read More »

Useful Oracle queries for SAP Basis Adminsitrators

Introduction Considerations System variables Database Show Oracle Database version Show database details Show database size Show Oracle Instant Client Version Installed components in Database Instance Show database instance details Monitor instance status of oracle DB Schema for SAP Tablespaces Show tablespaces details List of datafiles for tablespace Find tables being …

Read More »

Various ORA-* errors and solutions&workarounds

Hello everyone, I wanted to share some ORA-* errors which I’ve already faced, and provide solutions or workarounds for them. The list can be expanded with other ORA- error codes. I hope it helps you with your projects. ORA-01756  CLEAR_OLD_REPORTS I have faced this error during installation of support packages. …

Read More »

Oracle Parameter Processes and Sessions

The Oracle Parameter Processes PROCESSES DEFINITION Parameter type Integer Default value Derived from PARALLEL_MAX_SERVERS Parameter class Static Range of values 6 to operating system-dependent Real Application Clusters Multiple instances can have different values. PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its …

Read More »

System refresh using RMAN backup

Below steps are useful if RMAN is configure for Oracle Database backup and you want to do Backup restore using RMAN configuration for system refresh activity. Consideration Database      : Oracle 10g OS                : Linux 1.Ensure db is shutdown in target database Sqlplus “/ as sysdba” Shutdown immediate exit 2.Create …

Read More »

RMAN for SAP BRTOOLS

Important point needs to be consider while configuring RMAN for SAP BRTOOLS. I had to configure RMAN for taking incremental backup of our SAP database by using RMAN. Here i have mentioned point which helped me to connect BRTOOLS to RMAN. create following link first after installing TSM service at …

Read More »

Benchmarking and the single thread

If you work in tech long enough, you get to see a few cycles and turnovers.  I’m not talking about cell phone X to cell phone Y, I’m talking hardware generations.  I started running benchmarks long ago, and have written here on a few forays.  One of the most recent …

Read More »

Oracle home switch and SBP -1

Hi, SAP bundle patches are done every six months once. We have five production systems. To get a downtime for each system and the applying of SBP takes three hour per system. In the below approach i am dong all five systems in three hours time by installing a new …

Read More »