Posts by Sakthi Sethuperumal S

Steps to scp file from one server to another server in oracle cloud

INTRODUCTION: The below steps shows us how to enable the scp for file transfers in oracle cloud. Open the puttygen Import the target server ppk file It will ask for the target server ppk file we are going to scp Select the file and click open The ssh keys will be generated. Select the Export OpenSSH Key Save the File with ssh extension move the file to source server in /etc/ssh folder Now we are able to move the pfile to target server.

Read More

Migrating Non ASM Database to ASM Database.

Database Migration from Non-ASM to ASM We are going to convert our oracle Database to be migrated from Non ASM to ASM storage using RMAN commands Check the ASM instance…

Read More

Decrypting Web logic Password Oracle Apps R12.2

INTRODUCTION: The below steps shows how to decrypt the weblogic password for oracle Apps R12.2 STEP 1: Connect to instance as applmgr and source the ENV. su – applmgr .…

Read More

Running a Concurrent Program in Custom Manager in Oracle Apps R12.2

INTRODUCTION: The below steps shows us how to run a concurrent program in a custom manager, STEP 1: Navigate to System Administrator->Concurrent->Program->Define STEP 2: Create a custom manager as per…

Read More

Patch Analysis in Oracle Apps R12.1

INTRODUCTION The below steps shows us how to take patch analysis on oracle EBS R12.1. STEP 1: Download the Recommended Patch from MOS, move it to the server and Unzip.…

Read More

DROP AND RECREATE UNDO

INTRODUCTION: The below steps shows how to drop and recreate undo tablespace, by doing this activity we can gain more space in mount points and the database size will be reduced.   STEP 1: Check the DB size using the below query,   col “Database Size” format a20 col “Free space” format a20 col “Used space” format a20 select round(sum(used.bytes) / 1024 / 1024 / 1024 ) || ‘ GB’ “Database Size” , round(sum(used.bytes) / 1024 / 1024 / 1024 ) – round(free.p / 1024 / 1024 / 1024) || ‘ GB’ “Used space” , round(free.p / 1024 / 1024 / 1024) || ‘ GB’ “Free space” from (select bytes from v$datafile union all select bytes from v$tempfile union all select bytes from v$log) used , (select sum(bytes) as p from dba_free_space) free group by free.p /   STEP 2: Check the list of undo tablespaces using the below query,   column tablespace format a20…

Read More

RMAN Scratch

INTRODUCTION   The below steps will describe how to perform Rman Scratch.   STEP 1: Take a RMAN full backup of the database [oracle@Clone oradata]$ export ORACLE_SID=Product [oracle@Clone oradata]$ sqlplus…

Read More

MOVING DATA FILES AND REDO LOGS

INTRODUCTION:   The activity of moving redo logs online can gain us more space in mount points.   STEPS: STEP 1: Check the size of the mount points using df -h STEP 2: Moving the datafiles without bringing down the database, Issue the following command, ALTER DATABASE MOVE DATAFILE ‘/prdadata01/oracle/PRODA/db/apps_st/sample/sample.dbf’ TO ‘/prdadata01/oracle/PRODA/db/apps_st/data/sample.dbf’;   STEP 3: Moving the redo logs from one mount point to another mount point, Bring down the application node, sh $ADMIN_SCRIPTS_HOME/adstpall.sh apps/<appspassword> Bring down the listener and database lsnrctl stop shut immediate   STEP 4: Issue the following OS command   mv /prdadata02/oracle/PRODA/db/apps_st/data/log01a.dbf to /prdadata01/oracle/PRODA/db/apps_st/data/log01a.dbf mv /prdadata02/oracle/PRODA/db/apps_st/data/log01b.dbf to /prdadata01/oracle/PRODA/db/apps_st/data/log01b.dbf mv /prdadata03/oracle/PRODA/db/apps_st/data/log02b.dbf to /prdadata01/oracle/PRODA/db/apps_st/data/log02b.dbf mv /prdadata03/oracle/PRODA/db/apps_st/data/log02a.dbf to /prdadata01/oracle/PRODA/db/apps_st/data/log02a.dbf…

Read More

MIGARATION FROM WINDOWS TO LINUX(12.1.0.1 TO 19.0.0)

INTRODUCTION Migration of a windows database 12.1.0.1 to linux database of version 19.0.0, below are the steps to perform the migration.   INSTALLED A DATABASE IN WINDOWS AND CHECKED THE…

Read More

EXPDP OF FND_LOBS

ISSUE: ORA-31693: Table data object “APPLSYS”.”FND_LOBS” failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout ORA-01555: snapshot too old: rollback segment number  with…

Read More