Friday, August 5, 2011

Value for PHYS_MEMSIZE ,Create RFC,Tcode in Quality server

Q-:Made a ZSM01 Tcode in quality server
Sol-:
Steps
1) SM30
2)Program=SAPMTSTC
3)Authorization object=S_ADMI_FCD and its Value=TLCK
4)You can use local object
5)Select (radio bott) Transaction classification & SAVE



Q-:Create rfc with user oss_rfc and the paswd is update
Sol-:Use TX OSS1 ->Technical settings -> Save


Q-: What is the value for PHYS_MEMSIZE ?
Ans-: The value of PHYS_MEMSIZE is 10000.

Q-: How to find out who (admin ID) locked a t-code through SM01.
Sol-: Used STAD or STAT
2-:Update table TSTC for the transaction SM01 and field CINFO from A or 2 to 0
or 8.



Query-:
strengthen our Production XI system by adding one application server (with load balancing) to take care of the additional load. Right now, XI system (Netweaver 7.0, PI 7.0 ) is running on HP-Ux 11.31/Oracle 10g and configured as High Availability.

http://sapinterviewshelp.blogspot.com/2011/04/user-creation-in-sap-administrator.html
http://sapinterviewshelp.blogspot.com/2011/05/sap-related-queries-and-problems-which.html
http://sapinterviewshelp.blogspot.com/2011/05/sap-latest-interview-questions-and.html
http://sapinterviewshelp.blogspot.com/2011/06/sap-ecc-5-on-ms-sql-database-server-to.html
http://sapinterviewshelp.blogspot.com/2011/06/upgrade-ecc60-ehp1-ready-to-ecc60-ehp4.html
http://sapinterviewshelp.blogspot.com/2011/06/sap-ecc-5-on-ms-sql-database-server-to.html


Sol-:
SAP web dispatcher to balance the load on your Java instances, then map everything to go through this web dispatcher instead of going directly to your Central instance.

Thursday, June 23, 2011

upgrade ECC6.0 EHP1 Ready to ECC6.0 EHP4 | SAP GUI 7.1 to 7.2

Q-: Need to upgrade ECC6.0 EHP1 Ready to ECC6.0 EHP4. Did I use EHPInstaller or SAPUp?

Ans-: Use EHPinstaller tool to upgrade to EHP4.

Query-: Web Gui take more memory then not gui client

Both network allow me, but my question is like a sap router string we use to connect sap server. Like this I want connect and my current string of web gui is:

http://sapdevail:8000/sap/bc/gui/sap/its/test/webg ui_tj?sap-client
0

Now where I give router string or my static ip.


Solution-: 1- Your router string looks like it is missing something like a /h/dns-name
or /hIP-ADDRESS
2-: You can access from another network as long as the network firewall allows SAP traffic.


Q-: Explain what is the look of router id and how can you use the web string
Ans-: /H/124.247.208.216/s/3299/H/



Q-: if you installed WEBSAPGUI 7.10 patch 9 on a Windows 2008 R2 64-bit machine using a IIS 7 web service and strictly followed the manual on how to install it.

After tried to access the Web Console using http:///isapi_sapcnsl.dll. The browser prompts me to download the isapi_sapcnsl.dll file which of course shouldn't.


Q-:
My users cannot print in SAP after upgrade from SAP GUI 7.1 to 7.2. There is no error.?

You should have a look at method "G" or "C" instead to print

More info about method G at http://help.sap.com/saphelp_nw70/helpdata/en/42/dd 174f02302cede10000000a1553f7/content.htm

Q-: I have to refresh the QAS with a copy of PRD SAP Enterprise Portal. The O/S is Windows. Can I execute the brrestore in Windows to restore a PRD backup? How can I execute the restore?

sol-: Find the homogeneous system copy guide for your particular version and follow the procedure there. I don't believe that you can perform a restore as this is a Java instance. You will need to export the PRD system by following the procedure in the guide and then perform an installation suing the export .

If your system is a dual stack version then you can use the ABAP portions' backup and restore for the ABAP side only but will still have to do the export of the Java side.

2-: You can refresh a JAVA stack using a backup/restore... but the only supported way is through a SAP export and import. As stated by Al Fournier, the homogeneous system copy guide explains it all.

