psdgbt: bind csid (1) does not match session csid

Posted: April 16, 2013 in Database General
Tags: ,

Recently, after restarting a 11.2.0.1 database running on AIX 6.1, all of sudden following lines are getting written to alert.log file of database. Alert.log size increases to from few MB to some GB in span of few minutes.

Mon Apr 15 17:08:37 2013
Archived Log entry 3144 added for thread 1 sequence 3152 ID 0x29e688a7 dest 1:
Mon Apr 15 17:08:38 2013
Errors in file /u01/app/oracle/diag/rdbms/findb/FINDB/trace/findb_ora_21495880.trc:
Errors in file /u01/app/oracle/diag/rdbms/findb/FINDB/trace/findb_ora_21495880.trc:
Errors in file /u01/app/oracle/diag/rdbms/findb/FINDB/trace/findb_ora_21495880.trc:
Errors in file /u01/app/oracle/diag/rdbms/findb/FINDB/trace/findb_ora_21495880.trc:
Errors in file /u01/app/oracle/diag/rdbms/findb/FINDB/trace/findb_ora_21495880.trc:
Errors in file /u01/app/oracle/diag/rdbms/findb/FINDB/trace/findb_ora_21495880.trc:
Errors in file /u01/app/oracle/diag/rdbms/findb/FINDB/trace/findb_ora_21495880.trc:
Errors in file /u01/app/oracle/diag/rdbms/findb/FINDB/trace/findb_ora_21495880.trc:
Errors in file /u01/app/oracle/diag/rdbms/findb/FINDB/trace/findb_ora_21495880.trc:
Errors in file /u01/app/oracle/diag/rdbms/findb/FINDB/trace/findb_ora_21495880.trc:
Errors in file /u01/app/oracle/diag/rdbms/findb/FINDB/trace/findb_ora_21495880.trc:
Errors in file /u01/app/oracle/diag/rdbms/findb/FINDB/trace/findb_ora_21495880.trc:
Errors in file /u01/app/oracle/diag/rdbms/findb/FINDB/trace/findb_ora_21495880.trc:

This trace file generated is as:

oracle@titan $ head -300 findb_ora_21495880.trc
Trace file /u01/app/oracle/diag/rdbms/findb/FINDB/trace/findb_ora_21495880.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2
System name:    AIX
Node name:      titan
Release:        1
Version:        7
Machine:        002A8FXEXC00
Instance name: findb
Redo thread mounted by this instance: 1
Oracle process number: 4
Unix process pid: 21495880, image: oracle@titan


*** 2013-04-15 16:52:44.151
*** SESSION ID:(1.1) 2013-04-15 16:52:44.151
*** CLIENT ID:() 2013-04-15 16:52:44.151
*** SERVICE NAME:(SYS$USERS) 2013-04-15 16:52:44.151
*** MODULE NAME:(OMS) 2013-04-15 16:52:44.151
*** ACTION NAME:() 2013-04-15 16:52:44.151

psdgbt: bind csid (1) does not match session csid (873)
psdgbt: session charset is AL32UTF8

*** 2013-04-15 16:52:44.151
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=1, mask=0x0)
----- Error Stack Dump -----
----- Current SQL Statement for this session (sql_id=43c5ykm1mcp2a) -----
begin dbms_application_info.set_module(:1, :2); dbms_application_info.set_client_info(:3); dbms_session.set_identifier(:4); end;

i searched with “psdgbt: bind csid (1) does not match session csid” and got the solution. Well, reason for this problem was grid agent. This error may come when we start database or listener after starting the grid agent. In my case gris agent start automatically at server reboot and i have never faced this problem before. Solution for this problem is to shutdown the grid agent first, then restart the database and listener. After this start the grid agent. My issue is resolved with this.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s