Data Mover SQL Error ORA-12899: Value Too Large for Column

Error:
Data MoverSQL Error. Stmt #: 0 Error Position: 851 Return: 12899 - ORA-12899: value too large for column "SYSADM"."PS_GP_FORMULA_DTL".&q uot;FM_COMMENT" (actual: 255, maximum: 254)

Data Mover Release: 8.52
Database: HRMS91 (ENG)
Input file: C:\PT8.52\data\hcengs.db (ENG)
Importing GP_FORMULA_DTL
Import GP_FORMULA_DTL 0
Updating statistics for GP_FORMULA_DTL
Records remaining: 11949
Importing GP_FORMULA_DTL
File: Data MoverSQL error. Stmt #: 0 Error Position: 851 Return: 12899 - ORA-12899: value too large for column "SYSADM"."PS_GP_FORMULA_DTL".&q uot;FM_COMMENT" (actual: 255, maximum: 254)
Failed SQL stmt:INSERT INTO PS_GP_FORMULA_DTL (PIN_NUM, EFFDT, SEQ_NUM5, FRML_FUNC_OPTN, FRML_LEFT_PAREN, ENTRY_TYPE_FRML1, PIN_FRML_FLD1_NUM, FRML_FLD1_DAT_TYP, FRML_FLD1_DEC_VAL, FRML_FLD1_DATE_VAL, FRML_FLD1_CHAR_VAL, FRML_FLD1_ATRB_IND, PIN_RND1_NUM, FRML_FLD1_USE_OPTN, FRML_OPER1, FRML_FLD1_OLDV_IND, ENTRY_TYPE_FRML2, PIN_FRML_FLD2_NUM, FRML_FLD2_DAT_TYP, FRML_FLD2_DEC_VAL, FRML_FLD2_DATE_VAL, FRML_FLD2_CHAR_VAL, FRML_FLD2_ATRB_IND, PIN_RND2_NUM, FRML_FLD2_USE_OPTN, FRML_FLD2_OLDV_IND, FRML_RIGHT_PAREN, ENTRY_TYPE_FRML3, PIN_FRML_FLD3_NUM, FRML_FLD3_DAT_TYP, FRML_FLD3_ATRB_IND, PIN_RND3_NUM, FRML_FLD3_USE_OPTN, FM_COMMENT) VALUES (:1, TO_DATE(:2,'YYYY-MM-DD'), :3, :4, :5, :6, :7, :8, :9, TO_DATE(:10,'YYYY-MM-DD'), :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, TO_DATE(:21,'YYYY-MM-DD'), :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :
Error: Unable to insert row 5091
Error: SQL execute error for GP_FORMULA_DTL
Unsuccessful completion

Solution:
Changes need to done before starting of installation.
Change NLS_LENGTH_SEMANTICS to CHAR which is default as BYTE.
Below are the steps:

SQL> alter system set NLS_LENGTH_SEMANTICS=char scope=both;   

System altered.   

SQL> select value from v$parameter where upper(name)='NLS_LENGTH_SEMANTICS';   

VALUE
-------------------------------------------------------------------------------
CHAR   SQL> select value from v$nls_parameters where parameter='NLS_LENGTH_SEMANTICS';   

VALUE
----------------------------------------------------------------
BYTE   

SQL> startup force
ORACLE instance started.   

Total System Global Area  535662592 bytes
Fixed Size                  1348508 bytes
Variable Size             381684836 bytes
Database Buffers          146800640 bytes
Redo Buffers                5828608 bytes
Database mounted.
Database opened.
SQL> select value from v$parameter where upper(name)='NLS_LENGTH_SEMANTICS';   

VALUE
-------------------------------------------------------------------------------
CHAR   

SQL> select value from v$nls_parameters where parameter='NLS_LENGTH_SEMANTICS';   

VALUE
----------------------------------------------------------------
CHAR   

SQL>

Query to find the 10 Largest Objects in DB

SELECT * FROM
(
select
    SEGMENT_NAME,
    SEGMENT_TYPE,
    BYTES/1024/1024/1024 GB,
    TABLESPACE_NAME
from
    dba_segments
order by 3 desc 
) WHERE
ROWNUM <= 10 

ORA-12560 "TNS protocol adapter error" (Tns: Protocol Adapter Error Ora-12560 Connecting Via Sqlplus)

Cause:  The ORACLE_SID is not set in the environment

Solution:

To implement the solution, please execute the following steps (for Multiple Oracle Homes Or One oracle Home):
===============================================================
ORACLE_SID variables should only be set in the appropriate registry key that corresponds to the software installation. In this case it should be set back to Original (old) instance name for taking it as default ORACLE_SID.

For 8i and 9i, this would be:
----------------------------
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME(n)


For 10g and 11g, this would be:
-----------------------------------
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE\KEY_

OR

You may execute the following steps (If only one Oracle Home installed ) to set variables at system level :
======================================================================

1. Go to: My Computer >> right click >> Properties >> Advanced >> Env variables >> System

2. Add new variable

3. Enter ORACLE_SID as the variable name

4. Enter the database sid as the value