If you don't care about SAP's support, try to get a document called "An expert guide to successfully managing & executing Java system copy processes" by Sanjeev Gholap from BearingPoint.


Q-:
sap system has became slow. Now i am getting TIME_OUT error in ST22. The program 'SAPLSETRAN' has exceed MAXIMUM permitted runtime without interruption

How to analysis the issue.

Q-: SAP BI Reports and need to get the URL of them can we use crome browser?

Ans-: no, Chrome is not a supported browser for SAP products, yet.

SAP ECC 5 on MS SQL Database server to SAP ECC 5 on Oracle database server



Query-:
Moving our SAP ECC 5 on MS SQL Database server to SAP ECC 5 on Oracle database server is good.


Performance-wise, you should get a bout the same throughput.clients want to migration from Oracle to MS-SQL... not the other way around. All new clients I know go with MS-SQL or DB2. I don't see companies going to Oracle for new installations.

in this case, company has good Oracle knowledge. Check how much it will cost your more using ORacle versus training your ORacle team to use Ms-SQL.

Q-:Backup/restore method from PRD to QAS. because our QAS doesn't have new data to test. Current src & trg syst is
source = ECC6 PRD [SP level 19 & kernal level 185] + win2003 sp2 + mssql2005 sp2
target = ECC6 PRD [SP level 19 & kernal level 185] + win2003 sp1 + mssql2005 sp1

what we can for this problem



1-:can i take backup frm src & restore directly to trg OR i have to apply the SP's of win & mssql to trg & then restore?
2.my backup of mssql is going to be night backup, so no user would be logged and am gonna take simple recovery mode with full, so two files will get backup; .MDF & .LDF, other than this any other files necessary to restore
3.if restore is success, what is the next step,i mean how to log into ECC6 syst and other steps.
Sol-: Follow the steps in the System copy Guide and in SAP Notes 151603 and maybe you also need 551915.
You should patch the SQL Server before performing the copy.

Another Option-: However if you stop SAP and perform a backup, you have an offline backup.

Do not change the system to simple mode and you can restore the transaction logs to a point-in-time.

Thursday, June 9, 2011

Transport Requests Between Different Transport Systems|Sap Router

Query-:We installed the SAP Router and have started it as a NT Service. However when I go to SM59 and test for remote connections, I get an error message: ERPSOLMAN:Route permission denied.ERS to 194.39.131.34.sapdp99).

At my OSS1 Tx when i test for my Lo on i get an error message:
erpsolman:ROUTE PERMISSION DENIED:(ERS TO 194.39./131.34.SAPDP99)


Sol-:
The SAPROUTTAB is not configured correctly.

However you should get the error with Tx OSS1.

Note 169924 - OSS_Connection trouble shooting. Hopefully this should resolve the problem.



Query-:DIR_TRANS must be shared between all system.
and you must give the access right to all {SID}adm user to all content to this dir.
For all the systems that are in one Group you shuld have a single Transport directory so your DIR_TRANS should be pointing to that shared transport directory.


Sol-: You can configure TMS to transfer transport requests between Different transport systems.

Our production systems do not share the Transport Directory. In the import Queue is a green arrow indicating that the data and cofiles need to be copied.


When I am trying to maintain a "zxxx" table through SM30 in Quality I am getting "Client 200 has status 'not modifiable'" and getting the "Message no. TK430"

It's not recommended to make changes on quality, otherwise your systems will no longer lined up. You have to apply changes on DC1 and transport them to QAS and after that to prod.

another solution
Problem can be solved by following snote#301665.
In the live system, set the "Current settings" (CURSETTING) indicator in the OBJH table for the detailed screen of the overhead rates, the V_KONX view. Depending on your release, proceed as follows:

As of Release 4.6
As of Release 4.6, you can set the "Current settings" indicator for the V_KONX view directly. To do this, call transaction SOBJ and select the V_KONX object. Select "Details" (magnifying glass, F2) for the V_KONX object. Select the "Current settings" indicator on the detail screen in the "Derived attributes" group box and save this setting. Transfer this change to the OBJH table in the live system.
Reset the 'Current settings' indicator in a client that is not flagged as live, since the indicator prevents the inclusion of the add-ons in a transfer order (if the corrections from Notes 709504, 733777 and 820955 have been implemented in the system).






