Read and monitor Oracle related blogs and news sources, all in one place.
Original Post can be viewed at Recovering from Lost AWS EC2 Key
This article is for AWS users using EC2 instances. Summary: Please backup your AWS EC2 Key file and you will never have to go through below pain
AWS allows you to create a key-pair which can be downloaded (more...)
Original Post can be viewed at cursor: pin S wait on X
Few weeks back thread came up on oracle-l freelist regarding ”cursor: pin S wait on X” event . Tanel Poder replied to this thread with excellent explanation. You can read full thread here
This wait happens when your (more...)
Original Post can be viewed at Moving WordPress Blog to Amazon Web Services
Why I moved?Setting up AWS EC2 InstanceConfiguring EC2 InstanceMigrating WordPress DataOptimizing Webhost SetupMaking actual MoveOptimizing WordPress with w3tcIs Free AWS actually Free?How much will it cost?SummaryReferences Why I moved? Last Month I had moved my blog hosting from Dreamhost to Amazon Web Services(AWS). I decided to change hosting provider as my blog suffered 17 outages (as [...]
Original Post can be viewed at 11.2 AQ – Messages stuck in PROCESESED,WAIT State
I had been working today on AQ issue where messages were not moving from WAIT to READY State.This was on 11.2.0.3 database running on RHEL5u6(64 bit). I thought of quickly documenting it for easy reference When you enqueue record, you can specify delay after which record should be ready for dequeue. During this time, MSG_STATE [...]
Original Post can be viewed at Using SQL commands on ADRCI
While working with ADRCI , I came to know that we can run normal SQL commands for some of the operation.e.g To display current purge policy , you can run select * from adr_control instead of show control. adrci> desc ADR_CONTROL Name Type NULL? ----------------------------- --------------- ----------- ADRID number SHORTP_POLICY number LONGP_POLICY number LAST_MOD_TIME timestamp [...]
Original Post can be viewed at Happy New Year – Goodbye 2012 and welcome 2013
It seems Mayan’s freaked out lot of people by not making 2013 calendar Anyways our world survives and we will be entering 2013 in another 7 hours. So wishing all Oracle Community members a “Happy And Prosperous New Year” This year we have heard lot of buzz around “Big Data” and it seems to be [...]
Original Post can be viewed at Upgrade Enterprise Manager Cloud Control 12.1.0.1 to 12.1.0.2
Oracle released 12.1.0.2 Enterprise Manager few days back and have released it for most of platforms. You can directly upgrade Enterprise Manager Cloud Control 12c Release 1 (12.1.0.1) [with or without Bundle Patch 1] to 12.1.0.2 There are no pre patches required for this. But this upgrade requires considerable downtime. Oracle has termed this upgrade [...]
Original Post can be viewed at Limiting I/O and CPU resources using 11g Oracle Resource Manager
Recently I was working on using Oracle DBMS_RESOURCE_MANAGER to limit resources usage by read-only queries. This was required to prevent long running ad-hoc and poorly written queries.Instead of writing custom sql /script to kill long running session, we decided to utilize Oracle Database Resource Manager. We decided using elapsed_time as criteria for cancelling sql.But during [...]
Original Post can be viewed at Comic: How to write CV for NoSQL
This is pretty old comic from geek&Poke . Enjoy Related PostsLife Is Changed Now!!!!!Oracle Direct connector for HDFSWishing all a hApPy DiWaLi10,000 Hits – First MilestoneChecking Database Feature Usage StatsZemanta
Original Post can be viewed at ORA-12514 due to DNS issue
A User reported ORA-12514 error from JDBC application connecting to RAC database ORA-12514: TNS:listener does not currently know of service requested in connect descriptor To troubleshoot it, a)I checked following things to ensure specified service is running srvctl status service -d dbname -s serv_name b) Ensured service is registered with listener lsnrctl status Note that [...]
Original Post can be viewed at Sqlplus HTML reports
I was working on setting up monitoring for application team to monitor AQ and wanted html formatting of table data. On searching I found this link from Ittichai Chammavanijakul which makes use of css formatting to generate good visual reports. EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7369 SMITH CLERK 7902 17-DEC-1980 00:00:00 800 [...]
Original Post can be viewed at 11gR2:Oracle Online Patching
Online patching is new feature introduced in 11.1.0.6 and oracle started delivering patches with 11.2.0.2. This patch allows you to apply patch to live database i.e we do not need to shutdown database. This feature is only available for RDBMS home and can be installed/enabled using opatch. RDBMS Online Patching Aka Hot Patching [ID 761111.1] [...]
Original Post can be viewed at 11gr2-Formatted crsctl output
If you don’t like crsctl status res –t output then try using below Can also download here crsstat11g. I have tried this on linux crsctl status res |grep -v "^$"|awk -F "=" 'BEGIN {print " "} {printf("%s",NR%4 ? $2"|" : $2"\n")}'|sed -e 's/ *, /,/g' -e 's/, /,/g'|\ awk -F "|" 'BEGIN { printf "%-40s%-35s%-20s%-50s\n","Resource Name","Resource [...]
Original Post can be viewed at Checking column usage information using dbms_stats
Oracle 11gR2 DBMS_STATS introduced useful function report_col_usage to report column usage i.e if column is being used for equality,like predicates. I came to know it while reading Optimizer whitepaper .As per document, DBMS_STATS.REPORT_COL_USAGE reports column usage information and records all the SQL operations the database has processed for a given object. This information is used by Oracle [...]
Original Post can be viewed at Installing Adobe Flash Player using Yum on Linux
I have been using firefox on a linux desktop since last week. Lot of sites on internet are using flash player on it , so everytime I hit the site, it reported missing plugin. When I tried to install the plugin through firefox, it errored out and asked me to install manually. Finally today I [...]
Original Post can be viewed at F1:New RDBMS from Google!!
Google has published a paper on F1 – The Fault-Tolerant Distributed RDBMS Supporting Google’s Ad Business. F1 combines benefit of bigtable (concept from which hadoop is derived) and MySQL database. You can read about it at http://research.google.com/pubs/archive/38125.pdf Related PostsOracle Direct connector for HDFSLink: Best practices for AIX RAC Database on OTNTweaking _Shared_pool_reserved_min_alloc and ORA – 4031Lost your Oracle Prometric-ID [...]
Original Post can be viewed at Using current_scn for RMAN incremental ? Think again..
I am bloging about experience we had using rman incremental backup for syncing standby database. We had a standby database which lagged by considerable time and we decided to use rman incremental database to make it current. We have done this in past and used normal procedure of taking current_scn from V$database on standby and took [...]
Original Post can be viewed at Poll on Sql Plan Management
Dominic is conducting poll on SPM and Sql Profiles usage on his website. Link can be found here I have been using SPM and SQL Profiles (using coe_xfr_profile.sql) to fix plans for queries and believe me its very easy and quick way of fixing problems in production database. I have not yet used SPM to [...]
RSS