cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

ABAP Database is not available via R3trans

Former Member

on ‎03-16-2006 5:37 PM

0 Kudos

hello There!

I am new as a basis and currently installing Java Add-In for Abap.

My installation stopped during Phase23 of 25 Start J2EE instance. Below is the error i've got... From there i can no longer logon.

R3trans check finished with return code: 12

      • ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/C11/SYS/exe/run/startdb: Terminating with error code 12

Please need your help...

Thanks,

Nina

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
‎03-20-2006 3:31 AM
0 Kudos

4 ETW000 R3trans version 6.09 (release 640 - 28.04.04 - 16:14:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 20.03.2006 - 11:32:06

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] Mon Mar 20 11:32:06 2006 34486 0.034486

4 ETW000 [dev trc ,00000] db_con_init called 32 0.034518

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

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

4 ETW000 467 0.050551

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

4 ETW000 202303 0.252854

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

4 ETW000 46 0.252900

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

4 ETW000 53 0.252953

4 ETW000 [dev trc ,00000] Version of '/usr/sap/C11/SYS/exe/run/dboraslib.o' is "640.00", patchlevel (0.19)

4 ETW000 106 0.253059

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

4 ETW000 46 0.253105

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

4 ETW000 71 0.253176

4 ETW000 [dev trc ,00000] New connection 0 created 2371 0.255547

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

4 ETW000 54 0.255601

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

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

4 ETW000 44 0.255717

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

4 ETW000 49 0.255766

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/C11/920_64 from environment

4 ETW000 3857 0.259623

4 ETW000 [dev trc ,00000] -->oci_initialize 48 0.259671

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 1571 0.261242

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPC11's password 57 0.261299

4 ETW000 [dev trc ,00000] Connecting as /@C11 on connection 0 ... 31 0.261330

4 ETW000 [dev trc ,00000] Allocating service context handle 918 0.262248

4 ETW000 [dev trc ,00000] Allocating server context handle 37 0.262285

4 ETW000 [dev trc ,00000] Attaching to DB Server C11 (con_hdl=0,svchp=0x110c3ef38,svrhp=0x110c41598)

4 ETW000 88 0.262373

4 ETW000 [dev trc ,00000] Assigning server context 0x110c41598 to service context 0x110c3ef38

4 ETW000 42353 0.304726

4 ETW000 [dev trc ,00000] Allocating user session handle 450 0.305176

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x110c3ef38,srvhp=0x110c41598,usrhp=0x110c4c0f8)

4 ETW000 62 0.305238

4 ETW000 [dev trc ,00000] Assigning user session 0x110c4c0f8 to service context 0x110c3ef38

4 ETW000 6321 0.311559

4 ETW000 [dev trc ,00000] Now I'm connected to ORACLE 2315 0.313874

4 ETW000 [dev trc ,00000] Got SAPC11's password from OPS$-user 1610 0.315484

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 59 0.315543

4 ETW000 [dev trc ,00000] Rolling back transaction ... 526 0.316069

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

4 ETW000 261 0.316330

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 386 0.316716

4 ETW000 [dev trc ,00000] Connecting as SAPC11/<pwd>@C11 on connection 0 ...

4 ETW000 49 0.316765

4 ETW000 [dev trc ,00000] Assigning username to user session 0x110c4c0f8 296 0.317061

4 ETW000 [dev trc ,00000] Assigning password to user session 0x110c4c0f8 45 0.317106

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x110c3ef38,srvhp=0x110c41598,usrhp=0x110c4c0f8)

4 ETW000 50 0.317156

4 ETW000 [dev trc ,00000] Assigning user session 0x110c4c0f8 to service context 0x110c3ef38

4 ETW000 3361 0.320517

4 ETW000 [dev trc ,00000] Now I'm connected to ORACLE 877 0.321394

4 ETW000 [dev trc ,00000] Database NLS settings: AMERICAN_AMERICA.UTF8 1088 0.322482

4 ETW000 [dev trc ,00000] Database instance C11 is running on CRMdev with ORACLE version 9.2.0.3.0 since 20060317

4 ETW000 1937 0.324419

4 ETW000 [dev trc ,00000] Connection 0 opened 19875 0.344294

4 ETW000 [dev trc ,00000] NTAB: Structure of NTAB on DB is VERS_B 39520 0.383814

4 ETW000 [dev trc ,00000] NTAB: standalone processing 1611 0.385425

4 ETW000 [dev trc ,00000] NTAB: read profile 429 0.385854

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/entrycount 1000. 30 0.385884

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/ftabsize 500. 42 0.385926

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/irbdsize 100. 28 0.385954

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/sntabsize 100. 28 0.385982

4 ETW000 [dev trc ,00000] NTAB: compute_hash_card: 2003. 243 0.386225

