Lupa Password Admin SAP

Masih ingat tulisan tentang kunci ini, hahahah.. disadari atau tidak kadang bahkan sering gw lupa password, ya saking banyak nya password yang harus diingat, password socmed, pass email, pass ATM, dll. Sebagian dari kita men-siasati nya dengan menyamakan semua password nya, one for all,:) , mudah diingat, namun kurang aman, satu ketahuan, ketahuan semua, hahaha… ya memang kembali lagi keamanan biasanya berbanding terbalik dengan kenyamanan :p.

Heheheh,.. kok jadi kemana-mana, jadi ceritanya ini gw lupa password login SAP gw, jangankan password nya, usernya pun lupa, hahaha.. mau ga mau, suka ga suka ya ditempuh jalan reset password nya. Lha trus yang direset password nya user apa? Di SAP yang jadi superadmin nya adalah user sap* (dibaca:sapstar) dan ddic. kali ini gw coba reset untuk user sap* .Kebetulan SAP gw running di RHEL dan make oracle, langkah nya cukup simpel kok :

1. Masuk Database dari level OS,
karena gw make linux, gw masuk lewat ssh pake user root, terus switch user ke user DB admin nya. Setelah itu masuk ke database pake sqlplus

 login as: root
 root@172.16.8.145's password:
 Last login: Sat Aug 22 03:56:07 2015 from bagong.kobong
 [root@rhel57daf ~]#su - oradaf
 rhel57daf:oradaf 24>sqlplus "/as sysdba"
 SQL*Plus: Release 10.2.0.4.0 - Production on Sat Aug 22 03:56:58 2015
 Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
 Connected to:
 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
 With the Partitioning, Data Mining and Real Application Testing options
 SQL>

2. Hapus user sap* dari tabel
SQL> delete from SAPSR3.USR02 where BNAME='SAP*' and MANDT=001;
menghapus user SAP* dari nama tabel USR02 schema SAPSR3, MANDT=001 maksudnya di client SAP 001, bisa diubah sesuai dengan client mana user sap* yang akan direset.

3. Set Parameter di instance profile
edit file profile, berada di /sapmnt//profile, kita edit menggunakan text editor, dan ubah atau tambahkan parameter login/no_automatic_user_sapstar=0, menjadi seperti berikut :

 #.***********************************************************************
 #.* *
 #.* Instance profile DAF_DVEBMGS00_RHEL57DAF *
 #.* *
 #.* Version = 000002 *
 #.* Generated by user = SAP* *
 #.* Generated on = 30.04.2015 , 19:36:15 *
 #.* *
 #.***********************************************************************
 #parameter created by: SAP* 30.04.2015 19:30:15
 login/no_automatic_user_sapstar = 0
 SAPSYSTEMNAME = DAF
 SAPSYSTEM = 00
 INSTANCE_NAME = DVEBMGS00
 DIR_CT_RUN = $(DIR_EXE_ROOT)/run
 DIR_EXECUTABLE = $(DIR_INSTANCE)/exe
 exe/saposcol = $(DIR_CT_RUN)/saposcol

4. restart system SAP
bisa melalui user system admin nya, <SID>adm

 [root@rhel57daf ~]# su - dafadm
 rhel57daf:dafadm 12>stopsap
 Checking DAF Database
 ------------------------------
 ABAP Database is running
 Stopping the SAP instance DVEBMGS00
 ----------------------------------
 Shutdown-Log is written to /home/dafadm/stopsap_DVEBMGS00.log
 Instance on host rhel57daf stopped
 Waiting for cleanup of resources.....................
 Running /usr/sap/DAF/SYS/exe/run/stopdb
 Trying to stop DAF database ...
 Log file: /home/dafadm/stopdb.log
 DAF database stopped
 /usr/sap/DAF/SYS/exe/run/stopdb completed successfully
 Checking DAF Database
 ------------------------------
 ABAP Database is not available via R3trans

lalu start kembali

rhel57daf:dafadm 12>startsap
Checking DAF Database
------------------------------
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
------------------------------
04:52:46 22.08.2015 LOG: Effective User Id is root
***********************************************************************
* This is Saposcol Version COLL 20.95 700 - v2.12, AMD/Intel x86_64 with Linux, 2008/01/02
* Usage: saposcol -l: Start OS Collector
* saposcol -k: Stop OS Collector
* saposcol -d: OS Collector Dialog Mode
* saposcol -s: OS Collector Status
* The OS Collector (PID 5469) is already running .....
************************************************************************
saposcol already running
Running /usr/sap/DAF/SYS/exe/run/startdb
Trying to start DAF database ...
Log file: /home/dafadm/startdb.log
DAF database started
/usr/sap/DAF/SYS/exe/run/startdb completed successfully
Starting SAP Instance DVEBMGS00
------------------------------
Startup-Log is written to /home/dafadm/startsap_DVEBMGS00.log
Instance Service on host rhel57daf started
Instance on host rhel57daf started

Taraaa… sudah bisa login sekarang dengan user sap*🙂
saplogin

3 thoughts on “Lupa Password Admin SAP

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s