foalabs

RMAN Active Duplicate Fails with ORA-19837 ORA-19849 ORA-19850 Error: RMAN active duplicate fails with error: RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script ORA-19849: error while reading backup piece from service <service_name> ORA-19850: backup piece constructed from service <service_name> is corrupt ORA-19837: invalid blocksize 0 in backup piece header ORA-19660: some files in the backup set could not be verified ORA-19661: datafile 0 could not be verified ORA-19849: error while reading backup piece from service <service_name> ORA-19850: backup piece constructed from service <service_name> is corrupt ORA-19837: invalid blocksize 0 in backup piece header   Reason: This is because the Encryption is configured in the target database. Execute “SHOW ALL” in the rman and see if you notice the following, RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> CONFIGURE ENCRYPTION ALGORITHM ‘AES128’; ...

How to Drop and Recreate Temporary Tablespace in Oracle 1) Find the existing temp tablespace details :  select tablespace_name,file_name from dba_temp_files; 2) Create another Temporary Tablespace TEMP1 CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE ‘/u01/app/oradata/temp01′ SIZE 5G; 3) Assign new tablespace as  Default  temp tablespace. ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP1;  If any sessions are using temp space, then kill them. SELECT b.tablespace,b.segfile#,b.segblk#,b.blocks,a.sid,a.serial#,a.username,a.osuser, a.statusFROM v$session a,v$sort_usage WHERE a.saddr = b.session_addr;   ALTER SYSTEM KILL SESSION 'SID,SERIAL#' IMMEDIATE; 4) Drop the original temp tablespace? DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES; Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment

Installing puttygen on Mac OS To install puttygen on macOS, you need to install the PuTTY suite, which is part of a package called putty . This can be done using Homebrew , a popular package manager for macOS. Follow these steps: Step 1: Install Homebrew (if not installed) If you don't already have Homebrew installed, you can install it by running the following command in your terminal: Below is single line command. Make sure you run as single line. /bin/bash -c " $(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh) " Step 2: Install PuTTY (which includes puttygen) Once Homebrew is installed, you can install PuTTY, which includes the puttygen tool: brew install putty Step 3: Verify the installation After the installation is complete, verify that puttygen is installed by running the following command: puttygen -- help This should display usage information for puttygen , confirming that it has been installed successfully. Step 4: Use puttyg...

ServiceGenerationError:: Unable To Deploy Integrated SOA Gateway Webservice in R12 Error: When trying to generate an Integrated SOA Gateway Service the following error happens: Service Provider Access resulted in exception 'oracle.apps.fnd.soa.util.SOAException: ServiceGenerationError: ServiceGenerationError: Error in Service Generationnull' when attempting to perform 'GENERATE'. Please view Service Provider logs for more details From log file: Generating service with classId = 2570 Error in Service Generation. ServiceGenerationError: ServiceGenerationError: Error in Service Generationnull oracle.apps.fnd.soa.util.SOAException: ServiceGenerationError: ServiceGenerationError: Error in Service Generationnull at oracle.apps.fnd.soa.provider.util.ServerAccess.analyzeServerResponse(ServerAccess.java:160) at oracle.apps.fnd.soa.ui.ProviderAccess.generateWSDL(ProviderAccess.java:37) at oracle.apps.fnd.soa.provider.wsdl.ServiceGenerator.generateSingleService(ServiceGenerator.ja...

Using Edge Browser Concurrent Program Output Saving as FNDWRR.txt SYMPTOMS: Using Edge browser when concurrent program output is saved the output file name defaulting to FNDWRR.txt.This is happening only for txt format output type files. Expected Behaviour: When concurrent program output is saved the file name should default with program name. Eg: For Active User concurrent program the Output should be Active_Users.txt STEPS: The issue can be reproduced at will with the following steps: Using Edge Browser Connect to EBS application Navigate to System administrator responsibility Submit Active User concurrent Program Click On view Output Program output open in edge browser. Save the output using option Ctrl+S This issue is only for output format of type txt and only in Edge browser. Other browsers like the IE, Chrome the concurrent program outputs were getting saved with expected file naming convention. Reason: Edge browser failed to convert the output file name when using existing view...

How to run the Punchout TEST in Oracle EBS Application Steps: 1) Set the CLASSPATH variable to include the current directory as well as the javax-ssl-1_1.jar and  jssl-1_1.jar (whichever exists in the directory). Usually, these two files reside under $IAS_ORACLE_HOME/jlib You may need to run a command similar to the one given below to set the CLASSPATH env variable. CLASSPATH=$CLASSPATH:/eb_xxx0_p/applmgr/xxxora/iAS/jlib/jssl-1_1.jar:/eb_xxx0_p/applmgr/xxxora/iAS/jlib/javax-ssl-1_1.jar export CLASSPATH 2) Set the shared library path (LD_LIBRARY_PATH) to include the directory where the shared SSL library used byiProcurement resides. Usually this should be $IAS_ORACLE_HOME/lib/ You may need to run a similar command as below to set the LD_LIBRARY_PATH env variable. LD_LIBRARY_PATH=/eb_xxx0_p/applmgr/xxxora/iAS/lib:$LD_LIBRARY_PATH export LD_LIBRARY_PATH 3) Then please run the following command and see if you are successful. Make sure to set the echo $LD_LIBRARY_PATH and CLASSPATH as m...

Standard Value to set SGA and PGA Memory in Oracle Setting the appropriate values for SGA (System Global Area) and PGA (Program Global Area) is crucial for optimizing Oracle database performance. If you have 64 GB of total memory available on your server, you need to allocate memory to SGA and PGA wisely to balance between database cache, session management, and overall performance. Below are some guidelines for setting SGA and PGA values: Recommended Allocation Strategy For a server with 64 GB of total memory, consider the following strategy: SGA and PGA Distribution: Typically, allocate about 60-70% of the total memory to Oracle, leaving some for the OS and other processes. For example, if using 60% of 64 GB , then about 38 GB can be allocated to Oracle memory (SGA + PGA). SGA and PGA Breakdown: SGA (System Global Area) : Allocate about 75-80% of Oracle's allocated memory. PGA (Program Global Area) : Allocate about 20-25% of Oracle's allocated memory. Memory Settings Calc...