Find in this Blog

Saturday, December 26, 2020

COPY OLD SID to NEW SID SAP HANA+LINUX

COPY OLD SID to NEW SID SAP HANA+LINUX+SUSE

Step 1 : Add new user entry to  > 

testdbr:# cat /etc/passwd

       vi /etc/passwd

eg: s4xadm:x:1004:1002:SAP System Administrator:/home/s4xadm:/bin/csh

Step 2 Create folder Based on new SIDADM

----------------------------------------------

testdbr:/usr/sap # mkdir -p /home/s4xadm


Step 3 Set Password new SID user 

-----------------------------------------------

testdbr:/usr/sap # passwd s4xadm


Step 4 Copy SID folder to New SID & change DEVMSG"XX" ASCS"XX" Udate Ownership aswell 

------------------------------------------

testdbr:/usr/sap#     cp BIS  >>  S4X

testdbr:/usr/sap #    chown -R s4xadm:sapsys //usr/sap/S4X/

testdbr:/sapmnt #     cp BIS >> S4X

testdbr:/sapmnt #          chown -R s4xadm:sapsys //sapmnt/S4X/


Step 5 Create symbolic link

--------------------------------

Remove existing link... and create New go to (/usr/sap/S4X/SYS)

testdbr:/usr/sap/S4X/SYS ~ # ln -s /sapmnt/S4X/global global

testdbr:/usr/sap/S4X/SYS ~ #  ln -s /sapmnt/S4X/profile profile


Go to >>

testdbr:cd /usr/sap/S4X/SYS/exe 

ln -s /sapmnt/S4X/exe/uc uc

ln -s /usr/sap/S4X/SYS/exe/dbg run

ln -s /sapmnt/S4X/exe/nuc nuc

ln -s /sapmnt/S4X/exe/uc/linuxx86_64 dbg


Step 6 Copy ENV from Old SID to New SID(s4x)  

-------------------------------------------------------------------------------------------------

testdbr:~ #          cd /home/bisadm/

testdbr:/home/bisadm #  cp -pr .sap* .csh* .prof* .dbenv* /home/s4xadm/

testdbr:/home/bisadm #  cp -pr * /home/s4xadm


Step 7Change Owner to (new user)

----------------------------------------------

testdbr:/home/bisadm #    chown -R s4xadm:sapsys /home/s4xadm

testdbr:s4xadm 58>       cd /home/s4xadm/ 

update ENV file value 

testdbr:s4xadm 58>               vi .sapenv.csh

Replace with new SID value :%s/BIS/S4X/g

:wq

Step 8 Rename profile name with SID

------------------------------------

testdbr:bisadm 27>/ cdpro

BIS_DVEBMGS00_testdbr >>>> S4X_DVEBMGS56_testdbr

BIS_ASCS01_testdbr   >>>> S4X_ASCS55_testdbr


