DB-Connect Failed, Return Code 000256

[Former Member]

Hello,

When I try to start SAP I get a SQL error saying "DB-Connect failed, return code 000256". Does anybody know what could cause this error and how to slove this problem.

I checked the dev_w0 file as the following.

-

---

trc file: "dev_w0", trc level: 1, release: "46D"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Sat May 09 21:08:37 2015

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' ...

B Library 'D:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' loaded

B Version of 'D:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' is '46D.00'

B New connection 0 created

M relno 4640

M patchlevel 0

M patchno 534

M intno 0

M pid 2444

M

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

I MtxInit: -2 0 0

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation std

M <ES> Memory Reset enabled

X ES initialized.

M ThSysUsrCheck: clear T0

M calling db_connect ...

B find_con found the following connection for reuse:

B 0: name = R/3, concnt= 000000 state = DISCONNECTED, perm = YES, reco = NO

C Got ORACLE_HOME=D:\oracle\ora81 from environment

C Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

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

C Connecting as /@PRD on connection 0 ...

C *** ERROR => OCI-call 'olog' failed: rc = 12505

[dboci.c 2423]

C *** ERROR => CONNECT failed with sql error '12505'

[dboci.c 6550]

C Try to connect with default password

C Connecting as SAPR3/<pwd>@PRD on connection 0 ...

C *** ERROR => OCI-call 'olog' failed: rc = 12505

[dboci.c 2423]

C *** ERROR => CONNECT failed with sql error '12505'

[dboci.c 6550]

C Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

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

C Connecting as /@PRD on connection 0 ...

C *** ERROR => OCI-call 'olog' failed: rc = 12505

[dboci.c 2423]

C *** ERROR => CONNECT failed with sql error '12505'

[dboci.c 6550]

C Try to connect with default password

C Connecting as SAPR3/<pwd>@PRD on connection 0 ...

C *** ERROR => OCI-call 'olog' failed: rc = 12505

[dboci.c 2423]

C *** ERROR => CONNECT failed with sql error '12505'

[dboci.c 6550]

B ***LOG BY2=> sql error 12505 performing CON [dbsh 0695 ]

B ***LOG BY0=> [dbsh 0695 ]

B ***LOG BY2=> sql error 12505 performing CON [dblink 0627 ]

B ***LOG BY0=> [dblink 0627 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1069]

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 7751]

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M tid = -1

M mode = 255

M len = -1

M rq_id = -1

M rq_source = 255

M last_tid = 0

M last_mode = 0

M rfc_req = 0

M report = > <

M action = 0

M tab_name = > <

M

M *****************************************************************************

M *

M * LOCATION SAP-Server sap_PRD_00 on host sap (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Sat May 09 21:08:37 2015

M * RELEASE 46D

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 7831

M * COUNTER 1

M *

M *****************************************************************************

M

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 2444) [dpnttool.c 300]

[Former Member]

Hi,

Restart the listener and try again. If that doesnt work, follow this note - 576919.

Regards

Cyrus

[Former Member]

Check whether your database is up ?

Thanks

prince