Query-:

one of the Ecc6.0 server has been infected by virus.After removing the viruses,Sap instance is not starting.In mmc it theres error showing:
sapcpe couldnot start
strdbs.cmd could not be started.
Below is the log of sapstart.log

AP-R/3-Startup Program
Starting at 2011/06/07 16:45:51
Startup Profile: "c:\usr\sap\qas\sys\profile\START_DVEBMGS00_ECC6QAS "
Starting Programs
(4748) CreateProcess(\\ECC6QAS\sapmnt\QAS\SYS\exe\nuc\NTI 386\sapcpe.EXE pf=\\ECC6QAS\sapmnt\QAS\SYS\profile\QAS_DVEBMGS00_ ECC6QAS) failed(67). ERROR_BAD_NET_NAME: The network name cannot be found.
(4748) CreateProcess(\\ECC6QAS\sapmnt\QAS\SYS\exe\nuc\NTI 386\strdbs.cmd QAS) failed(67). ERROR_BAD_NET_NAME: The network name cannot be found.
(5476) CreateProcess: C:\usr\sap\QAS\DVEBMGS00\exe\msg_server.EXE pf=\\ECC6QAS\sapmnt\QAS\SYS\profile\QAS_DVEBMGS00_ ECC6QAS
(5160) CreateProcess: C:\usr\sap\QAS\DVEBMGS00\exe\disp+work.EXE pf=\\ECC6QAS\sapmnt\QAS\SYS\profile\QAS_DVEBMGS00_ ECC6QAS
(1580) CreateProcess: C:\usr\sap\QAS\DVEBMGS00\exe\igswd.EXE -mode=profile pf=\\ECC6QAS\sapmnt\QAS\SYS\profile\QAS_DVEBMGS00_ ECC6QAS

