Sap Pandit !!

Complete SAP-BASIS Solution

SAP BR*TOOL STUDIO


A NEW TOOL From SAP………….ADD Multiple Instances to your BR*TOOL studio and enjoy freedom of Administration for Multiple Instances with your favourite WEB browser..

Download Br *TOOL studio from SDN(sdn.sap.com)
Link Given Below
DOWNLOAD

Now Come to your Server

Create a Studio home in any Drive With This Directory Structure

:\Oracle\sap\brtools\studio

EXTRACT the SAPCAR -xvf BRSTUDIO710EN__XXX.SAR into this directory

1) Call setup.cmd from command prompt
2) Click Install
3) Give https port By Default its 8888
4) Provide Password
5) Now keystore File (This is for security as we are using HTTPS)
We need to generate it using JAVA commands
Open Command Prompt Change Directory to java home
Run This Command and provide info:
Keytool -genkey
Give this path to next screen and password also you provide just now
Now a file has been generated
C:\document and setting\username\.keystore
6) Now installation is over.
CHEERS…………………….

CLICK HERE TO Know How to use Studio Now…

Regards,
Gagan Deep Kaushal

November 8, 2008 Posted by | SAP BR*TOOL STUDIO | 2 Comments

Troubleshoot With SPAM (At Your Own Risk)


DO AT YOUR OWN RISK

Before doing Troubleshooting with SPAM queue please take Full Backup of your
system so at least you can rollback up to same scenario.
1) If your Spam queue Hangs at any point after DDIC_IMPORT phase then its not
possible to reset it using SPAM or any other transaction. So in this case you may
be need to reset queue manually using some commands.(DON’T DO THIS)
2) Table PAT01 clear the Support Package with error delete from sapr3.pat01 where
patch = ”; (in our case SAPKA70013)
3) commit;
4) Table PAT03 changed the status of ‘?’ or ‘I’ to ‘N’ “update sapr3.pat03 set
status=’N’ where status = ‘?’ and patch = ”; “
5) commit;
6) With user adm go to Prompt-DOS
7) tp showbuffer pf=c:\usr\sap\trans\bin\TP_DOMAIN_.PFL
8) tp delfrombuffer SID pf=c:\usr\sap\trans\bin\TP_DOMAIN_.PFL
9) After this you can check your SPAM queue it should be empty.
10) In case you face problems like “bupa_inbound” undefined that means your system
is inconsistent for that you can use
11) SE18 and then enter SPRX_PROXY_ACTIVATION click change and then
activate it.
12) After that system can be in consistent state but its not guaranteed as you manually
remove SPAM queue and only half he changes are there in System .So as soon as
you are able to find the error ,correct it and reimport the same SP to make your
system consistent.
13) I am still saying ‘DON’T DO THIS’ SAP WILL NEVER HELP YOU IN THIS
SCENARIO.
DO AT YOUR OWN RISK

November 8, 2008 Posted by | Troubleshoot With SPAM (At Your Own Risk) | Leave a comment

SAP BR*TOOL STUDIO


A NEW TOOL From SAP………….ADD Multiple Instances to your BR*TOOL studio and enjoy freedom of Administration for Multiple Instances with your favourite WEB browser..

Download Br *TOOL studio from SDN(sdn.sap.com)
Link Given Below
DOWNLOAD

Now Come to your Server

Create a Studio home in any Drive With This Directory Structure

:\Oracle\sap\brtools\studio

EXTRACT the SAPCAR -xvf BRSTUDIO710EN__XXX.SAR into this directory

1) Call setup.cmd from command prompt
2) Click Install
3) Give https port By Default its 8888
4) Provide Password
5) Now keystore File (This is for security as we are using HTTPS)
We need to generate it using JAVA commands
Open Command Prompt Change Directory to java home
Run This Command and provide info:
Keytool -genkey
Give this path to next screen and password also you provide just now
Now a file has been generated
C:\document and setting\username\.keystore
6) Now installation is over.
CHEERS…………………….

CLICK HERE TO Know How to use Studio Now…

Regards,
Gagan Deep Kaushal

November 8, 2008 Posted by | SAP BR*TOOL STUDIO | Leave a comment

Troubleshoot With SPAM (At Your Own Risk)


DO AT YOUR OWN RISK

Before doing Troubleshooting with SPAM queue please take Full Backup of your
system so at least you can rollback up to same scenario.
1) If your Spam queue Hangs at any point after DDIC_IMPORT phase then its not
possible to reset it using SPAM or any other transaction. So in this case you may
be need to reset queue manually using some commands.(DON’T DO THIS)
2) Table PAT01 clear the Support Package with error delete from sapr3.pat01 where
patch = ”; (in our case SAPKA70013)
3) commit;
4) Table PAT03 changed the status of ‘?’ or ‘I’ to ‘N’ “update sapr3.pat03 set
status=’N’ where status = ‘?’ and patch = ”; “
5) commit;
6) With user adm go to Prompt-DOS
7) tp showbuffer pf=c:\usr\sap\trans\bin\TP_DOMAIN_.PFL
8) tp delfrombuffer SID pf=c:\usr\sap\trans\bin\TP_DOMAIN_.PFL
9) After this you can check your SPAM queue it should be empty.
10) In case you face problems like “bupa_inbound” undefined that means your system
is inconsistent for that you can use
11) SE18 and then enter SPRX_PROXY_ACTIVATION click change and then
activate it.
12) After that system can be in consistent state but its not guaranteed as you manually
remove SPAM queue and only half he changes are there in System .So as soon as
you are able to find the error ,correct it and reimport the same SP to make your
system consistent.
13) I am still saying ‘DON’T DO THIS’ SAP WILL NEVER HELP YOU IN THIS
SCENARIO.
DO AT YOUR OWN RISK

