Clean Up Transport Directory
Q: We are out of space on /usr/sap/trans directory. I do not know what to do. I’ve been deleted all transported list from STMS, but the file system still full.
Answer:
Hi, you should do transport directory clean-up from file system, at least once a month.
To do that, please follow this:
1. Go to operating system and logon using user <sid>adm
2. Run: cd /usr/sap/trans/bin
3. Run: tp check all pf=TP_DOMAIN_<SID>.PFL
4. Run: tp clearold all pf=TP_DOMAIN_<SID>.PFL
This will move more than 6 months file from /usr/sap/trans/data to /usr/sap/trans/olddata
and also will delete more than 1 year ../cofiles and ../logs
Filed under: Admin Tasks | Leave a Comment
Tags: Clean Up, Transport Directory
Q: I am migrating SAP Netweaver 2004s SP9 from Solaris – Oracle to Windows – MSSQL 2005.
While I request Migration Key from Service Marketplace, it gave me error that said the Migration Key is invalid. The migration key is generated by SAP.
Answer:
Hi, you may refer to SAP Note 970518.
The source license is already use new License type, which is Digital-Sign License (The generated license key, longer that the previouse version.
You may use this General Migration key:
1G5fdEM50TMIrBzjt6TE5Pae
, which valid until end of 2008.
Filed under: SAP Netweaver | 1 Comment
Tags: Migration Key, Netweaver 7, OS DB Migration
Setting Oracle SP File
Q: I am running SAP Netweaver 7 with Oracle 10g. I would like to add new Oracle parameter and delete some parameter base on SAP Notes recommendation. How should I do that?
Answer:
1. You can edit using BRSPACE, by running command from OS: > brspace -f dbparam
2. OR, you can add/edit or delete the parameter from SQL Plus:
ADD / EDIT:
SQL> alter system set “<oracle parameter>”=<value> scope=spfile;
example: SQL> alter system set “OPTIMIZER_INDEX_COST_ADJ”=10 scope=spfile;
DELETE:
SQL> alter system reset “<oracle parameter>” scope = spfile sid = ‘*’;
exampler: SQL> alter system reset “_push_join_predicate” scope = spfile sid = ‘*’;
All parameter will be active after you restart the database.
Filed under: Oracle | 3 Comments
Tags: Setting Oracle SP File
Forgot SAP* Password
Q1: Please help me. I would like to update Support Package from Client 000, but I forgot all the password (DDIC and SAP*). How can I logon?
Q2: My temporary license Expired! I need to install new license, but all user can’t login except SAP*, but I forgot SAP* Password.
Answer:
To reset SAP* password, please follow this step:
1. Set the profile parameter login/no_automatic_user_sapstar to 0 from RZ10 (If you can’t logon, you can edit your Instance Profile directly from the OS level, folder /usr/sap/<SID>/SYS/profile, )
2. Restart Application Server.
3. Logon to your SQL command (eq: SQL PLUS for Oracle) and connect as SYSDBA.
4. Run: SELECT * FROM [DBSID].USR02 WHERE BNAME=’SAP*’ AND MANDT='<client>’
Example: SELECT * FROM PRD.USR02 WHERE BNAME=’SAP*’ AND MANDT=’000′
5. If exist, then run:
DELETE FROM PRD.USR02 WHERE BNAME=’SAP*’ AND MANDT=’000′
Make sure the user deleted by re-run step 4.
6. Logon to Client 000 with user SAP* and password: pass
Filed under: SAP Netweaver | 11 Comments
Tags: Forgot SAP* Password