Learn SAP Basis easily
After fresh installation of your Oracle Database Software, you may need to install some oracle patches. This article describes how to use OPatch to install Oracle database patches on Windows platforms in an SAP environment. (on UNIX/Linux the steps is almost the same, just change the path). 1. Check your current oracle patch. > cd … Read more
The currently used Oracle Instant Client is not up-to-date and you want to update it to latest supported version. Here are the steps: 1. Identify your current Oracle Instant Client (as described in article How to check Oracle instant Client version). 2. Download the latest supported Oracle Instant Client from SAP. 3. Download deldbclient.vbs, which … Read more
In this article I do Oracle Database Upgrade from Oracle 10.2.0.5 to Oracle 11.2.0.3 in a standalone server. Preparation 1. Check the Original Oracle Version. You can use the following command: >sqlplus -version Or > sqlplus / as sysdba; > select version from v$instance; Or from your SAP -> System -> Status Or from transaction … Read more
There are many ways to startup your Database Instance. In this article I’ll show you step by step to startup your Oracle Database Instance using Brtools. Login as <sid>adm to your operating system. 1. Call Brtools from command prompt and choose 1. Instance management 2.Choose 1. Start up database Start up database 3. Fill your … Read more
Now i’ll show you how to convert Long Raw (LRAW) to LOB online. You can after that do table reorg online once you’ve converted any LRAW field to LOB field. You can do the conversion using brspace. Here I use Oracle 11.2 and brspace 7.00. You can check your table contain LRAW field or not … Read more
In this article I’ll show you how to do table reorganize online using brspace (part of brtools) 7.00 on Oracle 11G. Table reorg Online is one of Oracle feature that is very useful for you as Database Administrator to do reorg and avoid downtime during SAP System operation. In some cases you need to reorganize table online … Read more
In this article I’ll show you how to do table / index compression with brspace (part of brtools). For this example I use Oracle Database 11G (Enterprise Edition). One of the great feature available in Oracle Database 11G is table and index compression (Part of Oracle Advanced Compression) that can reduce your database size significantly. … Read more