ORA-04023: Object could not be validated or authorized

ORA- Error:


SQL>SELECT DAT.*,DATE_MODE||';'||SYS_META_KEY MIS_XDISPARE
FROM MIS_SYS_DATA DAT WHERE 1 = 0 

ORA-04023: Object could not be validated or authorized

Bermuda Triangle The Mystery Solved ?

What is Bermuda Triangle ?

The Bermuda Triangle, also known as the Devil's Triangle or Hurricane Alley, is a loosely defined region in the western part of the North Atlantic Ocean where a number of aircraft and ships are said to have disappeared under mysterious circumstances.

Where is Bermuda Triangle Located ?

About 500,000 square miles of ocean off the southeastern tip of Florida , In Atlantic Ocean roughly bounded by Miami, Bermuda and Puerto Rico. The total area varying from 1,300,000 to 3,900,000 km (500,000 to 1,510,000 sq mi)."Indeed, some writers even stretch it as far as the Irish coast."

(Graphical Image of Bermuda Triangle)

                                                                                                                            

 (Satellite Image of Bermuda Triangle)

Who found Bermuda Triangle ?

ORA-02266: unique/primary keys in table referenced by enabled foreign keys

ORA- Error :

SQL> truncate table mis_report_new;
truncate table mis_report_new
*
ERROR at line 1:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys

Cause :

ORA-01830: date format picture ends before converting entire input string

ORA- Error :


SQL> SELECT TIMESTAMP ,db_user,OS_USER,object_schema,object_name,policy_name,statement_type,sql_text FROM DBA_FGA_AUDIT_TRAIL where policy_name like 'FGA%' and to_date(TIMESTAMP,'dd-mon-yyyy') >= to_date(sysdate-7,'dd-mon-yyyy') ORDER BY TIMESTAMP; 2 3

FROM DBA_FGA_AUDIT_TRAIL where policy_name like 'FGA%' and to_date(TIMESTAMP,'dd-mon-yyyy') >= to_date(sysdate-7,'dd-mon-yyyy')
*
ERROR at line 2:
ORA-01830: date format picture ends before converting entire input string

ORA-04022: nowait requested, but had to wait to lock dictionary object

ORA- Error:

SQL> exec dbms_fga.drop_policy('APPL_OWNER','MIS_CONDITION','FGA_MIS_CONDITION_SEL');

PL/SQL procedure successfully completed.


