Skip to content

AskDba.org Weblog

  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g
    • 11g
    • 12c
  • Performance
  • About Us

Tag: database

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

22 July, 2013

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

12c database has introduced 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…

Read Full Recipe
95 views 3:06 pm 0 Comments
12c:Limiting PGA with pga_aggregate_limit
Amit Bansal

7 July, 2013

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…

Read Full Recipe
162 views 5:48 pm 0 Comments
Saurabh Sood

20 February, 2012

ORA-7445 core dump [kokscold()+849] from EM 12c

The first problem reported by my EM 12c is an ORA-7445 error. After checking the alert log following is the exact message: Sun Feb 19 12:09:41 2012 Errors in file…

Read Full Recipe
60 views 3:23 pm 0 Comments
Amit Bansal

8 February, 2012

Copying Oracle Scheduler jobs with Arguments

Oracle provides dbms_scheduler.copy_job function to copy oracle scheduler jobs which works great. But problem is that it cannot copy  jobs which have  arguments. Need to copy jobs can arise due…

Read Full Recipe
47 views 10:43 am 0 Comments
Amit Bansal

19 January, 2012

11g: Multiple failed login attempt can block New Application connections

In Oracle database 11g, a new feature/enhancement has potential of bringing down the application due to multiple sessions hitting database with wrong password. As per Bug 7715339 - Logon failures…

Read Full Recipe
725 views 12:00 pm 5 Comments
Amit Bansal

26 September, 2011

Changing CRS/Database timezone in 11.2.0.2 post install

I had installed a 11.2.0.2 RAC setup few days back with incorrect timezone. It had to be PDT but I installed with UTC. Starting/stopping clusteware with correct timezone didn't solve…

Read Full Recipe
55 views 12:52 pm 0 Comments

Posts navigation

Older posts
Disclaimer!!

This blog reflect our own views and do not necessarily represent the views of our current or previous employers.

The contents of this blog are from our experience, you may use at your own risk, however you are strongly advised to cross reference with Product documentation and test before deploying to production environments.

Recent Comments
  • Prabhav Pushkar on MGMTDB: Grid Infrastructure Management Repository
  • Azure BLOB Storage As Remote Backend for Terraform State File - AskDba.org Weblog on Azure Infrastructure Automation With Terraform: Configuration
  • tolu on 11g: Multiple failed login attempt can block New Application connections
  • venkatesh on Retrieving Database SID,Port information from Grid Control repository
  • Patrick on Solving ORA-1031 while connecting as “/ as sysdba” :
Trending
  • Resolving Shutdown Immediate Hang Situations
  • Recreating Database Link
  • Limiting I/O and CPU resources using 11g Oracle Resource Manager
  • Using SSL to securely connect to Amazon Redshift Cluster
  • Connections to DataBase Hang Including "/ as sysdba"
  • Deciding "PROCESSES" parameter value
  • TNS file functionality for PostgreSQL
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 188 other subscribers
Proudly powered by WordPress | Tech Blog WordPress Theme by TheMagnifico
TOP