Blog

DATA GUARD CONFIGURATION ON ORACLE DATABASE APPLIANCE X3-2 USING DATAGUARD BROKER

Setting up Data Guard is a regular practice for DBAs to ensure their environments are able to withstand a disaster. Data Guard is a standard feature with Oracle Enterprise Edition. This blog lays out all of the steps necessary to configure Data Guard between two Oracle Database Appliances plus test the configuration with a switchover. This is a Data Guard set up on an ODA X3-2 Bare Metal configuration using ASM storage. Two ODAs are used for this configuration. ODALIVE and ODADEV, both X3-2. The primary database “ottawa” is located on “ODALIVE0” (which is the primary node “Node 1” of … read more

  • Share:

Configuring ASR Manager on Oracle ODA version 12.1.2.9.0 (SNMP v3 Security)

Oracle Auto Service Request is a warranty service offered under the bundled Oracle Premier Support for hardware support. This enables you to lean back and let Oracle take care of your repair requests and system part replacement needs of your ODA at no extra cost or headache. It centrally accepts hardware telemetry data sent from a group of ASR Assets. The ASR Manager then filters the incoming data and forwards potential fault telemetry to Oracle Backend systems. Music to your ears? Yes, but ASR does not come pre-installed and ready to go. Instead you need to install and configure the … read more

  • Share:

Upgrading the time zone file and timestamp with time zone data in a 12.2 Oracle database

It is sometimes necessary to upgrade the time zone file and timestamp with time zone (TSTZ) data in an Oracle database, for instance when you upgrade to a new version of the database or when the rules for Daylight Saving Time (DST) change. Since version 11.2, the update process was straightforward: one would simply download the proper scripts from this My Oracle Support (MOS) note and run them: Scripts to automatically update the RDBMS DST (timezone) version in an 11gR2 or 12c database . (Doc ID 1585343.1) With version 12.2.0.1, the update procedure has changed drastically as the DST files … read more

  • Share:

From The DBA Perspective: Highlights from Oracle OpenWorld 2017

Again this year Oracle OpenWorld was packed with too many keynotes, sessions and activities to choose from. In my very first blog post, I would like to talk about my personal favorites. Oracle OpenWorld 5k Run: Every year on Sunday morning, the SQL Developer team championed by Jeff Smith invites the community to run/walk/jog across the Golden Gate Bridge and back. The distance is just a bit more than 5k and you get a break half-way to enjoy the view! This is a great way to get energized for the coming week, to do teambuilding with your colleagues and to … read more

  • Share:

SPARC AND SOLARIS, THE PAST AND THE FUTURE

Originally posted on October 18, 2017 by Erik Benner, Vice President, Enterprise Transformation, Mythics Inc. Read the original post here: http://www.mythics.com/about/blog/sparc-and-solaris-the-past-and-the-future Thank you to Erik and our friends at Mythics for allowing us to re-post this! ________________________________________________ “A LIE CAN RUN ROUND THE WORLD BEFORE THE TRUTH HAS GOT ITS BOOTS ON.” –TERRY PRATCHETT, THE TRUTH Recently there have been a ton of rumors being spread that Solaris is dead, SPARC is dead and that these technologies are being abandoned by their creators. Many of these reference a web site that is an anonymous rumor site for corporate layoffs. The same site also has … read more

  • Share: