foalabs

Understanding Oracle's control_file_record_keep_time Parameter In Oracle databases, the control_file_record_keep_time parameter is a crucial setting that plays a significant role in controlling the retention period of historical information within the control file. This parameter is part of Oracle's Data Guard configuration and helps ensure data consistency and recoverability in the event of various failures or data corruption issues. What is the control_file_record_keep_time Parameter? The control_file_record_keep_time parameter is an initialization parameter introduced in Oracle Database 11g Release 2 (11.2). It defines the retention period (in days) for historical records kept in the control file. These historical records include information about backups, archived redo logs, and other database operations. Why is it Important? Maintaining historical information in the control file is vital for several reasons: Recovery: The historical information stored in the control file i...

XML Gateway Outbound PO Errors With Filenotfoundexception On Cwallett.Sso in EBS Oracle Apps Error: Setup xml gateway with trading partner for outbound transmission of Purchase Order to the Oracle Supplier Network. Generated approved purchase order.  However transaction monitor shows Delivery Status or Error and Delivery Message of Invalid CACert File. The xml_sql output shows following error: oracle.apps.ecx.oxta.ConnectionFailureException: Connection failure resulting from: java.io.FileNotFoundException: /inst/apps/<$CONTEXT_NAME>/certs/Apache/cwallet.sso Reason: The cwallet.sso did not exist in the location specified in the $INST_TOP/ora/10.1.3/j2ee/oafm/config/oc4j.properties.   This is the configuration file used by XML Gateway in EBS version 12.1.3.   Solution: For EBS 12.1.3 only Configure XML Gateway to use the JKS wallet instead of the SSO wallet.   This allows for TLS authentication.    1.  Ensure that the JDK version is ...

Oracle Cloud Compute Common Terms and Usage Oracle Cloud Compute offers a range of compute services and features for deploying and managing virtual machines and containers. Here are some key compute terms and their usage in Oracle Cloud: Compute Instance: A compute instance is a virtual machine (VM) running in Oracle Cloud. Instances can be used for a wide range of workloads, including applications, databases, and web servers. Availability Domain (AD): An availability domain is a physically separate data center within an Oracle Cloud region. Oracle Cloud regions consist of multiple availability domains to provide redundancy and high availability. Virtual Machine (VM): A virtual machine is a software emulation of a physical computer, running an operating system and applications. Oracle Cloud offers various VM shapes (sizes) with different CPU and memory configurations to meet different performance needs. Instance Shapes: Oracle Cloud provides a variety of instance shapes, each with s...

Oracle Cloud Storage Common Terms and Usage Oracle Cloud provides a variety of storage services and features to meet different storage needs. Here are some key storage terms and their usage in Oracle Cloud: Object Storage: Oracle Cloud Object Storage is a scalable and durable storage service designed for storing and managing unstructured data, such as files, images, videos, and backups. It's suitable for use cases like data archiving, content storage, and data backup. Buckets: In Object Storage, data is organized into containers called "buckets." Buckets are used to group related objects and manage access permissions. You can create, delete, and manage buckets to organize your data. Objects: Objects are individual files or pieces of data stored within buckets. Each object has a unique URL (Uniform Resource Locator) for access. You can upload, download, and delete objects in a bucket. Object Versioning: Object versioning is a feature in Oracle Cloud Object Storage that...

Oracle Cloud Networking Common Terms and Usage Oracle Cloud offers a range of networking services and features to help users build, manage, and secure their cloud infrastructure. Here are some key networking terms and their usage in Oracle Cloud: Virtual Cloud Network (VCN): A VCN is a fundamental building block of Oracle Cloud networking. It is a logically isolated network within Oracle Cloud Infrastructure (OCI) that you can customize and manage. You can use VCNs to organize your cloud resources, control traffic, and define network connectivity. Subnet: Subnets are subdivisions within a VCN. They help segregate resources within the VCN. You can create different subnets for different purposes, such as public-facing, private, or DMZ (Demilitarized Zone) subnets. Security Lists: Security Lists act as virtual firewalls for your instances within a subnet. You can define rules in a security list to control inbound and outbound traffic to and from instances. Route Tables: Route tables d...

How to find fragmentation in Tables and LOBs in Oracle Database In the world of database management, performance optimization is paramount. As data grows, tables and Large Objects (LOBs) can become fragmented, leading to inefficient storage and reduced query performance. Oracle, one of the most popular relational database management systems, offers several tools and techniques to identify and address fragmentation issues.  Fragmentation in a database occurs when data is not stored contiguously, resulting in scattered data blocks and unused space. This can lead to performance bottlenecks, as Oracle has to read multiple scattered blocks to retrieve a single row of data. Fragmentation is especially prevalent in tables and LOBs that experience frequent data modifications, such as insertions, updates, and deletions. Various ways to find segment level fragmentation for different TABLE and LOB segment types for different segment space management methods. Find if the tables are in MSSM or ...

After EBS DB Upgrade to 19c : PDB Not In Unicode (AL32UTF8) Character Set. PDB Character Set US7ASCII Error: While upgrading EBS Database to 19c PDB violations check (Log File : check_pdb_plugin_violations.out)  provides following message, PDB not in Unicode (AL32UTF8) character set. PDB character set US7ASCII Or when executing query getting below output select NAME,CAUSE,TYPE,ERROR_NUMBER,MESSAGE,STATUS,ACTION from PDB_PLUG_IN_VIOLATIONS; DB not Unicode WARNING              0 Character set mismatch: PDB character set US7ASCII. CDB character set AL32UTF8. RESOLVED Oracle recommends using Unicode (AL32UTF8) character set for the database. Consider migrating the database to Unicode. Solution: Check characterset of PDB (EBS Database) and create new CDB with same characterset select * from nls_database_parameters; CDB PARAMETER                      VALUE ------------------------------ ------------...