LOG IN TO BR*TOOL STUDIO

Hi ALL,
Here i am sharing the procedure to run and use BRTOOL STUDIO
1) To Run Studio Go to Studio home and run server.cmd
2) To Access it go to url;
Https:hostname:port/studio
3) A pop-up window will come
Provide username:Administrator(Same as shown Capital A and all other small )
Password:You provide at the time of installation
4) Click on instances and then Create
5) Provide Info as Password for Administrator
Database user (Please note that password of DB user should not be contain’@’ in password string)
6) Give The Path for brtool profile parameter
Oraclehome/database/init.sap
7) Finally click on Go(Left Side)
8) Now you will be log off and login to your instance Using
Administrator as username and password you provide at the time of installation
9) Now here you can create more user for brtool with different user roles.
You can use it to view space, check status ,control files,backup,restore and you now more thing…….. :)

HOW TO INSTALL BRTOOLS ?


Regards,
Gagan Deep Kaushal

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

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

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