News Regarding Post "bind csid (#) does not match session csid (#)"

Problem "bind csid (#) does not match session csid (#)" After further investigation and analysis, here some more news regarding the problem with "bind csid (#) does not match session csid (#)" I wrote: "Reason was - in my case - that an agent, which has connected to a freshly created clone of a production database a little to early, was stuck with an Character Set which was current at...

Read More

SQLcl - the SQL*Plus plus a plus ...

"euphoric: intensely happy or confident", @thatjeffsmith, https://youtu.be/ecgijS76jvw ... Just watched the video from @thatjeffsmith about SQLcl - and it is, indeed, worth the time. After looking that video, I'm pretty sure that SQLcl will replace SQL*Plus within months (if some more people 'spread the word'). Just a few keywords to make you curious: SQLcl is available...

Read More

Back From Holidays

After some weeks, spent in Sweden, I'm back ... and will continue writing blogposts ... :-) Stay tune...

Read More

ODA X6-2S - upgrade from 12.1.2.10.0 to 12.1.2.11.0 ... just a few remarks

Did an update of our ODA X6-2S from 12.1.2.10.0 to 12.1.2.11.0 Patch Bundle and want to share some findings.  The patching process is described quite good in the README - nevertheless, a few remarks: the whole process took about 2 hours - without downloading the necessary files and preparations (for example: read the README ;-)) The time, the update process takes, depends on the number of...

Read More

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

How to install and configure Oracle Forms & Reports 12c fully unattended - Part 2

Important update! (June 14th, 2017):  Please asure that all variables in setLocalEnv.sh are filled in correctly and adapted to Your environment. This especially for all variables regarding the Database Connection, like DB_PWD, DB_HOST, DB_PORT ... If not set correctly, the tool is not able to create the rcu repository which results in an error during runtime:  Problem invoking WLST...

Read More