sap folder is having share name saploc and i can access through network.Whereas in the errorlog it shows CreateProcess(\\ECC6QAS\sapmnt\QAS\SYS\exe\nuc\NTI 386\sapcpe.EXE .
under exe i have the folder named UC then why its looking for nuc...no idea.
O.S= WIN2000
DB= ORACLE 10g

solution-:
you have to restore all passwords (OS and Oracle) with your old defined password.
From the error message i must be the principal reason for this error.

also check if users are locked and check their permissions.

Monday, May 23, 2011

Sap Latest Interview Questions and practical problem solutions

Q-:How can we check the relevant developer trace as there will be so many
dev_w#.

Ans-:
1. Check the database for logs full
2. Check file systems - available disk space
3. Check relevant developer trace files for clues dev_w#

Q-:If you search for relevant SAP notes the ABAP Short Dump "SAPSQL ARRAY INSERT DUPREC" is also produced with Program bugs.

Ans-:

SAPSQL ARRAY INSERT DUPREC
This error means that a transaction / program was attempting to commit
information to the database that would result in a duplicate entry in a
table with primary key. Depending on when and where you are getting it it
can be caused by some SAP bugs in Physical Inventory Document Clearing,
number ranges being out of synchronization after a client copy etc.

Q-:
how to unlock client 000?

Ans-:

Set the parameter login/no_automatic_user_sapstar = 0 (Zero) in the instance profile and restart the system.
when you locked yourself. You can try using DDIC or
sap* with the master password that should give you access to client 000 and
you can unlock the locked user.
Just go to the Profile <\usr\sap\SID\SYS\profile> add parameter
login/no_automatic_user_sapstar and restart sap mmc once, after this you
can login with default password


Queries-:

I'm planning to do the installation for SAP ECC 6.0 on Windows Server 2008 R2 Standard with Database DB2 9.1.

Do I need to download the DB2 v9.5 or 9.7 from the service market place and start the Installation, which DB2 version is compatible with Windows Server 2008 R2 Standard (DB2 9.5 or DB2 9.7).




SPDD transport we got from development will not suit in Quality system as there will be many delta objects. In our Quality system many urgent corrections happened, so we are planning to import SPDD transport manually and then check delta objects and proceed further.


in this case you should by-pass the SPDD and SPAU steps and process them after the Patching is complete.

However as you have imported the request and are getting R/C=8 errors you really need to contact SAP
In case of delta objects as well you can use the procedure mentioned by me
as that will include the SPDD of the development system and then give you
the option during preprocessing phase to do the delta adjustments.

Please open a customer message with SAP support to resolve the issue as you
had already imported the SPDD tr.

Wednesday, May 4, 2011

Sap Related Queries And Problems Which You Face

- Is there any possibility to allow create queries in production environment by using transaction SQ01 when system is non-modifiable



-if you taken client export of production client from scc8 with sap all & and import this on QA client, after successfully import of STMS. when iexecute tcode scc7 "Post-Client Import Methods" and check scc3 after some time it got stuck on following error message . kindly advice what's wrong



- looking for SAP System copy tools instead of manual system copy . what is it?



Qus-:




indeed was simpler to copy the transport files in some temporary location and then remove them from the buffer.





sol- You need to release all the transport requests. Then you can continue applying the support packages.

point2-

If you do not need the requests delete the transport Requests from the import buffer of the QAS/PRD systems



Qus-:

I'm not able to install the SAPKH60301 into the system as well. Getting the error "No valid queue for SAP_APPL rel. 603"



Sol-: Use Tx SPAM and view the packages and see what Prerequisite packages are necessary.

qus-

After the offline backup weather I can take the incremental backup. For
offline backup I have shutdown the database and copied the datafiles, log
files, temp file and control file and started the target system database.
I have no catalog while taking the backup.Now, I need to take the
incremental backup from the point where i have taken the full online backup.




- weather in increment backup only control files and redolog file are enough too take backup or weather we have to take changed data files also

-

After offline backup weather I can take incremental backup by RMAN.

Sol-:

If you restore the full offline backup you can restore the subsequent redo log backups only as long as you have not started the database on the Target system.

point2-

If you have started the database it is no too late to to apply to apply log backups. You should have restored the database using the offline backup and performed a point-in-time recovery using the redo log backups before starting the database. Once you start the database it it too late to apply additional logs.







Friday, April 22, 2011

User Creation In Sap | Administrator users Logon


Q-:1 why problem in 555 client there is no DDIC user we can able to
login only by SAP* and create the user but why  not able to Copy
End User Roles.

Ans-:Create a user with SAP_ALL profile then you can do from that user



  Note-: link to download ECC 6.0 IDES system.
You can download the software form http://service.sap.com/swdc -> Installations and Upgrades -> A - Z Index -> E -> SAP ERP -> SAP ERP 6.0 -> IDES Version



Query -:  1-In our company rdisp/tm_max_no =3D 200. suppose if the no of user reaches 200 SAP will not allow the other user to enter. In that case how to control the sap user through OS level other than (dpmon) command.
We are in SAP R3 4.7EE
Os: solaris9
Database: oracle 9.2


Ans-: Yes, You can Administer Users logged on to an SAP system using the command
Log on to system as SIDADM
dpmon pf=<Full Path Instance Profile>
then enter m for menu
then enter l for work process admin table long
Then you will see the list as SM50 and from here you can kill a user session or restart work process for the user or stop work process.

Tuesday, April 19, 2011

Sap Regression Testing And Client Copy Logs Questions

Q1. remote client copy from Production to development server successfully But why for 
existing Material document we are not able to view accounting document
and how can done it.
ans-
Check the client copy logs and see if there were any errors if any error occur then resolve it and then try again.
Q-:2 In setting the first Sap-Screen visible to user
after logging in his ID.Like if i want user to use TCODE- SE38 after logging
IN,how can i change it. 

Ans-:
Login by user ID. press Shift+F7. mention the TCODE. it will be his
default default TCode like SE38.
 Q3-:
Actual regression testing scenarios for kernel upgrade. 
Ans-:
Ecc6.0 system which has SAP HR and our customized developments for our HR application. 
We are applying a Snote and the prerequsite for the applying the snote is a kernel upgrade. As I know we can only do testing or checks for a kernel upgrade. I am not aware of any regression testing steps for a kernel upgrade. Please let me know if we have regression testing scenarios for the same.



The regression testing is the responsibility of the Application team. In the past there have been some issues with Application Transaction codes after a kernel upgrade.
Remember to make a copy of the current kernel before changing the kernel.



 
 

 
 



Wednesday, March 30, 2011

Change the RFC | Sap Interviews Questions

Q-: How change the RFC's as they are system generated and there is no change option?. 

Ans-: You have need to check the Transport Tool from TMS? STMS->system overview->select the system XXX-->R3System->check->Transport Tool for errors from 000. Also does your user TMSADM have the correct authorizations and for that, does your ID have it? Check the TP logfile, ST22 and SM21 to see if it highlights any errors. 


Q-: How can I test my backup. Whether, I have taken the backup correctly or
not . After checking in DB12. 


ans-:
0005 is related to your 3rd party backup program. May this be the case?

 You have need to check out  BRBACKUP logs to know more about this error



Q-: When You installed Solution Manager 7.0EHP1.and wanted to do a Kernel upgrade, backed up the Kernel files and performed a Kernel upgrade.why properly stopped the MMC and the services. 

Ans-: Restart your SAP and Database and make sure to stop/ start the service SAP<SID>_<SYSNO> under services as well. 

Q-: TMS is not working, and while testing the RFC's and getting Incorrect Username & Password.

ans-: 

1. plan of resetting the password of user TMSADM in 000 in all systems and update all RFC's in all systems manually.

But there is  you are not able to change the RFC's as they are system generated and there is no change option.
2.change the TMS RFCs in SM59, because they are automatically generated by the system when configuring the transport system.
If you need to change the TMS RFCs, you should do it by doing the changes in the TMS config and distribute the new RFCs. This is done in tcode STMS.
 

Sap Database And Jdbc Exception Details

Exception Details:
 
com.sap.ip.bi.sdk.exception.BIConnectionFailedException: Cannot open the connection
at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactor y.getConnectionEx(JdbcConnectionFactory.java:238)
at com.sap.ip.bi.sdk.trialarea.connector.servlet.model.JDBCM odel.getConnection(JDBCModel.java:796)
at com.sap.ip.bi.sdk.trialarea.connector.servlet.model.JDBCM odel.getTables(JDBCModel.java:132)
at com.sap.ip.bi.sdk.trialarea.connector.servlet.controller. Control2.doPost(Control2.java:25)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at com.sap.engine.services.servlets_jsp.server.HttpHa ndlerImpl.runServlet(HttpHandlerImpl.java:401)
at com.sap.engine.services.servlets_jsp.server.HttpHa ndlerImpl.handleRequest(HttpHandlerImpl.java:266)
at com.sap.engine.services.httpserver.server.RequestA nalizer.startServlet(RequestAnalizer.java:386)
at com.sap.engine.services.httpserver.server.RequestA nalizer.startServlet(RequestAnalizer.java:364)
at com.sap.engine.services.httpserver.server.RequestA nalizer.invokeWebContainer(RequestAnalizer.java:1039)
at com.sap.engine.services.httpserver.server.RequestA nalizer.handle(RequestAnalizer.java:265)
at com.sap.engine.services.httpserver.server.Client.h andle(Client.java:95)
at com.sap.engine.services.httpserver.server.Processo r.request(Processor.java:175)
at com.sap.engine.core.service630.context.cluster.ses sion.ApplicationSessionMessageListener.process(Applica tionSessionMessageListener.java:33)
at com.sap.engine.core.cluster.impl6.session.MessageR unner.run(MessageRunner.java:41)
at com.sap.engine.core.thread.impl3.ActionObject.run( ActionObject.java:37)
at java.security.AccessController.doPrivileged(Access Controller.java:219)
at com.sap.engine.core.thread.impl3.SingleThread.exec ute(SingleThread.java:104)
at com.sap.engine.core.thread.impl3.SingleThread.run( SingleThread.java:176)
Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Cannot open the connection
at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnectio n.(JdbcManagedConnection.java:123)
at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnectio nFactory.createManagedConnection(JdbcManagedConnectionFact ory.java:112)
at com.sap.engine.services.connector.jca.ConnectionHa shSet.match(ConnectionHashSet.java:338)
at com.sap.engine.services.connector.jca.ConnectionMa nagerImpl.allocateConnection(ConnectionManagerImpl.java:262 )
at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactor y.getConnectionEx(JdbcConnectionFactory.java:233)
... 19 more
Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Cannot connect to JDBC data source
at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.conn ectDB(Connection.java:336)
at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.conn ect(Connection.java:99)
at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnectio n.(JdbcManagedConnection.java:118)
... 23 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
at com.microsoft.sqlserver.jdbc.SQLServerConnection.t erminate(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSChannel.read(Unkno wn Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.P relogin(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.c onnectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.l oginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.c onnect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.conne ct(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager .java:559)
at java.sql.DriverManager.getConnection(DriverManager .java:158)
at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.conn ectDB(Connection.java:320) 


Read more about sap servers





Sunday, March 27, 2011

EHP upgrade from NW 700 to EHP2 sp6 level

 Q-:
Why SAP Ehpi broke during phase FREECHK in module PREP_SPACECHECKS / Space checks in check level
Error Message-:Missing file '/usr/sap/BWS/EHPI/abap/exe/rsecssfx

Ans-: Check r u using the correct version of the EhPI tool
 


 How can  FTP a file from an AL11 directory to an FTP server? 

Ans-: A local FTP server (same  datacentre as the SAP servers) and a remote FTP server (on the internet or placed on some other place)
 but  if it uses the SAPFTP RFC then it's a 'frontend' (ie. desktop) source/target and if it uses SAPFTPA then its from the DIA instance (not the desktop). 



Important Point-: New driver version that allowed to install ODBC connection on W2008. old version  W2003 was 10.2.0.2, to the new version 10.2.0.4.

 First download from oracle
After installation complete u able to create the ODBC connection using the 32-bit version of the ODBC-admin program from windows (location: C:\Windows\SysWOW64\odbcad32.exe).
The only issue I have now is that after setting the environment variables TNS_ADMIN and PATH to the new Instant-client and ODBC driver files, the Oracle DB is not starting up because it cannot find the <sid>init.ora file anymore. have to do some digging to fix that (starts up fine when using the SPFILE). 




Q-: 

1. How to check the level on the present QA, then copy it to the new QA

2. Then install it on the new box 



Ans-:
copy the kernel from current QA system.

You will have use the solution manager to download the necessary patch files.


Ehp Upgrade In Sap,Installation Error

Q-:
Doing EHP upgrade from NW 700 to EHP2 sp6 level ..

Error
SAPehpi broke during phase FREECHK in module PREP_SPACECHECKS / Space checks
Error Message: Missing file '/usr/sap/BWS/EHPI/abap/exe/rsecssfx'

but unfortunately i dont get that file with the kernelgiven by SAP .. 



Ans-: 
Are you sure you are using the correct version of the EhPI tool ?

There is a SAP note indicating that this file is not required yet. See SAP note 1561615

If this is correct open a message with SAP 



Q-:2


What Is Problem When We installed SAP BI 7.0 on suse Linux 10 with oracle 10.2.0.2, installation is finished successfully but when  restart the system,suppose i login as oraSID,
When i stated lisner it is started successfully, next i run the startdb command, i got fallowing ERROR.

LOGFILE FOR STARTING ORACLE
Trying to start BIW database ...  


Ans-:  checking required environment variables
ORACLE_HOME is >/oracle/BIW/102_32<
ORACLE_SID is >BIW<


2. Check Initora
checking V2 connect

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 25-MAR-201104:24:25
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/oracle/BIW/102_32/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY =SAP.WORLD) (PROTOCOL = TCP) (HOST = biw7) (PORT = 1527))) (CONNECT_DATA = (SID= BIW) (GLOBAL_NAME = BIW.WORLD)))
OK (10 msec)
tnsping: V2 connect to BIW 


