{"id":2033,"date":"2019-03-11T22:50:41","date_gmt":"2019-03-11T21:50:41","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=2033"},"modified":"2019-05-08T14:14:59","modified_gmt":"2019-05-08T12:14:59","slug":"errores-psdgbt-bind-csid-x-does-not-match-session-csid-yy","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/errores-psdgbt-bind-csid-x-does-not-match-session-csid-yy\/","title":{"rendered":"Errores psdgbt: bind csid (X) does not match session csid (YY)"},"content":{"rendered":"

Hoy vamos a ver una entrada rapida y sencilla que nos ayudara a evitar una cascada de errores en el alert.log <\/p>\n

Es posible que, la reiniciar alguna e nuestras bases de datos que se encuentran bajo la monitorizacion de un Enterprise manager veamos que el alert.log de nuestra base de datos comienza a mostrar continuamente errores del tipo <\/p>\n

\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/TEST_stby\/TEST\/trace\/TEST_ora_743.trc:\r\nMon March 11 12:24:47 2019\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/TEST_stby\/TEST\/trace\/TEST_ora_743.trc:\r\nMon March 11 12:25:06 2019\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/TEST_stby\/TEST\/trace\/TEST_ora_743.trc:\r\n<\/pre>\n
Si comprobamos la traza podemos ver como se trata de errores del tipo
\n
\npsdgbt: bind csid (1) does not match session csid (46)
\npsdgbt: session charset is XXX <\/b><\/p>\n
Donde el charset variara en  funcion de nuestra base de datos, veamos una de estas trazas<\/p>\n
ORACLE_HOME = \/u01\/app\/oracle\/product\/12.1.0\/db
\nSystem name:    Linux
\nNode name:      test.pamplona.name
\nRelease:        3.8.13-118.19.12.el6uek.x86_64
\nVersion:        #2 SMP Tue Oct 31 12:31:15 PDT 2017
\nMachine:        x86_64
\nInstance name: TEST
\nRedo thread mounted by this instance: 1
\nOracle process number: 32
\nUnix process pid: 743, image: oracle@test.pamplona.name<\/p>\n
*** 2019-03-11 21:20:06.886
\n*** SESSION ID:(2.57596) 2019-03-11 21:20:06.886
\n*** CLIENT ID:() 2019-03-11 21:20:06.886
\n*** SERVICE NAME:() 2019-03-11 21:20:06.886
\n*** MODULE NAME:(emagent_SQL_oracle_database) 2019-03-11 21:20:06.886
\n*** CLIENT DRIVER:(jdbcthin) 2019-03-11 21:20:06.886
\n*** ACTION NAME:(ME$icc_dbs_age_last_backup) 2019-03-11 21:20:06.886<\/p>\n
psdgbt: bind csid (1) does not match session csid (46)
\npsdgbt: session charset is WE8ISO8859P15<\/p>\n
*** 2019-03-11 21:20:06.886
\ndbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=1, mask=0x0)
\n—– Error Stack Dump —–
\n—– Current SQL Statement for this session (sql_id=a0qc12302fzfk) —–
\nbegin dbms_application_info.set_module(:1  , :2  ); end;<\/p>\n
La solucion para este problema es muy muy sencila, simplemente, reinicia el agente del enterprise manager del servidor donde se encuentra ubicada la base de datos.<\/p>\n
Como siempre, mas informacion en soporte de Oracle
\nDoc ID 956222.1<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Hoy vamos a ver una entrada rapida y sencilla que nos ayudara a evitar una cascada de errores en el alert.log Es posible que, la reiniciar alguna e nuestras bases de datos que se encuentran bajo la monitorizacion de un … Sigue leyendo →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,565,60,567,921,66,5],"tags":[58,960],"class_list":["post-2033","post","type-post","status-publish","format-standard","hentry","category-11g","category-11g-en","category-12c","category-12c-en","category-18c","category-errores-ora","category-em","tag-alert-log","tag-psdgbt"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2033","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/comments?post=2033"}],"version-history":[{"count":5,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2033\/revisions"}],"predecessor-version":[{"id":2044,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2033\/revisions\/2044"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=2033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=2033"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=2033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}