Edit all 3 profile including default ,replace all profile value and instance value based on new ( delete logs from work directory

recheck all profile value updated to new


Step 9 Create New user store list 

--------------------------------------------

hdbuserstore list

hdbuserstore DELETE DEFAULT

hdbuserstore set DEFAULT testdbr.xxxx.local:30215@BIH SAPGBP testest.

Step 10 Update cat /etc/services


sapmsS4X        3655/tcp        # SAP System message Server Port (ASCSPORT)

Check the Kernel version compatible with NetWeaver version.

Clean the /tmp folder and reboot the server 


Step 11

startsap  (make sure source SID is stopped)



“Celebrating Work”

 Yoonus Changoth


Saturday, November 14, 2020

SLES 15 SP1 UPGRADE TO SP2 single step ---Upgrading with Zypper

#Upgrading with Zypper

When performing the Service Pack migration, YaST will install all recommended packages. Especially in the case of custom minimal installations, this may increase the installation size of the system significantly.

To change this default behavior and allow only required packages, adjust the solver.onlyRequires option in /etc/zypp/zypp.conf.


</ vi /etc/zypp/zypp.conf


solver.onlyRequires = true

installRecommends=false


Make sure SUSE connect is available with the system .

Register your SUSE Linux Enterprise machine if you have not done so:

sudo SUSEConnect --regcode YOUR_REGISTRATION_CODE


Run zypper migration:

</sudo zypper migration


Executing 'zypper patch-check --updatestack-only'

Refreshing service 'Basesystem_Module_15_SP1_x86_64'.
Refreshing service 'Desktop_Applications_Module_15_SP1_x86_64'.
Refreshing service 'SAP_Applications_Module_15_SP1_x86_64'.
Refreshing service 'SUSE_Linux_Enterprise_High_Availability_Extension_15_SP1_x86_64'.
Refreshing service 'SUSE_Linux_Enterprise_Server_for_SAP_Applications_15_SP1_x86_64'.
Refreshing service 'Server_Applications_Module_15_SP1_x86_64'.
Building repository 'SLE-Module-Basesystem15-SP1-Pool' cache .......................................................................................................................................[done]
Retrieving repository 'SLE-Module-Basesystem15-SP1-Updates' metadata ...............................................................................................................................[done]
Building repository 'SLE-Module-Basesystem15-SP1-Updates' cache ....................................................................................................................................[done]
Building repository 'SLE-Module-Desktop-Applications15-SP1-Pool' cache .............................................................................................................................[done]
Retrieving repository 'SLE-Module-Desktop-Applications15-SP1-Updates' metadata .....................................................................................................................[done]
Building repository 'SLE-Module-Desktop-Applications15-SP1-Updates' cache ..........................................................................................................................[done]
Building repository 'SLE-Module-SAP-Applications15-SP1-Pool' cache .................................................................................................................................[done]
Retrieving repository 'SLE-Module-SAP-Applications15-SP1-Updates' metadata .........................................................................................................................[done]
Building repository 'SLE-Module-SAP-Applications15-SP1-Updates' cache ..............................................................................................................................[done]
Building repository 'SLE-Product-HA15-SP1-Pool' cache ..............................................................................................................................................[done]
Retrieving repository 'SLE-Product-HA15-SP1-Updates' metadata ......................................................................................................................................[done]
Building repository 'SLE-Product-HA15-SP1-Updates' cache ...........................................................................................................................................[done]
Building repository 'SLE-Product-SLES_SAP15-SP1-Pool' cache ........................................................................................................................................[done]
Retrieving repository 'SLE-Product-SLES_SAP15-SP1-Updates' metadata ................................................................................................................................[done]
Building repository 'SLE-Product-SLES_SAP15-SP1-Updates' cache .....................................................................................................................................[done]
Building repository 'SLE-Module-Server-Applications15-SP1-Pool' cache ..............................................................................................................................[done]
Retrieving repository 'SLE-Module-Server-Applications15-SP1-Updates' metadata ......................................................................................................................[done]
Building repository 'SLE-Module-Server-Applications15-SP1-Updates' cache ...........................................................................................................................[done]
Loading repository data...
Reading installed packages...

Considering 10 out of 393 applicable patches:
Category    | Updatestack
------------+------------
security    | 1
recommended | 9

10 patches needed (1 security patch)

Executing 'zypper --no-refresh patch --updatestack-only'

Loading repository data...
Reading installed packages...
Resolving package dependencies...

The following 2 NEW packages are going to be installed:
  libyaml-cpp0_6 libzstd1

The following 10 NEW patches are going to be installed:
  SUSE-SLE-Module-Basesystem-15-SP1-2020-1026 SUSE-SLE-Module-Basesystem-15-SP1-2020-1611 SUSE-SLE-Module-Basesystem-15-SP1-2020-1637 SUSE-SLE-Module-Basesystem-15-SP1-2020-1869
  SUSE-SLE-Module-Basesystem-15-SP1-2020-2040 SUSE-SLE-Module-Basesystem-15-SP1-2020-2818 SUSE-SLE-Module-Basesystem-15-SP1-2020-3285 SUSE-SLE-Module-Basesystem-15-SP1-2020-432
  SUSE-SLE-Module-Desktop-Applications-15-SP1-2020-1611 SUSE-SLE-Module-Desktop-Applications-15-SP1-2020-1869

The following 15 packages are going to be upgraded:
  PackageKit PackageKit-backend-zypp PackageKit-lang libpackagekit-glib2-18 libsigc-2_0-0 libsolv-tools libyui-ncurses-pkg9 libyui-qt-pkg9 libzypp python3-solv typelib-1_0-PackageKitGlib-1_0
  yast2-pkg-bindings zypper zypper-log zypper-needs-restarting

15 packages to upgrade, 2 new.
Overall download size: 7.4 MiB. Already cached: 0 B. After the operation, additional 1.8 MiB will be used.
Continue? [y/n/v/...? shows all options] (y): y

Executing 'zypper  refresh'

Repository 'SLE-Module-Basesystem15-SP1-Pool' is up to date.
Repository 'SLE-Module-Basesystem15-SP1-Updates' is up to date.
Repository 'SLE-Module-Desktop-Applications15-SP1-Pool' is up to date.
Repository 'SLE-Module-Desktop-Applications15-SP1-Updates' is up to date.
Repository 'SLE-Module-SAP-Applications15-SP1-Pool' is up to date.
Repository 'SLE-Module-SAP-Applications15-SP1-Updates' is up to date.
Repository 'SLE-Product-HA15-SP1-Pool' is up to date.
Repository 'SLE-Product-HA15-SP1-Updates' is up to date.
Repository 'SLE-Product-SLES_SAP15-SP1-Pool' is up to date.
Repository 'SLE-Product-SLES_SAP15-SP1-Updates' is up to date.
Repository 'SLE-Module-Server-Applications15-SP1-Pool' is up to date.
Repository 'SLE-Module-Server-Applications15-SP1-Updates' is up to date.
All repositories have been refreshed.
command 'zypper --no-refresh --non-interactive install --no-recommends --auto-agree-with-product-licenses -t product sle-module-python2' failed
Can't install release package for registered product sle-module-python2
SUSE::Connect::ZypperError: No provider of 'sle-module-python2' found.
Calling SUSEConnect rollback to make sure SCC is synchronized with the system state.
Starting to sync system product activations to the server. This can take some time...
Available migrations:

    1 | SUSE Linux Enterprise Server for SAP Applications 15 SP2 x86_64
        Basesystem Module 15 SP2 x86_64
        Desktop Applications Module 15 SP2 x86_64
        Python 2 Module 15 SP2 x86_64
        Server Applications Module 15 SP2 x86_64
        SUSE Linux Enterprise High Availability Extension 15 SP2 x86_64
        SAP Applications Module 15 SP2 x86_64


[num/q]:1

Executing 'snapper create --type pre --cleanup-algorithm=number --print-number --userdata important=yes --description 'before online migration''

The config 'root' does not exist. Likely snapper is not configured.
See 'man snapper' for further instructions.
Upgrading product SUSE Linux Enterprise Server for SAP Applications 15 SP2 x86_64.
Upgrading product Basesystem Module 15 SP2 x86_64.
Upgrading product Desktop Applications Module 15 SP2 x86_64.
Upgrading product Python 2 Module 15 SP2 x86_64.
Upgrading product Server Applications Module 15 SP2 x86_64.
Upgrading product SUSE Linux Enterprise High Availability Extension 15 SP2 x86_64.
Upgrading product SAP Applications Module 15 SP2 x86_64.



The following 6 products are going to be upgraded:
  SUSE Linux Enterprise Server for SAP Applications 15 SP1  15.1-0 -> 15.2-0
  SUSE Linux Enterprise High Availability Extension 15 SP1  15.1-0 -> 15.2-0
  Basesystem Module                                         15.1-0 -> 15.2-0
  Desktop Applications Module                               15.1-0 -> 15.2-0
  SAP Applications Module                                   15.1-0 -> 15.2-0
  Server Applications Module                                15.1-0 -> 15.2-0

The following 8 packages are going to be downgraded:
  libsolv-tools libzypp python3-solv xdg-utils yast2-xml zypper zypper-log zypper-needs-restarting

The following 2 packages are going to change architecture:
  liblouis-data        x86_64 -> noarch
  snapper-zypp-plugin  noarch -> x86_64

The following 5 packages require a system reboot:
  glibc kernel-default-5.3.18-24.37.1 libopenssl1_1 systemd udev

902 packages to upgrade, 8 to downgrade, 186 new, 33 to remove, 2 to change arch.
Overall download size: 642.3 MiB. Already cached: 0 B. After the operation, additional 558.9 MiB will be used.

    Note: System reboot required.
Continue? [y/n/v/...? shows all options] (y): y


Executing %posttrans scripts .............................................................
There are running programs which still use files and libraries deleted or updated by recenfrom the latest updates. Run 'zypper ps -s' to list these programs.

Core libraries or services have been updated.
Reboot is required to ensure that your system benefits from these updates.
adobeqas:~ # reboot

Thanks
Yoonus




Thursday, November 12, 2020

447: backup could not be completed: [110203] Not all data could be written: Expected 4096 but transferred 0


EMC NOTWORKER 19X

====================

 cat /nsr/applogs/nsrsapsv_GBP_2020_11_12.16_13_01_158295.log

* 447: backup could not be completed: [110203] Not all data could be written: Expected 4096 but transferred 0, [110515] Backint missing software version tag SQLSTATE: HY000

(pid = 158295) (11/12/20 16:12:48.511314) The '/usr/sap/GBP/HDB00/exe/hdbsql' program exited with error status 3.

The backup for 'GBP:SYSTEMDB' failed.

* 447: backup could not be completed: [110515] Backint missing software version tag, [110203] Not all data could be written: Expected 4096 but transferred 0 SQLSTATE: HY000

(pid = 158295) (11/12/20 16:13:01.315609) The '/usr/sap/GBP/HDB00/exe/hdbsql' program exited with error status 3.

The backup for 'GBP:GBP' failed.

(pid = 158295) (11/12/20 16:13:01.315876) At least one of the database backups failed.

(pid = 158295) (11/12/20 16:13:01.316048) NMSAP full backup failed.



Solution: 
set the initSID.utl set like below


biprddb:/usr/sap/GBP/SYS/global/hdb/opt # cat initGBP.utl

NSR_CLIENT=biprddb.TXR.LOCAL
NSR_DATA_DOMAIN_INTERFACE=IP
NSR_DEVICE_INTERFACE=DATA_DOMAIN
NSR_PARALLELISM=24
NSR_SERVER=emcbkp137.TXR.local


Thanks
Yoonus



Sunday, November 8, 2020

CIF share Auto mount command on linux

 How to enable auto mount after reboor the Linux system.?

Add below entry to fstab 

//192.168.77.24/linux24 /LINUX24 cifs username=admin,password=test,dir_mode=0777,file_mode=0777,nounix

Execute: command 

mount all



Thanks

Yoonus

Thursday, July 2, 2020

SAP LINUX cmds

Mount the shard directory
 ==========================


 mount -t cifs -o username=administrator,password=Pxxs87sw0rd,dir_mode=0777,file_mode=0777,nounix //192.168.07.118/BWBKP /BWBKP


 
 sap service starting command
 ================================

 sapcontrol -nr 01 -function StartSystem ABAP


 check the sap runnin process
 ===========================

 ps -ef | grep sap



 start sap services
 =====================

 sapcontrol -nr 02 -function StartSystem ALL




 To start SAP services
 ========================

 /usr/sap/GuP/D01/exe/sapstartsrv pf=/usr/sap/GEu/SYS/profile/GuP_D01_s4hsrvr-glb -D -u gupadm &



 sapcontrol -nr 03 -function StartService GuP


Monday, January 13, 2020

3 PAR HARDISK ADDING AND TUNING


3par hdd replacement commands

1)insert the new hdd and type the below command.
>starttask admithw -notune –ni