then,
Shutdown database
First trying to shutdown the database - May be,
the database is in the nomount or mount state 


starting database

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Mar 25 04:24:31 2011
Copyright (c) 1982, 2005, Oracle. AllRights Reserved.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 457179136bytes
Fixed Size 1261404 bytes
Variable Size 239075492 bytes
Database Buffers 213909504 bytes
Redo Buffers 2932736 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 -Production
 

Presentation, Application ,Database Servers In SAP R/3

Application Server-: 
 
The application layer of an R/3 System is made up of the 
Application servers and the message server. Application 
Server is placed between the presentation server and database server. 
Application programs in an R/3 System are run on application servers. 
The application servers communicate with the presentation Components, 
the database using the message server. All the data are stored in a 
Centralized server. This server is called database server. The message 
server is used to communicate between different servers.
 
Presentation server in sap-:
 
Presentation server is system with GUI means all the output you can seen 
their and all the input is inserted by the presentation server. it collect 
the requirements from end users and dispatcher dispatch it to the data base 
layer for the response of that, where data base server is the main server 
which consist all the data information and tables, application server  placed 
between both, presentation and Database server and it provides interfacing 
between the database & presentation server. But now a new concept is introduced 
that is netweaver concept, in which a new layer is introduced that is internet 
layer. it consist every server different so it is called R/3 system earlier single
 System consist all the servers that is called R/1.