November 8, 2008 Posted by | Troubleshoot With SPAM (At Your Own Risk) | Leave a comment

Installing two Oracle databases on a host


Hi Team,

Here i am sharing the experience of installing two oracle database on same host.

After installing new database my first database won’t come up.there are some problems with listener.ora and tnsnames.ora so you have to follow this approach…

dbsid1 existing Database
dbsid2 New Database

Changes in listener.ora
################
# Filename……: listener.ora for more than one database
# Created…….: created by SAP AG, R/3 Rel. >= 4.0A
# Name……….:
# Date……….:
################
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=IPC)
(KEY= dbsid1.WORLD)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= dbsid1)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= dbsid2.WORLD)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= dbsid2)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = DBHOSTNAME)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 32768)
(SID_NAME = dbsid1)
(ORACLE_HOME = ORACLE_HOME_dbsid1)
(PRESPAWN_MAX = 10)
)
(SID_DESC =
(SDU = 32768)
(SID_NAME = dbsid2)
(ORACLE_HOME = ORACLE_HOME_dbsid2)
(PRESPAWN_MAX = 10)
)
)

and tnsnames.ora should be like this:
################
# Filename……: tnsnames.ora
# Name……….: LOCAL_REGION.world
# Date……….:
################
dbsid1.world =
(DESCRIPTION =
(SDU = 4096)
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = sap.world)
(PROTOCOL = TCP)
(HOST = DBHOSTNAME)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = dbsid1)
(GLOBAL_NAME = dbsid1.world)
)
)
dbsid2.world =
(DESCRIPTION =
(SDU = 4096)
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = sap.world)
(PROTOCOL = TCP)
(HOST = DBHOSTNAME)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = dbsid2)
(GLOBAL_NAME = dbsid2.world)
)
)

I think it will help you.

For more clarity follow SAP Note 98252

Regards,
Gagan Deep Kaushal

November 2, 2008 Posted by | Installing two Oracle databases on a host | Leave a comment

Installing two Oracle databases on a host


Hi Team,

Here i am sharing the experience of installing two oracle database on same host.

After installing new database my first database won’t come up.there are some problems with listener.ora and tnsnames.ora so you have to follow this approach…

dbsid1 existing Database
dbsid2 New Database

Changes in listener.ora
################
# Filename……: listener.ora for more than one database
# Created…….: created by SAP AG, R/3 Rel. >= 4.0A
# Name……….:
# Date……….:
################
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=IPC)
(KEY= dbsid1.WORLD)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= dbsid1)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= dbsid2.WORLD)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= dbsid2)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = DBHOSTNAME)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 32768)
(SID_NAME = dbsid1)
(ORACLE_HOME = ORACLE_HOME_dbsid1)
(PRESPAWN_MAX = 10)
)
(SID_DESC =
(SDU = 32768)
(SID_NAME = dbsid2)
(ORACLE_HOME = ORACLE_HOME_dbsid2)
(PRESPAWN_MAX = 10)
)
)

and tnsnames.ora should be like this:
################
# Filename……: tnsnames.ora
# Name……….: LOCAL_REGION.world
# Date……….:
################
dbsid1.world =
(DESCRIPTION =
(SDU = 4096)
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = sap.world)
(PROTOCOL = TCP)
(HOST = DBHOSTNAME)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = dbsid1)
(GLOBAL_NAME = dbsid1.world)
)
)
dbsid2.world =
(DESCRIPTION =
(SDU = 4096)
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = sap.world)
(PROTOCOL = TCP)
(HOST = DBHOSTNAME)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = dbsid2)
(GLOBAL_NAME = dbsid2.world)
)
)

I think it will help you.

For more clarity follow SAP Note 98252

Regards,
Gagan Deep Kaushal

November 2, 2008 Posted by | Installing two Oracle databases on a host | Leave a comment

Configure ADS in SAP Netweaver


Hi Team,
these links are very helpful to you to configure and understand what is ADS and how to configure it.

An Insight into Adobe Document Services (ADS)

Installing Credentials and Configuring ADS

How to Check If the ADS Service Is Running Properly

Hope it will help you

Regards,
Gagan Deep Kaushal

November 1, 2008 Posted by | Configure ADS in SAP Netweaver | Leave a comment

Configure SSO in EP


Hi Team,

Here i am sharing the link of a guide to configure SSO with EP
Click Here

Hope it will help you for more info you can contact..

Regards,
Gagan Deep Kaushal

November 1, 2008 Posted by | Configure SSO in EP | Leave a comment