Installing an Oracle Client on a Linux host is a rather easy and straightforward task but when you have to do this on a lot of hosts with different Linux distributions you probably will think about how to automate the process and not use the GUI at all. A simple script for installing an Oracle 12c…
Read More →Year: 2016
Lately I was responsible for implementing Kerberos authentication at the company where I work. During the planning I have discovered some differences and features which are not well documented regarding external authentication in Oracle. This blog post will discuss the issue with password expiration for externally authenticated users in Oracle 11g and 12c. When we change a…
Read More →In case you have been wondering how to measure the effect of an “ALTER TABLE MOVE” command on a full table scan then this little test will show it to you. Using ALTER TABLE MOVE is a good idea if you want to reorganize your tables but do not wish to enable row movement and export-import is…
Read More →I was contacted by the application developers to check a query which resulted in an ORA-56904 in a 12.1.0.2 Oracle Database. The query used Pivot to select data from a partitioned table which was stored in memory (INMEMORY clause). Without the INMEMORY clause the query was running fine. To recreate the scenario I used the following simplified test-case:…
Read More →One of our Avaloq Databases crashed with the following information in the alert log: Wed Mar 02 19:10:22 2016 PMON (ospid: 26747): terminating the instance due to error 471 Wed Mar 02 19:10:23 2016 System state dump requested by (instance=1, osid=26747 (PMON)), summary=[abnormal instance termination]. System State dumped to trace file /u00/oracle/orabase/diag/rdbms/ora5prim/ORA5/trace/ORA5_diag_26774_20160302191023.trc Instance terminated by…
Read More →