4 ETW000 [dev trc ,00000] NTAB: maxcnt 1000. 37 0.386262

4 ETW000 [dev trc ,00000] NTAB: hfactor 2003. 27 0.386289

4 ETW000 [dev trc ,00000] NTAB: mem_protocol_size 104 28 0.386317

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_offset 0 27 0.386344

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_size 0 28 0.386372

4 ETW000 [dev trc ,00000] NTAB: FTAB: header_size 80. 28 0.386400

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_size 64. 27 0.386427

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_cnt 1000. 28 0.386455

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_size 4 47 0.386502

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_cnt 128000. 29 0.386531

4 ETW000 [dev trc ,00000] NTAB: FTAB: data_size 512000. 28 0.386559

4 ETW000 [dev trc ,00000] NTAB: IREC: header_size 80. 28 0.386587

4 ETW000 [dev trc ,00000] NTAB: IREC: item_size 64. 27 0.386614

4 ETW000 [dev trc ,00000] NTAB: IREC: item_cnt 250. 27 0.386641

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_size 8 28 0.386669

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_cnt 12800. 27 0.386696

4 ETW000 [dev trc ,00000] NTAB: IREC: data_size 102400. 28 0.386724

4 ETW000 [dev trc ,00000] NTAB: STAB: header_size 80. 28 0.386752

4 ETW000 [dev trc ,00000] NTAB: STAB: item_size 64. 27 0.386779

4 ETW000 [dev trc ,00000] NTAB: STAB: item_cnt 250. 28 0.386807

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_size 4 27 0.386834

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_cnt 25600. 28 0.386862

4 ETW000 [dev trc ,00000] NTAB: STAB: data_size 102400. 28 0.386890

4 ETW000 [dev trc ,00000] NTAB: TTAB: header_size 184. 28 0.386918

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_size 40. 28 0.386946

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_cnt 1000. 27 0.386973

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_size 256 28 0.387001

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_cnt 1000. 28 0.387029

4 ETW000 [dev trc ,00000] NTAB: TTAB: data_size 256000. 27 0.387056

4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 110c6c4b0, hh_len 80 1988 0.389044

4 ETW000 [dev trc ,00000] NTAB: FTAB: aa_p 110d21090, aa_len 16024 36 0.389080

4 ETW000 [dev trc ,00000] NTAB: FTAB: ia_p 110d24f50, ia_len 64000 29 0.389109

4 ETW000 [dev trc ,00000] NTAB: FTAB: dat_p 110d34970, dat_len 512000 29 0.389138

4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 110c6c510, hh_len 80 28 0.389166

4 ETW000 [dev trc ,00000] NTAB: IREC: aa_p 110db1990, aa_len 16024 29 0.389195

4 ETW000 [dev trc ,00000] NTAB: IREC: ia_p 110db5850, ia_len 16000 29 0.389224

4 ETW000 [dev trc ,00000] NTAB: IREC: dat_p 110db96f0, dat_len 102400 28 0.389252

4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 110c83c70, hh_len 80 29 0.389281

4 ETW000 [dev trc ,00000] NTAB: STAB: aa_p 110dd2710, aa_len 16024 28 0.389309

4 ETW000 [dev trc ,00000] NTAB: STAB: ia_p 110dd65d0, ia_len 16000 29 0.389338

4 ETW000 [dev trc ,00000] NTAB: STAB: dat_p 110dda470, dat_len 102400 29 0.389367

4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 110c83cd0, hh_len 184 28 0.389395

4 ETW000 [dev trc ,00000] NTAB: TTAB: aa_p 110df3490, aa_len 16024 29 0.389424

4 ETW000 [dev trc ,00000] NTAB: TTAB: ia_p 110df7350, ia_len 40000 29 0.389453

4 ETW000 [dev trc ,00000] NTAB: TTAB: dat_p 110e00fb0, dat_len 256000 28 0.389481

4 ETW000 [dev trc ,00000] NTAB: ntab_mem_protocol 110c83cd0, ntab_mp_p 110c83cd0, ntab_proc_id 0

4 ETW000 57 0.389538

4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 110c6c4b0, ha_list 110d21090, hi_list 110d24f50, buffer 110d34970

4 ETW000 107 0.389645

4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 110c6c510, ha_list 110db1990, hi_list 110db5850, buffer 110db96f0

4 ETW000 60 0.389705

4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 110c83c70, ha_list 110dd2710, hi_list 110dd65d0, buffer 110dda470

4 ETW000 44 0.389749

4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 110c83d38, ha_list 110df3490, hi_list 110df7350, buffer 110e00fb0

4 ETW000 45 0.389794

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 0

4 ETW000 295 0.390089

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 1