SQL> EXECUTE DBMS_FGA.ADD_POLICY(OBJECT_SCHEMA => 'APPL_OWNER',OBJECT_NAME => ', POLICY_NAME => 'FGA_MIS_CONDITION_SEL', AUDIT_CONDITION => 'SYS_CONTEXT(''USERENV'',''SESSION_USER'') IN (''APPL_XE_WRITER'',''APPL_READER'')', AUDIT_COLUMN => 'AGREEMENT_CODE', ENABLE => TRUE, STATEMENT_TYPES => 'SELECT');

BEGIN DBMS_FGA.ADD_POLICY(OBJECT_SCHEMA => 'APPL_OWNER',OBJECT_NAME => 'MIS_CONDITION', POLICY_NAME => 'FGA_MIS_CONDITION_SEL', AUDIT_CONDITION => 'SYS_CONTEXT(''USERENV'',''SESSION_USER'') IN (''APPL_XE_WRITER'',''APPL_READER'')', AUDIT_COLUMN => 'AGREEMENT_CODE', ENABLE => TRUE, STATEMENT_TYPES => 'SELECT'); END;

*
ERROR at line 1:
ORA-04022: nowait requested, but had to wait to lock dictionary object
ORA-06512: at "SYS.DBMS_FGA", line 20
ORA-06512: at line 1

ORA-01086: savepoint never established in this session or is invalid

SAVEPOINT is transaction control language in SQL , PL/SQL used to manage transaction consistent state within a complex coding during transition from one object to other.



It mainly helps to save a particular state of transaction and rollback to that point.





Let's see why it causes error "ORA-01086: savepoint never established in this session or is invalid" and solution for the same in two different scenario.

Motivational Thoughts on Life to inspire

"Nothing is predestined; The obstacles of your past can become the gateways that lead to new beginnings" ~ Ralph Blum.

"Happy are those who dream dreams and are ready to pay the price to make them come true" ~ Leon J. Suenes.

"Dream is not what you see in sleep, dream is something which doesn't let you sleep" ~ Dr. A.P.J Abdul Kalam, India.

Motivational Thoughts on Leadership by world leaders

"The most important quality in a leader is that of being acknowledged as such.." ~ Andre Maurois.

"In organizations , real power and energy is generated through relationships. The patterns of relationships and capacities to form them are more important than tasks, functions, roles and positions" ~ Margaret Wheatly.

"Excellence is not an accomplishment. It is a spirit , a never-ending process" ~ Lawrence M. Miller.

Motivational thoughts on Failure and Success by successful people in world

"Try not to become a man of success but a man of value" ~ Albert Einstein. 

"Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration" ~ Evan Esar. 

"It is hard to fail,but it is worse never to have tried to succeed" ~ Theodore Roosevelt.

Power of Thinking : A Dot Experiment

Human mind is most powerful than any other creature in the world.It is being called so because it has evolved over the years to gain shelter , food , security and survive among the competitors in food chain. 

Human brain is capable of thinking at very high speed , about the things that exists or not , places , imagination , analysis , decision making , strategy are outcomes of it.

In a "Dot Experiment" will find out how power of thinking helps to imagine out of boundaries and showcase why a human mind is capable of analyzing the things beyond expectations.

This Experiment can be taken up individually or within a group of team members ; more the number of minds more it will add value to experiment.

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

ORA- Error:

SQL*Plus: Release 18.0.0.0.0 - Production on Tue Jun 9 00:10:02 2020 Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

SQL> ERROR:

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

SQL> 

SP2-0640: Not connected

SP2-0641: "EXECUTE" requires connection to server

SQL>

Solve Rubik's Cube 7 Easy Steps

Rubik's cube 3 x 3 can be solved in easy 7 steps given in two different clips's below. 

First clip will showcase how to practice certain steps which will be used very frequently during solution.

Understand & practice these steps to solve the 3 x 3 Rubik's cube rapidly.

It may take up to a day or two practice to solve Rubik's cube efficiently without looking into references..  

        Rubik's Cube Practice

restart or invoke a shell script from inside in linux

As an Unix or Database Administrator, we often write a shell script to perform maintenance task which can be called manually , in crontab or scheduled in deployment pipeline.


Requirement to invoke a shell script within a single call helps to reuse the input's passed such as  password , file name or any other input variable.


The EASY method to do the same is by recalling shell script within a shell script again ...

#!/bin/sh

sh test.sh $0 $1

The SMART way to do the same is by using the goto method to call a block for re-invoking a part of the code ...

#!/bin/sh

goto()
{
echo "Part of Code to be invoke repeatedly.." 
}

while true; do

 echo -n "Proceed Y/N:"
 read INPUT

 if [ $INPUT == "Y" ] ; then
    goto;
 else
    break
    exit
 fi

done

smtp-server: 501 5.1.7 Invalid address

Error:

smtp-server: 501 5.1.7 Invalid address
. . . message not sent

Scenario:


mailx receives smtp-server: 501 5.1.7 Invalid address when shell script triggered via crontab job ; no errors received and mail delivered to recipient when same shell script executed on linux prompt.



Cause:


1. Invalid email address or domain name in recipient filled value -c or at the end of line in mailx.

ORA-06502 ORA-06512 ORA-22275

ORA- Error:


declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
ORA-06512: at "SYS.DBMS_LOB", line 960
ORA-06512: at line 19

Cause:

l_clob variable used in dbms_lob.LoadCLOBFromFile is not initialized causing it to remain empty.

ORA-06512 ORA-00942

ORA- Error:

BEGIN code_new_package.set_flag; END;
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "SCOTT.CODE_NEW_PACKAGE", line 56
ORA-06512: at line 1

 

Cause:

1. Package/procedure executed does not exist in database.

2. User executing package/procedure does not hold privilege to execute.

3. Public synonym missing on the package.

ORA-06512 ORA-01403

ORA- Error :

DECLARE
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 13

Cause: 

Variable declared inside a PL/SQL block or a cursor returned no value ; caused ORA-01403 : no data found and lead to generic ORA-06512 error at line 13 of the code.