Oracle Apps DBA

How to find if the Oracle Client Software is 32-Bit or 64-Bit ? here you can have some ways to find it. You can find whether Oracle Client Software is 32-Bit or 64-Bit by using the following : 1.Check the sqlplus binary % file $ORACLE_HOME/bin/sqlplus 64-bit will show 64-bit. 32-bit will show 32-bit or not specify wordsize 2.Check for the directories : $ORACLE_HOME/lib32 $ORACLE_HOME/lib % ls -l $ORACLE_HOME/lib32 % ls -l $ORACLE_HOME/lib If the two directories $ORACLE_HOME/lib32 and $ORACLE_HOME/lib exist, then it is 64 bit client. If you have only $ORACLE_HOME/lib you need to use method 1 as there are client versions (11.2)where $ORACLE_HOME/lib32 directory does not exist on 64-bit client installations. Refernce: How To Find If The Oracle Client Software Is 32-Bit Or 64-Bit on UNIX platforms [ID 434295.1] NOTE:119707.1 - How to Tell if the Oracle Software is 32-Bit or 64-Bit

We can change the DB char set using the CSSCAN utility, it provides information about if we change the char set, which data we might lost during the char set conversion. let's see how to use csscan utility. 1.set your DB env 2.Go to $ORACLE_HOME/bin 3.Before invoke the csscan , make sure you have char set migration schema(csminst) available in database, if not install it first, otherwise you will get this below error while running csscan CSS-00107: Character set migration utility schema not installed sqlplus "/as sysdba" @?/rdbms/admin/csminst.sql 4.Invoke the csscan utility ./cssacn \"sys/oracle AS SYSDBA\" FULL=Y - to scan the whole DB ./cssacn \"sys/oracle AS SYSDBA\" table=schema.table_name - to scan a table still many options available to scan a schema itself etc. 5.while running the above, we need to provide the char set name, which we need to migrate and no of process. 6.Once it completed, validate the scan.txt, scan.err for any lossy