ORA-01452: Cannot CREATE UNIQUE INDEX; Duplicate Keys Found

Problem:-

While creating the unique index on a table, got below error.

SQL> create unique index TEST_IDX on TEST5(EMPNO);
create unique index TEST_IDX on TEST5(EMPNO)
*
ERROR at line 1:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

Cause:- You tried to execute a CREATE UNIQUE INDEX statement on one or more columns that contain duplicate values.

Solution:-

Find the duplicate rows in the table and delete them.

Use below script to delete the duplicate rows

REM This (more...)

ORA-08104: This Index Object Is Being Online Built Or Rebuilt

This post is about “ORA-08104”.  We are going t learn how to solve this issue. Steps are mention below:-

While dropping an index, if you are facing ORA-08104 error, then you need to clean it using dbms_repair

Problem:

SQL> drop index eric_icmsprod.SOTRAN00_IDX1;
drop index eric_icmsprod.SOTRAN00_IDX1
*
ERROR at line 1:
ORA-08104: this index object 94771 is being online built or rebuilt

Cause

you have not installed the patch for Bug 3805539 or (more...)

Storage Volumes and File System Layout in Oracle Cloud

This section provides information about the storage volumes and file system layout of a newly created database deployment on Oracle Database Cloud Service.

Compute Cloud Service Storage Volumes

When a Database Cloud Service deployment is created using the Oracle Database Cloud Service service level, the following storage volumes are created.

Storage Volume Description
bits 60 GB volume completely allocated to /u01 on the virtual machine.
boot 32 GB volume allocated to the following file system mounts on the virtual machine:
(more...)

Explain usage of different users in Oracle Cloud

This article provides information about Linux user accounts that are provisioned on Oracle Database Cloud Service.

Every Database Cloud Service compute node is provisioned with the following operating system user accounts. Both compute nodes are provisioned with the following operating system user accounts.

  1. opc: The system administrator account you use with the sudo command to perform operations that require root-user access.
  2. oracle: The Oracle Database administrator account you use to access the system and perform non-root (more...)

ORA-29516: Aurora Assertion Failure: Assertion Failure

 

This post is for steps which solve ORA-29516.

 

If the java component is corrupted, then while executing java related packages, you may face below error.

Cause

You have set additional mount options on the shared memory device, /dev/shm, other than just the option named defaults.

Problem:

select dbms_java.longname(‘TEST’) from dual;
select dbms_java.longname(‘TEST’) from dual
*
ERROR at line 1:
ORA-29516: Aurora assertion failure: Assertion failure at eox.c:359
Uncaught exception Root of (more...)

ORA-19588: Archived Log RECID Is No Longer Valid

As we know each and every problem have solutions. Let’s have a solution to the Error:- ORA-19588.

PROBLEM:

While taking RMAN backup, got below error.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t4 channel at 05/01/2017 03:18:01
ORA-19588: archived log RECID 143154 STAMP 942443843 is no longer valid

Cause: The indicated record has been marked as deleted. This indicates that the corresponding file has either been (more...)

RMAN-20035: Invalid High RECID In Rman Catalog

We are going to learn about the steps which we use to solve issues RMAN-20035. 

 

 

we face RMAN-20035: invalid high RECID  after connecting to catalog database.

 

executing command: SET COMMAND ID
starting full resync of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 07/27/2016 10:54:19
RMAN-03014: implicit resync of recovery catalog failed

on default channel at 07/27/2016 10:54:19
RMAN-20035: invalid (more...)

SQL*Plus tips #8: How to read the output of dbms_output without “serveroutput on”

When “serveroutput” is enabled, SQL*Plus executes “BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;” after each command.
That’s why I don’t like when it is always enabled: it adds extra calls and round-trips and it is inconvenient when I want to get a plan of the last executed query:

SQL> set serverout on;
SQL> select * from dual;

D
-
X

SQL> select * from table(dbms_xplan.display_cursor('','','allstats last'));

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------
SQL_ID  9babjv8yq8ru3, child number 0

BEGIN  (more...)

https for IIS on IaaS – the basics



More a quick reference for me than anything else - these are the steps to enable https for iis on IaaS in Azure (well or anywhere for that matter) - this will use a 'proper' certificate from a certifying authority to stop all those warnings you get with self certified ones.

So here are the quick steps - in this case i have a server called testssl this is in an azure domain called mycompany. (more...)

ORA-00027: Cannot Kill Current Session