4 ETW000 75 0.390164

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 2

4 ETW000 69 0.390233

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 3

4 ETW000 65 0.390298

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_READ_ONLY', tname = 'TADIR' ) {twdbcall.c:734}

4 ETW000 38003 0.428301

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_READ_ONLY', retcode = 0 )

4 ETW000 6483 0.434784

4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'C11' --- SYSTEM = 'C11'.

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_INSERT', tname = 'PATCHHIST' ) {saprel.c:1127}

4 ETW000 1299 0.436083

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_INSERT', retcode = 0 ) 64169 0.500252

4 ETW000 [dev trc ,00000] dsql_open (con_da=(0,R/3),stmt="SELECT EXECUTABLE,SAPRELEASE,H ...",#binds=0,name=UNKNOWN,#input=0)

4 ETW000 1100 0.501352

4 ETW000 [dev trc ,00000] dsql_fetch (con_da=(0,R/3),cu_id=0,#output=8) 225 0.501577

4 ETW000 [dev trc ,00000] dsql_close (con_da=(0,R/3),cu_id=0) 11646 0.513223

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_DELETE', tname = 'PATCHHIST' ) {saprel.c:1235}

4 ETW000 63 0.513286

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_DELETE', retcode = 0 ) 16688 0.529974

4 ETW690 "0" "0"

4 ETW000 [dev trc ,00000] db_con_commit (con_da={R/3,0,0},th_commit=1,tx=1,hold_cursor=0)

4 ETW000 512 0.530486

4 ETW000 COMMIT (0).

4 ETW000 trace to file pointer closed

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

4 ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time : 20.03.2006 - 11:32:06

4 ETW000 function : CONNECT

4 ETW000 buffersync : YES

4 ETW000 clients : default

4 ETW000 l.s.m. : VECTOR

4 ETW000 commit : 100000

4 ETW000 table cache : 16000000

4 ETW000

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 6849 0.006849

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 62 0.006911

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

4 ETW000 482 0.007393

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

4 ETW000 534 0.007927

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 363 0.008290

4 ETW000 [dev trc ,00000] Disconnected from connection 0 32 0.008322

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=1, com_tx=1)

4 ETW000 331 0.008653

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000 43 0.008696

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 20.03.2006 - 11:32:06

Show replies
Show replies
Former Member
‎03-16-2006 5:54 PM
0 Kudos

Hello Prince Jose,

Thanks for your quick reply.

i already run the database... here's the error.

CRMdev@root[/]su - c11adm

CRMdev:c11adm> startsap

Checking C11 Database

-

ABAP Database is not available via R3trans

Checking C11 Database

-

Starting SAP-Collector Daemon

-

******************************************************************************

  • This is Saposcol Version COLL 20.86 640 - AIX v4.20 5L-64 bit 040309

  • Usage: saposcol -l: Start OS Collector

  • saposcol -k: Stop OS Collector

  • saposcol -d: OS Collector Dialog Mode

  • saposcol -s: OS Collector Status

  • Starting collector (create new process)

******************************************************************************

/usr/sap/tmp/dev_coll moved to /usr/sap/tmp/dev_coll.old

saposcol on host CRMdev started

Running /usr/sap/C11/SYS/exe/run/startdb

Trying to start C11 database ...

Log file: /home/c11adm/startdb.log

/usr/sap/C11/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

Show replies
Show replies
Former Member
‎03-16-2006 6:01 PM
0 Kudos

execute R3trans -d and paste the log here.

Thanks

Prince

Former Member
‎03-16-2006 11:41 PM
0 Kudos

What is the database?...its Oracle?

I had the same error with oracle, the Oracle Client already instaled?.

Other point to review its the user authorizations.

Regards and good luck!

Ernesto

Former Member
‎03-16-2006 5:39 PM
0 Kudos

Checking C11 Database

-

Starting SAP-Collector Daemon

-

saposcol already running

Running /usr/sap/C11/SYS/exe/run/startdb

DB startup failed

Checking C11 Database

-

ABAP Database is not available via R3trans

Checking C11 Database

-

Starting SAP-Collector Daemon

-

saposcol already running

Running /usr/sap/C11/SYS/exe/run/startdb

DB startup failed

Show replies
Show replies
Former Member
‎03-16-2006 5:44 PM
0 Kudos

Seems Database is not online. Start the Database

Thanks

Prince Jose

Former Member
‎03-20-2006 3:31 AM
0 Kudos

Guys,

Thanks a lot! Our platform is AIX/Oracle. I am in the process of installing Java_add in for CRM.

I guess the error comes during phase 4-7 when by default i accepted another new schema name SAPC11DB... where my original schema is SAPC11. What do you think.

Please help me...

Nina

Message was edited by: Nina Evora

Ask a Question