Switching Off/On Archive Log in Oracle Database

Hi All,

Login to the system as root, then follow these steps:
-----------------------Switching Archive log Off----------------------------
su - SIDadm
>sqlplus /nolog
>conn sys as sysdba
Enter password: (Press Enter)
>startup mount; (Press Enter)
>alter database noarchivelog; (Press Enter)
> alter database open;

Now Start the SAP Instance only.

-----------------------Switching Archive log On----------------------------

su - SIDadm
>sqlplus /nolog
>conn sys as sysdba
Enter password: (Press Enter)
>startup mount; (Press Enter)
>alter database archivelog; (Press Enter)
> alter database open;

Proceed with starting SAP instance.

Note: Please refer to SAP/Oracle note for exact steps.

SAPCPE.exe Red after kernel Upgrade in SAP NW 7.01 SR1 in Windows

Hi All,

After applying SAP kernel on NW 7.01 SR1 in windows 2003 or 2008 the SAPCPE.exe is red in color and you can login to the SAP gui.

Refer to SAP note number: 1375494

SAP MMC Hangs After Kernel Upgrade in Windows 2008

Hi All,

The SAP MMC hangs after SAP Kernel upgrade in Windows 2008.

Solution: Please refer to SAP note number - 1326097

Adding SAP Datafile using BRTools

Hi All,

In this blog I will tell you how to add a new SAP datafile using BRTools:

In Windows login as SIDADM.

Start --> run --> cmd --> brtools

For Linux and Solaris login as root, then follow these commands:

> su - oraSID > sqlplus /nolog > conn sys as sysdba
Enter password: (Press enter)
Connected.
sql>brtools
---------------------------------------------------
Steps are common once brtools starts:
Step1:
------------------------------------------------------------------------------
BR*Tools main menu

1 = Instance management
2 - Space management
3 - Segment management
4 - Backup and database copy
5 - Restore and recovery
6 - Check and verification
7 - Database statistics
8 - Additional functions
9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
2 ----------------> Enter 2

-------------------------------------------------------------------------------
Database space management

1 = Extend tablespace
2 - Create tablespace
3 - Drop tablespace
4 - Alter tablespace
5 - Alter data file
6 - Move data file
7 - Additional space functions
8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
1 -------------> Enter 1

And then enter c two times.


Step2:
-------------------------------------------------------------------------------
Tablespace extension main menu

1 = Extend tablespace
2 - Show tablespaces
3 - Show data files
4 - Show disk volumes
5 * Exit program
6 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
1 ---------------> Select

After this all the table space will be displayed
Select the tablespace for which you want to add a new datafile.

For example we are trying to add datafile to tablespace "PSAPSR3".

As an example we have selected
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (1. file)

1 * Last added file name (lastfile) ....... [[Drive]:\ORACLE\SID\SAPDATA2\SR3_4\SR3.D
ATA4]
2 * Last added file size in MB (lastsize) . [2000]
3 - New file to be added (file) ........... [[Drive]:\oracle\SID\sapdata2\sr3_5\sr3.d
ata5]
4 # Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [2000]
6 - File autoextend mode (autoextend) ..... [yes]
7 - Maximum file size in MB (maxsize) ..... [10000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPSR3 add dataf
ile 'D:\oracle\SID\sapdata2\sr3_5\sr3.data5' size 2000M autoextend on next 20M m
axsize 10000M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c ---------------> Enter c to continue and create datafiles.
----After that enter n --------------------
BR0675I Do you want to perform this action?
BR0676I Enter 'y[es]' to perform the action, 'n[o]/c[ont]' to skip it, 's[top]'
to abort:
n --------------> Enter n to stop creating another datafile.

It will add a new datafile to it.

Hurray !!!!!!!! You have added a new datafile.



Note: Please refer to the SAP/Oracle note for exact procedure for adding datafile, the blogger is not responsible for any issue arising by using the above blog.

Moving Oracle Datafile Using BRtools in Solaris or Linux

The Following Steps will move the Oracle datafile from old location to new location

• Login as "su - oraSID"
  

• Enter command brtools
  

• Select 2 - Space management.

• Then Select 6 - Move data file.
  

• Select 3 ~ Tablespace names (tablespace) .. []And provide the table space name, Example " PSAPSR3700" etc.
  

• Select 4 ~ Data file names (file) ......... [] and enter the detail of the datafile which you want to move, Example = "/oracle/SID/sapdata1/sr3700_3/sr3700.data3
  

Please note the new destination should have the name starting with "sapdataXX" the location can be any where.

• Enter "c" continue 2 times

• Select 3 ~ Move destination and enter destination, Example=" /oracle/SID/sapdata1/".

• And Select 6 Force instance shutdown and enter yes

• Enter "c"

This is just a simple example and please refer to SAP note for exact steps to move Oracle data file through Brtools