SAP system down

[tolulope_okusaga]

Hello Gurus,

The SAP system does not start with the command "startsap".

the error displayed is "ABAP database is not available via R3trans".

I have checked and started the database with user oramlq; everything looks fine from the ORACLE end. the listener is working and i have checked the details from the ORACLE & SAP profile.

When I test the connection with the command "R3trans -d" I get an error "R3trans finished with (0012)".

what is the problem.

Regards,

Tolulope

[former_member185031]

So what the trans.log files says ?

Regards,

Subhash

[tolulope_okusaga]

Below is the log for "R3trans -x"

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

4 ETW000 R3trans version 6.14 (release 700 - 23.11.07 - 14:31:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 01.12.2009 - 15:30:12

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] Tue Dec 1 15:30:12 2009 4166 0.004166

4 ETW000 [dev trc ,00000] db_con_init called 216 0.004382

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

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

4 ETW000 786 0.005757

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

4 ETW000 203378 0.209135

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

4 ETW000 483 0.209618

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

4 ETW000 482 0.210100

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

4 ETW000 1774 0.211874

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

4 ETW000 483 0.212357

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

4 ETW000 910 0.213267

4 ETW000 [dev trc ,00000] New connection 0 created 296 0.213563

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 441 0.214004

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

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

4 ETW000 470 0.214739

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 485 0.215224

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 4341 0.219565

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

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 111252 0.331093

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

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

4 ETW000 448 0.331820

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

4 ETW000 1076 0.332896

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x10183ae50 0x1018428a0 0x101852fd8

4 ETW000 485 0.333381

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

4 ETW000 [dev trc ,00000] Allocating server context handle 244 0.333892

4 ETW000 [dev trc ,00000] Attaching to DB Server MLQ (con_hdl=0,svchp=0x101852f08,srvhp=0x1018551f8)

4 ETW000 472 0.334364

4 ETW000 [dev trc ,00000] Tue Dec 1 15:30:14 2009 1137362 1.471726

4 ETW000 [dev trc ,00000] Assigning server context 0x1018551f8 to service context 0x101852f08

4 ETW000 493 1.472219

4 ETW000 [dev trc ,00000] Allocating user session handle 299 1.472518

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x101852f08,srvhp=0x1018551f8,usrhp=0x1018430b8)

4 ETW000 752 1.473270

4 ETW000 [dev trc ,00000] Assigning user session 0x1018430b8 to service context 0x101852f08

4 ETW000 24978 1.498248

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;

4 ETW000 573 1.498821

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;

4 ETW000 754 1.499575

4 ETW000 [dev trc ,00000] Now '/@MLQ' is connected (con_hdl 0, nls_hdl 0).

4 ETW000 1579 1.501154

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000 482 1.501636

4 ETW000 [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)

4 ETW000 1251 1.502887

4 ETW000 [dev trc ,00000] OCI-call failed with -1=OCI_ERROR 2021 1.504908

4 ETW000 [dev trc ,00000] SQL error 942: 'ORA-00942: table or view does not exist'

4 ETW000 488 1.505396

4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-942 when accessing table SAPUSER

4 ETW000 484 1.505880

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 942 252 1.506132

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 375 1.506507

4 ETW000 [dev trc ,00000] Rolling back transaction ... 281 1.506788

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x101852f08,usrhp=0x1018430b8)

4 ETW000 570 1.507358

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 1016 1.508374

4 ETW000 [dev trc ,00000] Try to connect with default password 208 1.508582

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

4 ETW000 469 1.509051

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

4 ETW000 480 1.509531

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x10183ae50 0x1018428a0 0x101852fd8

4 ETW000 491 1.510022

4 ETW000 [dev trc ,00000] Assigning username to user session 0x1018430b8 253 1.510275

4 ETW000 [dev trc ,00000] Assigning password to user session 0x1018430b8 247 1.510522

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x101852f08,srvhp=0x1018551f8,usrhp=0x1018430b8)

4 ETW000 463 1.510985

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

4 ETW000 11150 1.522135

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

4 ETW000 479 1.522614

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 250 1.522864

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

4 ETW000 1670 1.524534

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#5 @ 431]

4 ETW000 480 1.525014

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

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

[JPReyes]

ORA-942 when accessing table SAPUSER
ORA-01017: invalid username/password; logon deni

You have a problem with the OPS$ users.

SAP Note 400241 should fix the issue.

Regards

Juan

[JPReyes]

Post the content of trans.log here,

Regards

Juan