cancel
Showing results for 
Search instead for 
Did you mean: 

DB error 0: when login the SAP

0 Kudos

Hi,

I have just install a new application server(on new hardware) on exiting production server. When I try to login GUI direct with production server then I am able to login and

If I try to login GUI with new application server its show an error u201CDB ERROR-0u201D.

I have update the kernel(221) on both systems.

Pls guide me to solve this problem.

Madan Choudhary

Accepted Solutions (0)

Answers (3)

Answers (3)

kishore_soma
Active Participant
0 Kudos

Dear Mada,

Jus for the clarification, Can we know, what it sht OS of CI and new apps server, Oracle client version in ci and new apps server. DB version.

Regards,

Kishore Soma

0 Kudos

i have try to upload new profile in main central system. but its not read the profile of additional application server.

its show profile not be read. the import is therefore not posiible.

so how i can maintaion the profile of new additional application server.

former_member227283
Active Contributor
0 Kudos

Hi,

In your landscape /sapmnt/<sid>/profile shared between CI and apps ???

The profile which is said earlier , present in default proifle or not ??

What error you get while importing the profile ??

Thanks

Anil

0 Kudos

yes in my lanscape the /sapmnt/<sid>/profile is shared.

error is:

Import the start and instance profiles of all active servers

The following default profile is imported:

bchqas_QAS_00:D:\usr\sap\QAS\SYS\profile\DEFAULT.PFL

The following instance profiles are imported:

bchqas_QAS_00:D:\usr\sap\QAS\SYS\profile\QAS_DVEBMGS00_bchqas

sapload_QAS_01:
bchqas\sapmnt\QAS\SYS\profile\QAS_D01_sapload

The following start profiles are imported:

bchqas_QAS_00:D:\usr\sap\QAS\SYS\profile\START_DVEBMGS00_bchqas

sapload_QAS_01:
bchqas\sapmnt\QAS\SYS\profile\START_D01_sapload

-


Log for the import of profiles

Instance profile
bchqas\sapmnt\QAS\SYS\profile\QAS_D01_sapload

Could not be read. The import is therefore not possible.

Start profile
bchqas\sapmnt\QAS\SYS\profile\START_D01_sapload

Could not be read. The import is therefore not possible.

Instance profile
bchqas\sapmnt\QAS\SYS\profile\QAS_D01_sapload

Could not be read by file; Therefore could not be checked.

(Server = sapload_QAS_01 )

former_member227283
Active Contributor
0 Kudos

Hi,

Instance profile \\bchqas\sapmnt\QAS\SYS\profile\QAS_D01_sapload                
Could not be read. The import is therefore not possible.                        
Start profile \\bchqas\sapmnt\QAS\SYS\profile\START_D01_sapload                 
Could not be read. The import is therefore not possible.                        
Instance profile \\bchqas\sapmnt\QAS\SYS\profile\QAS_D01_sapload

check the autnorization of all this there files in CI system

Thanks

Anil

0 Kudos

what permission given on that profile becouse as per permission these profile is permitted to evryone with full authorization.

what permission given on thses.

0 Kudos

how to make upload these files in rz10.

kishore_soma
Active Participant
0 Kudos

Hi madan,

Login to OS of CI, then go to start > run> type //localhost--> then you should be able to see two shares sapmnt and saploc --> open sapmnt/SID/profile. Check whether you are able to read it with <SID>adm user.

Regards,

Kishore Soma

0 Kudos

ya i have to checked all profile will open with <SID>adm.

former_member227283
Active Contributor
0 Kudos

Hi Madam,

As said earlier does that parameter exists in DEFAULT profile ??

Thanks

Anil

0 Kudos

yes,

this parameter is in default

rdisp/bufrefmode = sendon,exeauto

Former Member
0 Kudos

Please check the logs in the work directory dev_* for further information.

Kind regards,

Mark

0 Kudos

i am read some dev_* files from work dire but not geeting any error or solution.

can u please identify the trc file.

Former Member
0 Kudos

Hi,

What is the database? Also, can you brief us how did you install the application instance. Did you face any issue while installation. Check if the services are started and please paste the log of dev_w0

Regards,

Sharath

0 Kudos

trc file: "dev_w0", trc level: 1, release: "700"

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, MJ

