Installing Oracle Linux 8.4 With Apex 21/ Tomcat 9 running in pluggable Oracle XE 21c database(pdb) //Software download URL's at the end of this document. //Custom Template for server config and password attached to this document. Network Hostname … [Read more...]
Tom Kyte, Graham Wood og Andrew Holdsworth kommer til Danmark
Tre af verdens førende Oracle performance guruer er på verdensturné, og de kommer til Danmark 23. marts! Tom Kyte, Graham Wood og Andrew Holdsworth arbejder alle i Oracle Real-Word Performance Group The Real-World Performance (RWP) Group is part of the Oracle Database Development organization. Engineers in the RWP group … [Read more...]
Oracle 11.2.0.4 Physical Standby on Windows 2008
After database migration from Oracle 10gR2 on UNIX to Windows (Windows Server 2008 R2 64-bit), two productive databases were located on dedicated servers; one server running the 11.2.0.4 database and another server running the 12.1.0.1 database (both Enterprise Edition single-instance using non-ASM based storage). Another Windows server was … [Read more...]
Oracle Fine Grained Audit – who have queried confidential data
The need for more sophisticated controls on access to sensitive data is becoming increasingly important as organizations address emerging security requirements around data consolidation, privacy and compliance. There are many examples of data breaches which have been perpetrated using stolen credentials, SQL injection or by insiders who are … [Read more...]
How to secure and audit unauthorized data access
The need for more sophisticated controls on access to sensitive data is becoming increasingly important as organizations address emerging security requirements around data consolidation, privacy and compliance. There are many examples of data breaches which have been perpetrated using stolen credentials, SQL injection or by insiders who are … [Read more...]
How to find EBS technology stack component versions
This blog shows how to find the versions of technology stack components. This include versions of Forms, iAS, Framework, JDK, OJSP, Database, etc. 1 A very good report to collect versions of technology stack components is described in MOS article 601736.1. Below an example of how to run this report on unix/linux Logon the Applications … [Read more...]
Indkaldelse til ordinær generalforsamling i Danish Oracle User Group
Kære DOUG medlemmer, Indkaldelse til ordinær generalforsamling i Danish Oracle User Group tirsdag 11. marts 2014 kl. 14.30. Generalforsamlingen afholdes hos Oracle, Metalbuen 66, Ballerup. Kom og fortæl bestyrelsen hvilke emner, DOUG skal beskæftige sig med. Efter generalforsamlingen bliver der en præsentation: "Technology That Fits". Man er … [Read more...]
Oracle12c R1 RDBMS New Features: Upgrading to 12cR1 (pluggable) database
When upgrading to 12cR1 (pluggable and non-CDB) database we can choose between the following methods: 1) Upgrade the pre-12cR1 database to 12cR1 using DBUA or command-line/upgrade script (catctl.pl); for some releases a Direct Upgrade to 12cR1 is possible (10.2.0.5, 11.1.0.7 and >=11.2.0.2). Notice that in 12cR1 the upgrade can now run in … [Read more...]
EBS R12.1.1 upgrade – Seen errors when applying upgrade patch driver u6678700.drv
Upgrading from E-Business Suite 11i to R12 is a major step and some errors are to be expected during applying the English American patch driver, u6678700.drv. Some of the errors, seen during several upgrades on different customer sites, are listed below. Seen errors during applying of upgrade patch driver, u6678700.drv 1 Unable to allocate … [Read more...]
Zabbix – system monitoring
Recently we come across an open source system monitoring tool called "Zabbix" Zabbix has existed since 2001 and the recent stable version today is 2.20 We have chosen Zabbix because of the easy to use interface and the scalability/usability Also to be mentioned: distributed monitoring with centralized web administration support for both … [Read more...]
Zabbix – Oracle monitoring
To follow up on post recently blog about the zabbix system monitoing tool we have installed the Orabix for Oracle monitoring. This tool can: DBVersion (and relative validity of package) Archive ( archive log production with relative trend) EventWaits (monitor Files I/O,single block read, multiblock read, direct path read,SQLNet messages, … [Read more...]
Identify performance decrease due to enabled trace in an E-Business Suite R12 environment
Subledger Accounting profile option "SLA: Enable Diagnostics" Trace data generated during create accounting is stored in SLA diagnostic tables (XLA_DIAG_SOURCES og XLA_DIAG_EVENTS), when profile option "SLA: Enable Diagnostics" is set to "Y". It is important to disable this profile option after use, to avoid performance decrease. Sql below shows … [Read more...]
DOUG-dag 2013
Årets DOUG-dag bliver 23. oktober 2013 og afholdes hos Oracle i Ballerup, Metalbuen 66, 2750 Ballerup. Du kan tilmelde dig på http://tinyurl.com/dougday2013. Tidsplan, talere og emner nedenfor. Tidsplan: 0900-0930 Registrering og morgenmad 0930-0945 Velkomst 0945-1030 Mark Anthony 1030-1730 Sessioner i tre spor med fokus på … [Read more...]
Challenges with object invalidation and ORA-04045 in Active Data Guard STANDBY-database
At one of our customers Oracle Active Data Guard is being utilized for resource intensive BI queries during normal business hours. The setup is based on 11.2.0.3 EE on OEL 6.4 and everything is running just smooth. One issue has been identified - namely implicit invalidation of database objects, e.g. VIEWS and PL/SQL procedures. The invalidation … [Read more...]
Oracle Listener crash, TNS-01153: Failed to process string, on Windows
A few days ago, I was working at a customer and made a few changes to the running listener's configuration. After having verified that my changes were working as expected, I asked the listener to save the configuration, but the result was quite unexpected. The listener crashed with TNS-1153. I had hit bug #8612344, which is affecting all 10.2 … [Read more...]
- 1
- 2
- 3
- …
- 13
- Next Page »