on 08-08-2009 3:34 PM
Hi gurus,
What is the use of r3trans -d command in UNIX related to ORACLE Database...?
thanks in advance.
Regards,
BBR.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.