*

B

B Thu Apr 15 12:00:29 2010

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\QAS\D01\exe\dboraslib.dll' ...

B Library 'D:\usr\sap\QAS\D01\exe\dboraslib.dll' loaded

B Version of 'D:\usr\sap\QAS\D01\exe\dboraslib.dll' is "700.08", patchlevel (0.107)

B New connection 0 created

M sysno 01

M sid QAS

M systemid 560 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 111

M intno 20050900

M make: multithreaded, Unicode, optimized

M pid 3352

M

M kernel runs with dp version 229000(ext=109000) (@(#) DPLIB-INT-VERSION-229000-UC)

M length of sys_adm_ext is 576 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3352) [dpxxdisp.c 1301]

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M DpShMCreate: sizeof(wp_adm) 12928 (1436)

M DpShMCreate: sizeof(tm_adm) 4232256 (21056)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

M DpShMCreate: sizeof(comm_adm) 528064 (1048)

M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M DpShMCreate: sizeof(slock_adm) 0 (96)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1536)

M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 06810040, size: 4886568)

M DpShMCreate: allocated sys_adm at 06810040

M DpShMCreate: allocated wp_adm at 06812090

M DpShMCreate: allocated tm_adm_list at 06815310

M DpShMCreate: allocated tm_adm at 06815340

M DpShMCreate: allocated wp_ca_adm at 06C1E780

M DpShMCreate: allocated appc_ca_adm at 06C24540

M DpShMCreate: allocated comm_adm at 06C26480

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 06CA7340

M DpShMCreate: allocated gw_adm at 06CA7380

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 06CA73B0

M DpShMCreate: allocated wall_adm at 06CA73B8

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Thu Apr 15 12:00:30 2010

M ThInit: running on host sapload

M calling db_connect ...

C Prepending D:\usr\sap\QAS\D01\exe to Path.

C Oracle Client Version: '10.2.0.2.0'

C Client NLS settings: AMERICAN_AMERICA.UTF8

C Logon as OPS$-user to get SAPSR3's password

C Connecting as /@QAS on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 05BDACB8 06E56904 06E5618C

C Attaching to DB Server QAS (con_hdl=0,svchp=06E560D8,srvhp=06E675E4)

C

C Thu Apr 15 12:00:31 2010

C Starting user session (con_hdl=0,svchp=06E560D8,srvhp=06E675E4,usrhp=06EB2E08)

C Now '/@QAS' is connected (con_hdl 0, nls_hdl 0).

C Got SAPSR3's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=06E560D8,usrhp=06EB2E08)

C Now I'm disconnected from ORACLE

C Connecting as SAPSR3/<pwd>@QAS on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 05BDACB8 06E56904 06E5618C

C Starting user session (con_hdl=0,svchp=06E560D8,srvhp=06E675E4,usrhp=06EB2E08)

C Now 'SAPSR3/<pwd>@QAS' is connected (con_hdl 0, nls_hdl 0).

C Database NLS settings: AMERICAN_AMERICA.UTF8

C DB instance QAS is running on BCHQAS with ORACLE version 10.2.0.2.0 since APR 11, 2010, 17:15:57

B Connection 0 opened (DBSL handle 0)

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20100415 120030 BCHQAS

M db_connect o.k.

M ICT: exclude compression: .zip,.cs,.rar,.arj,.z,.gz,.tar,.lzh,.cab,.hqx,.ace,.jar,.ear,.war,.css,.pdf,.js,.gzip,.uue,.bz2,.iso,.sda,.sar,.gif

I MtxInit: 0 0 0

M SHM_PRES_BUF (addr: 0B500040, size: 4400000)

M SHM_ROLL_AREA (addr: 788A0040, size: 61440000)

M SHM_PAGING_AREA (addr: 0B940040, size: 32768000)

M SHM_ROLL_ADM (addr: 0D890040, size: 615040)

M SHM_PAGING_ADM (addr: 0D930040, size: 525344)

M ThCreateNoBuffer allocated 544152 bytes for 1000 entries at 0D9C0040

M ThCreateNoBuffer index size: 3000 elems

M ThCreateVBAdm allocated 12160 bytes (50 server) at 06FA0040

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X ES initialized.

B

