Tuesday, March 31, 2009

SAP Basis Operations-------UNIX-----Linux

Backups
....what do I need to backup?
....how often do I need to backup?
....what are my backup options?

Client Tasks
....add a client?
....add a logical system ID to be assigned to a client?
....change a client?
....copy one client to another in the same R/3 system?
....copy one client to another in different R/3 systems?
....copy only user master data from one client to another?
....delete a client?
....lock a client so configuration changes cannot be made?
....verify that a client copy ran successfully?
....view all past client copies for a client?


Communications Tasks

....add a RFC connection?
....delete a RFC connection?
....modify a RFC connection?
....verify one R/3 system is talking to another?

Database Tasks

....perform Database Stats, Check Database, and Backup Jobs – MS SQL Server?
....perform Database Stats, Check Database, and Backup Jobs – Oracle?

Job Tasks

....change the start time/date for a scheduled job?
....clean out old job logs?
....delete a scheduled job?
....delete a running job?
....schedule a new job to run?
....verify that a job has run successfully?

Printer Tasks

....add a printer?
....create a new Frontend aka Local aka Desktop Printer?
....reprint a document that has already printed?
....reroute a printer output request?
....reset the cache for a printer?
....view a list of all printer output requests?
....view a list of the output requests for one printer only?

Security Tasks

....attach a role to a user?
....attach a user to a role?
....copy an existing role to a new role?
....create a user role?
....delete a user role?
....grant a transaction to a user?
....modify a user role?
....move roles from one client to another?
....revoke an authorization from a user?
....revoke a transaction from a user?

Support Package and Binary Patch Tasks

....apply a SPAM/SAINT update?
....apply kernel patches?
....apply other SAP binary patches?
....apply support packages?
....check for New SPAM Updates, Support Packages and Kernel Patches?
....download a kernel patch from SAP Marketplace?
....download a SPAM/SAINT Update?
....download a support package from SAP Marketplace?
....download other SAP binary patches?
....find your Current SPAM Update and Support Package Level
....know when SAP releases new fixes for our SAP software?
....ready a kernel patch for application?
....find SAP’s most current patches?
....find your Current Kernel Patch Level?
....find your Current SPAM Update and Support Package Level?
....know when SAP releases new fixes for our SAP software?
....ready a kernel patch for application?
....ready a SPAM/SAINT update or Support Package for application?
....ready other SAP binary patches for application?

System Tasks
....add a system parameter?
....apply a SAP (OSS) note?
....check that the system parameters are valid?
....delete a system parameter?
....generate a developer’s key for a programmer?
....generate an object key to change a SAP-owned object?
....how do I make server files viewable from SAP?
....keep all users out of a transaction?
....modify a system parameter?
....open a service connection for SAP to come into my system?
....reclaim system space from obsolete temporary objects?
....recompile all ABAP programs in a R/3 system?
....send a message to all connected users?
....send a message to one connected user?
....start R/3?
....start saprouter (OSS Link)?
....start the OS collector?
....stop a SAP work process?
....stop R/3?
....stop saprouter?
....stop the OS collector?
....stop the R/3 subsystem?
....verify that our link to SAP is up?
....verify that R/3 is up?
....verify the status of saprouter?
....view a short dump received by a user?
....view all processes currently running?
....view all system locks?
....view all table locks?
....view all update locks?

Transport Tasks

....add a change request to a transport queue?
....add a new SAP Instance to an Existing TMS Domain?
....automate the Transport Process?
....configure TMS – Transport Management System – for the First Time?
....configure TMS to Use SAP's Quality Assurance Functionality?
....re-Transport One or Several Change Requests at Once?
....transport a change from one R/3 system to another?
....transport several change requests at once?
....verify that the transport system is up and running?
....view a history of what changes have been transported?
....use Target Groups to Transport to Mulitple Clients to Different Instances?


User Tasks

....add a user?
....add an ITS user?
....change a user’s password?
....change several users at once?
....copy an existing user to a new user?
....delete a user?
....delete an ITS user?
....drop a connected user?
....get a list of all users in a client?
....lock a user?
....lock all users at once?
....modify a user?
....modify an ITS user?
....produce various user reports?
....start an audit trace for a specific user?
....view a list of all users currently connected?

Web and Internet Tasks

....start and stop the SAP IGS Server?

Working with the SAP Marketplace

....apply a SAP License Key the new way?
....apply a SAP License Key the old way?
....check the status of a request License Key?
....find your Hardware Key?
....generate a Developer’s Key for a Programmer?
....generate an Object Key for a Programmer?
....open a Problem via SAP Marketplace?
....open a Service Connection for SAP Support to allow SAP access?
....request a new License Key?

http://rapidshare.com/files/98952415/BasisOperations-UNIX-Linux.doc.html
Read more...

Changing the SAP Portal look and feel

Changing the SAP Portal look and feel

http://rapidshare.com/files/128797210/Changing_the_portal_look_and_feel.pdf
Read more...

1000 SAP SOLVED QUESTIONS

1000 SAP SOLVED QUESTIONS

http://rapidshare.com/files/120207949/1000_SOLVED_QUESTIONS.doc
Read more...

