ABAP database must be started first

[Former Member]

Hello Experts,

I have a issue while starting SAP when execute startsap r3 I have experienced the error ABAP database must be started first.

My SAP environment is RHEL 5 and SAP NW7.0 with Oracle.

Please help me how to fix the issue.

before executing I have checked R3trans -d also it's fineshed with 0012.

Please refer below screenshot of error.

Thanks in Advance,

Karthik Bura

[maria_shen]

Hello all,

As you know, this is the Forum for IBM DB2 on LUW.
If you want to go on with communication, please continue with Oracle Forum.

Thank you.

Kind regards
Maria

[Former Member]

please check below trans.log

4 ETW000 R3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 01.11.2015 - 12:46:34

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [dev trc     ,00000]  Sun Nov  1 12:46:34 2015                             116  0.000116

4 ETW000  [dev trc     ,00000]  db_con_init called                                    19  0.000135

4 ETW000  [dev trc     ,00000]  create_con (con_name=R/3)                             33  0.000168

4 ETW000  [dev trc     ,00000]  Loading DB library '/usr/sap/W89/SYS/exe/run/dboraslib.so' ...

4 ETW000                                                                              39  0.000207

4 ETW000  [dev trc     ,00000]  load shared library (/usr/sap/W89/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000                                                                            6731  0.006938

4 ETW000  [dev trc     ,00000]  Library '/usr/sap/W89/SYS/exe/run/dboraslib.so' loaded

4 ETW000                                                                              23  0.006961

4 ETW000  [dev trc     ,00000]  function DbSlExpFuns loaded from library /usr/sap/W89/SYS/exe/run/dboraslib.so

4 ETW000                                                                               4  0.006965

4 ETW000  [dev trc     ,00000]  Version of '/usr/sap/W89/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.107)

4 ETW000                                                                               3  0.006968

4 ETW000  [dev trc     ,00000]  function dsql_db_init loaded from library /usr/sap/W89/SYS/exe/run/dboraslib.so

4 ETW000                                                                               1  0.006969

4 ETW000  [dev trc     ,00000]  function dbdd_exp_funs loaded from library /usr/sap/W89/SYS/exe/run/dboraslib.so

4 ETW000                                                                               0  0.006969

4 ETW000  [dev trc     ,00000]  New connection 0 created                               1  0.006970

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                               0  0.006970

4 ETW000  [dev trc     ,00000]  db_con_connect (con_name=R/3)                          0  0.006970

4 ETW000  [dev trc     ,00000]  find_con_by_name found the following connection for reuse:

4 ETW000                                                                               0  0.006970

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                               0  0.006970

4 ETW000  [dev trc     ,00000]  Oracle Client Version: '10.2.0.2.0'                  968  0.007938

4 ETW000  [dev trc     ,00000]  -->oci_initialize (con_hdl=0)                         23  0.007961

4 ETW000  [dev trc     ,00000]  Client NLS settings: AMERICAN_AMERICA.UTF8          2565  0.010526

4 ETW000  [dev trc     ,00000]  Logon as OPS$-user to get SAPSR3's password           24  0.010550

4 ETW000  [dev trc     ,00000]  Connecting as /@W89 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000                                                                              23  0.010573

4 ETW000  [dev trc     ,00000]  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

4 ETW000                                                                              34  0.010607

4 ETW000  [dev trc     ,00000]    0 UTF8                                                      1  0xa21f2b0  0xa22491c  0xa2241a4

4 ETW000                                                                              23  0.010630

4 ETW000  [dev trc     ,00000]  Allocating service context handle for con_hdl=0       53  0.010683

4 ETW000  [dev trc     ,00000]  Allocating server context handle                      32  0.010715

4 ETW000  [dev trc     ,00000]  Attaching to DB Server W89 (con_hdl=0,svchp=0xa224130,srvhp=0xa235914)

4 ETW000                                                                              54  0.010769

4 ETW000  [dev trc     ,00000]  Sun Nov  1 12:46:55 2015                         21013400  21.024169

4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12541

4 ETW000                                                                              28  21.024197

4 ETW000  [dbsloci.    ,00000]  *** ERROR => CONNECT failed with sql error '12541'

4 ETW000                                                                              29  21.024226

4 ETW000  [dev trc     ,00000]     set_ocica() -> OCI or SQL return code 12541        24  21.024250

4 ETW000  [dev trc     ,00000]  Try to connect with default password                  43  21.024293

4 ETW000  [dev trc     ,00000]  Connecting as SAPSR3/<pwd>@W89 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000                                                                              24  21.024317

4 ETW000  [dev trc     ,00000]  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

4 ETW000                                                                              25  21.024342

4 ETW000  [dev trc     ,00000]    0 UTF8                                                      1  0xa21f2b0  0xa22491c  0xa2241a4

4 ETW000                                                                              23  21.024365

4 ETW000  [dev trc     ,00000]  server_detach(con_hdl=0,stale=0,svrhp=0xa235914)

4 ETW000                                                                              22  21.024387

4 ETW000  [dev trc     ,00000]  Detaching from DB Server (con_hdl=0,svchp=0xa224130,srvhp=0xa235914)

4 ETW000                                                                              21  21.024408

4 ETW000  [dev trc     ,00000]  Deallocating server context handle 0xa235914           3  21.024411

4 ETW000  [dev trc     ,00000]  Allocating server context handle                       3  21.024414

4 ETW000  [dev trc     ,00000]  Attaching to DB Server W89 (con_hdl=0,svchp=0xa224130,srvhp=0xa235914)

4 ETW000                                                                               2  21.024416

4 ETW000  [dev trc     ,00000]  Sun Nov  1 12:47:16 2015                         21011598  42.036014

4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12541

4 ETW000                                                                              36  42.036050

4 ETW000  [dbsloci.    ,00000]  *** ERROR => CONNECT failed with sql error '12541'

4 ETW000                                                                              25  42.036075

4 ETW000  [dev trc     ,00000]     set_ocica() -> OCI or SQL return code 12541        15  42.036090

4 ETW000  [dblink      ,00431]  ***LOG BY2=>sql error 12541  performing CON [dblink#3 @ 431]

4 ETW000                                                                              99  42.036189

4 ETW000  [dblink      ,00431]  ***LOG BY0=>ORA-12541: TNS:no listener [dblink#3 @ 431]

4 ETW000                                                                              22  42.036211

2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'W89'"

[arun_kumar165]

Hi Karthik,

Please verify listener is running.

Please follow the procedure to startup

-->Start the listener first(ORA<SID>).

-->Start Database(SQL).

-->Start Sap(<SID>ADM).

[Former Member]

Hello Arun,

Please check ABAP database must be started first another post/thread created Please check thread https://scn.sap.com/thread/3820329 i have posted all information in thread.

Thanks,

Karthik