isql error with LANG environment variable in sybase

Issue:

Try to connect the SYBASE database using isql or isql64 command getting below error

Operating System = SUSE LINUX 12 SPS02

Sybase  ASE         = 15.7 Version

" The Context allocation routine failed when tried to load localization file!

   one or more following problem may caused the failure

  Your sybase Home Directory is /sybase/<SID> .Check the environment variable SYBASE if it     is not the one you want!

  Using local name 'POSIX' define in environment variable LANG 

  Local name "POSIX" doesn't exist in your /sybase/<SID>/locales/locales.dat file

 An error occurred when attempting to allocate localization -related structures."



Screen Shot :

Solution:

set the Environment Variable LANG variable appropriately for the region you're in.

Example :
india means

export LANG=en_US.UTF-8

How to increase the dialog work process run time

Follow the steps to increase the Dialog Work Process Runtime.

1. Execute the Transaction RZ11.

2. Enter the parameter name ---> rdisp/max_wprun_time click --> display.

3. Now you get the below screen,Click the change value and enter the desired time.

4. Do not Set the value to 0 as it will make the Dialog Work Process Runtime = unlimited.

5. Click Display and change value .

6. Default value is 600 sec =10 Min ,Now i changed to 20Min =1200 sec.

7. This parameter is Dynamic parameter change values affected immediately no need to Restart the SAP Application server. but its for temporally make changed in RZ10 transaction then only permanent change affected to the System.

8.more Details Refer the Snote : 25528. 

Install SAP HANA 2.0 SP01 Database in SUSE Linux 12 SP02

How to install SAP HANA 2.0 SPS01 Version on SUSE Linux 12 SP02.

Prerequisites  for install HANA 2.0 :

Refer the below SAP Snotes before install the SAP HANA 2.0 :

2404375 - SAP HANA platform 2.0 SPS 01 Release note.

2205917 - SAP HANA DB Re commanded OS settings for SUSE Linux 12.

2235581 - SAP Supporting Operating System.

2399995 - Hardware requirements for SAP HANA 2.0 SPS01.

Software Download :

SAP HANA 2.0 Media file from SAP market place .

SAP IN-MEMORY(SAP HANA) ---> HANA PLATFORM EDITION ---> SAP HANA PLATFORM EDITION ---> HANA PLATFORM EDITION 2.0 --> INSTALLATION

SAP HANA CD LABLE

51052030_1 to 51052030_4

Before install SAP HANA 2.0 Check the memory allocation

Then Check OS Version also :

SAP STANDARD OR RECOMMENDED FILE SYSTEM FOR SAP HANA 2.0

Directory                                    Details

   /                                                Root Directory

/hana/shared                              sapmnt path

/hana/data/SID                          hana data volume directory
/hana/log/SID                            hana log volume directory

/usr/sap                                      system instance

HANA Database installation

SAP HANA 2.0 SPS01 in a multi tenant database will be the only operation mode for SAP HANA database

Extracting the software dump file.

before that provide FULL authorization for SAP HANA Software directory

Run the setup file.

After extract the SAP HANA Dump file find the folder HDB_LCM_LINUX_X86_64  in this folder

execute the

./hdblcmgui

The hdblcmgui  is a HANA Database Life cycle Manager (hdblcm) GUI

Select the component and component location the click "NEXT"

Choose New installation Click "next"

Select SAP HANA CLIENT  DATABASE  and if you need SAP HANA STUDIO mark and Choose "NEXT"

Choose Single system host

Choose the SAP HANA installation standard Directory

Enter the Instance and DB SID,DB HOSTNAME,

Check Hostname

Enter the HDBADM PASSWORD

Enter the SAP HANA SCHEMA and ADMIN USER SYSTEM password.

Also enter the SAPADM user master Password

Check the Overview of input details

Installation Started

SAP HANA 2.0 SPS01 installed sucessfully.

.

  

How to Reset TMSADM

Procedure to reset TMSADM user:

If you want to reset user TMSADM to the default,or if the configuration of this was damaged, then

1. Logon on to the 000 client with superuser (SAP*,DDIC)