Wednesday, March 23, 2011

Sap Application Server - Sap Interviews Question

Sap Servers 
R/3 programs run on application servers. They are an important component of the R/3 System. 
There are different components in the appication servers

 work process


An application server contains several work processes,that can run an application. Each work process is linked to a memory area containing the settings of the application being run. The setting contains the current data for the application program. This needs to be available in each dialog step.


Each application server contains a dispatcher. The dispatcher is the attach between the work processes and the users logged onto the application server. Its work is to receive requests for dialog steps from the SAP Graphical user interface(presentation server) and direct them to a free work process.
Gateway

 Application server contains a gateway. This is the interface for the R/3 communication protocols (RFC, CPI/C). It can communicate with other application servers in the same R/3 System
 The fact that the individual work processes work independently makes them suitable for a multi-procecssor architecuture. The methods used in the dispatcher to distribute tasks to work processes
 you can read more about  dispatcher in next section



Application server Architecture

1.Presentation layer -:
In the presentation layer, the user interface can be developed with java server pages(JSP), or with web dynpro technology. Web Dynpro is used to design user interfaces for Java and ABAP applications. 
2.Business layer -:
Buisness layer is also  known as domain layer.It differentiate the buisness logic from other modules, such as the data access layer and user interface such as presentation layer
3.Connectivity layer-:
The Internet Communication Manager (ICM) dispatch the query to the presentation layes by using the internet protocols. some protocols used such as Http,Smtp,SSL
4. Persistence layer

