Skip to content
AskDba.org Weblog
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g10g Articles
    • 11gLists 11gR1/R2 articles
    • 12c
  • Performance
  • About Us
Menu Close
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g
    • 11g
    • 12c
  • Performance
  • About Us

Author: Amit Bansal

This author has written 158 articles
Home » Archives for Amit Bansal » Page 6

ORA-12514 due to DNS issue

  • Post author:Amit Bansal
  • Post published:5 July, 2012
  • Post category:10g/11g
  • Post comments:0 Comments

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…

Continue ReadingORA-12514 due to DNS issue

Sqlplus HTML reports

  • Post author:Amit Bansal
  • Post published:28 June, 2012
  • Post category:10g/11g
  • Post comments:1 Comment

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…

Continue ReadingSqlplus HTML reports

11gR2:Oracle Online Patching

  • Post author:Amit Bansal
  • Post published:22 June, 2012
  • Post category:11g
  • Post comments:1 Comment

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…

Continue Reading11gR2:Oracle Online Patching

11gr2-Formatted crsctl output

  • Post author:Amit Bansal
  • Post published:11 June, 2012
  • Post category:11g
  • Post comments:1 Comment

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…

Continue Reading11gr2-Formatted crsctl output

Checking column usage information using dbms_stats

  • Post author:Amit Bansal
  • Post published:6 June, 2012
  • Post category:11g/Performance
  • Post comments:2 Comments

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…

Continue ReadingChecking column usage information using dbms_stats

Installing Adobe Flash Player using Yum on Linux

  • Post author:Amit Bansal
  • Post published:4 June, 2012
  • Post category:Unix
  • Post comments:0 Comments

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,…

Continue ReadingInstalling Adobe Flash Player using Yum on Linux
  • Go to the previous page
  • 1
  • …
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • …
  • 27
  • Go to the next page
Copyright - OceanWP Theme by OceanWP