Posts

Showing posts from March, 2017

Oracle Database Error Solutions & DBA Knowledge Base

Welcome to Oracle Database Error Solutions, a professional technical knowledge base dedicated to helping Oracle Database Administrators, Oracle E-Business Suite administrators, developers, and IT professionals troubleshoot Oracle Database and Oracle Linux issues with confidence.

This website provides practical, real-world troubleshooting guides based on hands-on Oracle administration experience. You'll find detailed solutions for Oracle Database errors, RMAN backup and recovery, Data Guard, ASM, RAC, Oracle Linux administration, Oracle E-Business Suite (EBS), cloning, performance tuning, patching, installation, and day-to-day DBA tasks.

Whether you're resolving ORA-27101, ORA-28040, ORA-01555, ORA-12154, ORA-01017, or other Oracle errors, our step-by-step articles are designed to save you time and help you solve problems efficiently.

Oracle EBS Cloning with File System Cold Backup

-
Image
Applies to: Oracle EBS R12.1.3 Database 11.1.0.7.0 Operating System Oracle Enterprise Linux Server 5.8 Description: Production hostname is EBSPROD Test hostname is EBSTEST Solution: I am going to clone my Production server using file system cold backup. Execute adpreclone.pl on DB Tier of EBSPROD: $ cd /d01/oracle/PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_ebsprod $ perl adpreclone.pl dbTier pwd=apps After completion of above script, then go to APPS Tier of EBSPROD: $ cd /d01/oracle/PROD/inst/apps/PROD_ebsprod/admin/scripts $ perl adpreclone.pl appsTier pwd=apps After complete the above script, shutdown all services of APPS and DB and make tar files: $ tar -czf PROD_DB_15Mar17_0030.tar.gz /d01/oracle/PROD/db $ tar -czf PROD_APPS_15Mar17_0030.tar.gz /d01/oracle/PROD/apps $ tar -czf PROD_INST_15Mar17_0030.tar.gz /d01/oracle/PROD/inst $ tar -czf PROD_ARC_15Mar17_0030.tar.gz /archivelogs After installation of OS and all necessary RPM’s and configuration, cop...
2 comments
Read more