You can, but what happens when you want to integrate that shiny new cloud app with your existing applications and data? That integration has its own term—hybrid cloud—and for most enterprises, it’s the new norm. More than 65% of enterprise IT organizations will commit to hybrid cloud technologies (more...)
In Enterprise Manager Cloud Control 12c release 188.8.131.52, we released the Oracle Engineered System Healthchecks plug-in which processed the XML output from the EXAchk tool, included as part of Oracle Enterprise Manager system monitoring. The EXAchk tool provides functionality for system administrators to automate the assessment of Engineered Systems for known configuration problems and best practices.
Over the years since that first release, we increased the scope and functionality of the tool, (more...)
Written by Rena
Mayer, PR Online Editor, Oracle University
Growing numbers of organizations are seeking the benefits of cloud solutions, which include: increased operational efficiency, enhanced business agility, tighter staff collaboration, real-time intelligence across the organization, lower total cost of IT ownership, reliability, scalability and more.
Successful cloud implementations improve the way organizations operate, giving them an edge that leaves competitors in the dust.
According to a recent survey by IDG:
50% of (more...)
Change is difficult for technical folks. Our world is always moving at blinding speed, so if you start changing things that we don’t think need to be changed, even if you improve upon them, we’re not always appreciative.
Configuration Management, EM12c to EM13c
As requests came in for me to write on the topic of Configuration Management, I found the EM13c documentation very lacking, having to push (more...)
First up was Joel with a session called, “Oracle Storage Fragmentation”, where he discussed the potential fragmentation issues possible in tablespaces, tables and indexes. If you’ve been a DBA for a long time it’s easy to think everyone knows this stuff, but I get asked questions about this stuff a lot! The session had a good mix of content, with something to (more...)
“Tuned” in RHEL7/OEL7 is tuning daemon for automatically tuning the system via the use of tuning profile. It can also be configured to react to changes to improve performance of the server and also to make system settings persistent.
“tuned-adm” is a command line tool that provides a number of different profiles to improve performance.
Below are the profiles provided and supported in RHEL 7 :-
Apart from the (more...)
Recently I have been asked how the Copy-on-Write cloning works on the ZFS Storage Appliance. More specifically, the question was about the “master” copy: did it have to be static or could it be rolled forward? What better than a test to work out how it works. Unfortunately I don’t have an actual system available to me at home so I had to revert to the simulator, hoping that it represents the real appliance accurately.
“REDO_TRANSPORT_USER” was an Oracle Database Parameter that was introduced in Oracle release 11.1 to help transporting redo from a primary to a standby by using a user designated for log transport , The default configuration assumes the user “SYS” is performing the transport.
This distinction is very important since the user “SYS” is available on every Oracle database and as such most data guard environment when created with default settings are created with “SYS” (more...)
This isn’t directly Oracle related but it did come to light within an Oracle context
We had a problem with a password file in a RAC cluster and whilst they appeared to be the same on both nodes of a cluster there were issues. I knew we needed to check the size of the files and ensure they were the same but I could not remember the (l)Unix command.
I knew it was to do (more...)
To build Oracle Clusterware Database at Home, I believe , RAC ATTACK is the best place to learn. Its is a free curriculum and platform for hands-on learning labs related to Oracle RAC. While reviewing the article, I thought to perform 12cR1 RAC installation on OEL 7.2.
Attached is the document :- 12c_RAC_on_OEL7
The attached article is inspired by
Deploying Oracle RAC (more...)
What happens when you can’t get a PL/SQL Web Toolkit to work because it only prints to a web page? That’s more tedious because any
dbms_output.put_line command you embed only prints to a SQL*Plus session. The answer is quite simple, you create a test case and test it inside a SQL*Plus environment.
Here’s a sample web page that fails to run successfully …
1 2 3 4 5 6 7 8 9 10 11 (more...)
I wanted to go to Hotsos Symposium for quite some time, having heard so many great topics from there for years. And every time I was a bit lazy to think about what I can talk about. Apparently I thought that everything I know is well covered elsewhere, so why would I be accepted. Plus all these complexities of budget, getting a visa, travel arrangements, jet lag, and personal matters in between. Last year, when (more...)
Here’s a possible bug (though maybe “not a bug”) that came up over the weekend on the OTN database forum. An application generating lots of “literal string” SQL was tested with cursor_sharing set to force. This successfully forced the use of bind variable substitution, but a particular type of simple insert statement started generating very large numbers of child cursors – introducing a lot of mutex waits and library cache contention. Here’s a (substituted) statement (more...)
Security asked to determine when certain passwords were last changed and I used the ptime column in user$ table to find out.
set lines 120 set pages 60 col name form a30 col Last_Changed form a12 SELECT name,ptime "Last_Changed" FROM sys.user$ a, dba_users b where a.name=b.username order by 1;
NAME Last_Changed ------------------------------ ------------ ANONYMOUS 24-AUG-13 APEX_030200 24-AUG-13 APEX_PUBLIC_USER 24-AUG-13 APPQOSSYS 24-AUG-13 CTXSYS 24-AUG-13 DBSNMP 13-MAY-16** DIP 24-AUG-13 EXFSYS (more...)
I have been applying PSU lately and what’s so hard out it?
Four+ databases running on Primary with DG Broker for standby.
There are no conventions, as some standby databases have dr appended to primary name while others have 2 appended to primary name.
I wanted to view the DG configuration for currently active instances and show_dg_config.sh will show me this.
Next, I want a faster way to shutdown DG by having syntax generated (more...)