Startsap - Database is not available via R3trans

[former_member547765]

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,

[BJarkowski]

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?

[former_member547765]

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

[Former Member]

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

[former_member547765]

Hi Nishant,

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

Thanx