BR0233E Backup utility has reported an error while saving file

Issue: SAP oracle database Archive log backup failing using BR Tool


Error:

BR0233E Backup utility has reported an error while saving file
ERROR: incorrect format or option in .utl file (-p)
BR0231E Backup utility call failed
ERROR: Can't change to working directory Errno = 13 : Permission denied
BR0005I BRARCHIVE terminated with errors

Background/Analysis:

SAP archive backup policy started failing which is using brarchive ( SAP supplied backup utility BR Tool ) command executed via backup policy

As a first action logs & errors identified 

Secondly , brarchive command executed manually from database server which is client to backup media server as below

ORA-03106: fatal two-task communication protocol error

Error:

ORA-24330: internal OCI error

ORA-03106: fatal two-task communication protocol error

ORA-03114: not connected to ORACLE

Where: Error logged on oracle 11.2.0.2 client application server. Application based on c/c++ coding. Solaris 10 SPARC

CreateOUIProcess(): 13 Permission denied

Error:

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-03-19_06-52-06PM. Please wait ...Error in CreateOUIProcess(): 13
: Permission denied

When: While running ./runinstaller

Cause: oracle specific osuser unable to execute temp files from /tmp file system as execute permissions on /tmp was not allowed

$ ls -ld /tmp
drwxrwxrwt. 13 root root 4096 Mar 19 18:48 /tmp
 
Have look at the "." after drwxrwxrwt which means some restriction 

ORA-14402: updating partition key column would cause a partition change

Error: ORA-14402: updating partition key column would cause a partition change

Analysis:

Created a Sample test table to check if a row can move across the partition if gets updated

SQL> create table test ( a number) partition by range (a) ( partition amin values less than (2), partition a1  values less than (4) , partition amax values less than (maxvalue));

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS

Error:

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [PROCACT_SCHEMA  

ORA-06502: PL/SQL: numeric or value error

LPX-00210: expected '<' instead of '?'

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPW$WORKER", line 8164

----- PL/SQL Call Stack -----

  object      line  object

  handle    number  name

700000040277c30     19028  package body SYS.KUPW$WORKER

700000040277c30      8191  package body SYS.KUPW$WORKER

700000040277c30     15631  package body SYS.KUPW$WORKER

700000040277c30      3944  package body SYS.KUPW$WORKER

700000040277c30      8874  package body SYS.KUPW$WORKER

700000040277c30      1651  package body SYS.KUPW$WORKER    

700000040217c18         2  anonymous block

ORA-00600: internal error code, arguments: [kqd-objerror$]

Error: ORA-00600: internal error code, arguments: [kqd-objerror$], [U], [0], [88], [BIN$19274/1NYszgRAAUT/pFYw==$0], [], 

When: While purging recyclebin for a user or purging dba_recyclebin

 

SQL> purge recyclebin;

purge recyclebin

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [kqd-objerror$], [U], [0], [88], [BIN$19274/1NYszgRAAUT/pFYw==$0], [], [], [], [], [], [], []

Oracle Case insensitive search

Data entered in table column could be in different cases lower/upper making it difficult for search operation to retrieve all possible matches from the table

e.g.  To search abcd from the table if you enter Abcd as input string or anything that does not match with cases in which data is stored will result in “no rows selected” & vice versa.

Suppose case table has below rows, each one with different case but similar string

SQL> select * from case;

TEXT

--------------------------------------------------------------------------------

Abcd

aBcd

abCd

abcD

abcd

ABCD

6 rows selected.

ORA-12545: Connect failed because target host or object does not exist

Error: ORA-12545: Connect failed because target host or object does not exist


Background:

ORA-12545 is a generic error as a result of TNS configuration issue at client.
TNS configuration issue is unable to resolve host / IP specified in TNS entry
ORA-12545 is observed in DB links & remote connections via TNS alias



It has also been noticed in remote RAC databases wherein intermittent error being thrown while connecting to particular instance listed in address list