Reset SAPSR3DB Password Failed using SAP brtools - Manual Way updating SecStore

-

 Refer to SAP note 1592575 - Recreating Secstore.properties and secstore.key for 7.00/7.01/7.02 J2EE Netweaver systems

Download the attachments.


BEWARE: THE POWERPOINT CONTAINS INCORRECT SYNTAX.

BEWARE: THE LAST COMMAND IN THE TXT FILE HAS A TYPO.


the steps in that note might not directly rrelfectted here. but these steps are valid.


Exmaple of executions as below:


# java -classpath tc_sec_secstorefs.jar:exception.jar:iaik_jce.jar:logging.jar com.sap.security.core.server.secstorefs.SecStoreFS create -s ECD -f Sec.properties -k sec.key -enc -p Password1

SAP Secure Store in the File System - Copyright (c) 2003 SAP AG


Store with encryption and a key phrase created.

# java -classpath tc_sec_secstorefs.jar:exception.jar:iaik_jce.jar:logging.jar com.sap.security.core.server.secstorefs.SecStoreFS insert -s ECD -f Sec.properties -k sec.key admin/user/ECD SAPSR3DB

SAP Secure Store in the File System - Copyright (c) 2003 SAP AG


Key/value pair inserted.

# java -classpath tc_sec_secstorefs.jar:exception.jar:iaik_jce.jar:logging.jar com.sap.security.core.server.secstorefs.SecStoreFS insert -s ECD -f Sec.properties -k sec.key admin/password/ECD Password1

SAP Secure Store in the File System - Copyright (c) 2003 SAP AG


Key/value pair inserted.

# java -classpath tc_sec_secstorefs.jar:exception.jar:iaik_jce.jar:logging.jar com.sap.security.core.server.secstorefs.SecStoreFS insert -s ECD -f Sec.properties -k sec.key admin/port/ECD 1527

SAP Secure Store in the File System - Copyright (c) 2003 SAP AG


Key/value pair inserted.

# java -classpath tc_sec_secstorefs.jar:exception.jar:iaik_jce.jar:logging.jar com.sap.security.core.server.secstorefs.SecStoreFS insert -s ECD -f Sec.properties -k sec.key admin/host/ECD NodeECD01

SAP Secure Store in the File System - Copyright (c) 2003 SAP AG


Key/value pair inserted.

# java -classpath tc_sec_secstorefs.jar:exception.jar:iaik_jce.jar:logging.jar:opensqlsta.jar:jdbc20.jar com.sap.sql.connect.OpenSQLConnectInfo create_dr jdbc/pool/ECD oracle.jdbc.pool.OracleConnectionPoolDataSource jdbc:oracle:thin:@NodeECD01:1527:ECD SAPSR3DB Password1 ECD Sec.properties sec.key

Driver successfully created

#

Once created, you can replace original SecStore witn the newly created keyt and properties file.

Make sure chmod 600.


//alak


Comments

Post a Comment

Popular posts from this blog

SAP: Segregate Different SMTP Mail Server Based on Sender Domain

-
Image
  Requirement : An SAP server, with a single Productive client shared by multiple company codes. Each CoCode would have their own domain (FQDN), and any email send out, for example PO to vendors, are to be sent using each individual CoCode SMTP mail server. Solution Steps: 1. Configure multiple SMTP nodes in Tx SCOT, limiting each node with a Sender Group 2. Set different Sender Group (CDG) parameters for each user of each CoCode (Tx SU01 > Parameters) 3. Test using SCOT's Routing Test feature 4. Profit Detail Step: Logon to SAP system and configure multiple SMTP Node, can use  Continue with SCOT Wizard. Once you get multiple Nodes (as per below screenshot), double click any of them,  In this example, we double click on the "SECOND" node. And then click on "Set" button for the address type you want to configure (that would most probably be for INT type) And click the Pencil icon for setting the Sender Group Here we can set based on FQDN or any string. We are ...
Read more

SAP Client Copy Error: Errors occurred during export of container object FINB-TR-DERIVATION

-
 Reference from: https://www.consultoria-sap.com/2010/03/client-copy-derivation-rule-tables-are.html TL;DR - Execute report ABADRCHECK with selected 'DELSTEPS' //alak ==== Client copy is completed with status "Post-Processing Required". There is an error in log for object FINB-TR-DERIVATION: DA300 "No active nametab exists for *some db table*" Name of db table is usually with naming convention: xxyyyysssmmmnnnn (xx - application class, yyyy - strategy ID, sss - system indicator, mmm - client, nnnn - sequence number) These db tables are part of some instance of derivation tool in your system and are used to store Derivation Rule Values. Other terms ABADR, FINB_TR_CC_EXIT, FINB_TR_CC_EXIT_TARGET, DA 300, DA300, CC, SCC9, SCCL, SCC3 Reason and Prerequisites During processing CC there was huge workload into your system. CC processcreates new tables to store copied derivation rules. This is done in parallel asynchronous process. But due to workload into system, t...
Read more

Quick Dirty Script for Checking Oracle Data Gurad Gap and Emailing it

-
 Situation: primary DB: prd_CCC standby DB: prd_WWW file 1: gap-check.bat @echo off cls echo. echo. echo This script checks for Archive Logs at prd_ccc and Applied Logs at prd_www echo. echo Querying prd_ccc (Primary) echo select max(sequence#) "Primary" from v$archived_log where archived='YES';|sqlplus -s / as sysdba echo Querying prd_www (Standby) echo select max(sequence#) "Standby" from v$archived_log where applied='YES';|sqlplus -s / as sysdba echo. DGMGRL / "show configuration" date /t && time /t && hostname && whoami file 2: emailer.ps1 $Username      = "username" $EmailPassword = "password" $today = Get-Date $Username = $Username $EmailTo = "adam@jasabyte.com"  $EmailFrom = "server@jasabyte.com" $Body = Get-Content .\status.log -Raw $Subject = "PRIMARY/STANDBY DB GAP - $today" $SMTPServer = "mail.smtp2go.com"  $SMTPMessage = New-Object System.Net.Mai...
Read more