dbms_lob.write Failed with ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275


Error Description:
PLSQL Block with dbms_lob.write command is getting failed with following error. Command: dbms_lob.write (tempblob,length(tempname), 1,utl_raw.cast_to_raw (substr(tempname,1,length(tempname))));

ORA-06502: PL/SQL: numeric or value error: raw variable length too long: Convert Varchar2 to Blob with utl_raw.cast_to_raw


Error Description:
Oracle datatype conversion from VARCHAR2 to BLOB using the function utl_raw.cast_to_raw  is getting failed with following error.

SQL>  update bl_test set TR_PIC=utl_raw.cast_to_raw(TR_NAME) WHERE LENGTH(TR_NAME)>2000;

Convert Oracle Varchar2 column to Blob data type Using utl_raw.cast_to_raw – Example

Here is the example for normal Oracle VARCHAR2 datatype to BLOB database.

In this example EMP is my sample table and I trying to convert ENAME column to blob.

Fix ORA-19870 ORA-19863: device block size 4186112 is larger than max allowed: 1048576


Error Description:
RMAN Duplicate database command failed with following error message.
RMAN-00571: ==============================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ==
RMAN-00571: ==============================================
RMAN-03002: failure of Duplicate Db command at 07/20/2012 09:50:30
RMAN-05501: aborting duplication of target database

HISTTIMEFORMAT: How to See the Linux commands History with Date and Time?

Linux command prompt provides history of all commands which got executed under that login. If you give normal history command it will not show the date and time for the command execution. But in many cases you would need the date and time of the command execution which we can easily get it by formatting the HISTTIMEFORMAT environment variable.

Siebel Error SBL-ODC-00105 ORA- 24345 A Truncation or null fetch error occurred


Error Description:
Siebel application screen is throwing the following error while querying.
SBL-ODC-00105 ORA- 24345 A Truncation or null fetch error occurred

Oracle EM Alert: Critical:DBNAME - There have been n failed login attempts in the last x minutes: Identify the LOGIN failure with 1017 returncode


This is an Oracle EM alert which says the database has n unsuccessful login attempts in x minutes.
In order to identify the login details which are getting failed you should have enable the database auding especially enable the “connect audit”.

How to Perform Multiple Comparisons in Oracle SQL Query Using Select .. Case .. When .. Else


Oracle 10g R1 onwards the case .. when clause has been added to the select statement which can perform several comparisons in a single query. Prior to that we should have to use the DECODE function to achieve this goal.

ORA-04031: unable to allocate 2048024 bytes of shared memory: 11 g RAC Fix error

The following error is getting logged frequently in alert log and as per the metalink suggestion the SGA_TARGET has to be increased to fix the same. To increase the SGA_TARGET value it requires the database bounce. If you are running in Oracle RAC environment you can perform this change without full database outage. Please find the steps to change value instance by instance.
Error: ORA-04031: unable to allocate 2048024 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")

How to Fix PLS-00201: identifier 'DBMS_AQ' must be declared

Error Description:
Procedure compilation failed with following error.
PLS-00201: identifier 'DBMS_AQ' must be declared

Solution Description
You have to grant the execute privilege on package DBMS_AQ to the particular user who owns the procedure.

How to Renew the Domain Registered From Blogger Settings – Domain Auto Renewal via Google Apps

The domain which is registered from the blogger is valid only for one year from the date of registration. You must have to renew the domain to retain your visitors. If you forget to renew your domain after a year, someone else can take the domain. If you miss the existing domain name it is very tough to achieve the same amount visitors with different domain name.

11g Deferred Segment: ORA-01950: no privileges on tablespace


Normally "ORA-01950: no privileges on tablespace" error occurs due to the no space quota allocated to the user on the particular tablespace. I wish to explain the difference in ORA-01950 error with deferred segment creation values with TRUE and FALSE. 

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

Error Description:
Application is getting following error while accessing the partitioned table.
The SQL Exception is: "ORA-14402: updating partition key column would cause a partition change
Normally this error happens after making the partitions to the tables.

How to Configure Tablespace / Monitoring Alert Emails in Oracle 11g OEM Rules

You can configure the monitoring alerts using Oracle EM.
Here I am going demonstrate OEM configuration for tablespace monitoring alert. 
Please see the steps. 
  1. Login to OEM console with username (sysman) and password

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