Posts Tagged ‘Oracle DBA’

ORA-01552: cannot use system rollback segment for non-system tablespace ‘TEMP’

April 15th, 2024, posted in Oracle Queries
Share
$ sqlplus / as sysdba
alter system set undo_management=auto scope=spfile;
2) Restart the database.
SQL> Shutdown immediate;
SQL> startup
Share

STEPS HOW TO APPLY APPS PATCH USING ADPATCH IN R12.1.3

June 5th, 2023, posted in Oracle, Solaris
Share

Below are the steps to apply apps patch using ADpatch in oracle EBS R12.1.3. But before applying the patch please go through readme.txt file to understand how to, and all the high level steps in a better way.

SQL> select release_name from apps.fnd_product_groups;
RELEASE_NAME
12.1.3

STEP 1: Download and extract the patch from the Oracle support site.

I have downloaded the patch in /scratch/stage directory.

[oracle@orahowdb stage]$ ls -lrt p30311974*
-rw-r--r-- 1 gbuora dba 1067724 Oct 14 02:57 p30311974_R12.CDR.C_R12_GENERIC.zip

[oracle@orahowdb stage]$ unzip p30311974_R12.CDR.C_R12_GENERIC.zip

STEP 2: Set the environmental variables.

 Set environment variables


[oracle@orahowdb stage]$  source /scratch/u01/E-BIZ/apps/apps_st/appl/APPSdm48sp_orh16fn.env

[oracle@orahowdb stage]$  which adadmin
/scratch/u01/E-BIZ/apps/apps_st/appl/ad/12.0.0/bin/adadmin

[oracle@orahowdb stage]$  which adpatch
/scratch/u01/E-BIZ/apps/apps_st/appl/ad/12.0.0/bin/adpatch 

STEP 3: Check if patch is already applied or not and the count of valid and invalid objects.

SQL> select * from AD_BUGS where bug_number='30311974';
SQL> select count(*) from dba_objects where status='INVALID';

STEP 4: Stop the application. and check if application is completely stopped.

[oracle@orahowdb stage]$  cd $ADMIN_SCRIPTS_HOME
[oracle@orahowdb scripts]$  adstpall.sh apps/apps
[oracle@orahowdb  scripts]$ ps -ef|grep /scratch/u01/E-BIZ


Note:  /scratch/u01/E-BIZ is the apps installed directory.

STEP 5: Enable maintenance mode.

[oracle@orahowdb scripts]$  sqlplus apps/apps @/scratch/u01/E-BIZ/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE

STEP 6: Goto the unzipped patch directory and note down the drv file name.

[oracle@orahowdb stage]$ cd 30311974
[ oracle@orahowdb  30311974]$ ls -ltr *.drv
-rw-rw-r-- 1 gbuora dba 12001 Oct 11 10:03 u30311974.drv

STEP 7: execute adpatch command to apply the patch.

Below are the options which you need to enter during adpatch options.

Filename [adpatch.log] : u30311974.log ===just enter patch_num .log=====
Enter the password for your 'SYSTEM' ORACLE schema:xxx ==enter system password====
Enter the ORACLE password of Application Object Library [APPS] :xxx ===enter apps pss apps==
Please enter the name of your AutoPatch driver file : u30311974.drv ===enter .drv file name===

STEP 8: After patching disable the maintenance mode.

sqlplus apps/apps @/scratch/u01/E-BIZ/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql DISABLE

STEP 9: Start the services.

cd $ADMIN_SCRIPTS_HOME
[oracle@orahowdb 30311974]$ echo $ADMIN_SCRIPTS_HOME
/scratch/u01/E-BIZ/inst/apps/dm48sp_orh16fn/admin/scripts
[ oracle@orahowdb  scripts]$ adstrtal.sh apps/apps

STEP 10: Check the applied patch.

SQL> select * from AD_BUGS where bug_number=' 30311974';

Below are the applied adpatch logs for your reference.