McGraw Hill SAP NetWeaver Portal Technology The Complete Reference Jun 2008

McGraw Hill SAP NetWeaver Portal Technology The Complete Reference Jun 2008

Rapidshare Link:

Read more...

SAP Enterprise Portal User Administration

SAP Enterprise Portal User Administration:

Rapidshare Link:
http://rapidshare.com/files/131792745/Enterprise_Portal_User_Administration.pdf
Read more...

SAP Enterprise Portal Cookbook

SAP Enterprise Portal Cookbook (Overview and Architecture )

Rapidshare Link:
http://rapidshare.com/files/131792673/Enterprise_Portal_Cookbook_Vol_1.pdf
http://rapidshare.com/files/131792723/Enterprise_Portal_Cookbook_Vol_2.pdf
Read more...

How to allow only specific users to login to the SAP system from various GUI systems?

When the parameter login/multi_login_users is activated, it will restrict users from logging in from various systems. However, if you wish to allow only few users to login to SAP from various systems, i.e., multiple logins with the same user ID, you need to add the following parameter:
login/disable_multi_gui_login
Enter the list of users that should be allowed. Separate the user IDs with commas, and do not leave any spaces between the user IDs.
Read more...

Adding New Instance to TMS Setup.

  1. Log on to client 000 of the SAP instance to serve as the Domain Controller.
  2. Go to transaction SE06.
  3. Click on the Perform Post Installation Actions button.
  4. Go to transaction STMS.
  5. You should see a popup box with the title TMS: Configure Transport Domain. If the popup doesn't say that, press F6 to change to the correct popup box.
  6. Fill in the TMS: Configure Transport Domain popup with the
    Description, Name of DOMAIN_, and the description of the Transport Domain. Then click Save.
  7. On the Transport Management System screen (if you aren’t there, back out until you are), assuming that this is the first SAP instance and there are no other
    installed SAP instances in your landscape yet, and assuming that you want your transport requests to be transportable and not local only,
    click on Overview → Systems.
  8. On the System Overview – Domain Domain_ screen, click SAP System → Create → External System. Fill in QAS if you are going to have a three system configuration or PRD if you are going to have a two system configuration, or make up a if you are never really going to have another SAP system. Fill in the rest of the information including the Path which is assumed to be :\usr\sap\trans for NT or \usr\sap\trans for UNIX. Click Environment → Transport Routes.
  9. On the Display Transport Routes screen, click the User Settings button, turn “on” the Hiergraphical List Editor, and click the √ Continue button. Back out of the screen and then go back in – you should see the list in a text mode which makes it easier to handle.
  10. On the Display Transport Routes screen, click the DisplayChange button to toggle into Change Mode.
  11. On the Change Transport Routes screen, click Configuration → Standard Configuration → Development and Production System.
  12. Fill in the Development and Production System popup, using your current SAP system SID as the Development system and the SAP instance you created in step #8 as the Production system. Click the √ mark to Continue.
  13. Back on the Change Transport Routes screen, click the Save icon and confirm all the popup questions.
  14. On the Change Transport Routes screen, back out until you can once more see the Transport Management System screen. Click Overview → Systems.
  15. On the Display TMS Configuration: System XXX screen, double-click the TMS Domain domain controller SAP instance.
  16. On the Display TMS Configuration: System XXX screen, click the DisplayChange button to toggle into Change Mode. Click the Communication tab and make sure that the Transport Group Name is correct. It should contain of the Domain Controller in the format of DOMAIN_ where is the System ID of the SAP Domain controller. Use the dropdown to find the correct entry it the field is blank. Click the Transport Tool tab. Verify that the information on the tab is correct and click the Insert Row button. Add a Parameter of CTC and a Value of 1. Click the Save button.
  17. Do step #16 for every system in your TMS Domain, making sure to change all Transport Group Names are the same and the CTC row is added to each with a value of 1.
  18. Save your way back the the main STMS screen.

Read more...

Some OSDB migration question for the Certification TADM70

1) Which of the following statements is true? Regarding incremental migration

a) The export of the bigger tables select by IMIG must be do offline.
B) The IMIG migration make sense only when a few tables have the more date.

2) In the SAP versions 4.X which file is used to restart the export?

-) file TOC;

3) Which must be the release of R3load for the request of the migration key, in a system 4.6x ?

The release of the R3load must be the same of the SAP kernel released for the release 4.6x

4) Which programs create the CMD files ?

SAPINST, R3SETUP and MIGMON.

5) Which of the following statements is true? TABART

A) Every Table can be assigned to one TABART
B) TABART has the dimension of tables

6) For verify if the existing objects in the *.STR files are on DB which control must to be do?

7) Which things are questioned on Remote Audit Project?

8) files TSK:

-) are introduced on version 6.10
-) they has R3load execution parameters
-) Allow the restart management for export import


10) In which situation must be “CALLED” an OS/DB migration consultant?
When we are doing an Heterogeneous System Copy, in every kind of system (development, test and production).

11) If we change an entry in task file from ‘ok’ to ‘err’ what must happen at restart the import with R3load?