2)check status
>servicemag status -d
>show task
>showpd



Thanks
Yoonus

Friday, January 10, 2020

ORA-04024: self-deadlock detected while trying to mutex pin cursor 0xC1F2B19A8, ORA-01092: ORACLE instance terminated. Disconnection forced

Restoring Issue: Generated below error


ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-04024: self-deadlock detected while trying to mutex pin cursor 0xC272AF8B8
Process ID: 5473
Session ID: 384 Serial number: 35520


Reason:

It is a know  bug in Release 12.1.0.2.0. 

To clear this please apply below "_fix_control" parameter in SP file  and start restore again with new file , because once  you applied the logs,  recreating log file sequence will be changed , it will prompt the non generated archive file, avoid that restore your file from scratch and create control file again and try to recover.

SQL> alter system set “_fix_control”=’9550277:ON’;

This is the required Fix control parameter  but apply along with below Fix control parameter.

ALTER SYSTEM SET "_fix_control"=
"20107874:OFF",
"20355502:8",
"22540411:ON",
"7324224:OFF",
"7168184:OFF",
"8937971:ON",
"13077335:ON",
"13627489:ON",
"14255600:ON",
"14595273:ON",
"18405517:2",
"5099019:ON",
"5705630:ON",
"6055658:OFF",
"6120483:OFF",
"6399597:ON",
"6430500:ON",
"6440977:ON",
"6626018:ON",
"6972291:ON",
"7658097:ON",
"9196440:ON",
"9495669:ON",

"9550277:ON" scope=spfile;


Thanks
Yoonus