Monday, March 21, 2011

Sap Interview Questions - ERP

Q-: What is ERP
Ans-:
ERP is a package with the techniques and concepts for the merged management of business as a whole, for effective use of  resources, for better the efficiency of an enterprise. In begining ERP was targeted for manufacturing industry mainly for planning and managing  business such as  production and financial market, human resources,accounts etc. Sap is itself ERP.


Q-: Different types of ERP ?
Ans-

  1.  SAP, BAAN, JD Edwards, Oracle financial, Siebel, PeopleSoft. mostly companies try to implement the sap in their organization because of number of advantages aver other ERP packages.
Q-: Why do you usually choose to implement SAP? 
Ans- There are number of technical reasons numbers of companies are planning to implement SAP. It’s help organize and command all the data, and functions from main server and provides  highly secure data handling, min data redundancy, max data consistency. so it is adopted by mostly companies such as honda, oil mills, and many more.
Q-:What do you mean by IDES?
Ans - International Demonstration and Education System. Application provided for faster learning and implementation.
Q-: Define SAP R/3?
Ans - A third generation set of highly integrated software modules that performs common business function based on multinational leading practice. it is three tier, includes presentation server, application server, database server seprately.

Thursday, February 24, 2011

what is Sap


SAP, started in 1972 by five IBM employees in Germany, it is the world's largest inter-enterprise software company and the world's fourth-largest  software supplier.
 The original SAP  provide help to  customers with the ability to interact with a common corporate database for a wide range of applications.today many companies implement the sap in their organization to manage all their branches.
today the latest SAP applications, built around their latest R/3 system, provide the ability to manage financial, asset, and management, accounting, production operations and materials, personnel, plants, and archived documents. The R/3 system runs on a number of platforms including windows 2000 and uses the  client/server model.
As of January 2007, SAP, a publicly traded company, had over 38,4000 employees in over 50 countries, and more than 36,200 customers around the world. SAP is turning its attention to small- and-medium sized businesses. recently  R/3 version was provided for IBM's as/400 platform.