[oracle@orahowdb 30311974]$ cd 30311974
[oracle@orahowdb 30311974]$ ls -ltr *.drv
-rw-rw-r-- 1 gbuora dba 12001 Oct 11 10:03 u30311974.drv
[ oracle@orahowdb  30311974]$ adpatch
Copyright (c) 2002 Oracle Corporation Redwood Shores, California,Oracle Applications AutoPatch USA
       unless you have written permission from Oracle Corporation.
 Attention: AutoPatch no longer checks for unapplied pre-requisite patches.
 You must use OAM Patch Wizard for this feature. Alternatively, you can
 review the README for pre-requisite information.
 Your default directory is '/scratch/u01/E-BIZ/apps/apps_st/appl'.
 Is this the correct APPL_TOP [Yes] ?
 AutoPatch records your AutoPatch session in a text file
 you specify.  Enter your AutoPatch log file name or press [Return]
 to accept the default file name shown in brackets.
 Filename [adpatch.log] : u30311974.log
 You can be notified by email if a failure occurs.
 Do you wish to activate this feature [No] ?
 Please enter the batchsize [1000] :
 Please enter the name of the Oracle Applications System that this
 APPL_TOP belongs to.
 The Applications System name must be unique across all Oracle
 Applications Systems at your site, must be from 1 to 30 characters
 long, may only contain alphanumeric and underscore characters,
 and must start with a letter.
 Sample Applications System names are: "prod", "test", "demo" and
 "Development_2".
 Applications System Name [dm48sp] : dm48sp *
 NOTE: If you do not currently have certain types of files installed
 in this APPL_TOP, you may not be able to perform certain tasks.
 Example 1: If you don't have files used for installing or upgrading
 the database installed in this area, you cannot install or upgrade
 the database from this APPL_TOP.
 Example 2: If you don't have forms files installed in this area, you cannot
 generate them or run them from this APPL_TOP.
 Example 3: If you don't have concurrent program files installed in this area,
 you cannot relink concurrent programs or generate reports from this APPL_TOP.
 Do you currently have files used for installing or upgrading the database
 installed in this APPL_TOP [YES] ? YES *
 Do you currently have Java and HTML files for HTML-based functionality
 installed in this APPL_TOP [YES] ? YES *
 Do you currently have Oracle Applications forms files installed
 in this APPL_TOP [YES] ? YES *
 Do you currently have concurrent program files installed
 in this APPL_TOP [YES] ? YES *
 Please enter the name Oracle Applications will use to identify this APPL_TOP.
 The APPL_TOP name you select must be unique within an Oracle Applications
 System, must be from 1 to 30 characters long, may only contain
 alphanumeric and underscore characters, and must start with a letter.
 Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".
 APPL_TOP Name [orh16fn] : orh16fn *
 You are about to apply a patch to the installation of Oracle Applications
 in your ORACLE database 'dm48sp'
 using ORACLE executables in '/scratch/u01/E-BIZ/apps/tech_st/10.1.2'.
 Is this the correct database [Yes] ?
 AutoPatch needs the password for your 'SYSTEM' ORACLE schema
 in order to determine your installation configuration.
 Enter the password for your 'SYSTEM' ORACLE schema:xxxx
 The ORACLE username specified below for Application Object Library
 uniquely identifies your existing product group: APPLSYS
 Enter the ORACLE password of Application Object Library [APPS] :xxxx
 AutoPatch is verifying your username/password.
 The status of various features in this run of AutoPatch is:
 Feature                          Active?   APPLTOP    Data model    Flags
 ------------------------------   -------   --------   -----------   -----------
 CHECKFILE                        Yes       1          1             Y N N Y N Y
 PREREQ                           Yes       6          6             Y N N Y N Y
 CONCURRENT_SESSIONS              No        2          2             Y Y N Y Y N
 PATCH_TIMING                     Yes       2          2             Y N N Y N Y
 PATCH_HIST_IN_DB                 Yes       6          6             Y N N Y N Y
 SCHEMA_SWAP                      Yes       1          1             Y N N Y Y Y
 JAVA_WORKER                      Yes       1          1             Y N N Y N Y
 CODELEVEL                        Yes       1          1             Y N N Y N Y
 Identifier for the current session is 30861
 Reading product information from file…
 Reading language and territory information from file…
 Reading language information from applUS.txt …
 AutoPatch warning:
  Product Data File
  /scratch/u01/E-BIZ/apps/apps_st/appl/admin/zfaprod.txt
  does not exist for product "zfa".
 This product is registered in the database but the
 above file does not exist in APPL_TOP.  The product
 will be ignored without error.
 AutoPatch warning:
  Product Data File
  /scratch/u01/E-BIZ/apps/apps_st/appl/admin/zsaprod.txt
  does not exist for product "zsa".
 This product is registered in the database but the
 above file does not exist in APPL_TOP.  The product
 will be ignored without error.
 AutoPatch warning:
  Product Data File
  /scratch/u01/E-BIZ/apps/apps_st/appl/admin/jtsprod.txt
  does not exist for product "jts".
 This product is registered in the database but the
 above file does not exist in APPL_TOP.  The product
 will be ignored without error.
 Reading database to see what industry is currently installed.
 Reading FND_LANGUAGES to see what is currently installed.
 Currently, the following language is installed:
 Code   Language                                Status
 ----   --------------------------------------- ---------
 US     American English                        Base
 Your base language will be AMERICAN.
 Setting up module information.
 Reading database for information about the modules.
 Saving module information.
 Reading database for information about the products.
 Reading database for information about how products depend on each other.
 Reading topfile.txt …
 Saving product information.
 AD code level : [B.8]
 Trying to obtain a lock…
 Attempting to instantiate the current-view snapshot…
 Was already instantiated. So no instantiation done this time.
 Start date: Mon Oct 14 2019 04:22:42
 0 "left over" javaupdates.txt files uploaded to DB: Mon Oct 14 2019 04:22:42
 0 patches uploaded from the ADPSV format patch history files: Mon Oct 14 2019 04:22:42
 0 patches uploaded from the ADPSV format preinstall patch history files: Mon Oct 14 2019 04:22:42
 Uploading information about files copied during the previous runs …
 0 "left over" filescopied_.txt files uploaded to DB: Mon Oct 14 2019 04:22:42
 Enter the directory where your Oracle Applications patch has been unloaded
 The default directory is [/scratch/stage/30311974] :
 Please enter the name of your AutoPatch driver file : u30311974.drv
 Getting Oracle Applications Release…
 Current installed release is  12.1.3
 Reading patch driver file…
 Parsing and loading patch driver file…
         212 lines processed.
 Not checking patch integrity as integrity checking flag is turned off.
 Successfully read patch driver file.
 Determining target release…
 Current target    release is  12.1.3
 Determining which bug fixes to apply…
 Done determining which bug fixes to apply.
 Log and Info File sync point:
   Mon Oct 14 2019 04:23:08
 Turning off actions that reference unrecognized products.
 Log and Info File sync point:
   Mon Oct 14 2019 04:23:08
 End of unrecognized products checking.
 AD utilities can support a maximum of 999 workers. Your
 current database configuration supports a maximum of 73 workers.
 Oracle recommends that you use between 4 and 8 workers.
 Enter the number of parallel workers [4] :
 AutoPatch will run in parallel mode.
 Did not need to apply new applterr.txt.
 Applying new applprod.txt (if any)…
 Did not need to apply new applprod.txt.
 Performing version checking for driver files…
 Copying driver files into installation area…
 No driver files were selected for copying.
 Skipping…
  ForceCopy driver files into installation area for Specified driver
  since no such action is present for this driver file
 Screening out files not valid for this installation…
 Determining valid on-site files…
 Skipping…
  Determine forms to generate for Specified driver
  since no such action is present for this driver file
 Skipping…
  Determine Oracle Reports libraries to generate for Specified driver
  since no such action is present for this driver file
 Skipping…
  Determine reports to generate for Specified driver
  since no such action is present for this driver file
 Skipping…
  Determine if need to generate message files for Specified driver
  since no such action is present for this driver file
 Looking for active bug fixes with no active actions…
 Reading customized files list (if any)…
 Did not find customized files registration file
 "/scratch/u01/E-BIZ/apps/apps_st/appl/admin/applcust.txt"
 The file may have been uploaded to the database.
 This patch replaces the following customized files:
 No customized files are replaced by this patch.
 Copying files into installation area…
 
 You are running admvcode
 Header information is:
   $Header: aiopatch.lc 120.7.12010000.2 2014/02/06 11:42:55 mkumandu ship $
 Start of admvcode session
 Date/Time is Mon Oct 14 2019 04:23:12
 Filelist file is: /scratch/u01/E-BIZ/apps/apps_st/appl/admin/dm48sp/out/copymast.txt
 Patch   Character Set is: us7ascii
 On-site Character Set is: UTF8
 Log and Info File sync point:
   Mon Oct 14 2019 04:23:12
 Information about files copied to the APPL_TOP would be written to the
 informational message file.
 Character set 'US7ASCII' is a subset of character set 'UTF8'.
 No character set conversion is required.
 Copying files to APPL_TOP…
 0 directories created.
   33 files copied without         character set conversion.
    0 files copied with successful character set conversion.
 33 files copied successfully.
    0 files had fatal errors.
 admvcode is exiting with status 0
 End of admvcode session
 Date/time is Mon Oct 14 2019 04:23:13
 
 Done copying files into installation area.
 Skipping…
  ForceCopy files into installation area for Specified driver
  since no such action is present for this driver file
 Skipping…
  Archive object modules into product libraries for Specified driver
  since no such action is present for this driver file
 Skipping…
  Create Directories for Specified driver
  since no such action is present for this driver file
 Skipping…
  Relink for Specified driver
  since no such action is present for this driver file
 Performing second half of mirrored copies…
 No mirrored copies were executed in this patch.
 Updating Oracle Applications Java files if necessary…
 No Oracle Applications Java files required updates.
 Checking to see if any files possibly included in the product JAR files
   were copied by this patch…
   Running AutoConfig to instantiate templates which affect
   the generation of JAR files since none of these templates
   were patched during this run of adpatch.
 No product JAR files need to be re-generated.
 Checking to see if adjborg.txt or any files included in
   adjborg.txt were copied by this patch…
 Neither adjborg.txt nor any file included in
 Getting list of invalid objects in APPS schema.
 Invalid object reports are recorded in
 /scratch/u01/E-BIZ/apps/apps_st/appl/admin/dm48sp/log/30861_preenv.*
 Running SQL and EXEC commands in parallel…
 Creating the AD_UTIL_PARAMS table…
 Table AD_UTIL_PARAMS already exists, so dropping the table and recreating it.
 Creating FND_INSTALL_PROCESSES table…
 * Start of AD Worker session *
 AD Worker version: 12.0.0
 AD Worker started at: Mon Oct 14 2019 04:23:17
 APPL_TOP is set to /scratch/u01/E-BIZ/apps/apps_st/appl
 Worker process 3 started.
 * Start of AD Worker session *
 AD Worker version: 12.0.0
 AD Worker started at: Mon Oct 14 2019 04:23:17
 APPL_TOP is set to /scratch/u01/E-BIZ/apps/apps_st/appl
 Worker process 4 started.
 Checking if all jobs have their actual and symbolic arguments in sync….
 Done.
 Reading jobs from FND_INSTALL_PROCESSES table …
 * Start of AD Worker session *
 AD Worker version: 12.0.0
 AD Worker started at: Mon Oct 14 2019 04:23:17
 APPL_TOP is set to /scratch/u01/E-BIZ/apps/apps_st/appl
 Done reading jobs from FND_INSTALL_PROCESSES table …
 Telling workers to read 'todo' restart file.
 * Start of AD Worker session *
 AD Worker version: 12.0.0
 AD Worker started at: Mon Oct 14 2019 04:23:17
 APPL_TOP is set to /scratch/u01/E-BIZ/apps/apps_st/appl
 Done.
 Starting phase 0 (A0): con
 There are now 35 jobs remaining (current phase=A0):
     0 running, 1 ready to run and 34 waiting.
 Assigned: file cdr_stop_jobq.sql on worker  1 for product cdr username CDR.
 Completed: file cdr_stop_jobq.sql on worker  1 for product cdr username CDR.
 Starting phase 1 (A1): tab
 There are now 34 jobs remaining (current phase=A1):
     0 running, 1 ready to run and 33 waiting.
 Assigned: file DME_OPOBJ_CONTEXT_MAP_TMP.xdf on worker  1 for product cdr username APPS.
 Completed: file DME_OPOBJ_CONTEXT_MAP_TMP.xdf on worker  1 for product cdr username APPS.
 Starting phase 2 (A2): tab+2
 There are now 33 jobs remaining (current phase=A2):
     0 running, 1 ready to run and 32 waiting.
 Assigned: file dme2484partitionindex.sql on worker  1 for product cdr username CDR.
 Completed: file dme2484partitionindex.sql on worker  1 for product cdr username CDR.
 Starting phase 3 (A3): tbm: Create Large Indexes
 There are now 32 jobs remaining (current phase=A3):
     0 running, 1 ready to run and 31 waiting.
 Assigned: file DME_OPOBJ_CONTEXT_MAP_TMP.xdf on worker  1 for product cdr username APPS.
 Completed: file DME_OPOBJ_CONTEXT_MAP_TMP.xdf on worker  1 for product cdr username APPS.
 Starting phase 4 (A4): os
 There are now 31 jobs remaining (current phase=A4):
     0 running, 1 ready to run and 30 waiting.
 Assigned: file cdrpubsynonym.sql on worker  1 for product cdr username CDR.
 Completed: file cdrpubsynonym.sql on worker  1 for product cdr username CDR.
 Starting phase 5 (A5): pls
 There are now 30 jobs remaining (current phase=A5):
     0 running, 5 ready to run and 25 waiting.
 There are now 25 jobs remaining (current phase=A6):
     0 running, 22 ready to run and 3 waiting.
     4 running, 10 ready to run and 3 waiting.
 Starting phase 7 (A7): upg
 There are now 3 jobs remaining (current phase=A7):
     0 running, 1 ready to run and 2 waiting.
 Assigned: file dmeschexpval.sql on worker  1 for product cdr username CDR.
 Completed: file dmeschexpval.sql on worker  1 for product cdr username CDR.
 Starting phase 8 (A8): en+1
 There are now 2 jobs remaining (current phase=A8):
     0 running, 1 ready to run and 1 waiting.
 Assigned: file cdr_start_jobq.sql on worker  1 for product cdr username CDR.
 Completed: file cdr_start_jobq.sql on worker  1 for product cdr username CDR.
 Starting phase 9 (A9): last
 There are now 1 jobs remaining (current phase=A9):
     0 running, 1 ready to run and 0 waiting.
 Assigned: file cdrdmwbld248.ldt on worker  1 for product cdr username APPS.
 Program completed successfully
 Completed: file cdrdmwbld248.ldt on worker  1 for product cdr username APPS.
 Telling workers to quit…
 All workers have quit.
 Dropping FND_INSTALL_PROCESSES table…
 FND_INSTALL_PROCESSES table dropped.
 Dropping AD_DEFERRED_JOBS table…
 AD_DEFERRED_JOBS table dropped.
 Done running SQL and EXEC commands in parallel.
 Running Invoker's Rights Maintenance…
 Creating the AD_UTIL_PARAMS table…
 Table AD_UTIL_PARAMS already exists, so dropping the table and recreating it.
 Creating FND_INSTALL_PROCESSES table…
 Setting parallel context: Invoker's Rights processing at R120
 Need to perform Invoker's Rights processing
 Making job list for APPLSYS/*
 Writing dependencies of jobs to run to appldep.txt file…
 There are now 10 jobs remaining (current phase=A0):
     0 running, 1 ready to run and 9 waiting.
 Reading completed jobs from restart file (if any).
 There are now 10 jobs remaining (current phase=A0):
     0 running, 1 ready to run and 9 waiting.
 Determining which java executables are supported by adJavaWorker…
 Starting worker processes.
 Worker process 1 started.
 Worker process 2 started.
 * Start of AD Worker session *
 AD Worker version: 12.0.0
 AD Worker started at: Mon Oct 14 2019 04:28:00
 APPL_TOP is set to /scratch/u01/E-BIZ/apps/apps_st/appl
 Worker process 3 started.
 * Start of AD Worker session *
 AD Worker version: 12.0.0
 AD Worker started at: Mon Oct 14 2019 04:28:00
 APPL_TOP is set to /scratch/u01/E-BIZ/apps/apps_st/appl
 Worker process 4 started.
 Checking if all jobs have their actual and symbolic arguments in sync….
 Done.
 Reading jobs from FND_INSTALL_PROCESSES table …
 * Start of AD Worker session *
 AD Worker version: 12.0.0
 AD Worker started at: Mon Oct 14 2019 04:28:00
 APPL_TOP is set to /scratch/u01/E-BIZ/apps/apps_st/appl
 * Start of AD Worker session *
 AD Worker version: 12.0.0
 AD Worker started at: Mon Oct 14 2019 04:28:00
 APPL_TOP is set to /scratch/u01/E-BIZ/apps/apps_st/appl
 Done reading jobs from FND_INSTALL_PROCESSES table …
 Telling workers to read 'todo' restart file.
 Done.
 Starting phase 0 (A0): invoker
 There are now 10 jobs remaining (current phase=A0):
     0 running, 1 ready to run and 9 waiting.
 Assigned: file adinvset.pls on worker  1 for product ad  username APPLSYS.
 Completed: file adinvset.pls on worker  1 for product ad  username APPLSYS.
 Starting phase 1 (A1): invoker+1
 There are now 9 jobs remaining (current phase=A1):
     0 running, 4 ready to run and 5 waiting.
 There are now 5 jobs remaining (current phase=A2):
     0 running, 4 ready to run and 1 waiting.
 There are now 1 jobs remaining (current phase=A3):
     0 running, 1 ready to run and 0 waiting.
 Assigned: file adinvcln.pls on worker  1 for product ad  username APPLSYS.
 Completed: file adinvcln.pls on worker  1 for product ad  username APPLSYS.
 Done with Invoker's Rights processing.
 Telling workers to quit…
 All workers have quit.
 Dropping FND_INSTALL_PROCESSES table…
 FND_INSTALL_PROCESSES table dropped.
 Dropping AD_DEFERRED_JOBS table…
 AD_DEFERRED_JOBS table dropped.
 Updating the checkfile repository if necessary…
 Processing the last batch…
   Done updating the checkfile repository…
 Dropping AD_TABLE_INDEX_INFO table…
 AD_TABLE_INDEX_INFO table dropped.
 Done running SQL scripts and EXEC commands.
 Compiling invalid objects…
 sqlplus -s APPS/ @/scratch/u01/E-BIZ/apps/apps_st/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS  APPS  4  0 NONE FALSE
 sqlplus -s APPS/ @/scratch/u01/E-BIZ/apps/apps_st/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS  APPS  4  0 NONE FALSE
 Number of invalid objects: 2
 Getting list of invalid objects in APPS schema.
 Invalid object reports are recorded in
 /scratch/u01/E-BIZ/apps/apps_st/appl/admin/dm48sp/log/30861_postenv.*
 Skipping…
  Generate forms library files for Specified driver
  since no such action is present for this driver file
 Skipping…
  Generate forms menu files for Specified driver
  since no such action is present for this driver file
 Skipping…
  Generate forms for Specified driver
  since no such action is present for this driver file
 Skipping…
  Generate reports libraries for Specified driver
  since no such action is present for this driver file
 Skipping…
  Generate reports for Specified driver
  since no such action is present for this driver file
 Skipping…
  Generate Messages for Specified driver
  since no such action is present for this driver file
 Skipping…
  Generate Workflow resource files for Specified driver
  since no such action is present for this driver file
 Skipping …
  Running AutoConfig since none of its templates were
  patched during this run of adpatch.
 Saving Patch History information to Database…
 Trying to obtain a lock…
   Inserted 1 patch history records (total). 
 Gathering Statistics for AD_PATCH_HIST_TEMP
 Done Gathering Statistics for AD_PATCH_HIST_TEMP
               Inserted 1 bug history records for this patch (total).
                           Inserted 2 action history records for this bug (total).                         
 Gathering Statistics for AD_PATCH_HIST_TEMP
 Done Gathering Statistics for AD_PATCH_HIST_TEMP
               Inserted 1 bug history records for this patch (total).
                           Inserted 2 action history records for this bug (total).                         
 Updating the current-view snapshot…
 Done saving Patch History information.
 About to do IREP processing…
 Attempting to process IREP files …
 Successfully processed IREP files.
 Done IREP processing.
 Copying applprod.tmp to applprod.txt (if needed)…
 Did not need to copy applprod.tmp to applprod.txt.
 Copying admin//applterr.txt to admin/applterr.txt (if needed)…
 Did not need to copy admin/dm48sp/applterr.txt to admin/applterr.txt.
 sqlplus -s APPS/* @/scratch/u01/E-BIZ/apps/apps_st/appl/ad/12.0.0/sql/adtimrpt.sql 30861 adt30861
 A job timing report has been generated for the current session.
 You should check the file
     /scratch/u01/E-BIZ/apps/apps_st/appl/admin/dm48sp/out/adt30861.lst
 for details.
 Purging timing information for prior sessions.
 sqlplus -s APPS/* @/scratch/u01/E-BIZ/apps/apps_st/appl/ad/12.0.0/sql/adtpurge.sql 10 1000
 Done purging timing information for prior sessions.
 AutoPatch is complete.
 AutoPatch may have written informational messages to the file
 /scratch/u01/E-BIZ/apps/apps_st/appl/admin/dm48sp/log/u30311974.lgi
 Errors and warnings are listed in the log file
 /scratch/u01/E-BIZ/apps/apps_st/appl/admin/dm48sp/log/u30311974.log
 and in other log files in the same directory.
Share

Oracle : FRM-92102 ERRORS

January 14th, 2023, posted in Oracle
Share

Error reported was

Users are experiencing FRM-92102:A network error has occurred . The forms client attempted to reestablish its connection to the server 5 time(s) witho
ut success. Please check the network connection and try again.

Reference SR is 6782240.992 ( Leviton Mfg Co )

Please read through Note: 365529.1 Ext/Pub Troubleshooting FRM-92XXX Errors in Oracle Applications:
Please provide feedback on the questions listed in sections:
A. General List of Questions
D. Intermittent or Random Disconnects

These sections gave very good understanding on the problem at hand.

The most important point was timeout settings.
What the following timeout settings are set to:
Timeout Parameters:

FORMS60_TIMEOUT = 120

Heartbeat = 2 in $OA_HTML/bin/appsweb.cfg

Self Service Timeout Profile Options:
ICX: Session Timeout = 30
ICX:Limit Time = 4
ICX:Limit connect = 1000

session.timeout=1800000 (zone.properties in Apache)

So analyst recommended following adjustments

The ‘FORMS60_TIMEOUT = 120’ should not be set so high. For users that walk away and stay con
nected, this will consume unnecessary resources.
It is recommended that the ‘FORMS60_TIMEOUT be set to something like 30 minutes with 60 minutes being about the
max.

Concerning the:
ICX:Limit Time = 4
ICX:Limit connect = 1000

The ICX:Limit Time, controls the total time a session can be logged in. If set to 4 hours,
then after 4 hours the user will get disconnected, regardless of what activity
is being done. Bump this setting up to something like 8 to 10 hours.

The ICX:Limit connect, needs to be bumped up to 2000 +, because each time Session Time is
checked it adds another ICX connection. This IS NOT DETERMEND BY THE NUMBER OF U
SER CONNECTIONS. The more ICX checks its self the more ICX connections you are g
oing to see. Session expiration can also occur when the total number of times th
e session is validated exceeds ‘ICX: Limit Connect’.

The above two ICX settings are most likely the source of the errors you are seeing.

So we had to reset above settings and bounce apps.

We had a question about licensing issue as well and analyst said

The ‘ICX:Limit Connect’ has nothing to do with the number of concurrent users connecting to the a
pplications. Increasing ICX:Limit Connect to 2000+ will NOT voilate your licens
ing with Oracle ( Leviton had only 1000 concurrent user license) .

Share

Oracle EBS Application [UNEXPECTED] java.io.FileNotFoundException

September 4th, 2022, posted in Oracle EBS Application
Share

The concurrent program the output of which is XML report is failing in warning and the log shows the below message:
Beginning post-processing of request 5292785 on node AP6105RT at 02-AUG-2006 04:47:48. Post-processing of request 5292785 failed at 02-AUG-2006 04:49:48 with the error message:

The Output Post-processor is running but has not picked up this request. No further attempts will be made to post-process this request, and the request will be marked with Warning status.
Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary. Example if the response time is set to 60 make it at-least 180. Bounce the concurrent manager once this is done. This will resolve the issue.

If the issue still persist, check the OPP log file. You follow below navigation

System Administrator -> Concurrent : Manager -> Administrator

On this screen click on Output Post Processor and then click on Processes button -> Manager Log button

 

Error : 

 

[11/10/19 10:27:07 AM] [OPPServiceThread1] Post-processing request 16359131.
[11/10/19 10:27:07 AM] [820550:RT16359131] Executing post-processing actions for request 16359131.
[11/10/19 10:27:07 AM] [820550:RT16359131] Starting XML Publisher post-processing action.
[11/10/19 10:27:07 AM] [820550:RT16359131] 
Template code: XXSD_RDF_TO_XML_PROC
Template app:  AR
Language:      en
Territory:     00
Output type:   EXCEL
[11/10/19 10:27:07 AM] [UNEXPECTED] [820550:RT16359131] java.io.FileNotFoundException:
        /usr/tmp/xml/xdoSBWzBuUW6V111019_1027079523.fo (No such file or directory)
	at java.io.FileOutputStream.open(Native Method)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:131)
	at oracle.apps.xdo.common.tmp.TmpFile.createTmpFileJDK118(TmpFile.java:146)
	at oracle.apps.xdo.common.tmp.TmpFile.createTmpFile(TmpFile.java:113)
	at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:987)
	at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
	at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1665)
	at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)
	at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5936)
	at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)
	at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)
	at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:285)
	at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:173)

[11/10/19 10:27:07 AM] [820550:RT16359131] Completed post-processing actions for request 16359131.

 

Cause :

The Temporary directory for XML Publisher has not been modified after making the clone so it was pointing to non existing location and getting error out.

 

Issue :

Issue was with XML Publisher temporary directory path.

 

Solution :

1. Create a new Temporary Directory on OS level for the cloned environment.
2. Make sure that the application owner (APPLMGR) has Read and Write permission this directory.
3. Setup this new directory for XML Publisher via :
XML Publisher Administrator responsibility: Properties -> General -> Temporary Directory.

3. Restart the Server.
4. Test again with a XML Publisher Report.

Share

Duplicate Database from RMAN Backup – Oracle

April 10th, 2022, posted in Oracle Queries
Share

Duplicate Database from RMAN Backup


Seven Steps for Duplicate Database :

Step 1) RMNA Backup (Prerequisites)

Step 2) Create Password File

Step 3) Create Directory Structure

Step 4) Create Pfile

Step 5) Start Database in nomount Stage

Step 6) Run Duplicate Database Command

Step 7) Verify Duplicate Database

 

Step 1 RMAN Full database backup required (Prerequisites)

If database is in non archivelog mode then Shutdown the database and open in mount stage then take database backup i.e.RMAN > backup database;

If database is in archivelog mode use command i.e.  RMAN > backup database plus archivelog;

Backup Database using following command

Backup Database

-bash-4.1$ rman

Recovery Manager: Release 12.1.0.2.0 - Production on Fri Mar 11 12:19:23 2016

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target sys/sysdba123@orcl

connected to target database: ORCL (DBID=1611723298)

RMAN>

RMAN> configure controlfile autobackup on;

using target database control file instead of recovery catalog

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters are successfully stored

RMAN> backup database plus archivelog;



Step 2 Create a password file for the duplicate instance.

Copy Source database password file and rename it to new database password file

Go to directory: /mnt/devops_0/Oracle/db1212/product/12.1.0.2/db_1/dbs/

$ cp orapworcl orapwduporcl





Step 3 Create directory structure for Duplicate Database

Login with user db1212

Following directories need to be created

–          DupOrcl

–          Oradata

–          Fast_recovery_area

–          Diag

–          Adump

Following are sample commands

-bash-4.1$ mkdir /mnt/devops_0/DupDB/DupOrcl

-bash-4.1$ mkdir /mnt/devops_0/DupDB/DupOrcl/adump

-bash-4.1$ mkdir /mnt/devops_0/DupDB/DupOrcl/oradata

-bash-4.1$ mkdir /mnt/devops_0/DupDB/DupOrcl/oradata/duporcl

-bash-4.1$ mkdir /mnt/devops_0/DupDB/DupOrcl/fast_recovery_area

-bash-4.1$ mkdir /mnt/devops_0/DupDB/DupOrcl/diag

-bash-4.1$





Step 4 Create Pfile with few parameters.

Login with db1212

Create Pfile with following parameters

Go to directory: /mnt/devops_0/Oracle/db1212/product/12.1.0.2/db_1/dbs/

Parameters as below for initduporcl.ora,

*.audit_file_dest='/mnt/devops_0/DupDB/DupOrcl/adump'

*.audit_trail='db'

*.compatible='12.1.0.2.0'

*.db_block_size=8192

*.db_create_file_dest='/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl'

*.db_name='duporcl'

*.db_recovery_file_dest='/mnt/devops_0/DupDB/DupOrcl/fast_recovery_area'

*.db_recovery_file_dest_size=4560m

*.diagnostic_dest='/mnt/devops_0/DupDB/DupOrcl/diag'

*.undo_tablespace='UNDOTBS1'





Step 5 Start Database in nomount stage.

-bash-4.1$ export ORACLE_SID=duporcl

-bash-4.1$

-bash-4.1$ echo $ORACLE_SID

duporcl

-bash-4.1$

SQL> startup nomount

ORACLE instance started.

Total System Global Area  222298112 bytes

Fixed Size                  2922760 bytes

Variable Size             163579640 bytes

Database Buffers           50331648 bytes

Redo Buffers                5464064 bytes

SQL>

SQL> exit




Step 6 Run Duplicate Database command.
$ rman auxiliary /

$ DUPLICATE DATABASE TO duporcl

SPFILE

set control_files='/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/control01.ctl'

set DB_FILE_NAME_CONVERT='/mnt/devops_0/OrclNew/oradata/orclnew/','/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/'

set LOG_FILE_NAME_CONVERT='/mnt/devops_0/OrclNew/oradata/orclnew/','/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/'

BACKUP LOCATION '/mnt/devops_0/OrclNew/fast_recovery_area/ORCLNEW'

;






Following is the log for above command for future references.

-bash-4.1$ rman auxiliary /

Recovery Manager: Release 12.1.0.2.0 - Production on Fri Mar 11 12:04:18 2016

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to auxiliary database: DUPORCL (not mounted)

RMAN> DUPLICATE DATABASE TO duporcl

SPFILE

set control_files='/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/control01.ctl'

set DB_FILE_NAME_CONVERT='/mnt/devops_0/OrclNew/oradata/orclnew/','/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/'

set LOG_FILE_NAME_CONVERT='/mnt/devops_0/OrclNew/oradata/orclnew/','/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/'

BACKUP LOCATION '/mnt/devops_0/OrclNew/fast_recovery_area/ORCLNEW'

;

Starting Duplicate Db at 11-MAR-16

contents of Memory Script:

{

   restore clone spfile to  '/mnt/devops_0/Oracle/db1212/product/12.1.0.2/db_1/dbs/spfileduporcl.ora' from

 '/mnt/devops_0/OrclNew/fast_recovery_area/ORCLNEW/autobackup/2016_03_10/o1_mf_s_906121024_cg2639ch_.bkp';

   sql clone "alter system set spfile= ''/mnt/devops_0/Oracle/db1212/product/12.1.0.2/db_1/dbs/spfileduporcl.ora''";

}

executing Memory Script

Starting restore at 11-MAR-16

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=13 device type=DISK

channel ORA_AUX_DISK_1: restoring spfile from AUTOBACKUP /mnt/devops_0/OrclNew/fast_recovery_area/ORCLNEW/autobackup/2016_03_10/o1_mf_s_906121024_cg2639ch_.bkp

channel ORA_AUX_DISK_1: SPFILE restore from AUTOBACKUP complete

Finished restore at 11-MAR-16

sql statement: alter system set spfile= ''/mnt/devops_0/Oracle/db1212/product/12.1.0.2/db_1/dbs/spfileduporcl.ora''

contents of Memory Script:

{

   sql clone "alter system set  db_name =

 ''DUPORCL'' comment=

 ''duplicate'' scope=spfile";

   sql clone "alter system set  control_files =

 ''/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/control01.ctl'' comment=

 '''' scope=spfile";

   sql clone "alter system set  db_file_name_convert =

 ''/mnt/devops_0/OrclNew/oradata/orclnew/'', ''/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/'' comment=

 '''' scope=spfile";

   sql clone "alter system set  LOG_FILE_NAME_CONVERT =

 ''/mnt/devops_0/OrclNew/oradata/orclnew/'', ''/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/'' comment=

 '''' scope=spfile";

   shutdown clone immediate;

   startup clone nomount;

}

executing Memory Script

sql statement: alter system set  db_name =  ''DUPORCL'' comment= ''duplicate'' scope=spfile

sql statement: alter system set  control_files =  ''/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/control01.ctl'' comment= '''' scope=spfile

sql statement: alter system set  db_file_name_convert =  ''/mnt/devops_0/OrclNew/oradata/orclnew/'', ''/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/'' comment= '''' scope=spfile

sql statement: alter system set  LOG_FILE_NAME_CONVERT =  ''/mnt/devops_0/OrclNew/oradata/orclnew/'', ''/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/'' comment= '''' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area    1073741824 bytes

Fixed Size                     2932632 bytes

Variable Size                713031784 bytes

Database Buffers             352321536 bytes

Redo Buffers                   5455872 bytes

contents of Memory Script:

{

   sql clone "alter system set  db_name =

 ''ORCLNEW'' comment=

 ''Modified by RMAN duplicate'' scope=spfile";

   sql clone "alter system set  db_unique_name =

 ''DUPORCL'' comment=

 ''Modified by RMAN duplicate'' scope=spfile";

   shutdown clone immediate;

   startup clone force nomount

   restore clone primary controlfile from  '/mnt/devops_0/OrclNew/fast_recovery_area/ORCLNEW/autobackup/2016_03_10/o1_mf_s_906121024_cg2639ch_.bkp';

   alter clone database mount;

}

executing Memory Script

sql statement: alter system set  db_name =  ''ORCLNEW'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''DUPORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area    1073741824 bytes

Fixed Size                     2932632 bytes

Variable Size                713031784 bytes

Database Buffers             352321536 bytes

Redo Buffers                   5455872 bytes

Starting restore at 11-MAR-16

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=12 device type=DISK

channel ORA_AUX_DISK_1: restoring control file

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/control01.ctl

Finished restore at 11-MAR-16

database mounted

released channel: ORA_AUX_DISK_1

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=12 device type=DISK

contents of Memory Script:

{

   set until scn  1804148;

   set newname for datafile  1 to

 "/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/system01.dbf";

   set newname for datafile  3 to

 "/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/sysaux01.dbf";

   set newname for datafile  4 to

 "/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/undotbs01.dbf";

   set newname for datafile  5 to

 "/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/example01.dbf";

   set newname for datafile  6 to

 "/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/users01.dbf";

   restore

   clone database

   ;

}

executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 11-MAR-16

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00001 to /mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/system01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00003 to /mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/sysaux01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00004 to /mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/undotbs01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00005 to /mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/example01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00006 to /mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/users01.dbf

channel ORA_AUX_DISK_1: reading from backup piece /mnt/devops_0/OrclNew/fast_recovery_area/ORCLNEW/backupset/2016_03_10/o1_mf_nnndf_TAG20160310T121557_cg2615wf_.bkp

channel ORA_AUX_DISK_1: piece handle=/mnt/devops_0/OrclNew/fast_recovery_area/ORCLNEW/backupset/2016_03_10/o1_mf_nnndf_TAG20160310T121557_cg2615wf_.bkp tag=TAG20160310T121557

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:05

Finished restore at 11-MAR-16

contents of Memory Script:

{

   switch clone datafile all;

}

executing Memory Script

datafile 1 switched to datafile copy

input datafile copy RECID=6 STAMP=906206847 file name=/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/system01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=7 STAMP=906206847 file name=/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/sysaux01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=8 STAMP=906206847 file name=/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/undotbs01.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=9 STAMP=906206847 file name=/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/example01.dbf

datafile 6 switched to datafile copy

input datafile copy RECID=10 STAMP=906206847 file name=/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/users01.dbf

contents of Memory Script:

{

   set until scn  1804148;

   recover

   clone database

    delete archivelog

   ;

}

executing Memory Script

executing command: SET until clause

Starting recover at 11-MAR-16

using channel ORA_AUX_DISK_1

starting media recovery

channel ORA_AUX_DISK_1: starting archived log restore to default destination

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=1 sequence=11

channel ORA_AUX_DISK_1: reading from backup piece /mnt/devops_0/OrclNew/fast_recovery_area/ORCLNEW/backupset/2016_03_10/o1_mf_annnn_TAG20160310T121703_cg2637go_.bkp

channel ORA_AUX_DISK_1: piece handle=/mnt/devops_0/OrclNew/fast_recovery_area/ORCLNEW/backupset/2016_03_10/o1_mf_annnn_TAG20160310T121703_cg2637go_.bkp tag=TAG20160310T121703

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

archived log file name=/mnt/devops_0/OrclNew/Archives/1_11_906113933.dbf thread=1 sequence=11

channel clone_default: deleting archived log(s)

archived log file name=/mnt/devops_0/OrclNew/Archives/1_11_906113933.dbf RECID=1 STAMP=906206849

media recovery complete, elapsed time: 00:00:01

Finished recover at 11-MAR-16

Oracle instance started

Total System Global Area    1073741824 bytes

Fixed Size                     2932632 bytes

Variable Size                713031784 bytes

Database Buffers             352321536 bytes

Redo Buffers                   5455872 bytes

contents of Memory Script:

{

   sql clone "alter system set  db_name =

 ''DUPORCL'' comment=

 ''Reset to original value by RMAN'' scope=spfile";

   sql clone "alter system reset  db_unique_name scope=spfile";

}

executing Memory Script

sql statement: alter system set  db_name =  ''DUPORCL'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset  db_unique_name scope=spfile

Oracle instance started

Total System Global Area    1073741824 bytes

Fixed Size                     2932632 bytes

Variable Size                713031784 bytes

Database Buffers             352321536 bytes

Redo Buffers                   5455872 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DUPORCL" RESETLOGS ARCHIVELOG

  MAXLOGFILES     16

  MAXLOGMEMBERS      3

  MAXDATAFILES      100

  MAXINSTANCES     8

  MAXLOGHISTORY      292

 LOGFILE

  GROUP   1 ( '/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/redo01.log' ) SIZE 50 M  REUSE,

  GROUP   2 ( '/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/redo02.log' ) SIZE 50 M  REUSE,

  GROUP   3 ( '/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/redo03.log' ) SIZE 50 M  REUSE

 DATAFILE

  '/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/system01.dbf'

 CHARACTER SET AL32UTF8

contents of Memory Script:

{

   set newname for tempfile  1 to

 "/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/temp01.dbf";

   switch clone tempfile all;

   catalog clone datafilecopy  "/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/sysaux01.dbf",

 "/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/undotbs01.dbf",

 "/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/example01.dbf",

 "/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/users01.dbf";

   switch clone datafile all;

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/temp01.dbf in control file

cataloged datafile copy

datafile copy file name=/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/sysaux01.dbf RECID=1 STAMP=906206886

cataloged datafile copy

datafile copy file name=/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/undotbs01.dbf RECID=2 STAMP=906206886

cataloged datafile copy

datafile copy file name=/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/example01.dbf RECID=3 STAMP=906206886

cataloged datafile copy

datafile copy file name=/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/users01.dbf RECID=4 STAMP=906206886

datafile 3 switched to datafile copy

input datafile copy RECID=1 STAMP=906206886 file name=/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/sysaux01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=2 STAMP=906206886 file name=/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/undotbs01.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=3 STAMP=906206886 file name=/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/example01.dbf

datafile 6 switched to datafile copy

input datafile copy RECID=4 STAMP=906206886 file name=/mnt/devops_0/DupDB/DupOrcl/oradata/duporcl/users01.dbf

contents of Memory Script:

{

   Alter clone database open resetlogs;

}

executing Memory Script

database opened

Finished Duplicate Db at 11-MAR-16




Step 7 Check Duplicate Database Status

-bash-4.1$ ps -ef | grep pmon

db1212    8550     1  0 Mar09 ?        00:00:12 ora_pmon_orcl12c

db1212   32132     1  0 12:07 ?        00:00:00 ora_pmon_duporcl

 -bash-4.1$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Mar 11 12:09:06 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE

——— ——————–

DUPORCL   READ WRITE

Share