B Thu Apr 15 12:00:55 2010

B db_con_shm_ini: WP_ID = 0, WP_CNT = 9, CON_ID = -1

B

B Thu Apr 15 12:00:56 2010

B dbtbxbuf: Buffer TABL (addr: 134500C8, size: 30000000, end: 150EC448)

B dbtbxbuf: Profile: max_objects = 5000, displace = 1, reorg = 1

B dbtbxbuf: request_unit = 2000, sync_reload = 5, inval_reload = 5

B dbtbxbuf: protect_shm = 0, force_checks = 0

B dbtbxbuf: tsize_retry = 14293376

B ***LOG BB0=> buffer TABL started with length 30000000 bytes [dbtbxbuf#2 @ 16178] [dbtbxbuf1617 8]

B dbtbxbuf: Buffer TABLP (addr: 150F00C8, size: 10240000, end: 15AB40C8)

B dbtbxbuf: Profile: max_objects = 500, displace = 1, reorg = 1

B dbtbxbuf: request_unit = 2000, sync_reload = 5, inval_reload = 5

B dbtbxbuf: protect_shm = 0, force_checks = 0

B dbtbxbuf: tsize_retry = 5045888

B ***LOG BB0=> buffer TABLP started with length 10240000 bytes [dbtbxbuf#2 @ 16178] [dbtbxbuf1617 8]

B dbtbxbuf: Reading TBX statistics:

B dbtbxbuf: 14 object entries precreated

B Layout of EIBUF buffer shared memory:

B 0: 1 * 4 = 4

B 1: 1 * 344 = 344

B 2: 9 * 20 = 180

B 3: 4001 * 48 = 192048

B 4: 2000 * 232 = 464000

B 5: 4001 * 4 = 16004

B 6: 1 * 200 = 200

B 7: 65 * 4 = 260

B 8: 13754 * 256 = 3521024

B Tracing = 0, Shm Protection = 0, Force checks = 0, Recovery delay = 500000

B dbexpbuf: Buffer EIBUF (addr: 15AC00D0, size: 4194304, end: 15EC00D0)

B ***LOG BB0=> buffer EIBUF started with length 4096k bytes [dbexpbuf#2 @ 2342] [dbexpbuf2342 ]

B Layout of ESM buffer shared memory:

B 0: 1 * 4 = 4

B 1: 1 * 344 = 344

B 2: 9 * 20 = 180

B 3: 4001 * 48 = 192048

B 4: 2000 * 232 = 464000

B 5: 4001 * 4 = 16004

B 6: 1 * 200 = 200

B 7: 65 * 4 = 260

B 8: 13754 * 256 = 3521024

B Tracing = 0, Shm Protection = 0, Force checks = 0, Recovery delay = 500000

B dbexpbuf: Buffer ESM (addr: 15ED00D0, size: 4194304, end: 162D00D0)

B ***LOG BB0=> buffer ESM started with length 4096k bytes [dbexpbuf#2 @ 2342] [dbexpbuf2342 ]

B Layout of CUA buffer shared memory:

B 0: 1 * 4 = 4

B 1: 1 * 344 = 344

B 2: 9 * 20 = 180

B 3: 3001 * 48 = 144048

B 4: 1500 * 232 = 348000

B 5: 3001 * 4 = 12004

B 6: 1 * 200 = 200

B 7: 193 * 4 = 772

B 8: 5012 * 512 = 2566144

B Tracing = 0, Shm Protection = 0, Force checks = 0, Recovery delay = 500000

B dbexpbuf: Buffer CUA (addr: 162E00D0, size: 3072000, end: 165CE0D0)

B ***LOG BB0=> buffer CUA started with length 3000k bytes [dbexpbuf#2 @ 2342] [dbexpbuf2342 ]

B Layout of OTR buffer shared memory:

B 0: 1 * 4 = 4

B 1: 1 * 344 = 344

B 2: 9 * 20 = 180

B 3: 4001 * 48 = 192048

B 4: 2000 * 232 = 464000

B 5: 4001 * 4 = 16004

B 6: 1 * 200 = 200

B 7: 81 * 4 = 324

B 8: 13754 * 256 = 3521024

B Tracing = 0, Shm Protection = 0, Force checks = 0, Recovery delay = 500000

B dbexpbuf: Buffer OTR (addr: 165D00D0, size: 4194304, end: 169D00D0)

B ***LOG BB0=> buffer OTR started with length 4096k bytes [dbexpbuf#2 @ 2342] [dbexpbuf2342 ]

B ***LOG BB0=> buffer CALE started with length 500000 bytes [dbcalbuf#4 @ 2228] [dbcalbuf2228 ]

B dbtran INFO (init_connection '<DEFAULT>' [ORACLE:700.08]):

B max_blocking_factor = 5, max_in_blocking_factor = 5,

B min_blocking_factor = 5, min_in_blocking_factor = 5,

B prefer_union_all = 0, prefer_join = 0,

B prefer_fix_blocking = 0, prefer_in_itab_opt = 1,

B convert AVG = 0, alias table FUPD = 0,

B escape_as_literal = 1, opt GE LE to BETWEEN = 0,

B select * =0x0f, character encoding = STD / <none>:-,

B use_hints = abap->1, dbif->0x1, upto->2147483647, rule_in->0,

B rule_fae->0, concat_fae->0, concat_fae_or->0

M SecAudit(RsauInit): Start init of Security Audit Log for first wp.

M SecAudit(RsauCreateShm): New block for Security Audit Log allocated in SCSA

M SecAudit(RsauCreateShm): SCSA memory usage: SecAudit = 1152, total = 3048

M SecAudit(RsauShmInit): SCSA size................ = 4096

M SecAudit(RsauShmInit): addr of SCSA............. = 067E0040

M SecAudit(RsauShmInit): addr of RSAUSHM.......... = 067E07A8

M SecAudit(RsauShmInit): addr of RSAUSLOTINFO..... = 067E07E0

M SecAudit(RsauShmInit): addr of RSAUSLOTS........ = 067E07EC

M SecAudit(RsauShmInit): SHM version.............. = 5

M SecAudit(RsauShmInit): SHM Slot version......... = 2

M SecAudit(RsauShmInit): RSAU active.............. = 0

M SecAudit(RsauShmInit): number of slots possible. = 10

M SecAudit(RsauShmInit): number of slots requested = 2

M SecAudit(RsauShmInit): number of slots used..... = 2

M SecAudit(RsauShmInit): user selection........... = 0

M SecAudit(RsauShmInit): max size of one file..... = 0 KB

M SecAudit(RsauShmInit): max size of all files.... = 102400 KB

M SecAudit(RsauGetCurrentProfile): Init of shared memory completed

M SecAudit(RsauGetCurrentProfile): Security Audit Log not active

M SsfSapSecin: automatic application server initialization for SAPSECULIB

N SsfSapSecin: Looking for PSE in database

N SsfPseLoad: started...(path=D:\usr\sap\QAS\D01\sec, AS=sapload, instanceid=01)

N SsfPseLoad: Downloading file D:\usr\sap\QAS\D01\sec\SAPSYS.pse (client: , key: SYSPSE, len: 1579)

N SsfPseLoad: ended (1 of 1 sucessfully loaded, 1 checked...

N MskiCreateLogonTicketCache: Logon Ticket cache created in shared memory.

N MskiCreateLogonTicketCache: Logon Ticket cache pointer registered in shared memory.

M CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

M CCMS: AlMsUpload called by wp 0.

M CCMS: AlMsUpload successful for D:\usr\sap\QAS\D01\log\ALMTTREE.DAT (469 MTEs).

S *** init spool environment

S initialize debug system

T Stack direction is downwards.

T debug control: prepare exclude for printer trace

T new memory block 16AA7350

S spool kernel/ddic check: Ok

S using table TSP02FX for frontend printing

S 0 spool work process(es) found

S frontend print via spool service enabled

S printer list size is 150

S printer type list size is 50

S queue size (profile) = 300

S hostspool list size = 3000

S option list size is 30

S found processing queue enabled

S found spool memory service RSPO-RCLOCKS at 200400A8

S doing lock recovery

S setting server cache root

S found spool memory service RSPO-SERVERCACHE at 20040330

S using messages for server info

S size of spec char cache entry: 297028 bytes (timeout 100 sec)

S size of open spool request entry: 2236 bytes

S immediate print option for implicitely closed spool requests is disabled

A

A Thu Apr 15 12:00:57 2010

A

A -PXA--


A PXA INITIALIZATION

A System page size: 4kb, total admin_size: 4968kb, dir_size: 4928kb.

A Attached to PXA (address 488A0040, size 150000K)

A abap/pxa = shared protect gen_remote

A PXA INITIALIZATION FINISHED

A -PXA--


A

A ABAP ShmAdm attached (addr=6C858000 leng=20955136 end=6DC54000)

A >> Shm MMADM area (addr=6CCCDDD8 leng=126176 end=6CCECAB8)

A >> Shm MMDAT area (addr=6CCED000 leng=16150528 end=6DC54000)

A RFC Destination> destination sapload_QAS_01 host sapload system QAS systnr 1 (sapload_QAS_01)

A RFC Options> H=sapload,S=01,d=2,

A RFC FRFC> fallback activ but this is not a central instance.

A

A RFC rfc/signon_error_log = -1

A RFC rfc/dump_connection_info = 0

A RFC rfc/dump_client_info = 0

A RFC rfc/cp_convert/ignore_error = 1

A RFC rfc/cp_convert/conversion_char = 23

A RFC rfc/wan_compress/threshold = 251

A RFC rfc/recorder_pcs not set, use defaule value: 2

A RFC rfc/delta_trc_level not set, use default value: 0

A RFC rfc/no_uuid_check not set, use default value: 0

A RFC rfc/bc_ignore_thcmaccp_retcode not set, use default value: 0

A RFC Method> initialize RemObjDriver for ABAP Objects

M ThrCreateShObjects allocated 9514 bytes at 06FC0040

N SsfSapSecin: putenv(SECUDIR=D:\usr\sap\QAS\D01\sec): ok

N SsfSapSecin: PSE D:\usr\sap\QAS\D01\sec\SAPSYS.pse found!

N

N =================================================

N === SSF INITIALIZATION:

N ===...SSF Security Toolkit name SAPSECULIB .

N ===...SSF trace level is 0 .

N ===...SSF library is D:\usr\sap\QAS\D01\exe\sapsecu.dll .

N ===...SSF hash algorithm is SHA1 .

N ===...SSF symmetric encryption algorithm is DES-CBC .

N ===...sucessfully completed.

N =================================================

N MskiInitLogonTicketCacheHandle: Logon Ticket cache pointer retrieved from shared memory.

N MskiInitLogonTicketCacheHandle: Workprocess runs with Logon Ticket cache.

M JrfcVmcRegisterNativesDriver o.k.

W =================================================

W === ipl_Init() called

W ITS Plugin: Path dw_gui

W ITS Plugin: Description ITS Plugin - ITS rendering DLL

W ITS Plugin: sizeof(SAP_UC) 2

W ITS Plugin: Release: 700, [7000.0.111.20050900]

W ITS Plugin: Int.version, [33]

W ITS Plugin: Feature set: [14]

W ===... Calling itsp_Init in external dll ===>

W === ipl_Init() returns 0, ITSPE_OK: OK

W =================================================

M

M Thu Apr 15 12:03:35 2010

M ThIUsrDel: th_rollback_usrdelentry = 1

B

B Thu Apr 15 12:04:49 2010

B table logging switched off for all clients

nirmal_konchada
Active Contributor
0 Kudos

Hi,

This error generally arises when there is kernel problem.

Did u apply license for the new node??(may be another reason)

Regards,

Nirmal.K

0 Kudos

this node is proeprly licenced.

0 Kudos

may be if we install a new dialog instance on new hardware, not need to be licence.

if its wrong ...thn how update it.

nirmal_konchada
Active Contributor
0 Kudos

Please check by applying kernel lower/higher than 221..

Nirmal.

0 Kudos

i have allready tried with other kernels

but problem is still same

former_member227283
Active Contributor
0 Kudos

Hi Madan,

I am assuming you have shared your /sapmnt mount point between CI and apps.

Login to SAP and check in DEFAULT where following parameter exists or not

rdisp/bufrefmode  =  sendon,exeauto

If you have not shared the /sapmnt , then you have to check maually default profile of ci and apps , where both the default profile should contain above parameter.

If not , then add the parameter and restart the SAP.

Thanks

Anil