A login session is one of the most common problems while we are working on the huge amount of data with multiple users.  This post explains about those steps which we use to kill the session.

 

ORA-00027: cannot kill the current session, the error comes, when you are trying to kill your current session, which is not allowed.

EXAMPLE:

Get the sid and serial# for the current session.

SQL> select username,inst_id, sid, serial# FROM (more...)

Generic error(Failed Jdk Version Is Incompatible.Please Use A Jdk Version With Opatchauto)

While running the opatchauto command in oracle grid you may face the jdk version error as below. We are going to learn about the steps which we use to solve this issue.

root # /crsapp/app/oracle/product/grid12c/OPatch/opatchauto apply /softdump/12C_GRIDSOFT/PATCH/22191349 -analyze -ocmrf /softdump/12C_GRIDSOFT/PATCH/grid.rsp 
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.

OPatchauto Version : 12.1.0.1.10
OUI Version : 12.1.0.2.0
Running from : /crsapp/app/oracle/product/grid12c

opatchauto log file: /crsapp/app/oracle/product/grid12c/cfgtoollogs/opatchauto/22191349/opatch_gi_2016-04-06_09-27-57_analyze. (more...)

Oracle ACE Director

I was at UKOUG Tech17 this week in my capacity at both Speaker and Tech Lead (organizing and selecting the agenda, drinks, parties, etc – although the heavy lifting is done by the @UKOUG office)

There was rather a nice surprise waiting for me. Jennifer from the Oracle ACE Program upgraded my Oracle ACE to Oracle ACE Director.

ACED_blk

This is a wonderful honour and reflects the many many days dedicated each year to the Oracle (more...)

Bug with integer literals in PL/SQL

This interesting question was posted on our russian forum yesterday:

We have a huge PL/SQL package and this simple function returns wrong result when it’s located at the end of package body:

create or replace package body PKGXXX as
  ...
  function ffff return number is
  nRes number;
  begin        
    nRes :=  268435456;
    return nRes;
  end;
end;
/

But it works fine in any of the following cases:
* replace 268435456 with power(2, 28), or
* replace (more...)

List of other Certification earned

Soon

The post List of other Certification earned appeared first on ORACLE-HELP.

Shooting the DBA isn’t a Silver Bullet to the Cloud

We’ve all been watching numerous companies view value in bypassing the Database Administrator and other critical IT roles in an effort to get IT faster to the cloud.  It may look incredibly attractive to sales, but the truth of it is, it can be like setting up land mines in your own yard.

Having the right people in the right roles, doing the right tasks is essential to having a complete cloud deployment.  (more...)

UKOUG Tech17 : It’s a Wrap!

Just a quick reflection on the UKOUG Tech17 event…

Here are the posts I wrote over the event.

Things went pretty well for me this week. My timetable allowed me to come for two full days, which was nice. It’s a lot less stressful when you are not trying to (more...)

Fusing blobs in Azure…….



If you're reading this as a DBA you might be thinking i've written some plsql code to combine to blob column values into one - you'd be sadly mistaken what I'm actually going to talk about is this thing

https://azure.microsoft.com/en-us/blog/linux-fuse-adapter-for-blob-storage/

What this enables is the mounting of azure blob storage directly as a unix 'filesystem'. Now azure file storage can already be done using the tried and trusted smb protocol (samba) and we (more...)

UKOUG Tech17 : Wednesday

Wednesday started with a quick trip to the doctor, then I got a bus into town for the conference. I kept bumping into interesting people and chatting, so I didn’t manage to get to any of the early sessions.

I missed picking up my Best UK Speaker award and the group photo yesterday, so I picked it up today and did a photo with Linda and Jennifer, two of the ladies that keep the Oracle ACE (more...)

UKOUG Tech17 : Tuesday

Tuesday was a work day for me, so I was in work until the late afternoon, then left for the conference to do my APEX session. A little while later I was sitting in traffic thinking, “I’m not going to make it!” The traffic opened, I got a parking spot really quickly and I made it with 3 minutes to spare… 🙂

The session was based around API first development for APEX. I was quite (more...)

I went to a conference – and all I can post about is this picture

I was on DOAG and UKOUG conferences this year and hold some presentations there.
Of course I attended even more presentations and learned a lot of new things.
But I did not blog about it for some good reasons:
The presentations I attended are done already. Which means the presenters did a lot of research and put it all into great presentations and abstracts - so why should I create a weak copy of their (more...)