Category Archives: Oracle

Oracle Inmemory Database (and materialized view)…

Posted on 16. April 2015 by vogler

# turn on the inmemory option (it’s part of the SGA, so get sure that the SGA is big enought) alter system set inmemory_size=1G scope=spfile; One gigabyte seems to be less, but inmemory tables are stored column oriented. so, Oracle … Continue reading →

Posted in Oracle | Comments Off on Oracle Inmemory Database (and materialized view)…

How to replicate values to data centers, big-data, SOA, … with WinCC OA…

Posted on 16. December 2014 by vogler

With a little adaptor in the RDB-Manager it is easy to forward values to an Java EE Server like Glassfish (free). And from a Java-Bean values can be forwarded to any kind of data sink.   As an example i … Continue reading →

Posted in Oracle, WinCC OA | Comments Off on How to replicate values to data centers, big-data, SOA, … with WinCC OA…

Oracle Startup Pluggable Database with Container Database…

Posted on 31. August 2014 by vogler

With 12.1.0.2 the state of pluggable databases can be saved: ALTER PLUGGABLE DATABASE xxx SAVE STATE;

Posted in Oracle | Comments Off on Oracle Startup Pluggable Database with Container Database…

Oracle Listener disable connect logging…

Posted on 25. August 2014 by vogler

Disable logging of every connect request: listener.ora: LOGGING_ = OFF otherwise the listener will log every connect and fill up the listener.log [oracle@Database trace]$ ls -la total 30696 drwxr-xr-x 2 oracle oinstall 4096 Aug 24 20:19 . drwxr-xr-x 14 oracle … Continue reading →

Posted in Oracle | Comments Off on Oracle Listener disable connect logging…

Flashback Database ….

Posted on 23. August 2014 by vogler

It is pretty cool to create a restore point for the database before doing some upgrades. If upgrade fails the database can be set back to the restore point by a single statement. CREATE RESTORE POINT before_upgrade GUARANTEE FLASHBACK DATABASE; … Continue reading →

Posted in Oracle | Comments Off on Flashback Database ….

WinCC OA pivot query to combine history values with same timestamp in one row…

Posted on 5. August 2014 by vogler

This example combines the WinCC OA audit trail datapoint elements to a single row for one audit trail entry. select “TS”,”TIME”,”USERNAME”,”UINUM”,”BATCHID”,”ITEM”,”ITEMTYPE”,”ACTION”,”OLDVAL”,”NEWVAL”,”REASON”,”HOST” from ( select h.ts, e.ELEMENT_NAME, NVL(to_char(h.VALUE_NUMBER),h.VALUE_STRING) val from eventhistory h join elements e on e.ELEMENT_ID = h.ELEMENT_ID where e.ELEMENT_NAME … Continue reading →

Posted in Oracle, WinCC OA | Comments Off on WinCC OA pivot query to combine history values with same timestamp in one row…

Oracle sum of intervals …

Posted on 16. July 2014 by vogler

When timestamps are used in your tables and you subtract two timestamps then you will get as result a value of type “interval”. And it is not possible to sum up intervals. But it can be done by casting to … Continue reading →

Posted in Oracle | Comments Off on Oracle sum of intervals …

CRS-2566 User ‘oracle’ does not have sufficient permissions to operate on resource ‘ora.reco.acfsvol.acfs’…

Posted on 15. July 2014 by vogler

While installing an Oracle Standard Edition on an Oracle Database Appliance (ODA) on the cluster filesystem (cloudfs) i got the following error: CRS-2566 User ‘oracle’ does not have sufficient permissions to operate on resource ‘ora.reco.acfsvol.acfs’ I installed the Oracle Standard … Continue reading →

Posted in Oracle | Comments Off on CRS-2566 User ‘oracle’ does not have sufficient permissions to operate on resource ‘ora.reco.acfsvol.acfs’…

Oracle TCP/IP Connection Timeout…

Posted on 14. July 2014 by vogler

• Set the following registry entry (or create if it does not exist): KeepAliveTime Key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters Value type: REG_DWORD – Time in milliseconds Range: 1 – 0xFFFFFFFF Default value: 7.200.000 (two hours) For example this value can be set to … Continue reading →

Posted in Oracle, WinCC OA | Comments Off on Oracle TCP/IP Connection Timeout…

Oracle SQLDeveloper set language to english….

Posted on 3. July 2014 by vogler

C:\App\sqldeveloper\sqldeveloper.exe –AddVMOption=-Duser.language=en

Posted in Oracle | Comments Off on Oracle SQLDeveloper set language to english….