cancel
Showing results for 
Search instead for 
Did you mean: 

use of r3trans -d command in UNIX related to Database...?

former_member953603
Participant
0 Kudos

Hi gurus,

What is the use of r3trans -d command in UNIX related to ORACLE Database...?

thanks in advance.

Regards,

BBR.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi BBR,

Yes, this command is related to Database.

This would test if SAP database is available. The log for this command would be written at 'trans.log' file by default.

R3trans is the Transport Program used to transport data between SAP Systems and for the migration between different SAP releases. -d option would check the DB connect.

Regards,

Raj.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi ,

R3trans-d is used to check the whether DB is active or not .Along with R3trans-d to check db active or not , I give you some more command to check.

Following methods used to check whether DB is active or not :

1. ps -ef |grep ora

2. ps -ef |grep ora_

3. ps -ef |grep pmon

4. R3trans -d ; give RC - 0000 means active other than 0000

is error

5. in Brtools 1.Instance Management, 6 - Show instance

status, 3-Database instance, give the instance name i mean

Database Name and press continue....give the status

6. we can also check for SQL

SQL> select status from v$instance;

STATUS

-


OPEN

Hope this will help u out.

Thanks and Regards,

Arun Rathour

Former Member
0 Kudos

Dear Arun,

Is there anyway that I can see " brconnect " step by step log.

As we can ( R3trans -d ) total steps & logs in "trans.log" file ...?

Thanks & regards

Kushal

Former Member
0 Kudos

Hi,

R3trans -d is the command use to check connection between the SAP appilcation and Database . R3trans uses <sid>adm dba_environment parameter and oracle client to connect to database. if your database is up and R3trans -d is not connecting then you can look database paramerters, Listener for that <sid>adm. you will get suerful inforamtion in trans.log as suggested by Raj.