bind csid (#) does not match session csid (#)

Problem A database's alert log is full of messages like Wed Jun 28 09:13:09 2017 Errors in file /cloudfs/adr/diag/rdbms/scs12fi/SCS12FI/trace/SCS12FI_ora_16694.trc: Wed Jun 28 09:13:10 2017 Errors in file /cloudfs/adr/diag/rdbms/scs12fi/SCS12FI/trace/SCS12FI_ora_16694.trc: Wed Jun 28 09:13:13 2017 Errors in file /cloudfs/adr/diag/rdbms/scs12fi/SCS12FI/trace/SCS12FI_ora_16694.trc: Wed Jun...

Read More

EM 13c: TNS-01190 errors when listener owner and agent owner are not the same account

Problem: When monitoring listener's logfile, lots of TNS-01190 are found: <msg time='2017-06-26T10:21:47.608+02:00' org_id='oracle' comp_id='tnslsnr'  type='UNKNOWN' level='16' host_id='edosrvoda03'  host_addr='192.168.15.70'>  <txt>26-JUN-2017 10:21:47 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=edosrvoda03)(USER=oracle))(COMMAND=trc_directory)(ARGUMENTS=2)(SERVICE=LISTENER)(VERSION=202375680))...

Read More

dbca - db creation stops with dbmssml.sql error

Abstract: Trying to create a database using dbca on a Oracle Linux 7 running in a Virtualbox Container. DBCA throws an error during database creation: something like "dbmssml.sql. refer to dbmssml0.log error in process: perl". The mentioned log file is empty. Solution: Important!: It is NOT a database software or a dbca problem. Additionally, if You run a 'perl -v' command, You'll receive a...

Read More

OracleXADataSource cannot be cast to java.sql.Driver

Tried to start a Forms / Reports Server on an all new server. During startup of the AdminServer, I got an errormessage: <BEA-000362> <Server failed. Reason:  There are 1 nested errors: oracle.security.jps.JpsException: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: java.lang.ClassCastException: oracle.jdbc.xa.client.OracleXADataSource...

Read More

ODA X6 - netca cannot add listener - displaying 'Use another port number' messages

Tried to create e new listener to run on a non-default portnumber on an ODA X6. Each time when adding a new port number (doesn't matter which number) an error screen pops up, stating that I shall choose another port number: I checked more than once and using different tools - there is no port...

Read More