Renewing SAP Router License

Hi All,
Here are the Steps of renewing the SAP Router License.

Step1: Login as sncadm user. Take a Backup of folder where SAP Router is installed.
Ex: D:\usr\sap\saprouter to D:\usr\sap\saprouter_backup.

Step2: Execute the below command

sapgenpse get_pse -v -r certreq1 -p local.pse

It will ask for PIN, so enter any 4 digit number and remember this, as you may need it in at other places during renewal. Easy to remember code is 1234.

Also enter the distinguish name.(You can find the distinguish name at https://websmp203.sap-ag.de/saprouter-sncadd )

Now copy the content of “certreq“ .(Either to the clipboard or to the notepad)

Step3: At Service Market Place logon to https://websmp203.sap-ag.de/saprouter-sncadd -----> SAPRouter Certificates -----> Apply Now.

On the next page Click on "Continue"

After that Paste the Contect into the Edit Box(Paste the content from -----BEGIN CERTIFICATE REQUEST----- to -----END CERTIFICATE REQUEST----- ).

Now Click on "Request Certificate".

Copy the entire content of the Certificate from Begining to End to a text file named “srcert.txt“ and copy this file to the same location where it was present. Rename it to "srcert".

Ex: D:\usr\sap\saprouter

Step4: Install the certificate in our saprouter by running

:\usr\sap\saprouter>sapgenpse.exe import_own_cert -c srcert -p local.pse

Now we have to create the credentials for the SAProuter with command

:\usr\sap\saprouter>sapgenpse seclogin -p local.pse -O

This will create a file called cred_v2 in the same directory.

Step5: Check if the certificate has been imported correctly

:\usr\sap\saprouter>Sapgenpse get_my_name -v -n Issuer

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.