In this post we look at one way to simply back up your Oracle database in the AWS cloud. We're planning on making this the first in a series of Quick Guides for working with Oracle and public cloud. We hope you like it, please follow, comment or like if we're hitting the spot!
This example uses a self managed database, rather than RDS, so (more...)
I’ve updated my install cookbooks page to include a new cookbook for installation of Oracle 188.8.131.52 Real Application Clusters on Oracle Linux 6.7.
This is also the first one I’ve published since I left the employment of Violin Memory to work for Kaminario, so this install uses a Kaminario K2 All Flash Array. However, it applies very well to any Oracle RAC installation which uses relatively capable storage.
Over the past years we've worked on many Oracle projects, some with RAC, some without, some which intended to implement RAC and failed, and some which implemented poorly and ripped it out at the last minute.For those new to Oracle, RAC is the Real Application Cluster option for the database which lets you cluster the database servers. The main reason for using for RAC is that it brings resilience to a system, it (more...)
By default on an Oracle RAC installation, the listeners are configured to allow any database to register with them. There is no security out of the box to determine which databases may register. While this makes it easy to create new databases without worrying about listener registration, this can cause potential problems in a real environment.
This can be dangerous working with RAC environments where the database registers with both a local and remote listener. The (more...)
That is how many lines of PL/SQL I had to write in Oracle Apex 5.0 to make a web service call to an external API.
I used Adzuna's REST API to retrieve the latitude and longitude and the price of 2 bed properties for rent in a specific location in UK. The API returns JSON which the APEX_JSON (more...)
I had the pleasure of rebuilding an Exadata rack for a customer a while back, and it provided a pretty good refresher in backup and recovery for me. As DBAs, we back up databases all the time, but the restores are performed much less frequently. In the case of this rack, there were several databases across multiple ASM diskgroups. One of the goals of the rebuild was to consolidate all of the databases into a (more...)
A rather not so great post about an ORA-00600 error i faced on a standby database. Environement was 184.108.40.206 on Sun Super Cluster machine. MRP process was hitting ORA-00600 while trying to apply a specific archive log.
The error message was something like this
MRP0: Background Media Recovery terminated with error 600 Errors in file /u01/app/oracle/product/220.127.116.11/diag/diag/rdbms/xxxprd/xxxprd1/trace/xxxprd1_pr00_6342.trc: ORA-00600: internal error code, arguments: , , , , , , , (more...)
I think this is cool as it gives you the ability to use SQL on an HBase table.
To test this, let's say you login to HBase and you create an HBase table like (more...)
If you’ve run an exachk report, y0u may have seen the following message with regard to your databases:
|FAIL||Database Check||Database parameter CLUSTER_INTERCONNECTS is NOT set to the recommended value||db01:dbm011, db02:dbm012||View|
This check is commonly seen when a database is created on Exadata without using the custom “Exadata” templates included with the database creation assistant. These customized templates include a multitude of recommended parameter settings found in (more...)
Pour utiliser cet assistant, le "Database Tuning Pack" est nécessaire.
Plus d'information :
- Page OTN
- Note MOS 1965342.1
- Signing Up for a Database CloudService
- Installingan Application into Your Database Cloud Service
- Data Loading and the Oracle Database Cloud Service
- Creating a RESTful Web Service
- ManagingUsers and Roles in a Database Cloud Service
- MonitoringYour Database Cloud Services
Java Cloud Service
Database Cloud Service
- Orderinga Trial Subscription to an Oracle Cloud Service
- Administering a Trial Subscription to an Oracle Cloud Service
- Creating a Database Cloud Instance
- Connecting to a Database Instance in the Oracle Database Cloud Service
- Vidéos complémentaires sur le site Web OPC
Using sysbench to performance test AWS RDS MySQL hardware is an easy three step operation.
Sysbench creates synthetic tests and they are done on a 1 mil row 'sbtest' table that sysbench creates in the MySQL database you indicate. The test doesn't intrude with your database schema, and it doesn't use your data, so it is quite safe. The test is an OLTP test trying to simulate event operations in the database as it (more...)
Plus de détails : http://eventreg.oracle.com/profile/web/index.cfm?PKWebId=0x1713052088
ERROR 1205 (HY000) : Lock wait timeout exceeded; try restarting transaction
You get the error because your allocated time to hold a DML lock in a transaction exceeds the set limit. Usually the default limit to hold a DML row lock, set by innodb_lock_wait_timeout db parameter, is 50 seconds. If your transaction doesn't commit/rollback within 50 seconds (more...)