Category Archives: Oracle

Oracle Inmemory Database (and materialized view)…

# 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…

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…

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…

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 ….

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…

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 …

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’…

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…

• 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….

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

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