Take / Generate Oracle 10g 11g Active Session History Report (ASH) Manually

Oracle ASH report introduced on Oracle 10GR2. It is kind of statistical data collected by Oracle Sampled data. The sampling is done on the current active sessions. Sampled data collected to circular buffer in SGA and the same can be accessed through V$ views. V$ACTIVE_SESSION_HISTORY view provides the sampled session activity for the instance.

Fix ORA-02299: cannot validate (SCOTT.EMP_UK) - duplicate keys found

Error Description:
Unique key constraint creations failed on table with following error.

SQL> alter table emp add constraint emp_UK unique (emp_id);
alter table emp add constraint emp_UK unique (emp_id)
                               *
ERROR at line 1:
ORA-02299: cannot validate (SCOTT.EMP_UK) - duplicate keys found

Retrieve / Recover / Restore Dropped Table in Oracle 10g 11g Using Flashback Table Feature

Suppose by mistake if you drop a table in Oracle 10g Oracle 11g you can retrieve the table using Flashback table feature. Flashback feature works with recycle bin to recover the table. For this the recycle bin must be enabled for the database.

How to Drop Oracle 10g 11g Bin$ / Recycle bin Tables

In Oracle 10g and 11g if you do a select * from tab; you can see many tables starts with Bin$ which we cannot drop using drop table command. These are the objects in the recycle bin which can be used for recovery purpose in case needed.

SQL> select * from tab;

Oracle Kill Session Command Fails with ORA-00027: cannot kill current session

Error Description:
DBA is trying to kill oracle sessions and one session is getting failed with following error.
SQL> alter system kill session '786,53315';
alter system kill session '786,53315'

Oracle Create table, Materialized View Command Fails with ORA-01723: zero-length columns are not allowed



Error Description:
Oracle Create As Select Command (CTAS) failed with following error.
SQL> create table emp as select name, null age from candidate;
create table emp as select name, null age from candidate
                                 *
ERROR at line 1:

Public Database Link fails with ORA-12154: TNS:could not resolve the connect identifier specified

Error Description:
Select from database link fails with following error.

12154. 00000 -  "TNS:could not resolve the connect identifier specified"
*Cause:    A connection to a database or other service was requested using
           a connect identifier, and the connect identifier specified could not
           be resolved into a connect descriptor using one of the naming methods
           configured. For example, if the type of connect identifier used was a
           net service name then the net service name could not be found in a
           naming method repository, or the repository could not be
           located or reached.

Oracle 10g 11g Archivelog Vs Noarchivelog Mode Difference, Advantages, Features

For Oracle database, it is mandatory to have 2 or more redo log groups which record the each and every change to the database. The LGWR process writes the changes to the redo log files in a cyclic manner. It starts writing into first redo group and moves to 2nd one and so on. After completion of the last group, the LGWR again starts writing with the first one.

How to Calculate Income Tax (IT) for New Financial Year 2012-13 after Budget

Please find some simple calculations for income tax for the financial year 2012-13. Finance minister increased the tax exemption limit to 2Lakhs from 1.8Lakhs and 20% slab extended up to 10Lakhs margin. 30% slab is applicable for 10lakhs and above.

How to Remove / Hide / Disable Google Plus One +1 Button from Adsense Image Ads

Google Plus One +1 button started coming in Google Adsense ads since October 2011. This gives additional relevance to the Adsense ads and it is useful to deliver more useful ads to the page users. Moreover the clicks on the +1 buttons are not counted as Adsense clicks and won’t generate any income to you.

EXPDP IMPDP Failed or terminated with ORA-31633, ORA-06512, ORA-00955

Error Description:
IMPDP failed with following error.
impdp job_name=schemaexp schemas=test dumpfile=exp_test%u.dmp logfile=imp_exp_TEST.log directory=exp_dir

Import: Release 11.2.0.2.0 - Production on Tue Mar 6 00:26:25 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

EXPDP IMPDP Failed with ORA-39065, ORA-39079, ORA-06512, ORA-06512, ORA-24033

Error Description: IMPDP fails or terminate with following errors.

ORA-39065: unexpected master process exception in SEND
ORA-39079: unable to enqueue message RP,KUPC$C_3_20120305232114,MCP,KUPC$A_4_232736061619000,1,N
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer