Oracle11g
Oracle 11g Articles
This page contains articles related to Oracle Database 11gR1 and 11gR2
Latest Articles
- 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 [...]
- 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 [...]
- 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 /u01/app/oracle/diag/rdbms/pkldb/pkldb/trace/pkldb_j035_14712.trc (incident=52961): ORA-07445: exception encountered: core dump [kokscold()+849] [SIGSEGV] [ADDR:0x50] [PC:0x115E16F] [Address not mapped to object] [] Incident details in: /u01/app/oracle/diag/rdbms/pkldb/pkldb/incident/incdir_52961/pkldb_j035_14712_i52961.trc From the incident trace [...]
- 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 to following scenarios 1)Runaway jobs – When Scheduler job is running without any SID. This means OS session is not present and this will not [...]
- 11gR2:Listener Startup Issues - In this blog post I will be discussing listener startup issues faced in 11gR2 RAC. I will be constantly updating this post based on my experiences or any comments on this blog post. Let’s get started.You will experience following errors while starting listener using srvctl [oracle@prod01]~% srvctl start listener -n prod01 PRCR-1013 : Failed to [...]
New Database Features
- 11gR2:Enable and Disable Oracle Feature with Chopt
- 11gR2 – SysAsm vs SysDba
- 11gR2: Monitoring Real Time SQL Plan Execution from Oracle Enterprise Manager
- 11gR2:What if Oracle gives you Kernel parameter fixup script
- 11g New Feature: Database Replay
- 11G:SYSASM role
- New ASM Background Processes in 11G
- Understanding of Oracle 11g Automatic Diagnostic Repository – Part 1
General Database Administration
- ORA-7445 core dump [kokscold()+849] from EM 12c
- Copying Oracle Scheduler jobs with Arguments
- 11g: Multiple failed login attempt can block New Application connections
- Changing CRS/Database timezone in 11.2.0.2 post install
- Oracle Database Appliance Introduced
- Oracle 11gR2 on linux is out
- Cloning database..Just do some Post checks !!
- Scheduling Job through Cron??
- Oracle Database 11G Installation on Solaris 10
- Solving ORA-1031 while connecting as “/ as sysdba” :
- AWE -What is It and How to use it?
- Recovering from ORA-1578 ORA-8103 (Logical Corruption)
- Significance of LD_LIBRARY_PATH
- Understanding of Oracle 11g Automatic Diagnostic Repository – Part 1
- Physical Corruption: ORA-1578 PART-2
- Application Design and ORA – 4031
- Physical Corruption: ORA-1578 -Part 1
- Deciding “PROCESSES” parameter value
- ERRORSTACK- Oracle Debugging Event
- Changing Database Characterset With Export/Import Utilities
