|
#1
20/05/08, 20:17:24
|
|||
|
|||
|
DB-Connect Failed, Return Code 000256
Hola
Al intentar arrancar SAP,me arranca, pero en 1 min el disp work mueren. En el Eventwiever veo el error: DB-Connect Failed, Return Code 000256 Lo curioso es que no he moficado nada en el servidor, ni variables de entorno... Estoy perdido .... alguna idea???  
|
|
#4
21/05/08, 07:27:00
|
|||
|
|||
SAP version?
OS version? DB version? Mira esta ruta /usr/sap/SID/DEVGMGS00/work que contiene ?
|
|
#8
21/05/08, 08:29:10
|
||||
|
||||
¿tienes oracle?
en caso afirmativo ¿has mirado el fichero de alertas de oracle? ¿la traza de los WP's? ¿el log del listener? Con la información que das es dificil averiguar algo mas. En principio es un problema con la conexión a la BBDD, puede ser porque ésta no esté arrancada o por algun problema al conectarse los work process. intenta hacer un R3trans -d y mira a ver si se conecta e investoga el trans.log Un saludo
|
|
#9
21/05/08, 08:50:50
|
|||
|
|||
|
Hola
Te reenvio el log del trans.log Lo curioso es que no se ha modificado nada... 4 ETW000 R3trans version 6.05 (release 46D - 28.03.01 - 11:30:00). 4 ETW000 =============================================== 4 ETW000 4 ETW000 control file: <no ctrlfile> 4 ETW000 R3trans was called as follows: R3trans -d 4 ETW000 date&time : 21.05.2008 - 10:33:41 4 ETW000 trace at level 2 opened for a given file pointer 4 ETW000 [developertrace,0] Wed May 21 10:33:42 2008 183370 0.183370 4 ETW000 [developertrace,0] db_con_init called 160 0.183530 4 ETW000 [developertrace,0] create_con (con_name=R/3) 124 0.183654 4 ETW000 [developertrace,0] Loading DB library 'dboraslib.dll' ... 4 ETW000 252 0.183906 4 ETW000 [developertrace,0] load shared library (dboraslib.dll), hdl 0 4 ETW000 4777 0.188683 4 ETW000 [developertrace,0] Library 'dboraslib.dll' loaded 4 ETW000 88 0.188771 4 ETW000 [developertrace,0] function DbSlExpFuns loaded from library dboraslib.dll 4 ETW000 94 0.188865 4 ETW000 [developertrace,0] Version of 'dboraslib.dll' is '46D.00' 4 ETW000 137 0.189002 4 ETW000 [developertrace,0] function dsql_db_init loaded from library dboraslib.dll 4 ETW000 98 0.189100 4 ETW000 [developertrace,0] function dbdd_exp_funs loaded from library dboraslib.dll 4 ETW000 113 0.189213 4 ETW000 [developertrace,0] New connection 0 created 105 0.189318 4 ETW000 [developertrace,0] db_con_connect (con_name=R/3) 97 0.189415 4 ETW000 [developertrace,0] find_con found the following connection for reuse: 4 ETW000 85 0.189500 4 ETW000 [developertrace,0] Got ORACLE_HOME=d:\oracle\ora81 from environment 4 ETW000 1365 0.190865 4 ETW000 [developertrace,0] -->oci_initialize 72 0.190937 4 ETW000 [developertrace,0] Got ORACLE_SID=PK2 from environment 4 ETW000 332 0.191269 4 ETW000 [developertrace,0] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment 4 ETW000 96 0.191365 4 ETW000 [developertrace,0] Logon as OPS$-user to get SAPR3's password 4 ETW000 80 0.191445 4 ETW000 [developertrace,0] Connecting as /@PK2 on connection 0 ... 4 ETW000 80 0.191525 4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='', dbname='PK2') 4 ETW000 101 0.191626 4 ETW000 [developertrace,0] Wed May 21 10:33:44 2008 2200553 2.392179 4 ETW000 [dboci.c ,0] *** ERROR => OCI-call 'olog' failed: rc = 1017 4 ETW000 110 2.392289 4 ETW000 [dboci.c ,0] *** ERROR => CONNECT failed with sql error '1017' 4 ETW000 91 2.392380 4 ETW000 [developertrace,0] Try to connect with default password 4 ETW000 78 2.392458 4 ETW000 [developertrace,0] Connecting as SAPR3/<pwd>@PK2 on connection 0 ... 4 ETW000 84 2.392542 4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='SAPR3', dbname='PK2') 4 ETW000 83 2.392625 4 ETW000 [dboci.c ,0] *** ERROR => OCI-call 'olog' failed: rc = 1017 4 ETW000 107060 2.499685 4 ETW000 [dboci.c ,0] *** ERROR => CONNECT failed with sql error '1017' 4 ETW000 94 2.499779 4 ETW000 [developertrace,0] Got ORACLE_SID=PK2 from environment 4 ETW000 676 2.500455 4 ETW000 [developertrace,0] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment 4 ETW000 85 2.500540 4 ETW000 [developertrace,0] Logon as OPS$-user to get SAPR3's password 4 ETW000 77 2.500617 4 ETW000 [developertrace,0] Connecting as /@PK2 on connection 0 ... 4 ETW000 69 2.500686 4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='', dbname='PK2') 4 ETW000 72 2.500758 4 ETW000 [dboci.c ,0] *** ERROR => OCI-call 'olog' failed: rc = 1017 4 ETW000 510291 3.011049 4 ETW000 [dboci.c ,0] *** ERROR => CONNECT failed with sql error '1017' 4 ETW000 85 3.011134 4 ETW000 [developertrace,0] Try to connect with default password 4 ETW000 69 3.011203 4 ETW000 [developertrace,0] Connecting as SAPR3/<pwd>@PK2 on connection 0 ... 4 ETW000 74 3.011277 4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='SAPR3', dbname='PK2') 4 ETW000 82 3.011359 4 ETW000 [developertrace,0] Wed May 21 10:33:45 2008 130841 3.142200 4 ETW000 [dboci.c ,0] *** ERROR => OCI-call 'olog' failed: rc = 1017 4 ETW000 96 3.142296 4 ETW000 [dboci.c ,0] *** ERROR => CONNECT failed with sql error '1017' 4 ETW000 80 3.142376 4 ETW000 [dblink ,627] ***LOG BY2=>sql error 1017 performing CON 4 ETW000 115 3.142491 4 ETW000 [dblink ,627] ***LOG BY0=> 48 3.142539 2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PK2'"
|
|
#10
21/05/08, 09:06:59
|
||||
|
||||
|
da la sensacion de que se haya cambiado la password del usuario sapr3
¿teneis la password estandard o la habeis cambiado? si teneis oracle 8 como parece, intenta desde el SO: svrmgrl connect sapr3 cuando te pida la password introduce sap si no la habeis cambiado y si la habeis cambiado pues la que sea si esto te funciona y puedes hacer p.ej. un select * from t000; el problema viene por otro lado. si no puedes conectarte con sapr3, el problema viene de alli y tienes como opciones: 1.- la rapida y chapuza: cambiar la password de sapr3 a sap (la pass standard) 2. aplicar la nota OSS 400241 para reinicializar el metodo de conexion Un saludo Úlima edición por elalien fecha: 21/05/08 a las 09:40:14.
|
 |
| Herramientas | Buscar en Tema |
| Desplegado | |
|
|
Mode Lineal
