MGMTDB: Grid Infrastructure Management Repository

Original Post can be viewed at MGMTDB: Grid Infrastructure Management Repository

MGMTDB is new database instance which is used for storing Cluster Health Monitor (CHM) data. In 11g this was being stored in berkley database but starting Oracle database 12c it is configured as  Oracle Database Instance. In 11g, .bdb files (more...)

12c: Exporting Database Views as Tables

Original Post can be viewed at 12c: Exporting Database Views as Tables

Starting Oracle Database 12c, you can export view to be imported as a table. There is no need to individually export each table, Data Pump will dump a table with the same columns as the view and with (more...)

12c: Sqlplus Displays Last Login Time For Non – Sys Users

Original Post can be viewed at 12c: Sqlplus Displays Last Login Time For Non – Sys Users

12c database has introduces a pretty nifty Security feature which allows you to check last login time for non-sys user. e.g If I connect to scott user as below, it displays that (more...)

12c:Limiting PGA with pga_aggregate_limit

Original Post can be viewed at 12c:Limiting PGA with pga_aggregate_limit

This is a interesting feature for Oracle DBA’s. Till now there has been no way of limiting total PGA being used by oracle instance. _pga_max_size (hidden parameter) could be used to limit per process memory. SGA_TARGET used to be hard (more...)

12c:Specifying lock timeout for finish_redef_table

Original Post can be viewed at 12c:Specifying lock timeout for finish_redef_table

Oracle 12c database has introduced enhancement to DBMS_REDEFINITION for specifying a a lock timeout (in seconds) which will allow FINISH_REDEF_TABLE to acquire an exclusive lock for swapping the source and interim tables.If timeout expires, then operation exits. This (more...)

Openfiler on Virtualbox and 12c Oracle Flex ASM

Original Post can be viewed at Openfiler on Virtualbox and 12c Oracle Flex ASM

Last week Oracle released 12c database and Oracle blogosphere is bustling with lot of people posting details about new versions and setup. I too decided to take plunge and setup my own RAC cluster. I had (more...)

portmap: unrecognized service on RHEL6

Original Post can be viewed at portmap: unrecognized service on RHEL6

Quick note for people using NFS for shared storage on RAC database. Till RHEL5 we had to ensure nfs,nfslock and portmap service has to be running. These services are required otherwise you will get following errors while mounting database

(more...)

Recovering from Lost AWS EC2 Key

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...)

cursor: pin S wait on X

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...)

Moving WordPress Blog to Amazon Web Services

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 [...]

AskDba.org Weblog

11.2 AQ – Messages stuck in PROCESESED,WAIT State

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 [...]

AskDba.org Weblog

Using SQL commands on ADRCI

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 [...]

AskDba.org Weblog

Happy New Year – Goodbye 2012 and welcome 2013

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 [...]

AskDba.org Weblog

Upgrade Enterprise Manager Cloud Control 12.1.0.1 to 12.1.0.2

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 [...]

AskDba.org Weblog

Limiting I/O and CPU resources using 11g Oracle Resource Manager

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 [...]

AskDba.org Weblog

Comic: How to write CV for NoSQL

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

AskDba.org Weblog

ORA-12514 due to DNS issue

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 [...]

AskDba.org Weblog

Sqlplus HTML reports

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 [...]

AskDba.org Weblog

11gR2:Oracle Online Patching

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] [...]

AskDba.org Weblog