11) When we are doing a Heterogeneous System Copy?
When we are changing DB or OS.
.
13) Which program produce the DBSIZE.TPL file on 4.X migrations ?

The program R3SETUP

14) R3load options
socket , continue_on_error ..

15) Which program produces the EXT files on 6.X migrations ?
The program R3szchk

16) Which program produce the DDL.TPL?
The program R3ldclt
17) merge_bck option of R3load

When the merge of task file finish, the import process start automatically
The option merge_bck change the status of the entries xeq to err in task files

18) If own system crash for “POWER FAILURE” in a 4.X migration which action can be do?

Delete TOC, DUMP and LOG files from the package that was interrupted at crash time

19) When is not possible do a migration with R3LOAD ?

When an INCV conversion has not completed

When the PREPARE phase has been started

20) From which program has been created the R3LOAD TSK files ?

From R3LOAD

21) In which directory is created the file DDL.TPL ?
a) install directory
b) data
c) DB
d) DB/DBS
e) Dump directory

22) When a certified consultant for OS/DB migration is supported by SAP ?
When use the tools released for SAP

23 ) Which kind of thinks is able to do MIGMON ??
a) Copy dump files with rcp command

24) if a customer have an CUSTOM tablespace with the correct TABART, but after reorganization activities the tablespace can be placed on standard tablespace without modify the TABART. Indicate if the follow sentences are true or false:

A) The export R3LOAD is interrupted because doesn’t found the correct tablespace.
B) R3SIZECHK can be able to calculate the dimension without any problem

25) Which files/directory must be copied from source to target system?
a) I command files?
b) Installation directory ?
c) Dump files ?
d) Task files ?
e) DB directory ?

26) DUMP file

a) In the dump file can be found the information for the follow file dump for be imported
b) Is created by R3LOAD
Read more...

Oracle interview Questions --- Part-2

14. What are the advantages of views?
- Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.
- Hide data complexity.
- Simplify commands for the user.
- Present the data in a different perspective from that of the base table.
- Store complex queries.

15. What is an Oracle sequence?
A sequence generates a serial list of unique numbers for numerical columns of a database's tables.

16. What is a synonym?
A synonym is an alias for a table, view, sequence or program unit.

17. What are the types of synonyms?
There are two types of synonyms private and public.

18. What is a private synonym?
Only its owner can access a private synonym.

19. What is a public synonym?
Any database user can access a public synonym.

20. What are synonyms used for?
- Mask the real name and owner of an object.
- Provide public access to an object
- Provide location transparency for tables, views or program units of a remote database.
- Simplify the SQL statements for database users.

21. What is an Oracle index?
An index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.

22. How are the index updates?
Indexes are automatically maintained and used by Oracle. Changes to table data are automatically incorporated into all relevant indexes.

23. What are clusters?
Clusters are groups of one or more tables physically stores together to share common columns and are often used together.

24. What is cluster key?
The related columns of the tables in a cluster are called the cluster key.

25. What is index cluster?
A cluster with an index on the cluster key.

26. What is hash cluster?
A row is stored in a hash cluster based on the result of applying a hash function to the row's cluster key value. All rows with the same hash key value are stores together on disk.
Read more...

Oracle interview Questions --- Part-1

Oracle Concepts and Architecture Database Structures

1. What are the components of physical database structure of Oracle database?
Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more control files.

2. What are the components of logical database structure of Oracle database?
There are tablespaces and database's schema objects.

3. What is a tablespace?
A database is divided into Logical Storage Unit called tablespaces. A tablespace is used to grouped related logical structures together.

4. What is SYSTEM tablespace and when is it created?
Every Oracle database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database.

5. Explain the relationship among database, tablespace and data file.
Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace.

6. What is schema?
A schema is collection of database objects of a user.

7. What are Schema Objects?
Schema objects are the logical structures that directly refer to the database's data. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database triggers, procedures, functions packages and database links.

8. Can objects of the same schema reside in different table spaces?
Yes.

9. Can a tablespace hold objects from different schemes?
Yes.

10. What is Oracle table?
A table is the basic unit of data storage in an Oracle database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.

11. What is an Oracle view?
A view is a virtual table. Every view has a query attached to it. (The query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)

12. Do a view contain data?
Views do not contain or store data.

13. Can a view based on another view?
Yes.

Read more...

ADM 110; Installation of SAP ECC6.0


Explains how to install SAP ERP Central Component. It describe the planning, preparation, installation and post installation activities perform to install SAP ERP Central Component.




RapidShare Link:


Read more...

SAP NetWeaver 7 - Overview

Introduce the possible uses of SAP NetWeaver 7 and provides an overview of
the technical infrastructure it represents.

Rapidshare Link: http://rapidshare.com/files/182373805/SAPNW_EN_Col62_FV_Part_Ltr.pdf
Read more...

SAP Enterprise Portal: Technology and Programming

SAP Enterprise Portal: Technology and Programming by Arnd Goebel; Dirk Ritthaler (Author)

Rapidshare Link:
http://rapidshare.com/files/200238440/SAP_Press_-_SAP_Enterprise_Portal_-_2005.djvu


Read more...