2. Call the Transaction STMS

3. Choose Overview ---> Systems.The system overview appears.

4. Choose Extras--> Reset Users

5. The want to Regenerate the RFC with Standard user name and password

6.Choose Extras ----> Regenerate RFC.

Configure SAP GUI Logon screen information

Configure the SAP GUI LOGIN screen information.

Follow the steps to configure.

Goto -->SE61

Choose the  Document Type : General Text

Language                                : English

Create Document name         : ZLOGIN_SCREEN_INFO

click to Create the Document.

Type the Message what you want to display area in SAP GUI Login Page,

Example : @0S@ Message and @1A@Message.

Save the information to particular package or local object.

Now we will get below information what we configure in Se61 -->Zlogin_screen_info document.

step by step procedure to take system copy in SAP

Step by Step procedure to take System copy in SAP system.
1. I am going to take SAP ERP 6.0 EHP5 System follow the below steps.

Choose System Copy ---> Source System Export --> Database instance Export.

2. Select the New installation.

the choose -- > next

3. Select the current instance profile.

4. Enter the Current System <SID>adm Password.

5. Check the Current SAP Database <SID> (DBSID)

6. Select the Export location during the installation of the target system.

7. SAP system handling the non- standard abap  objects using this SMIGR_CREATE_DDL  to create DDL file tcode se38 .

    Choose the DDL file location or if you not created choose NO and continue.

8. Impotent selection screen here you can decide to if you want to migrate the DB choose the Target Database Type.If not required to migrate the DB hit enter to move next step.

9. SAP system extended export option choose New Export from Scratch

10. Split tool parameter step if you need to make changes in split tables change it or else leave standard selection. 

11. Here Database Export and unicode selection unicode must in little endian  parallel jobs user defined.

12 . Parameter summary here if you want to change before enter the option we can made it here.

13. System Export phase screen its take time based on your database data and system performance.

14.Successfully Exported the system copy file for ERP6.0 EHP5 system ready to build the new system.

Note : Import the Export system copy file same here choose target system and use this system copy file to install.

MAXDB get online and offline command

Here are the correct dbmcli commands to Start | Stop | Restart

Start DB:

dbmcli -d <db_name>-u<db_user>,<db_password>db_online


Stop DB:

dbmcli -d <db_name>-u<db_user>,<db_password>db_offline

Restart DB:

dbmcli -d<db_name>-u<db_user>,<db_password>db_online

Want to do admin task in MAXDB run the below command

ADMIN :

dbmcli -d<db_name>-u<db_user>,<db_password> db_admin

This are the basic commands  .

Upgrade steps for MAXDB

Please follow the below steps to upgrade the MAXDB Database.

1. First of all stop the SAP System and Services.

2. Then Check the Present Version of the SAP MAXDB database.

     Login to the MAXDB Database switch to sqd<SID> user.

     view the version

      sdbregview -l

3. Stop the Database using below commands.

    dbmcli -d<db_name> -u <dbmuser>,<password> db_offline

4. Upgrade steps

   login database host as root user.(not in a sqdadm)

   

   SDBUPD -d <db_name>-u<db_user>,<password>

5.

Upgrade finished.

6. Check the MAXDB Version

login to sqd<SID> user

sdbuninst -l

7. After check the version now ready to use

8. Start the SAP service and SAP system,

How to reset SAP* and DDIC password in MSSQL Server

Reset the SAP* and DDIC password in MSSQL Server using sql query,

1. log in to the Microsoft SQL server.

2. Enter the NEW QUERY.

3. Execute the below Query 

select * from ABC.abc.USR02 where MANDT='000' and BNAME='SAP*'

Result

MANDT       BNAME

000                 SAP*

ABC = SID(database ID)

4.Reset the SAP* and DDIC Password.

delete from ABC.abc.USR02 where MANDT='000' and BNAME='SAP*'

Result

MANDT     BNAME

simply delete the user in particular client the SAP* and DDIC user password has been reset to standard password.

User name     Password

SAP*             PASS,06071992
DDIC            19920706