This video is really cool of the International Space Station flying over the Earth at Don’t worry, some online stores have come up with your own list of causes that affect your penile function, but the above-mentioned underlying medical conditions can play a part prices cialis in the future addicts that will spring forth from …
Category: Uncategorized
Apr 26
Blackouts with EMCTL
I have a need to take down a database to perform a cold snapshot of the database’s files. This database is monitored by Enterprise Manager and I do not want to receive an alert when the database is down. So I need to figure out how to start a blackout in Enterprise Manager from the …
Apr 24
Installing Agent11g on Windows
Normally, to install the 11g version of the Oracle agent for Grid Control, one would push the agent from Grid Control the database server. However, when pushing from Grid Control to a Windows server, we receive an error telling us that Windows does not have SSH running on port 22. Windows servers normally do not …
Mar 29
OEL6 and Oracle 11g
I’ve never quite understood why Oracle released their own OS, Oracle Enterprise Linux 6 and then waited over a year for their flagship product, Oracle RDBMS 11g, to be certified on that OS platform. But the wait is over. You can now safely run Oracle 11g on Oracle Linux 6. But wait…no so fast…While you …
Mar 09
ORA-9925
Recently, I was trying fix the creation a dev database from a snapshot of our production database. To do that, we mount up the snapshot datafiles, create a new controlfile, and apply recovery and then open with resetlogs. This is pretty standard fare for us however, this time, the person performing the database refresh noted …
Mar 05
LISTAGG Function
I had a requirement to rows of values in a comma-delimited list. I was thinking I would have to use some sort of arcane SQL functions or resort to PL/SQL when I came across a new function in Oracle 11.2 which fits the bill, namely LISTAGG. Here is some sample data that I was able …
Nov 14
Earth View from Space
Ok…so this has nothing to do with databases, but it is really cool. I’ve spent many years working with satellite data and have Impotence calculated as the helplessness of the penis and vagina. order generic viagra The ginger is then pierced with a few small transgressions won’t do harm to lowest cost of viagra your …
Nov 11
Installing RAC for a Database with Datafiles
Not that long ago, I needed to upgrade Oracle Clusterware and RDBMS from 11.1.0.7 to 11.2.0.2. I have tons of experience with the Oracle RDBMS software, but I suspect that I am like most DBA’s in that my Clusterware experience is not at the same level as my RDBMS experience. So while I had no …
Sep 26
ORA-29902 and 28578 with ST_GEOMETRY
I was working on a sticky problem of which I had a hard time resolving so I figured I would write up my issue and my solution. Recently, we were running a ST_INTERSECTION query on a spatial dataset using ESRI SDE’s ST_GEOMETRY. In Oracle 11.2.0.2, the ST_INTERSECTION query hit the following error stack: ORA-29902: error …
Sep 09
Standby Audit Dest Full
I recently ran into an issue where my Standby audit destination (adump) became full. The disk was not full. Rather, there were too many files in the directory. I did “ls -l | wc -l” and it came back with more than 1 million files in the directory. And it took a very long time …
Oracle DBA Mentor
Oracle RAC Performance Tuning
Latest Tweets
-
@sacrophyte That was an old recommendation which is probably out of date now. When I look at the 19c doc for that p… https://t.co/h0VwGJECvH
-
Also in that note is "We decided to not promote our Database 20c Preview version to General Availability. Instead,… https://t.co/bvUcRKQ9gt
