Skip to Content
0

Startsap - Database is not available via R3trans

Dec 15, 2017 at 09:10 AM

262

avatar image

Dear All,

Need Help,

I have restored sap database using brrestore.

when i startsap it said Database is not available

did i missed some process ?

=======================

hostname:d01adm 2> startsap
Checking D01 Database
Database is not available via R3trans
-------------------------------------------
Trying to start D01 database ...
Log file: /home/d01adm/startdb.log
Starting Startup Agent sapstartsrv
OK
Instance Service on host hostname started
-------------------------------------------
starting SAP Instance ASCS01
Startup-Log is written to /home/d01adm/startsap_ASCS01.log
-------------------------------------------
/usr/sap/D01/ASCS01/exe/sapcontrol -prot NI_HTTP -nr 01 -function Start
Instance on host hostname started
Starting Startup Agent sapstartsrv
OK
Instance Service on host hostname started
-------------------------------------------
starting SAP Instance DVEBMGS00
Startup-Log is written to /home/d01adm/startsap_DVEBMGS00.log
-------------------------------------------
/usr/sap/D01/DVEBMGS00/exe/sapcontrol -prot NI_HTTP -nr 00 -function Start
Instance on host hostname started

===================================

hostname:d01adm 3> R3trans -d
This is R3trans version 6.24 (release 720 - 08.07.13 - 20:13:05 ).
unicode enabled version
2EETW000 sap_dext called with msgnr "2":
2EETW000 ---- db call info ----
2EETW000 function: db_ntab
2EETW000 fcode: NT_RDTDESCR
2EETW000 tabname: TADIR
2EETW000 len (char): 5
2EETW000 key: TADIR
2EETW000 retcode: 2
R3trans finished (0012).
hostname:d01adm 4> R3trans -x
This is R3trans version 6.24 (release 720 - 08.07.13 - 20:13:05 ).
unicode enabled version
R3trans finished (0000).

Thanks,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Bartosz Jarkowski Dec 15, 2017 at 10:23 AM
1

Before starting a SAP system, the startsap command is checking if the database is available. If not, you get the message - but you shouldn't worry too much because the script is also starting the database.

Based on provided output I can't see any issues. Do you experience troubles connecting to the instance?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Bartosz,

i check my instance service is up :

orad01 4194472 1 0 Dec 14 - 0:02 ora_diag_D01
orad01 5046310 1 0 Dec 14 - 0:06 ora_dbw0_D01
orad01 9961722 1 0 Dec 14 - 0:02 ora_arc2_D01
orad01 11337852 1 0 Dec 14 - 0:30 ora_psp0_D01
orad01 12058800 1 0 Dec 14 - 0:37 ora_mmnl_D01
orad01 12845130 1 0 Dec 14 - 0:00 ora_q000_D01
orad01 13434986 1 0 Dec 14 - 0:00 ora_arc3_D01
orad01 14287078 1 0 Dec 14 - 0:19 ora_cjq0_D01
orad01 14352384 1 0 Dec 14 - 0:16 ora_mmon_D01
orad01 16056340 1 0 Dec 14 - 1:04 ora_dia0_D01
orad01 16646394 1 0 Dec 14 - 0:03 ora_dbrm_D01
orad01 17236180 1 0 Dec 14 - 0:02 ora_gen0_D01
orad01 17760330 1 0 Dec 14 - 0:00 ora_reco_D01
orad01 18219102 1 0 Dec 14 - 0:03 ora_smco_D01
orad01 18809016 1 0 Dec 14 - 0:19 ora_pmon_D01
orad01 18874468 1 0 Dec 14 - 0:00 ora_q001_D01
orad01 20119732 1 0 Dec 14 - 0:04 ora_smon_D01
orad01 21364922 1 0 Dec 14 - 0:03 ora_mman_D01
orad01 22806710 1 0 Dec 14 - 0:00 ora_qmnc_D01
orad01 23003250 1 0 Dec 14 - 0:26 ora_ckpt_D01
orad01 24313916 1 0 Dec 14 - 0:00 ora_arc1_D01
orad01 24707104 1 0 Dec 14 - 1:25 ora_vktm_D01
orad01 24903822 1 0 Dec 14 - 0:03 ora_lgwr_D01
orad01 25690184 1 0 16:04:24 - 0:00 ora_w000_D01
orad01 26607720 1 0 Dec 14 - 0:00 ora_arc0_D01

0
avatar image
Former Member Dec 19, 2017 at 12:23 PM
1

Dear Irfan ,

You are facing the above error , when your database is being not shutdown properly or it might be shutdown accidentally without manually stooping the DB from OS level . kindly Start the Database from OS level , from ORA<SID> if having Linux based OS where SAP is configured , then try to start SAP after your manually start db and start the listener controls for the same if applicable. Then you can use - STARTSAP , from <SID>ADM user.

Regards,

Nishant

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Nishant,

i am begginer on sap basis, would you explain the step?

Thanx

0