tag:blogger.com,1999:blog-19916919927036270062024-03-13T13:49:05.046+05:30Oracle Applications DBAhttps://www.linkedin.com/in/kirankumaraleKiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.comBlogger177125tag:blogger.com,1999:blog-1991691992703627006.post-85932975999879197472024-02-03T14:00:00.000+05:302024-02-03T14:00:03.019+05:30ECPUC<p> </p><h3 style="background-color: white; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 13.65px; padding-top: 0.5em;">ECPUC.sql</h3><div><br /></div><div><pre style="overflow-wrap: break-word; text-wrap: wrap;">E-Business Suite Critical Patch Update Checker (ECPUC)</pre><pre style="overflow-wrap: break-word; text-wrap: wrap;"><br /></pre><pre style="overflow-wrap: break-word; text-wrap: wrap;"><span style="background-color: #fbf9f8; color: #161513; font-family: OracleSansVF, OracleSansVFCyGr, -apple-system, BlinkMacSystemFont, "Segoe UI", "Helvetica Neue", sans-serif; font-size: 14.336px; white-space-collapse: collapse;">ECPUC is avaialble with </span><span class="kmContent" id="kmPgTpl:r1:ot71" style="-webkit-font-smoothing: antialiased; -webkit-tap-highlight-color: rgba(0, 0, 0, 0); background-color: #fbf9f8; background-repeat: no-repeat; box-sizing: border-box; font-family: OracleSansVF, OracleSansVFCyGr, -apple-system, BlinkMacSystemFont, "Segoe UI", "Helvetica Neue", sans-serif; font-size: small; list-style: none; margin: 0px; padding: 0px; white-space-collapse: collapse;"><a href="https://updates.oracle.com/download/35583866.html" style="-webkit-font-smoothing: antialiased; -webkit-tap-highlight-color: rgba(0, 0, 0, 0); background-repeat: no-repeat; box-sizing: border-box; color: #006b8f; list-style: none; margin: 0px; padding: 0px; text-decoration-line: none;" target="_blank">Patch 35583866</a></span></pre><pre style="overflow-wrap: break-word; text-wrap: wrap;"><br /></pre><pre style="overflow-wrap: break-word; text-wrap: wrap;">When run, ECPUC.sql generates the ECPUC_YYYY-MM-DD_HH24-MI.lst report for your environment which includes a list of required patches and security fixes available as of the latest quarterly Oracle E-Business Suite (EBS) Critical Patch Update (CPU)</pre><pre style="overflow-wrap: break-word; text-wrap: wrap;"><br /></pre><pre style="overflow-wrap: break-word; text-wrap: wrap;">Connect to the database as the APPS user.
For example: $ sqlplus APPS
Run ECPUC.sql while connected as APPS to the database.
For example: SQL> @ECPUC.sql</pre></div>Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-13059148615601582062024-01-09T19:57:00.002+05:302024-01-09T19:58:35.618+05:30Vulnerability Scanning Service<p><b> Title: Strengthening Cloud Security with Oracle's Vulnerability Scanning Service</b></p><p><br /></p><p><b>Introduction:</b></p><p><br /></p><p>In today's dynamic digital landscape, ensuring the security of your cloud infrastructure is paramount. Oracle Cloud Infrastructure's Vulnerability Scanning Service emerges as a powerful tool to fortify your defenses against potential threats. This service is specifically designed to assess and monitor the security of your cloud hosts, providing a robust solution to identify and eliminate vulnerabilities and open ports on various supported operating systems, including Oracle Linux, CentOS, Ubuntu, and Windows Server.</p><p><br /></p><p><b>Getting Started:</b></p><p><br /></p><p>To kickstart your journey towards a more secure cloud environment, you can create a Scan Recipe tailored to your specific requirements. This will enable you to seamlessly integrate the Vulnerability Scanning Service into your workflow, allowing for continuous monitoring and assessment of your hosts.</p><p><br /></p><p><b>Benefits and Features:</b></p><p><br /></p><p>The heart of this service lies in its agent plugin, which meticulously inspects the host's operating system. It goes beyond the surface by comparing installed components with several open-source vulnerability databases, ensuring a thorough analysis. Additionally, the plugin identifies open ports on the host and validates against industry-standard benchmarks defined by the Center for Internet Security (CIS), focusing on Linux authentication and access benchmarks. The service also scans public IP addresses to identify open ports, a critical step in fortifying the most vulnerable points of your infrastructure. All scan results are conveniently stored in the same region, allowing you to review them through detailed reports.</p><p><br /></p><p><b>Requirements:</b></p><p><br /></p><p>Before diving into host scanning, ensure that your administrator creates policies that grant the Vulnerability Scanning Service access to your host resources. These policies should also empower your administration group to effectively manage the scanning resources. Examples of such policies include permissions to manage instances, read compartments, and access VNICS and VNIC attachments.</p><p><br /></p><p><b>Example Service Policy:</b></p><p><br /></p><p>- Allow the service vulnerability-scanning-service to manage instances in tenancy.</p><p>- Allow the service vulnerability-scanning-service to read compartments in tenancy.</p><p>- Allow the service vulnerability-scanning-service to read VNICS in tenancy.</p><p>- Allow the service vulnerability-scanning-service to read VNIC attachments in tenancy.</p><p><br /></p><p><b>Example User Group Policy:</b></p><p><br /></p><p>- Allow the group SecurityAdmins to manage VSS-family in tenancy.</p><p><br /></p><p><b>Pricing:</b></p><p><br /></p><p>The best part? The Vulnerability Scanning Service is absolutely free for all paying customers. Oracle encourages users to leverage this service alongside other cloud security products to maximize their overall security posture.</p><p><br /></p><p>A typical list of hosts that have been scanned: </p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKOnvc1dmd3KFLuKifKDpO7R0kqSTVH1vPV3IAvHRutSabxwXYptOJ9dLt3Lb9NrOGsL24mJ7fWHqpRE82qhXWKA3hJFHWrL60b_IOWDcM4r2kFF-OZPaFS4eASswA2QySShiVdjndkqbM06hleEn2L9U5hLr8nU8jzDuZWTqSDEu0paOP5WcItzpd/s1109/12.PNG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="520" data-original-width="1109" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKOnvc1dmd3KFLuKifKDpO7R0kqSTVH1vPV3IAvHRutSabxwXYptOJ9dLt3Lb9NrOGsL24mJ7fWHqpRE82qhXWKA3hJFHWrL60b_IOWDcM4r2kFF-OZPaFS4eASswA2QySShiVdjndkqbM06hleEn2L9U5hLr8nU8jzDuZWTqSDEu0paOP5WcItzpd/s16000/12.PNG" /></a></div><br /><p>Detail Host scan results with the vulnerabilities listed:</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8IZ5Tbq_3nNYlgkHApfJMwNtG99Q_fskR226cvY-Ql6OCyMtlaOO9h6kvUYxZgLy4fP8QC2XpUalrG9p_Wg8TjJqtaROAd0uNdRPWQFZ456jp8bAXmuU7p8zCh4JtzyKvoHTurwJh4KIJvf4tiLGm9y1qvUp5khcu9gz6peT4T6h4FPwbdmwuSUyS/s1168/23.PNG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="731" data-original-width="1168" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8IZ5Tbq_3nNYlgkHApfJMwNtG99Q_fskR226cvY-Ql6OCyMtlaOO9h6kvUYxZgLy4fP8QC2XpUalrG9p_Wg8TjJqtaROAd0uNdRPWQFZ456jp8bAXmuU7p8zCh4JtzyKvoHTurwJh4KIJvf4tiLGm9y1qvUp5khcu9gz6peT4T6h4FPwbdmwuSUyS/s16000/23.PNG" /></a></div><br /><p><br /></p><p><br /><br /></p>Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-2929376493676596992024-01-09T19:21:00.004+05:302024-01-09T19:21:52.238+05:30Federating Microsoft Active Directory on Oracle Cloud Infrastructure<p>**Title: A Guide to Federating with Microsoft Active Directory on Oracle Cloud Infrastructure**</p><p><br /></p><p>Federating with Microsoft Active Directory (AD) through Microsoft Active Federation Services (AD FS) is a crucial step in integrating your organization's identity management with Oracle Cloud Infrastructure. This guide outlines the steps to achieve seamless federation.</p><p><br /></p><p><b>### About Federating with Microsoft Active Directory</b></p><p><br /></p><p>Your organization may have multiple Active Directory accounts, each possibly representing a division. While it's possible to federate multiple Active Directory accounts with Oracle Cloud Infrastructure, each federation trust should be established for a single Active Directory account.</p><p><br /></p><p>To initiate federation with Active Directory, a trust needs to be set up between Active Directory and Oracle Cloud Infrastructure. This involves steps in both the Oracle Cloud Infrastructure Console and Active Directory Federation Services.</p><p><br /></p><p><b>#### Step 1: Obtain Required Information from Active Directory Federation Services</b></p><p><br /></p><p>**Summary:** Retrieve the SAML metadata document and the names of Active Directory groups for mapping to Oracle Cloud Infrastructure Identity and Access Management (IAM) groups.</p><p><br /></p><p>1. Locate the SAML metadata document for your AD FS federation server:</p><p> - Default URL: `https://<yourservername>/FederationMetadata/2007-06/FederationMetadata.xml`</p><p> - Download and save this document for the next step.</p><p><br /></p><p>2. Note all Active Directory groups intended for mapping to Oracle Cloud Infrastructure IAM groups.</p><p><br /></p><p>#### Step 2: Add Active Directory as an Identity Provider in Oracle Cloud Infrastructure</p><p><br /></p><p>**Summary:** Add the identity provider to your tenancy. Optionally, set up group mappings.</p><p><br /></p><p>1. Sign in to the Oracle Cloud Infrastructure Console.</p><p><br /></p><p>2. Navigate to Identity & Security > Federation.</p><p><br /></p><p>3. Click "Add identity provider" and provide the required information:</p><p> - Display Name: A unique name for the federation trust.</p><p> - Description: A friendly description.</p><p> - Type: Select Microsoft Active Directory Federation Services (ADFS) or SAML 2.0 compliant identity provider.</p><p> - XML: Upload the FederationMetadata.xml file downloaded earlier.</p><p><br /></p><p> Click "Show Advanced Options" for additional settings like assertion encryption and force authentication.</p><p><br /></p><p>4. Click "Continue" and set up mappings between Active Directory groups and IAM groups.</p><p><br /></p><p> - Enter the Active Directory group name under Identity Provider Group.</p><p> - Choose the corresponding IAM group from the list under OCI Group.</p><p><br /></p><p> Click "Create" to finish.</p><p><br /></p><p><b>#### Step 3: Copy the URL for the Oracle Cloud Infrastructure Federation Metadata Document</b></p><p><br /></p><p>**Summary:** Obtain the URL for the Oracle Cloud Infrastructure Federation Metadata document.</p><p><br /></p><p>1. On the Federation page, click "Download this document."</p><p>2. Copy the URL provided, which looks similar to:</p><p> - `https://auth.r2.oracleiaas.com/v1/saml/ocid1.tenancy.oc1..aaaaaaaaqdt2tvdmhsa3jmvc5dzulgs3pcv6imfwfgdya4aq/metadata.xml`</p><p><br /></p><p><b>#### Step 4: In Active Directory Federation Services, Add Oracle Cloud Infrastructure as a Trusted Relying Party</b></p><p><br /></p><p>1. Open the AD FS Management Console and sign in.</p><p><br /></p><p>2. Add Oracle Cloud Infrastructure as a trusted relying party:</p><p> - Right-click AD FS > Add Relying Party Trust.</p><p> - Import data about the relying party using the Oracle Cloud Infrastructure Federation Metadata URL copied in Step 3.</p><p><br /></p><p> Follow the wizard to complete the setup.</p><p><br /></p><p><b>#### Step 5: Add Claim Rules for the Oracle Cloud Infrastructure Relying Party</b></p><p><br /></p><p>**Summary:** Add claim rules to include required elements in the SAML authentication response.</p><p><br /></p><p>1. Add the Name ID rule:</p><p> - Incoming claim type: Windows account name.</p><p> - Outgoing claim type: Name ID with Persistent Identifier format.</p><p> - Pass through all claim values.</p><p><br /></p><p> Click "Finish" and add the groups rule.</p><p><br /></p><p><b>#### Step 6: Set up IAM Policies for the Groups</b></p><p><br /></p><p>If not done earlier, configure IAM policies to control federated user access to Oracle Cloud Infrastructure resources. Refer to [Getting Started with Policies](#) for guidance.</p><p><br /></p><p><b>#### Step 7: Share Tenant Information with Federated Users</b></p><p><br /></p><p>Provide federated users with the Oracle Cloud Infrastructure Console URL (`https://cloud.oracle.com`) and your tenant's name. Users will need to input the tenant name when signing in.</p><p><br /></p><p>---</p><p><br /></p>Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-89906352550357505212024-01-09T16:55:00.003+05:302024-01-09T16:55:42.099+05:30Cloud Guard<p><b> Automatically identify and remediate security problems.</b></p><p><br /></p><p>Cloud Guard is a centralized infrastructure security console that enables IT security and risk management teams to monitor the aggregated security posture for applications, workloads and databases running on Oracle cloud.</p><p><br /></p><p><b>Features</b></p><p><br /></p><p>Detects misconfigured resources and identifies risky activities.</p><p>Delivers out-of-the-box recipes that apply security best practices with a few clicks.</p><p>Provides automated responders to trigger corrective actions.</p><p>Gives a global view of customer's overall security posture of their OCI tenancy, including security and risk scores and activity maps.</p><p><br /></p><p><b>Targets</b></p><p>Targets set the scope of resources to be examined. For OCI, compartments and their descendent structures are used.</p><p><br /></p><p><b>Detectors</b></p><p>Detectors are Cloud Guard components that identify issues with resources or user actions and alert when an issue is found.</p><p><br /></p><p><b>Problems</b></p><p>Problems are notifications that a configuration or activity is a potential security issue.</p><p><br /></p><p><b>Responders</b></p><p>Responders provide notifications and corrective actions to for security problems.</p><p><br /></p><p>Cloud Guard is not available for free Oracle Cloud Infrastructure tenancies. Before you attempt to enable Cloud Guard, ensure that:</p><p><br /></p><p>You have a paid tenancy.</p><p><br /></p><p>Your tenancy account type is one of these:</p><p>default_dbaas</p><p>enterprise_dbaas</p><p>enterprise</p>Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-16639077951773787992024-01-08T17:01:00.001+05:302024-01-08T17:29:22.370+05:30Oracle Database@Azure<p><b># Simplifying Oracle Database@Azure Integration: A Comprehensive Guide</b></p><p><br /></p><p>In the dynamic landscape of cloud computing, the collaboration between Oracle and Microsoft has paved the way for streamlined database management through Oracle Database@Azure. This innovative solution combines the power of Oracle Cloud Infrastructure (OCI) with Microsoft Azure, providing users with a seamless and efficient experience. In this article, we'll delve into the key features and step-by-step processes to implement Oracle Database@Azure, covering identity federation, provisioning an Exadata VM cluster, database creation, and Infrastructure as Code (IAC).</p><p><br /></p><p><b>### Identity Federation:</b></p><p><br /></p><p>- **Purpose:** Federating identities between Entra ID and OCI to reduce management overhead and allow users to access OCI accounts with Azure logins.</p><p> </p><p>- **Benefits:** Enforces consistent identity structure across both cloud providers.</p><p> </p><p>- **Prerequisites for Azure User:** Requires specific Entra ID privileges - External identity provider administrator, Groups administrator, User administrator.</p><p> </p><p><br /></p><p><b>### Groups and Roles:</b></p><p><br /></p><p>- **Azure Groups:** Includes infra-admins, VM cluster admins, etc., for administering Exadata database resources and VM clusters in Azure.</p><p> </p><p>- **Replication in OCI:** Groups with attached policies are replicated in OCI during federation.</p><p> </p><p>- **Azure Roles:** Include database owner, infra-admin, VM cluster admin, subscription manager, and database reader with standard permissions.</p><p> </p><p>- **OCI Groups and Policies:** Created to manage database actions.</p><p><br /></p><p><b>### Provisioning:</b></p><p><br /></p><p>- **Streamlined Process:** Provisioning Oracle Database@Azure resources involves a few simple steps in each portal (Azure and Oracle Cloud Console).</p><p> </p><p>- **Steps in Azure Portal:** Creating infrastructure, VM clusters, etc., involves specifying subscription, resource group, naming, region, availability zone, configuration customization, maintenance setup, consent, tagging, and final review/validation.</p><p><br /></p><p>- **Resource Deployment:** Resources can be deployed directly from the Azure portal by selecting Oracle Database@Azure from the Azure services.</p><p><br /></p><p>- **User Prerequisites:** Users must be part of the Exadata infrastructure administrators group in Azure and have sufficient limits assigned to the region.</p><p><br /></p><p>- **Infrastructure Creation Flow:** Involves steps like Basics (subscription, resource group, naming), Configuration (customization of servers and storage), Maintenance (setting maintenance details), Consent (agreeing to terms), Tags (naming infrastructure resource), and final Review and Create.</p><p><br /></p><p><br /></p><p><b>## Provisioning an Exadata VM Cluster:</b></p><p><b><br /></b></p><p><b>### Prerequisites:</b></p><p><br /></p><p>- Grant appropriate permissions for VM cluster admins and Oracle Database@Azure.</p><p>- Create a virtual network (vNet) with two delegated subnets for Oracle Database@Azure.</p><p><br /></p><p><b>### Required Permissions:</b></p><p><br /></p><p>- Microsoft.Network/virtualNetworks/*</p><p>- Microsoft.Network/virtualNetworks/subnets/*</p><p><br /></p><p><b>### Creation Process:</b></p><p><br /></p><p>1. On the Oracle Exadata VM Clusters tab, click the Create link.</p><p>2. Follow the multistep process, including Basics, Configuration, Networking, Diagnostics collection, Consent, Tags, and Review and create.</p><p><br /></p><p><b>## Database Creation and Management:</b></p><p><br /></p><p>Database creation, deletion, and management are facilitated in the Oracle Cloud Console, accessible through single sign-on in the Azure portal. Before proceeding, set up Identity Federation with trust between Azure Entra ID and OCI identity domains. Azure groups must be created and replicated in OCI.</p><p><br /></p><p><b>### Creating a Database:</b></p><p><br /></p><p>1. Access the Oracle Cloud Console through the Azure portal.</p><p>2. Use Console or Database APIs to create database homes, container databases, and pluggable databases.</p><p>3. Provide necessary information such as name, database service version (e.g., 19c), admin credentials, backup configuration, etc.</p><p>4. Complete the process, and your new database progresses from "Provisioning" to "Available."</p><p><br /></p><p><b>## Infrastructure as Code (IAC):</b></p><p><br /></p><p>Oracle Database@Azure supports both GUI and CLI operations through PowerShell in Azure and Terraform in OCI. PowerShell is applicable for resources within Azure, while Terraform can be used natively in OCI Resource Manager or as a standalone application for operations in both Azure and OCI.</p><p><br /></p><p><b>## Management Responsibilities:</b></p><p><br /></p><p>The management responsibilities for Oracle Database@Azure are shared between Oracle, Microsoft, and the customer. </p><p><b>Oracle </b>takes care of Exadata hardware, host infrastructure, and the Oracle Database@Azure API endpoint, while <b>Azure</b> handles the physical network, SDN, and application infrastructure. Data residency and support are shared responsibilities, and customers play a role in certain service components as outlined in the Azure portal and Oracle Cloud Console.</p><p><br /></p><p>Implementing Oracle Database@Azure empowers organizations with a powerful, collaborative solution that harnesses the strengths of both Oracle and Microsoft. By following these comprehensive steps, users can seamlessly integrate and manage their databases, fostering efficiency and innovation in their cloud journey. </p>Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-80084161371354714352024-01-08T16:07:00.000+05:302024-01-08T17:29:54.560+05:30Oracle Database Security Assessment Tool (DBSAT) 3.0<p> **Oracle DBSAT 3.0 Unveiled: Strengthening Your Database Security Posture**</p><p><br /></p><p>**1. Oracle Best Practice Findings:**</p><p> - DBSAT 3.0 brings a more nuanced approach to security by clearly identifying findings aligned with Oracle best practices (OBP). This distinction ensures that users not only adhere to conventional security frameworks but also follow recommended configurations specific to Oracle databases.</p><p><br /></p><p>**2. Expanded Security Checks:**</p><p> - The release incorporates a range of new security checks, including support for Oracle Database 23c SQL Firewall. Addressing auditing-related issues, transparent sensitive data protection, and numerous other checks, DBSAT 3.0 provides a more exhaustive examination of database security.</p><p><br /></p><p>**3. Updated DISA STIG Support:**</p><p> - In alignment with the latest US Department of Defense Information Systems Agency (DISA) Security Technical Implementation Guide (STIG) version V2R8, DBSAT 3.0 ensures that users have the latest guidance and best practices for securing their Oracle databases.</p><p><br /></p><p>**4. Desupport Notices for Proactive Measures:**</p><p> - DBSAT 3.0 assists organizations in proactive risk management by listing desupport notices. This feature helps identify database features and parameters that are approaching or have reached end-of-life, enabling users to take timely measures.</p><p><br /></p><p>**5. Enhanced Remarks and Recommendations:**</p><p> - To facilitate more effective risk mitigation, the remarks and recommendations provided by DBSAT have been updated in version 3.0. These updates aim to make the information clearer and more actionable, aiding users in addressing security issues promptly.</p><p><br /></p><p>**6. DBSAT Discoverer Enhancements:**</p><p> - Reflecting a commitment to global standards, DBSAT Discoverer now includes support for India permanent account number (PAN) and the unique identification (Aadhaar) number, ensuring that users can align their security practices with regional regulatory requirements.</p><p><br /></p><p>**7. Integration with Oracle Solutions:**</p><p> - DBSAT remains a pivotal component in Oracle's security ecosystem, powering various solutions, including Oracle Data Safe Security Assessment, Oracle Audit Vault and Database Firewall, and more. This integration underscores the tool's versatility and centrality in ensuring comprehensive database security.</p><p><br /></p><p><br /></p><p>In essence, Oracle DBSAT 3.0 is not merely an update but a strategic move towards fortifying Oracle database security. Its incorporation of best practices, extended security checks, and support for global standards make it a valuable tool for organizations aiming to enhance their database security posture. Embrace the latest features and stay one step ahead in the ever-evolving landscape of database security.</p><p><br /></p><p>Oracle Database Security Assessment Tool (DBSAT) (Doc ID 2138254.1)<span style="white-space: pre;"> </span></p>Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-51573400942406716812024-01-08T15:33:00.001+05:302024-01-08T17:30:12.581+05:30Oracle Data Safe - Cloud service<p> Oracle Data Safe is a comprehensive database security control center designed to protect sensitive and regulated data in Oracle databases. The key features of Oracle Data Safe include:</p><p><br /></p><p>1. **Security Assessment:**</p><p> - Analyzes database configurations, user accounts, and security controls.</p><p> - Provides findings and recommendations for remediation activities based on best practices, Security Technical Implementation Guides (STIG), and Center for Internet Security (CIS) Configurations.</p><p><br /></p><p>2. **User Assessment:**</p><p> - Identifies highly privileged accounts that may pose a threat if misused or compromised.</p><p> - Reviews user information in the data dictionary, calculating a potential risk score for each user.</p><p> - Evaluates user types, authentication methods, password policies, and password change intervals.</p><p> - Provides links to audit records related to each user.</p><p><br /></p><p>3. **Data Discovery:**</p><p> - Helps find sensitive data within databases.</p><p> - Allows customization for searching specific types of sensitive data.</p><p> - Scans actual data in the database and its data dictionary, providing a list of sensitive columns.</p><p> - Default searches include identification, biographic, IT, financial, healthcare, employment, and academic information.</p><p><br /></p><p>4. **Data Masking:**</p><p> - Enables the masking of sensitive data for non-production purposes.</p><p> - Useful for creating copies of production data for development and testing without exposing sensitive information.</p><p> - Replaces sensitive data with realistic but fictitious data.</p><p><br /></p><p>5. **Activity Auditing:**</p><p> - Monitors and audits user activity on databases.</p><p> - Helps organizations track and review database usage.</p><p><br /></p><p>6. **Alerts:**</p><p> - Informs users of unusual database activities in real-time.</p><p> - Enables proactive response to potential security incidents.</p><p><br /></p><p>7. **SQL Firewall:**</p><p> - Protects against risks such as SQL injection attacks and compromised accounts.</p><p> - Built into the Oracle Database 23c kernel.</p><p> - Allows centralized management and monitoring of SQL Firewall policies for target databases.</p><p> - Collects authorized SQL activities, generates and enables policies with allowlists of approved SQL statements and database connection paths.</p><p> - Provides a comprehensive view of SQL Firewall violations across the fleet of target databases.</p><p><br /></p><p>These features collectively offer a robust and centralized solution for managing the security of Oracle databases, helping organizations comply with regulations and secure sensitive information effectively.</p>Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-36101520558817194822021-11-15T16:18:00.010+05:302021-11-15T16:25:43.228+05:30EBS_SYSTEM Schema, AD-TXK DELTA13 and 12.2.11<p> </p><div class="separator" style="clear: both; text-align: center;"><br /></div><p></p><table border="0" cellpadding="0" cellspacing="0" id="kmPgTpl:r1:0:tl5" style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 11px; width: 100%px;" summary=""><tbody><tr id="kmPgTpl:r1:0:rl12"><td align="left" id="kmPgTpl:r1:0:cf49"><span class="xq" id="kmPgTpl:r1:0:ol22" style="color: black; font-size: 14.3px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Oracle E-Business Suite Release 12.2 System Schema Migration (Doc ID 2755875.1)<br /></label></span></td></tr></tbody></table><div class="separator" style="clear: both; text-align: center;"></div><p></p><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><strong style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small; text-align: left;">Requirements:</strong></div><div class="separator" style="clear: both; text-align: center;"><strong style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small; text-align: left;"> </strong></div><div class="separator" style="clear: both; text-align: center;"><strong style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small; text-align: left;">AD Delta 13 (or later) and TXK Delta 13 (or later)</strong><span face="Tahoma, Verdana, Helvetica, sans-serif" style="background-color: white; font-size: small; text-align: left;"> </span></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><strong style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small; text-align: left;">EBS 12.2.11 RUP, or EBS Release 12.2.3-12.2.10 and EBS System Schema Migration Consolidated Patch</strong></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnwwRv2cNA58ehiA1ewsYpkfGxkga_4XqFLn3qWs2vz1KS1dygafxjLzYfy6xZuel4KIm-TMeHXc7Y92zpAci_p3N3tyZ6Jxn0cIj2Vh-vh5EymrVo3bUOjh6-e7GnxuntS3lOk9gXkA/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="556" data-original-width="1059" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnwwRv2cNA58ehiA1ewsYpkfGxkga_4XqFLn3qWs2vz1KS1dygafxjLzYfy6xZuel4KIm-TMeHXc7Y92zpAci_p3N3tyZ6Jxn0cIj2Vh-vh5EymrVo3bUOjh6-e7GnxuntS3lOk9gXkA/s16000/image.png" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuyzs2wZ-2Kaecm40tab_xSUhihzMzrbNMEILm6knM4VKIZYD5tlzhrrPaX45RZ3LPs-zsI5ygTWYEMKDwNlFqjKRv3zefde6Bb7ndR32MXWv23-NUmK_Z8gZGqCIDiBGLsCdHT86b2w/s1049/Screenshot+2021-11-15+162345.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="444" data-original-width="1049" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuyzs2wZ-2Kaecm40tab_xSUhihzMzrbNMEILm6knM4VKIZYD5tlzhrrPaX45RZ3LPs-zsI5ygTWYEMKDwNlFqjKRv3zefde6Bb7ndR32MXWv23-NUmK_Z8gZGqCIDiBGLsCdHT86b2w/s16000/Screenshot+2021-11-15+162345.jpg" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><br /><div class="separator" style="clear: both; text-align: center;"><img alt="" border="0" class="placeholder" id="0e7d6ecd91bfd" src="https://www.blogger.com/img/transparent.gif" style="background-color: #d8d8d8; background-image: url('https://fonts.gstatic.com/s/i/materialiconsextended/insert_photo/v6/grey600-24dp/1x/baseline_insert_photo_grey600_24dp.png'); background-position: center; background-repeat: no-repeat; opacity: 0.6;" /></div><br /><br /></div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><br /><br /></div><br /><br /></div><br /><br /></div><br /><p></p>Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-2038302588836168022021-02-24T10:27:00.002+05:302021-02-24T10:27:34.998+05:30DB Switchover to Standby - DGMGRL<p> <b>prod-ebs-db10</b></p><p><br /></p><p>dgmgrl</p><p>edit database 'PROD' set state = 'TRANSPORT-OFF';</p><p>edit database 'PRODS' set state = 'APPLY-OFF';</p><p><br /></p><p><b>On standby database:</b></p><p>CREATE RESTORE POINT DG1 GUARANTEE FLASHBACK DATABASE;</p><p><br /></p><p><b>On primary database:</b></p><p>CREATE RESTORE POINT DG1 GUARANTEE FLASHBACK DATABASE;</p><p><br /></p><p><b>dgmgrl</b></p><p>edit database 'PROD' set state = 'TRANSPORT-ON';</p><p>edit database 'PRODS' set state = 'APPLY-ON';</p><p><br /></p><p><b>DB Switchover Steps to DR - STDBY</b></p><p><br /></p><p>PROD:oracle@prod-ebs-db10:~> </p><p>srvctl stop database -d PROD</p><p><br /></p><p>PROD:oracle@stdby-ebs-db01:~></p><p>srvctl stop database -d PRODS</p><p><br /></p><p><b>Switchover the database </b></p><p><br /></p><p>PROD:oracle@prod-ebs-db10:~> srvctl start instance -d PROD -i PROD1</p><p>PROD:oracle@prod-ebs-db10:~> srvctl status database -d PROD</p><p><br /></p><p>PROD:oracle@stdby-ebs-db01:~> srvctl start instance -d PRODS -i PROD1</p><p>PROD:oracle@stdby-ebs-db01:~> srvctl status database -d PRODS</p><p><br /></p><p>PROD:oracle@stdby-ebs-db01:~>dgmgrl /</p><p>DGMGRL> show configuration</p><p>PROD:oracle@prod-ebs-db10:~>dgmgrl /</p><p>PROD:oracle@prod-ebs-db10:~>DGMGRL> show configuration</p><p>PROD:oracle@prod-ebs-db10:~>DGMGRL> validate database 'PROD';</p><p><br /></p><p>PROD:oracle@stdby-ebs-db01:->DGMGRL> validate database 'PRODS'</p><p><br /></p><p>PROD:oracle@prod-ebs-db10:~>DGMGRL> connect sys@PROD</p><p>PROD:oracle@prod-ebs-db10:~>DGMGRL> validate database 'PROD'</p><p>PROD:oracle@prod-ebs-db10:~>DGMGRL> switchover to 'PRODS'</p><p><br /></p><p>PROD:oracle@prod-ebs-db10:~> srvctl status database -d PROD</p><p><br /></p><p>PROD:oracle@prod-ebs-db10:~>sqlplus / as sysdba</p><p>set pages 1000</p><p>SELECT</p><p> name,</p><p> db_unique_name,</p><p> open_mode,</p><p> database_role,</p><p> switchover#</p><p>FROM</p><p> v$database;</p><p><span style="white-space: pre;"> </span></p><p>PROD:oracle@prod-ebs-db10:~></p><p>srvctl config database -d PROD</p><p><br /></p><p>PROD:oracle@stdby-ebs-db01:~></p><p>srvctl config database -d PRODS</p><p><br /></p><p>PILLAR1:oracle@stdby-ebs-db01:~></p><p>srvctl status service -d PRODS</p><p><br /></p><p><b>stdby-ebs-db01</b></p><p><br /></p><p>srvctl add service -d PRODS -s APPS_SRVC -r PROD1 -a PROD2 -e SELECT -m BASIC -q TRUE -w 5 -z 180 -P BASIC</p><p>srvctl add service -d PRODS -s PROD_SRVC -r PROD1 -a PROD2 -e SELECT -m BASIC -q TRUE -w 5 -z 180 -P BASIC</p><p><br /></p><p><b>Configure DB and Apps after Switchover</b></p>Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com1tag:blogger.com,1999:blog-1991691992703627006.post-14925021081246154532021-02-22T21:02:00.001+05:302021-02-22T21:02:18.468+05:30UTL_FILE_DIR issue in 19c<p> Concurrent requests/reports fails with below error after DB is upgraded to 19c.</p><p><br /></p><p>Cause: FDPSTP failed due to ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.</p><p>Directory &FILE_DIR is invalid, contact your system administrator.</p><p><br /></p><p>Action: Check that the directory is a valid directory with wri</p><p><br /></p><p>Fix:</p><p>======</p><p>Create the first directory that was existing in utl_file_dir parameter in 12c before the DB upgrade.</p><p><b>1) Connect to the PDB.</b></p><p>alter session set container=TST;</p><p><br /></p><p><b>2) Create the directory</b></p><p>CREATE OR REPLACE DIRECTORY APPLPTMP AS '/u01/TEST/applptmp';</p><p><br /></p><p><b>3) Run autoconfig on DB and APPS:</b></p><p><br /></p><p>cd $ORACLE_HOME/appsutil/bin/</p><p>0/dbhome_1/appsutil/TEST_xxxx-365-db02.xml \LE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/u01/app/oracle/product/19.3.0.</p><p>> -oraclehome=/u01/app/oracle/product/12.1.0 -outdir=/u01/app/oracle/product/19.3.0.0/dbhome_1/appsutil/log \</p><p>> -upgradedhome=/u01/app/oracle/product/19.3.0.0/dbhome_1 -mode=getUtlFileDir -servicetype=onpremise</p><p>Enter the APPS Password:</p><p><br /></p><p>Script Name : txkCfgUtlfileDir.pl</p><p>Script Version : 120.0.12020000.11</p><p>Started : xxxxxx xxxx xxxx xxxxx</p><p><br /></p><p>Log File : /u01/app/oracle/product/19.3.0.0/dbhome_1/appsutil/log/TXK_UTIL_DIR_Tue_xx_xx_xx_xx_1/txkCfgUtlfileDir.log</p><p><br /></p><p>Context file: /u01/app/oracle/product/19.3.0.0/dbhome_1/appsutil/TEST_xxxx-365-db02.xml exists.</p><p><br /></p><p>==============================================================================</p><p>Successfully generated the below file with UTL_FILE_DIR content:</p><p>/u01/app/oracle/product/19.3.0.0/dbhome_1/dbs/TEST_utlfiledir.txt</p><p><br /></p><p>==============================================================================</p><p>Completed : Tue JXXX xx xx:00</p><p><br /></p><p><br /></p><p>Successfully Completed the script</p><p>ERRORCODE = 0 ERRORCODE_END</p><p>[TEST|orateb1@xxx-365-db02 bin]$ vi /u01/app/oracle/product/19.3.0.0/dbhome_1/dbs/TST_utlfiledir.txt</p><div><br /></div>Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com1tag:blogger.com,1999:blog-1991691992703627006.post-43924256925501902282021-02-22T13:41:00.002+05:302021-02-22T13:52:24.043+05:30OCI - Mobile APP<div class="separator" style="clear: both; text-align: center;"><br /></div><h1 style="clear: both; text-align: center;">OCI Mobile APP</h1><div class="separator" style="clear: both; text-align: center;"><br /></div><h4 style="clear: both; text-align: center;"><p style="text-align: left;">Using the mobile APP for OCI, below tasks can be performed.<br /><br />Check for the resources by each compartment. <br />Monitor resource health, properties,metrics.<br />Check CPU, Memory and I/O usage.<br />View Alarms, Billing Information.<br />Check Service limits , Quotas, Usage.</p></h4><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhC1oml1_SflTqUsq_Idu1V1RKXJHSpULinTOX3HKtNJUQBHc42_Q1LKIX7-dXQ0zGl0E9n1Mkq9DdGwBsMOfCzy3E69SXtH9M-H1bgqeV_aluOQdERBZ54rFjomdDXjH_uTrGiGqH5RQ/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="711" data-original-width="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhC1oml1_SflTqUsq_Idu1V1RKXJHSpULinTOX3HKtNJUQBHc42_Q1LKIX7-dXQ0zGl0E9n1Mkq9DdGwBsMOfCzy3E69SXtH9M-H1bgqeV_aluOQdERBZ54rFjomdDXjH_uTrGiGqH5RQ/s16000/image.png" /></a></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZPr2X92Ek6aCrKxbMK1vmvMxCMKAvfN23WkjC9IGPlEI2fFuP7HbatpVsvrMNi4kiwHaxknXvu72fLlkWOYHXXz7_sLZqahfzEFJcaSDwFLB8MoxzTU1t2jioWx3RLjS0GlmGZZRw9Q/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="548" data-original-width="445" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZPr2X92Ek6aCrKxbMK1vmvMxCMKAvfN23WkjC9IGPlEI2fFuP7HbatpVsvrMNi4kiwHaxknXvu72fLlkWOYHXXz7_sLZqahfzEFJcaSDwFLB8MoxzTU1t2jioWx3RLjS0GlmGZZRw9Q/s16000/image.png" /></a></div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEboDZtJWVB4EZzZejDa64zwVF9sYs6g9H2YGuNEepw-1hNYg_JKM21yl-EN7RgAZQ1J2N0uXwHwS7i0CKd7-awiH4HJue_5UBFp7vo_9jWMcvJnADq9VZ0eAb9LdIqTuGgqJRCOTT-w/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="395" data-original-width="422" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEboDZtJWVB4EZzZejDa64zwVF9sYs6g9H2YGuNEepw-1hNYg_JKM21yl-EN7RgAZQ1J2N0uXwHwS7i0CKd7-awiH4HJue_5UBFp7vo_9jWMcvJnADq9VZ0eAb9LdIqTuGgqJRCOTT-w/s16000/image.png" /></a></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8tKR2q21UuRWw5_RLKnMQnAZ5p6LkBr0cAhFT6JYEAROFZIwU5OTu4rAnt5jaGmzXBRja6XBmUbXCEQI5cYREnEAtaWAp9KvTuhj88RgIikcsM2o3bL7bZAthhyphenhyphenGBttic7rWiARuWTQ/s556/12.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="556" data-original-width="398" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8tKR2q21UuRWw5_RLKnMQnAZ5p6LkBr0cAhFT6JYEAROFZIwU5OTu4rAnt5jaGmzXBRja6XBmUbXCEQI5cYREnEAtaWAp9KvTuhj88RgIikcsM2o3bL7bZAthhyphenhyphenGBttic7rWiARuWTQ/s16000/12.jpg" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnBpvdvjDm5QdVeix-_27jQS7A8no6TRCsOjIXZt4r2aOZ9_mPlkQbK8oZ0fklh5ai0Iio_i5qLTBiMwCp09r5i7_vfS0DAEaZuQdEp-lfSpx72tkMJl_XATLrhSutYKmvjzFvCmIDbg/s489/23.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="489" data-original-width="397" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnBpvdvjDm5QdVeix-_27jQS7A8no6TRCsOjIXZt4r2aOZ9_mPlkQbK8oZ0fklh5ai0Iio_i5qLTBiMwCp09r5i7_vfS0DAEaZuQdEp-lfSpx72tkMJl_XATLrhSutYKmvjzFvCmIDbg/s16000/23.jpg" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKXrWkI_nVYeexB6hiB7C7myLe0xQrfRtAGLdxOmA09xAa8YMCI3NlRWqos2JfG1AzhYcZCTzYE_h8dB7CeFiGCW7p5uT2X3cr68fcc89peTsCWHojssGE3WlwFgXaAPZSk0KIhsKNRQ/s411/34.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="411" data-original-width="402" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKXrWkI_nVYeexB6hiB7C7myLe0xQrfRtAGLdxOmA09xAa8YMCI3NlRWqos2JfG1AzhYcZCTzYE_h8dB7CeFiGCW7p5uT2X3cr68fcc89peTsCWHojssGE3WlwFgXaAPZSk0KIhsKNRQ/s16000/34.jpg" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><img alt="" border="0" class="placeholder" id="503b3661042e3" src="https://www.blogger.com/img/transparent.gif" style="background-color: #d8d8d8; background-image: url('https://fonts.gstatic.com/s/i/materialiconsextended/insert_photo/v6/grey600-24dp/1x/baseline_insert_photo_grey600_24dp.png'); background-position: center; background-repeat: no-repeat; opacity: 0.6;" /></div></div></div></div><div class="separator" style="clear: both; text-align: center;"><img alt="" border="0" class="placeholder" id="67e73d64a227e" src="https://www.blogger.com/img/transparent.gif" style="background-color: #d8d8d8; background-image: url('https://fonts.gstatic.com/s/i/materialiconsextended/insert_photo/v6/grey600-24dp/1x/baseline_insert_photo_grey600_24dp.png'); background-position: center; background-repeat: no-repeat; opacity: 0.6;" /></div><br /><br />Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-1758201906803382532021-02-18T19:06:00.003+05:302021-02-18T19:06:20.010+05:30ADOP - File System Synchronization Options - 12.2.10<p> </p><p><br /></p><p>ADOP - File System Synchronization Options</p><p><br /></p><p><b>On R12.AD.C.Delta.12 and R12.TXK.C.Delta.12, or on EBS 12.2.10,</b></p><p>We have below options for Prepare and Fs_clone respectively.</p><p><br /></p><p><b>prepare_sync_mode </b>— Valid for prepare phase. </p><p>Can have a value of either or <b>delta or patch</b>. The default is patch.</p><p>Specifying delta uses the file system synchronization command specified in the $APPL_TOP_NE/ad/admin/delta_sync_drv.txt file.</p><p>Specifying patch reapplies all the patches that were applied to the run file system.</p><p><br /></p><p><b>fs_clone_sync_mode</b> — Valid for prepare and fs_clone phases. </p><p>Can have a value of either <b>cp or delta</b>. The default is cp.</p><p>Specifying cp creates the complete patch file system from the run file system.</p><p>Specifying delta uses the file system synchronization command specified in the $APPL_TOP_NE/ad/admin/delta_sync_drv.txt file.</p>Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-59483928668249387252021-01-13T18:31:00.007+05:302021-01-15T15:09:41.690+05:30Install, Configure and Integrate OID 12c and OAM 12c with EBS 12.2<p style="text-align: left;"></p><h1 style="font-variant-caps: normal; font-variant-ligatures: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="font-size: 32px;">Install, Configure and Integrate OID 12c and OAM 12c with EBS 12.2</span></h1><div style="font-variant-caps: normal; font-variant-ligatures: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="font-size: 32px;"><br /></span><b><span face=""Verdana","sans-serif"" lang="EN" style="background: white; color: #222222; line-height: 115%; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana; mso-highlight: white;">References:</span></b></div><div style="font-variant-caps: normal; font-variant-ligatures: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><b><span face=""Verdana","sans-serif"" lang="EN" style="background: white; color: #222222; font-size: 11.5pt; line-height: 115%; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana; mso-highlight: white;"><br /></span></b><span lang="EN">Integrating Oracle E-Business Suite
Release 12.2 with Oracle Internet Directory 12c (12.2.1.3.0) (Doc ID 2339362.1)<br /></span><span lang="EN">Integrating Oracle E-Business Suite
Release 12.2 with Oracle Access Manager 12c (12.2.1.3.0)<br /> </span><span lang="EN">using Oracle E-Business Suite AccessGate
(Doc ID 2339348.1)<br /></span><span lang="EN">Overview of Single Sign-On Integration
Options for Oracle E-Business Suite (MOS Note 1388152.1)<br /></span><span lang="EN">Example to Install and Configure Oracle
Directory Integration Platform (DIP) 12.2.1.3 Separate From Oracle Internet
Directory (OID) 12.2.1.3 (Doc ID 2306423.1)</span></div><div style="font-variant-caps: normal; font-variant-ligatures: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span lang="EN"><br /></span><h4 style="text-align: left;"><span style="color: black; font-size: 24pt;">Install OID</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Install FMW Infrastructure for
OID</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">[debssso@dev-ebs-sso01 ~]$ cd
/stage/soft/<br /></span><span style="color: black;">$ /devsso/jdk/bin/java -jar
fmw_12.2.1.3.0_infrastructure.jar <br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Install OID 12c Software</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">[debssso@dev-ebs-sso01 soft]$
./fmw_12.2.1.3.0_oid_linux64.bin<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Apply patch for RCU Error:</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">[debssso@dev-ebs-sso01 ~]$ cd
/stage/soft/29691671<br /></span><span style="color: black;">[debssso@dev-ebs-sso01
29691671]$ export ORACLE_HOME=/devsso/app/oracle/oim<br /></span><span style="color: black;">[debssso@dev-ebs-sso01
29691671]$ export PATH=$ORACLE_HOME/OPatch:$PATH<br /></span><span style="color: black;">[debssso@dev-ebs-sso01
29691671]$ opatch apply<br /></span><span style="color: black;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Run RCU for OID</span></h4><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">[debssso@dev-ebs-sso01 soft]$
cd /devsso/app/oracle/oim/oracle_common/bin/<br /></span><span style="color: black;">[debssso@dev-ebs-sso01 bin]$
./rcu<br /></span><span style="color: black;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Run config.sh for OID</span></h4><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">[debssso@dev-ebs-sso01 bin]$ cd
../common/bin/<br /></span><span style="color: black;">[debssso@dev-ebs-sso01 bin]$
./config.sh<br /></span><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">Choose OID (Collocated) and DIP<br /></span><span style="color: black;">Listen Address:
dev-ebs-sso01.us.corp.example2qa.com<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h3 style="text-align: left;"><span style="color: black; font-size: 24pt;">Install OAM</span></h3><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Install FMW Infrastructure for
OAM</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">[debssso@dev-ebs-sso01 bin]$ cd
/stage/soft/<br /></span><span style="color: black;">[debssso@dev-ebs-sso01 soft]$
/devsso/jdk1.8.0_251/bin/java -jar fmw_12.2.1.3.0_infrastructure.jar</span></div><div style="font-variant-caps: normal; font-variant-ligatures: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="color: black;"><br /></span><h4 style="text-align: left;"><span style="color: black; font-size: large;">Install OAM 12c Software</span></h4></div><div style="font-variant-caps: normal; font-variant-ligatures: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="color: black;"><br /></span><span style="color: black;">[debssso@dev-ebs-sso01 soft]$
/devsso/jdk1.8.0_251/bin/java -jar fmw_12.2.1.3.0_idm.jar<br /></span><span style="color: black;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Run RCU for OAM</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">[debssso@dev-ebs-sso01 soft]$
cd /devsso/app/oracle/oam/oracle_common/bin/<br /></span><span style="color: black;">[debssso@dev-ebs-sso01 bin]$
./rcu<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Run config.sh for OAM</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">cd
/devsso/app/oracle/oam/oracle_common/common/bin<br /></span><span style="color: black;">./config.sh<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">On EBSQ1 Instance, Install
Webgate</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">txkrun.pl -script=SetOAMReg
-installWebgate=yes -webgatestagedir=/finapp/EBSQ1/OAM_Webgate<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Apply OAM Webgate Bundle Patch
29309637</span></h4><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">[EBSQ1@qa-ebs-app01 ~]$ which
curl<br /></span><span style="color: black;">/usr/bin/curl<br /></span><span style="color: black;">[EBSQ1@qa-ebs-app01 ~]$ ls -trl
/usr/bin/curl<br /></span><span style="color: black;">-rwxr-xr-x. 1 root root 156672
Apr 2 19:02 /usr/bin/curl<br /></span><span style="color: black;">[EBSQ1@qa-ebs-app01 ~]$ ldd
/usr/bin/curl<br /></span><span style="color: black;">[EBSQ1@qa-ebs-app01 ~]$ ls -ltr
/usr/lib64/libcurl.so.4*<br /></span><span style="color: black;">-rwxr-xr-x. 1 root root 439344
Apr 2 19:02 /usr/lib64/libcurl.so.4.3.0<br /></span><span style="color: black;">lrwxrwxrwx. 1 root root
16 May 11 07:34 /usr/lib64/libcurl.so.4 -> libcurl.so.4.3.0<br /></span><span style="color: black;">[root@qa-ebs-app01 ~]# cd
/usr/lib64<br /></span><span style="color: black;">[root@qa-ebs-app01
lib64]# ln -s /usr/lib64/libcurl.so.4.3.0 libcurl.so<br /></span><span style="color: black;">[root@qa-ebs-app01 lib64]# ls
-trl /usr/lib64/libcurl.so<br /></span><span style="color: black;">lrwxrwxrwx. 1 root root 27 Jul
13 08:54 libcurl.so -> /usr/lib64/libcurl.so.4.3.0<br /></span><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">[EBSQ1@qa-ebs-app01
ContentsXML]$ cd $FMW_HOME/<br /></span><span style="color: black;">[EBSQ1@qa-ebs-app01 FMW_Home]$
export ORACLE_HOME=/finapp/EBSQ1/fs1/FMW_Home/Oracle_OAMWebGate1<br /></span><span style="color: black;">[EBSQ1@qa-ebs-app01 FMW_Home]$
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH<br /></span><span style="color: black;">[EBSQ1@qa-ebs-app01 FMW_Home]$
cd /finapp/EBSQ1/OAM_Webgate/<br /></span><span style="color: black;">[EBSQ1@qa-ebs-app01
OAM_Webgate]$ cd 29309637/<br /></span><span style="color: black;">[EBSQ1@qa-ebs-app01 29309637]$
opatch apply -jdk $COMMON_TOP/util/jdk64<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">On EBSQ1 Instance, Deploy
Access Gate</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">[EBSQ1@qa-ebs-app01 ~]$ perl
$AD_TOP/patch/115/bin/adProvisionEBS.pl ebs-create-oaea_resources
-contextfile=$CONTEXT_FILE -deployApps=accessgate
-SSOServerURL=http://dev-ebs-sso01.us.corp.example2qa.com:7021
-managedsrvname=oaea_server1 -managedsrvport=6801
-logfile=OAEA_Server_deploy.log<br /></span><span style="color: black;">Enter the APPS Schema password:<br /></span><span style="color: black;">Enter the WebLogic AdminServer
password:<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Add MS to Config files</span></h4><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">$ perl
$FND_TOP/patch/115/bin/txkSetAppsConf.pl \<br /></span><span style="color: black;">-contextfile=$CONTEXT_FILE \<br /></span><span style="color: black;">-configoption=addMS \<br /></span><span style="color: black;">-accessgate=qa-ebs-app01.us.corp.example2qa.com:6801<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Register OID with EBS</span></h4><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">[EBSQ1@qa-ebs-app01 ~]$
$FND_TOP/bin/txkrun.pl -script=SetSSOReg
-registeroid=yes
-ldaphost=dev-ebs-sso01.us.corp.example2qa.com
-ldapport=9055 -oidadminuser=cn=orcladmin
-oidadminuserpass=devsso2020 -appspass=fvcey3xnab
-instpass=fvcey3xnab -appname=EBSQ1
-svcname=EBSQ1 -provisiontype=4
-dbldapauthlevel=0<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Update Profiles</span></h4><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">SQL> set serveroutput on<br /></span><span style="color: black;">DECLARE<br /></span><span style="color: black;">stat BOOLEAN;<br /></span><span style="color: black;">BEGIN<br /></span><span style="color: black;">stat :=
FND_PROFILE.SAVE('APPS_SSO_OID_IDENTITY','Y','SITE');<br /></span><span style="color: black;">IF stat THEN<br /></span><span style="color: black;">dbms_output.put_line( 'Profile
APPS_SSO_OID_IDENTITY updated with Enabled ' );<br /></span><span style="color: black;">commit;<br /></span><span style="color: black;">ELSE<br /></span><span style="color: black;">dbms_output.put_line( 'Profile
APPS_SSO_OID_IDENTITY could NOT be updated with Enabled' );<br /></span><span style="color: black;">rollback;<br /></span><span style="color: black;">END IF;<br /></span><span style="color: black;">END;<br /></span><span style="color: black;">/<br /></span><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">SQL> set serveroutput on<br /></span><span style="color: black;">DECLARE<br /></span><span style="color: black;">stat BOOLEAN;<br /></span><span style="color: black;">BEGIN<br /></span><span style="color: black;">stat := FND_PROFILE.SAVE('APPS_SSO_LINK_SAME_NAMES','Y','SITE');<br /></span><span style="color: black;">IF stat THEN<br /></span><span style="color: black;">dbms_output.put_line( 'Profile
APPS_SSO_LINK_SAME_NAMES updated with Enabled' );<br /></span><span style="color: black;">commit;<br /></span><span style="color: black;">ELSE<br /></span><span style="color: black;">dbms_output.put_line( 'Profile
APPS_SSO_LINK_SAME_NAMES could NOT be updated with Enabled' );<br /></span><span style="color: black;">rollback;<br /></span><span style="color: black;">END IF;<br /></span><span style="color: black;">END;<br /></span><span style="color: black;">/<br /></span><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">SQL> set serveroutput on<br /></span><span style="color: black;">DECLARE<br /></span><span style="color: black;">stat BOOLEAN;<br /></span><span style="color: black;">begin<br /></span><span style="color: black;">stat :=
FND_PROFILE.SAVE('APPS_SSO', 'SSWA_SSO', 'SITE');<br /></span><span style="color: black;">IF stat THEN<br /></span><span style="color: black;">dbms_output.put_line( 'Profile
APPS_SSO updated with SSWA_SSO' );<br /></span><span style="color: black;">commit;<br /></span><span style="color: black;">ELSE<br /></span><span style="color: black;">dbms_output.put_line( 'Profile
APPS_SSO could NOT be updated with SSWA_SSO' );<br /></span><span style="color: black;">rollback;<br /></span><span style="color: black;">END IF;<br /></span><span style="color: black;">end;<br /></span><span style="color: black;">/<br /></span><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">Run autoconfig<br /></span><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">Bring down Services<br /></span><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">adstpall.sh<br /></span><span style="color: black;">adautocfg.sh<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Enable TLS</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Generate CSR for certs</span></h4></div><div style="font-variant-caps: normal; font-variant-ligatures: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="color: black; font-size: 18pt;"><br /></span><span style="color: black;">[debssso@dev-ebs-sso01
devwallet]$ export JAVA_HOME=/devsso/jdk1.8.0_251<br /></span><span style="color: black;">[debssso@dev-ebs-sso01
devwallet]$ /devsso/app/oracle/oim/bin/orapki wallet create -wallet . -pwd
devsso2020<br /></span><span style="color: black;">[debssso@dev-ebs-sso01
devwallet]$ /devsso/app/oracle/oim/bin/orapki wallet add -wallet . -dn
"CN=dev-ebs-sso01.us.corp.example2qa.com,OU=IT,O=Example,L=Cambridge,S=MA,C=US,emailAddress=db-admins@example.com"
-keysize 2048<br /></span><span style="color: black;">Enter wallet password:<br /></span><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">[debssso@dev-ebs-sso01
devwallet]$ /devsso/app/oracle/oim/bin/orapki wallet export -wallet . -dn
"CN=dev-ebs-sso01.us.corp.example2qa.com,OU=IT,O=Example,L=Cambridge,S=MA,C=US,emailAddress=db-admins@example.com"
-request ./dev-ebs-sso01.csr<br /></span><span style="color: black;">Enter wallet password:<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Add certs to wallet</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">[debssso@dev-ebs-sso01
devwallet]$ /devsso/app/oracle/oim/bin/orapki wallet add -wallet
/devsso/devwallet/. -trusted_cert -cert /devsso/devwallet/root.cer -pwd
devsso2020<br /></span><span style="color: black;"><br /></span><span style="color: black;">[debssso@dev-ebs-sso01
devwallet]$ pwd<br /></span><span style="color: black;">/devsso/devwallet<br /></span><span style="color: black;">[debssso@dev-ebs-sso01
devwallet]$ /devsso/app/oracle/oim/bin/orapki wallet add -wallet
/devsso/devwallet/. -trusted_cert -cert /devsso/devwallet/intermediary.cer -pwd
devsso2020<br /></span><span style="color: black;"><br /><br /></span><span style="color: black;">[debssso@dev-ebs-sso01
devwallet]$ /devsso/app/oracle/oim/bin/orapki wallet add -wallet
/devsso/devwallet/. -user_cert -cert /devsso/devwallet/dev-ebs-sso01.cer -pwd
devsso2020<br /></span><span style="color: black;"><br /></span><span style="color: black;">[debssso@dev-ebs-sso01
devwallet]$<br /></span><span style="color: black;">[debssso@dev-ebs-sso01
devwallet]$ /devsso/app/oracle/oim/bin/orapki wallet display -wallet .<br /></span><span style="color: black; font-size: 13.5pt;"><o:p><br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Prepare Java Keystores</span></h4><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">[debssso@dev-ebs-sso01 ~]$
/devsso/app/oracle/oim/bin/orapki wallet pkcs12_to_jks -wallet
/devsso/devwallet -pwd devsso2020 -jksKeyStoreLoc /devsso/devwallet/devssoK.jks
-jksKeyStorepwd devsso2020 -jksTrustStoreLoc /devsso/devwallet/devssoT.jks
-jksTrustStorepwd devsso2020<br /></span><span style="color: black;">Oracle PKI Tool : Version
12.1.0.2<br /></span><span style="color: black;">Copyright (c) 2004, 2014,
Oracle and/or its affiliates. All rights reserved.<br /></span><span style="color: black;"><br /></span><span style="color: black;">[debssso@dev-ebs-sso01 ~]$ cd
/devsso/devwallet/<br /></span><span style="color: black;"><br /></span><span style="color: black;">[debssso@dev-ebs-sso01 devwallet]$<br /></span><span style="color: black;">keytool -import -trustcacerts
-alias cert1 -file /devsso/devwallet/adcert1.txt -keystore
/devsso/devwallet/devssoDIP.jks<br /></span><span style="color: black;">keytool -import -trustcacerts
-alias cert2 -file /devsso/devwallet/adcert2.txt -keystore
/devsso/devwallet/devssoDIP.jks<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="font-size: large;">On OIM_Domain Weblogic Console, Perform Below Steps:</span></h4></div><div style="font-variant-caps: normal; font-variant-ligatures: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><h3 style="text-align: left;"><span><span style="font-size: large;"><br /></span></span><span style="font-size: small;"><span><span style="color: black;">a)Update Keystore Location and
password for OIM Adminserver<br /></span></span><span style="color: black;"><o:p> <br /></o:p></span><span><span style="color: black;">b)Update Hostname verification to
“None”<br /></span></span><span style="color: black;"><o:p> <br /></o:p></span><span><span style="color: black;">c)Verify and Update the Listen
Address, Listen Port and SSL Listen port for Admin Server<br /></span></span><span style="color: black;"><o:p> <br /></o:p></span><span><span style="color: black;">d)Update Keytstore location and
password for WLS_ODS1<br /></span></span><span style="color: black;"><o:p> <br /></o:p></span><span><span style="color: black;">e)Update HostName Verification to
“None”<br /></span></span><span style="color: black;"><o:p> <br /></o:p></span><span><span style="color: black;">f)Verify and Update Listen
Address,Port and SSL Listen Port for WLS_ODS1 Managed Server<br /></span></span><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">g)Copy boot.properties</span></span></h3><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black; font-size: 13.5pt;">[</span><span style="color: black;">debssso@dev-ebs-sso01 ~]$ cd
/devsso/app/oracle/oim/user_projects/domains/OIM_domain/servers/wls_ods1<br /></span><span style="color: black;">[debssso@dev-ebs-sso01
wls_ods1]$ mkdir security<br /></span><span style="color: black;">[debssso@dev-ebs-sso01
wls_ods1]$ cd security/<br /></span><span style="color: black;">[debssso@dev-ebs-sso01
security]$ ls<br /></span><span style="color: black;">[debssso@dev-ebs-sso01
security]$ cp
/devsso/app/oracle/oim/user_projects/domains/OIM_domain/servers/AdminServer/security/boot.properties
/devsso/app/oracle/oim/user_projects/domains/OIM_domain/servers/wls_ods1/security<br /></span><span style="color: black;">[debssso@dev-ebs-sso01
security]$ ls -trl<br /></span><span style="color: black;">total 4<br /></span><span style="color: black;">-rw-r-----. 1 debssso dba 186
Jul 15 15:23 boot.properties<br /></span><span style="color: black;">[debssso@dev-ebs-sso01
security]$<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Update SSL Mode for DIP Server</span></h4><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">[debssso@dev-ebs-sso01 ~]$
export JAVA_HOME=/devsso/jdk1.8.0_251<br /></span><span style="color: black;">[debssso@dev-ebs-sso01 ~]$<br /></span><span style="color: black;">$ORACLE_HOME/bin/manageDIPServerConfig
set -attribute sslmode -val 1 -h dev-ebs-sso01.us.corp.example2qa.com -p 9009
-D "weblogic"<br /></span><span style="color: black;">[Weblogic user password]<br /></span><span style="color: black;">Connection parameters
initialized.<br /></span><span style="color: black;">Connecting at
dev-ebs-sso01.us.corp.example2qa.com:9009, with userid "weblogic"..<br /></span><span style="color: black;">Connected successfully.<br /></span><span style="color: black;">The attribute sslmode is
successfully changed to value 1.<br /></span><span style="color: black;">[debssso@dev-ebs-sso01 ~]$<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Add Cipher Suites Configured
for OID into DIP</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">http://dev-ebs-sso01.us.corp.example2qa.com:9001/em/<br /></span><span style="color: black;">Weblogic -> OIM_Domain ->
wls_ods1 -> Weblogic Server -> System MBean Browser -> com.bea ->
Server -> wls_ods1 -> SSL -> wls_ods -> CipherSuites<br /></span><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black; font-size: 18pt;">Add<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">TLS_DH_anon_WITH_AES_128_GCM_SHA256<br /></span><span style="color: black;">SSL_DH_anon_WITH_3DES_EDE_CBC_SHA<br /></span><span style="color: black;">TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384<br /></span><span style="color: black;">TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256<br /></span><span style="color: black;">TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA<br /></span><span style="color: black;">TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA<br /></span><span style="color: black;">TLS_DHE_RSA_WITH_AES_256_GCM_SHA384<br /></span><span style="color: black;">TLS_DHE_RSA_WITH_AES_128_GCM_SHA256<br /></span><span style="color: black;">TLS_DHE_RSA_WITH_AES_256_CBC_SHA<br /></span><span style="color: black;">TLS_DHE_RSA_WITH_AES_128_CBC_SHA<br /></span><span style="color: black;">TLS_RSA_WITH_AES_256_GCM_SHA384<br /></span><span style="color: black;">TLS_RSA_WITH_AES_128_GCM_SHA256<br /></span><span style="color: black;">TLS_RSA_WITH_AES_256_CBC_SHA256<br /></span><span style="color: black;">TLS_RSA_WITH_AES_128_CBC_SHA256<br /></span><span style="color: black;">TLS_RSA_WITH_AES_256_CBC_SHA<br /></span><span style="color: black;">TLS_RSA_WITH_AES_128_CBC_SHA<br /></span><span style="color: black;">TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384<br /></span><span style="color: black;">TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256<br /></span><span style="color: black;">TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA384<br /></span><span style="color: black;">TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256<br /></span><span style="color: black;">TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA<br /></span><span style="color: black;">TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA<br /></span><span style="color: black;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Update /devssp/jdk/jre/lib/security/java.security
file</span></h4><span style="color: black;">jdk.tls.disabledAlgorithms=SSLv3,
RC4, DES, DH keySize < 1024, \<br /></span><span style="color: black;"> EC keySize <
224, DES40_CBC, RC4_40, 3DES_EDE_CBC<br /></span><span style="color: black;"><span style="mso-tab-count: 1;"> <span style="font-size: 13.5pt;"> </span><br /> </span></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">- Apply
weblogic patch</span></h4><span style="color: black;">- Upgrade
OPatch to 13.9.4<br /></span><span style="color: black;">java -jar
/stage/soft/WLS_Patch/6880880/opatch_generic.jar -silent
oracle_home=/devsso/app/oracle/oim<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">- Apply OUI
patch</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">export
ORACLE_HOME=/devsso/app/oracle/oim<br /></span><span style="color: black;">export
PATH=$ORACLE_HOME/OPatch:$PATH<br /></span><span style="color: black;">cd
/stage/soft/WLS_Patch/29909359<br /></span><span style="color: black;">opatch apply -silent -jre
/devsso/jdk/jre<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">- Apply
latest WL PSU patch</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">export
ORACLE_HOME=/devsso/app/oracle/oim<br /></span><span style="color: black;">export
PATH=$ORACLE_HOME/OPatch:$PATH<br /></span><span style="color: black;">cd
/stage/soft/WLS_Patch/31535411<br /></span><span style="color: black;">opatch apply -silent<br /></span><span style="color: black;">cd
/stage/soft/WLS_Patch/31544340<br /></span><span style="color: black;">opatch apply -silent<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">- Apply OID
mandatory patches</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">cd
/stage/soft/OID_Patch/31404516<br /></span><span style="color: black;">opatch apply -silent<br /></span><span style="color: black;">cd
/devsso/soft/OID_Patch/26649795<br /></span><span style="color: black;">opatch apply -silent<br /></span><span style="color: black;">vi db.properties<br /></span><span style="color: black;">DRIVER_NAME:oracle.jdbc.OracleDriver<br /></span><span style="color: black;">DRIVER_TYPE:thin<br /></span><span style="color: black;">DB_HOST:debssso-db.example.com<br /></span><span style="color: black;">DB_PORT:1631<br /></span><span style="color: black;">DB_SERVICENAME:DEBSSSO_SRV<br /></span><span style="color: black;">[debssso@dev-ebs-sso01 oracle]$
pwd<br /></span><span style="color: black;">/devsso/app/oracle<br /></span><span style="color: black;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Setup OID</span></h4><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">sh
$ORACLE_HOME/oracle_common/common/bin/wlst.sh<br /></span><span style="color: black;">connect('weblogic','weblogic1','t3://dev-ebs-sso01.us.corp.example2qa.com:9001')<br /></span><span style="color: black;">wls:/OIM_domain/serverConfig/>
oid_setup(orcladminPassword = 'devsso2020', odsPassword = 'example123', realmDN
='dc=corp,dc=example2qa,dc=com', port=9055, sslPort=9057)<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Store User Config for OID</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">[debssso@dev-ebs-sso01 logs]$
cd $ORACLE_HOME<br /></span><span style="color: black;">[debssso@dev-ebs-sso01 oim]$ cd
user_projects/domains/OIM_domain/<br /></span><span style="color: black;">[debssso@dev-ebs-sso01
OIM_domain]$ cd bin<br /></span><span style="color: black;">[debssso@dev-ebs-sso01 bin]$ sh
startComponent.sh oid1 storeUserConfig<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Configure DIP with OID</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">[debssso@dev-ebs-sso01 oracle]$
export ORACLE_HOME=/devsso/app/oracle/oim<br /></span><span style="color: black;">[debssso@dev-ebs-sso01 oracle]$
export WL_HOME=/devsso/app/oracle/oim/wlserver<br /></span><span style="color: black;">[debssso@dev-ebs-sso01 oracle]$
export JAVA_HOME=/devsso/jdk1.8.0_251<br /></span><span style="color: black;">[debssso@dev-ebs-sso01 oracle]$
$ORACLE_HOME/bin/dipConfigurator setup -wlshost
dev-ebs-sso01.us.corp.example2qa.com -wlsport 9001 -wlsuser weblogic -ldaphost
dev-ebs-sso01.us.corp.example2qa.com -ldapport 9057 -ldapuser
"cn=orcladmin" -isldapssl true -dbconfigfile db.properties<br /></span><span style="color: black;">Enter password to contact
WebLogic Server :<br /></span><span style="color: black;">Enter password to contact LDAP
Server :<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Modify OID startNodeManager.sh</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">cd /devsso/app/oracle/oim/user_projects/domains/OIM_domain/bin<br /></span><span style="color: black;">cp startNodeManager.sh
startNodeManager.sh_v1<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Add</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">JAVA_OPTIONS="${JAVA_OPTIONS}
-Dweblogic.nodemanager.sslHostNameVerificationEnabled=false
-Dweblogic.security.SSL.minimumProtocolVersion=TLSv1.2 "<br /></span><span style="color: black;">export JAVA_OPTIONS</span></div><div style="font-variant-caps: normal; font-variant-ligatures: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="color: black;"><br /></span><span style="color: black;">cd
/devsso/app/oracle/oim/user_projects/domains/OIM_domain/nodemanager<br /></span><span style="color: black;">cp nodemanager.properties
nodemanager.properties_v1</span></div><div style="font-variant-caps: normal; font-variant-ligatures: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="color: black;"><br /></span><span style="color: black;">vi nodemanager.properties<br /></span><span style="color: black;">KeyStores=CustomIdentityAndCustomTrust<br /></span><span style="color: black;">CustomIdentityAlias=oraKey<br /></span><span style="color: black;">CustomIdentityKeyStoreFileName=/devsso/devwallet/devssoK.jks<br /></span><span style="color: black;">CustomIdentityKeyStorePassPhrase=devsso2020<br /></span><span style="color: black;">CustomIdentityKeyStoreType=JKS<br /></span><span style="color: black;">CustomIdentityPrivateKeyPassPhrase=devsso2020<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Update cacerts in JDK</span></h4><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">cd /devsso/jdk/jre/lib/security<br /></span><span style="color: black;">cp cacerts cacerts_v1<br /></span><span style="color: black;">keytool -import -trustcacerts
-file /devsso/devwallet/root.cer -alias exampleroot -keystore
/devsso/jdk/jre/lib/security/cacerts<br /></span><span style="color: black;">keytool -import -trustcacerts
-file /devsso/devwallet/intermediary.cer -alias exampleint -keystore
/devsso/jdk/jre/lib/security/cacerts<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Update Java options in
SetDomainEnv.sh</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">cd
/devsso/app/oracle/oim/user_projects/domains/OIM_domain/bin<br /></span><span style="color: black;">cp setDomainEnv.sh
setDomainEnv.sh_v1<br /></span><span style="color: black;">JAVA_OPTIONS="
-Dweblogic.security.SSL.enableJSSE=true -Dweblogic.ssl.JSSEEnabled=true
-Dweblogic.security.SSL.protocolVersion=TLSv1.2
-Dweblogic.security.SSL.minimumProtocolVersion=TLSv1.2 ${JAVA_OPTIONS} "<br /></span><span style="color: black;">export JAVA_OPTIONS<br /></span><span style="color: black;">EXTRA_JAVA_PROPERTIES="-Djava.io.tmpdir=/devsso/temp
${EXTRA_JAVA_PROPERTIES}"<br /></span><span style="color: black;">export EXTRA_JAVA_PROPERTIES<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Update keystorelocation for DIP
Server</span></h4><span style="color: black;"><o:p><span style="font-size: 13.5pt;"> </span><br /></o:p></span><span style="color: black;">[debssso@dev-ebs-sso01 bin]$
./manageDIPServerConfig get -h dev-ebs-sso01.us.corp.example2qa.com -p 9009 -D
weblogic -attr keystorelocation<br /></span><span style="color: black;">[Weblogic user password]<br /></span><span style="color: black;">The attribute keystorelocation
has value JKS_KEYSTORE_LOCATION.<br /></span><span style="color: black;">[debssso@dev-ebs-sso01 bin]$
./manageDIPServerConfig set -h dev-ebs-sso01.us.corp.example2qa.com -p 9009 -D
weblogic -attr keystorelocation -val /devsso/devwallet/devssoDIP.jks<br /></span><span style="color: black;">[Weblogic user password]<br /></span><span style="color: black;">The attribute keystorelocation
is successfully changed to value /devsso/devwallet/devssoDIP.jks.</span></div><h4 style="font-variant-caps: normal; font-variant-ligatures: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><br /><span style="color: black; font-size: 13.5pt;">Set the JKS Password</span></h4><div style="font-variant-caps: normal; font-variant-ligatures: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="color: black;"><br /></span><span style="color: black;">debssso@dev-ebs-sso01 bin]$ sh
$ORACLE_HOME/oracle_common/common/bin/wlst.sh<br /></span><span style="color: black;">wls:/offline>
connect('weblogic','weblogic1'
,'t3://dev-ebs-sso01.us.corp.example2qa.com:9001')<br /></span><span style="color: black;">wls:/OIM_domain/serverConfig/>
createCred(map="dip", key="jksKey",
user="jksuser", password="devsso2020")<br /></span><span style="color: black;">Apply TXK patches for OAM
Registration<br /></span><span style="color: black;">[hostq1@qa-ebs-app01 OAM]$ adop
phase=apply patches=31142470,26401178,26879682,29460647 patchtop=/stage/soft/OAM
apply_mode=downtime<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Register OAM</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">[hostq1@qa-ebs-app01 config]$
txkrun.pl -script=SetOAMReg -registeroam=yes \<br /></span><span style="color: black;">-oamHost=http://dev-ebs-sso01.us.corp.example2qa.com:9021
\<br /></span><span style="color: black;">-oamUserName=weblogic \<br /></span><span style="color: black;">-ldapUrl=ldap://dev-ebs-sso01.us.corp.example2qa.com:9055
\<br /></span><span style="color: black;">-oidUserName=cn=orcladmin \<br /></span><span style="color: black;">-skipConfirm=yes \<br /></span><span style="color: black;">-ldapSearchBase=dc=corp,dc=example2qa,dc=com
\<br /></span><span style="color: black;">-ldapGroupSearchBase=dc=corp,dc=example2qa,dc=com</span></div><div style="font-variant-caps: normal; font-variant-ligatures: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><br /></div><h4 style="font-variant-caps: normal; font-variant-ligatures: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="color: black; font-size: 13.5pt;">Create Synchronization Profiles</span></h4><div style="font-variant-caps: normal; font-variant-ligatures: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2; word-spacing: 0px;"><span style="color: black;"><br /></span><span style="color: black;">Profile name : AD_TO_OID<br /></span><span style="color: black;">Host : corp.example2qa.com<br /></span><span style="color: black;">Port : 636<br /></span><span style="color: black;">User : svc_oraclesync@corp.example2qa.com<br /></span><span style="color: black;">Pwd : _xxxxxxx<br /></span><span style="color: black;">Edit Mapping Rules<br /></span><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><h4 style="text-align: left;"><span style="color: black; font-size: 18pt;">Synchronize Bootstrap Profile</span></h4><span style="color: black; font-size: 13.5pt;"><o:p> <br /></o:p></span><span style="color: black;">export
WL_HOME=/devsso/app/oracle/oim/wlserver<br /></span><span style="color: black;">export
ORACLE_HOME=/devsso/app/oracle/oim<br /></span><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">cd $ORACLE_HOME/bin<br /></span><span style="color: black;">./syncProfileBootstrap -h
dev-ebs-sso01.us.corp.example2qa.com -port 9009 -D weblogic -profile ad_to_oid
-lp 50<br /></span><span style="color: black;"><o:p> <br /></o:p></span><span style="color: black;">Run Multiple times till Entries
Failed is 0<br /></span><span style="color: black;">The bootstrap operation
completed, the operation results are:<br /></span><span style="color: black;">entries read in bootstrap
operation: 24964<br /></span><span style="color: black;">entries filtered in bootstrap
operation: 0<br /></span><span style="color: black;">entries ignored in bootstrap
operation: 0<br /></span><span style="color: black;">entries processed in bootstrap
operation: 3172<br /></span><span style="color: black;">entries failed in bootstrap
operation: 21792<br /></span><o:p> </o:p><br /></div>
<p style="text-align: left;"></p>Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-45825478393039899172021-01-13T14:11:00.001+05:302021-01-16T15:03:31.980+05:30High-Level EBS Upgrade Steps 12.1.3 to 12.2.9<p> </p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk72mPcAUhsU4blgNeqE9F5Z3gcjSfvtAbsJ-tTe_i_Ehh2ET16-wVXpyJ1aXXTvrOVyfqywrZtnxFhfMdGSvAcymT4zKm0e65lrFwPu35k_ctPYnmi4ERMqSYHyy3QWTinkOfX1vNqA/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="2478" data-original-width="610" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk72mPcAUhsU4blgNeqE9F5Z3gcjSfvtAbsJ-tTe_i_Ehh2ET16-wVXpyJ1aXXTvrOVyfqywrZtnxFhfMdGSvAcymT4zKm0e65lrFwPu35k_ctPYnmi4ERMqSYHyy3QWTinkOfX1vNqA/s16000/image.png" /></a></div><br /><br /><br /><p></p>Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com1tag:blogger.com,1999:blog-1991691992703627006.post-34279590319252400842020-03-11T22:22:00.001+05:302020-03-11T22:23:04.565+05:30OCI-CLI Buckets and Objects<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: inherit;">BUCKETS</span><br />
<span style="font-family: inherit;">=======</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">LIST ---</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">oci os bucket list -ns kaless --compartment-id ocid1.compartment.oc1..xxxxxxxxxxxxxxxxccccccccccccdddddddddddddd</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">CREATE ---</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">oci os bucket create -ns kaless --name CLIbucket --compartment-id ocid1.compartment.oc1..xxxxxxxxxxxxxxxxccccccccccccdddddddddddddd</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">GET, UPDATE, DELETE ---</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">oci os bucket get -ns kaless --name CLIarchbucket</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">oci os bucket update -ns kaless --name CLIarchbucket --compartment-id ocid1.tenancy.oc1..bbbbbbbbbbbbbbbffffffffffffjjjjjjjjjjjjjjjjj</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">oci os bucket delete -ns kaless --name CLIbucket</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">OBJECTS</span><br />
<span style="font-family: inherit;">=========</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">oci os object put -ns kaless -bn hello --file://C:\Pictures --name MyLogo.jpg</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">oci os object put -ns kaless -bn hello --file://C:\Pictures --name BigPic.jpg --part-size</span><br />
<span style="font-family: inherit;"><upload_part_size_in_mb> --parallel-upload-count <maximum_number_parallel_uploads></maximum_number_parallel_uploads></upload_part_size_in_mb></span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">oci os bucket create -ns kaless --name hello --compartment-id ocid1.compartment.oc1..aaaaaaaaddp3cccccccccccccccccccbbbbbbbbvv</span><br />
<span style="font-family: inherit;">--metadata file://C:\temp\testfile.json</span></div>
Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-20764746828262413372019-12-13T21:42:00.002+05:302019-12-13T21:42:34.365+05:30Load data to ADW/ATP using DBMS_CLOUD<div dir="ltr" style="text-align: left;" trbidi="on">
Create Credentials<br />
<br />
begin<br />
DBMS_CLOUD.create_credential(<br />
credential_name => 'OBJ_STORE_CRED',<br />
username => 'ale@xxxx.com',<br />
password => 'Auth_Token'<br />
);<br />
end;<br />
/<br />
<br />
Check default Bucket:<br />
<br />
select property_value from database_properties where property_name='DEFAULT_BUCKET';<br />
<div>
<br /></div>
<div>
Set Default Bucket:</div>
<div>
<br /></div>
<div>
<div>
alter database property set default_bucket='https://swiftobjectstorage.region.oraclecloud.com/v1/object_storage_namespace';</div>
</div>
<div>
<br /></div>
<div>
List Objects from Bucket:</div>
<div>
<br /></div>
<div>
select * from table(dbms_cloud.list_objects(credential_name => 'DEF_CRED_NAME',location_uri => 'https://objectstorage.region.oraclecloud.com/n/object_storage_namespace/b/bucket/o/'));</div>
<div>
<br /></div>
<div>
Drop Credentials not needed:</div>
<div>
<br /></div>
<div>
<div>
BEGIN</div>
<div>
DBMS_CLOUD.DROP_CREDENTIAL (</div>
<div>
credential_name => 'DEF_CRED_NAME');</div>
<div>
END;</div>
<div>
/</div>
</div>
<br />
Load Data from Object Storage to a Table.<br />
<br />
BEGIN<br />
DBMS_CLOUD.COPY_DATA(<br />
table_name =>'EMPLOYEES',<br />
credential_name =>'OBJ_STORE_CRED',<br />
file_uri_list =>'https://swiftobjectstorage.<region>.oraclecloud.com/v1/<tenancy>/<bucketname>/<filename>',</filename></bucketname></tenancy></region><br />
format => json_object('delimiter' value ',')<br />
);<br />
END;<br />
/<br />
<br />
Log and Status of data Load:<br />
<br />
As ADMIN user,<br />
<br />
SELECT table_name, owner_name, type, status, start_time, update_time, logfile_table, badfile_table FROM user_load_operations WHERE type = 'COPY' order by start_time desc;<br />
<div style="font-family: "Courier New", Courier, monospace; font-size: 11.7px;">
<br /></div>
</div>
Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-30809276540011741352019-12-13T20:41:00.001+05:302019-12-13T20:41:34.564+05:30Built-in SQL Developer Web - ADW<div dir="ltr" style="text-align: left;" trbidi="on">
Autonomous Data Warehouse<br />
======================<br />
<br />
SQL Developer Web is a browser-based interface of Oracle SQL Developer and<br />
provides a subset of the features of the desktop version.<br />
<br />
• Run SQL statements and scripts in the worksheet<br />
• Export data<br />
<br />
Oracle SQL Developer Web runs in Oracle REST Data Services and access is<br />
provided through schema-based authentication.<br />
<br />
<br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj81wOpDbq1bEWZZxQ0JRaCTTOp0P7_Jz6OPIbmBOq5CIz8_o6URzeJXJVoq-J3PZWz933ACWMrqaSVuSsU-XDWOQWRLCKUAFG3DBlIY-H1V9m-Q-xNq_Nu6CagSx9Phv7AuKIzsTPBTQ/s1600/sqldev1.jpg" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" data-original-height="434" data-original-width="1065" height="259" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj81wOpDbq1bEWZZxQ0JRaCTTOp0P7_Jz6OPIbmBOq5CIz8_o6URzeJXJVoq-J3PZWz933ACWMrqaSVuSsU-XDWOQWRLCKUAFG3DBlIY-H1V9m-Q-xNq_Nu6CagSx9Phv7AuKIzsTPBTQ/s640/sqldev1.jpg" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Apex and SQL Developer can be launched from ADW Service Console</td></tr>
</tbody></table>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQmCg7dGeVkBpIwo0EZ2YKeiBvuNE49oaCiAhVckxuz5Wym9rFcFpk4p68gXMtQmm0dB0od2u6HEzhtMvurDbTYKBhaQ4Sr0jkbpz9_XNbfCGSSHi8VjSVTRVdYTTXvrKxo74QdQkJcw/s1600/sqldev2.jpg" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" data-original-height="452" data-original-width="1076" height="267" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQmCg7dGeVkBpIwo0EZ2YKeiBvuNE49oaCiAhVckxuz5Wym9rFcFpk4p68gXMtQmm0dB0od2u6HEzhtMvurDbTYKBhaQ4Sr0jkbpz9_XNbfCGSSHi8VjSVTRVdYTTXvrKxo74QdQkJcw/s640/sqldev2.jpg" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Login as ADMIN User</td></tr>
</tbody></table>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7tBhyphenhyphenCfTDSvFe2rhnY8L7ANXET-cUcD4S3yG6sJr9Sg42Tvr-ISVLrIezUDD80prXT3szVpffssDc5bavN4cAGu3B_KFjjbSDe-v6SGLEK9Uh-ImeQdUWzwZb_E0eQN_x2w0eWhuGig/s1600/sqldev3.jpg" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" data-original-height="464" data-original-width="1072" height="275" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7tBhyphenhyphenCfTDSvFe2rhnY8L7ANXET-cUcD4S3yG6sJr9Sg42Tvr-ISVLrIezUDD80prXT3szVpffssDc5bavN4cAGu3B_KFjjbSDe-v6SGLEK9Uh-ImeQdUWzwZb_E0eQN_x2w0eWhuGig/s640/sqldev3.jpg" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Run Queries or Scripts to view Outputs</td></tr>
</tbody></table>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgi2wSemIJLOdhuoMhfxu8A9KyYPV9pMeMgUCh5NJnx6KcG7WJmYVUJ5kd49_GIXPf7I8ZnKCKmfZ7Joh_NwDueopYcA0F9e9BiEhK3QcPnEBn4mdQxzK9mRuW3xLL6J9zwv-sV74uhHw/s1600/sqldev4.jpg" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" data-original-height="455" data-original-width="1066" height="272" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgi2wSemIJLOdhuoMhfxu8A9KyYPV9pMeMgUCh5NJnx6KcG7WJmYVUJ5kd49_GIXPf7I8ZnKCKmfZ7Joh_NwDueopYcA0F9e9BiEhK3QcPnEBn4mdQxzK9mRuW3xLL6J9zwv-sV74uhHw/s640/sqldev4.jpg" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">View data Models and Work on them</td></tr>
</tbody></table>
<br /></div>
Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-61621686118939340822019-11-16T19:10:00.000+05:302019-11-16T20:06:37.460+05:30APIs, Keys and OCIDs<div dir="ltr" style="text-align: left;" trbidi="on">
EBSCloudBackup.pl is a script which uses APIs and asks for below details for taking a backup of an On-prem Instance to Oracle Cloud Object Storage.<br />
<br />
Every resource on OCI has a randomly generated OCID assigned to it.<br />
<br />
<br />
Oracle Cloud User Name : xxxxx@yyyyy.com<br />
Oracle Cloud User Auth Token : ********************<br />
<div>
<br /></div>
<br />
Oracle Cloud Infrastructure Details:<br />
<br />
Oracle Storage Cloud Service Endpoint : https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/tenancyName<br />
Oracle Cloud User Name : xxxxxxxx@yyyyyyyyyy.com<br />
Oracle Cloud User OCID : ocid1.user.oc1..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx<br />
Oracle Cloud Fingerprint : f0:05:f4:dd:15:03:7a:4a:e1:fc:f7:1d:b3:c2:ef:70<br />
Oracle Cloud User Private Key Path : /stage/EbsBackup/oci_api_key.pem<br />
Oracle Cloud Tenancy OCID : ocid1.tenancy.oc1..aaaaaaaaymxxxxxxxxxxxxxxxxxxxxpppppppppppppp<br />
Oracle Cloud Region : us-ashburn-1<br />
Oracle Cloud Tenant Name : TenancyName<br />
Oracle Cloud Compartment OCID : ocid1.compartment.oc1..bbbbbbbbbbbbbbbbbbbbbxxxxxxxxxxxxxxpppppppppp<br />
Target Database Type : Compute<br />
<br />
<br />
Where do we find the details on OCI?<br />
<br />
Tenancy OCID:<br />
<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAPei_Y2BE7e28xGf6p9TrkN_EequcqAknIimHP8mJNxFPp53EScmwmijyH8USCrj6cvDXxyumUEaN1p3Mrxt2PT1t5yj5F6556Fayk7J9SnxcN3KJ5sIgGZod0DEs7nYlt6M8ioTFDA/s1600/tenancyOCID.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="421" data-original-width="938" height="287" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAPei_Y2BE7e28xGf6p9TrkN_EequcqAknIimHP8mJNxFPp53EScmwmijyH8USCrj6cvDXxyumUEaN1p3Mrxt2PT1t5yj5F6556Fayk7J9SnxcN3KJ5sIgGZod0DEs7nYlt6M8ioTFDA/s640/tenancyOCID.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
User OCID:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhijHwJgKM8PWsyDCFM6sCCgvFuZ1lO_pY-TWRZJvmaL6d0KHQJHaiuxiQHUdxKZJ-6UvUOVIulX_59J5rEWD3RIq0BFhCz0GMlQCL6C3W2qD1znivSfgzQdQSMR3q0gkN4EbkRj_AHPQ/s1600/UserOCID.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: left;"><img border="0" data-original-height="459" data-original-width="955" height="306" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhijHwJgKM8PWsyDCFM6sCCgvFuZ1lO_pY-TWRZJvmaL6d0KHQJHaiuxiQHUdxKZJ-6UvUOVIulX_59J5rEWD3RIq0BFhCz0GMlQCL6C3W2qD1znivSfgzQdQSMR3q0gkN4EbkRj_AHPQ/s640/UserOCID.png" width="640" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Generate Token for user - User Auth Token<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7hDsBPVzj0wpt8Exi4LF3uNl-SDBCX0ZSS4uH2Bw8Hy0ONMXDb5CiMJSd-fS3P4YmtQ8cq75XAOLxW6_tDfdoFB09gyJ8_oEGjU385vDSl1Jt8D9HWYyL0mgYN6s7zo7DPF_F464WWQ/s1600/generateToken.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="439" data-original-width="953" height="294" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7hDsBPVzj0wpt8Exi4LF3uNl-SDBCX0ZSS4uH2Bw8Hy0ONMXDb5CiMJSd-fS3P4YmtQ8cq75XAOLxW6_tDfdoFB09gyJ8_oEGjU385vDSl1Jt8D9HWYyL0mgYN6s7zo7DPF_F464WWQ/s640/generateToken.png" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihJCxeq_Mas_JQXUwFlhhUr25Clxpa2Bx0tnMx-l8y530OYFa_M5HeVobxvCVgR2ahBRmvp5p9NIxwTchuDPUKdHIEOzlEDGxCUPyp0B2q4DGdjSUQ4De85OqGlZ0W-4hMck3PKdOL7g/s1600/generatedToken.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="194" data-original-width="613" height="202" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihJCxeq_Mas_JQXUwFlhhUr25Clxpa2Bx0tnMx-l8y530OYFa_M5HeVobxvCVgR2ahBRmvp5p9NIxwTchuDPUKdHIEOzlEDGxCUPyp0B2q4DGdjSUQ4De85OqGlZ0W-4hMck3PKdOL7g/s640/generatedToken.png" width="640" /></a></div>
<br />
Generate a Public Key -- and Upload the key to OCI so that you will get a Fingerprint needed above.<br />
<br />
<br />
<div class="MsoNormal">
Download and Install Git Bash<o:p></o:p></div>
<div class="MsoNormal">
Generate the private key and Public key as below using gitbash.</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="background: black; line-height: 18.4px; margin-bottom: 0.0001pt;">
<span style="color: #bfbfbf; font-family: inherit , serif; font-size: 10pt; line-height: 15.3333px;">$ mkdir ~/.oci <o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="background: black; line-height: 18.4px; margin-bottom: 0.0001pt;">
<span style="color: #bfbfbf; font-family: inherit , serif; font-size: 10pt; line-height: 15.3333px;">$ openssl genrsa -out ~/.oci/oci_api_key.pem -aes128 -passout stdin 2048 <o:p></o:p></span></div>
<div class="MsoNormal" style="background: black; line-height: 18.4px; margin-bottom: 0.0001pt;">
<span style="color: #bfbfbf; font-family: inherit , serif; font-size: 10pt; line-height: 15.3333px;">$ chmod go-rwx ~/.oci/oci_api_key.pem <o:p></o:p></span></div>
<div class="MsoNormal" style="background: black; line-height: 18.4px; margin-bottom: 0.0001pt;">
<span style="color: #bfbfbf; font-family: inherit , serif; font-size: 10pt; line-height: 15.3333px;">$ openssl rsa -pubout -in ~/.oci/oci_api_key.pem -out ~/.oci/oci_api_key_public.pem -passin stdin <o:p></o:p></span></div>
<div>
<span style="color: #bfbfbf; font-family: inherit , serif; font-size: 10pt; line-height: 15.3333px;"><br /></span></div>
<div class="MsoNormal">
Copy the public key to upload to OCI.</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="background: black; line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;">
<span style="color: #bfbfbf; font-family: "inherit" , "serif"; font-size: 10.0pt; line-height: 115%;"> cat ~/.oci/oci_api_key_public.pem <o:p></o:p></span></div>
<div class="MsoNormal" style="background: black; line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;">
<span style="color: #bfbfbf; font-family: "inherit" , "serif"; font-size: 10.0pt; line-height: 115%;">-----BEGIN PUBLIC
KEY----- <o:p></o:p></span></div>
<div class="MsoNormal" style="background: black; line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;">
<span style="color: #bfbfbf; font-size: 10pt;"><span style="font-family: inherit , serif;">---------------------------------------xxxxxxxxxxxxx</span></span></div>
<div class="MsoNormal" style="background: black; line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;">
<span style="color: #bfbfbf; font-size: 10pt;">xxxxxxxxxxxxxxxxxxxxxxxyyyyyyyyyyyyyyyyy</span></div>
<div class="MsoNormal" style="background: black; line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;">
<span style="color: #bfbfbf; font-size: 10pt;">hhhhhhhhhhhhhhhhhhhhhhhhhhhyyyyyyyyyyyy</span></div>
<div class="MsoNormal" style="background: black; line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;">
<span style="color: #bfbfbf; font-size: 10pt;">kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk</span></div>
<div class="MsoNormal" style="background: black; line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;">
<span style="color: #bfbfbf; font-size: 10pt;">sssssssssssssssssssssssssssssssssssssssssssssss</span></div>
<div class="MsoNormal" style="background: black; line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;">
<span style="color: #bfbfbf; font-size: 10pt;">................................................</span></div>
<div class="MsoNormal" style="background: black; line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;">
<span style="color: #bfbfbf; font-size: 10pt;">----------------------------------------------------- </span></div>
<div class="MsoNormal">
</div>
<div class="MsoNormal" style="background: black; line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0cm; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;">
<span style="color: #bfbfbf; font-family: "inherit" , "serif"; font-size: 10.0pt; line-height: 115%;">-----END PUBLIC
KEY----- <o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Upload the Public Key to OCI.</div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_AobUuDj3V9Jj1SChLBTS1Q-mTfKoP7Rq0bvT4L4fqNfqaqKM36rolOvSPwtSMhsJkXyb5JV6YW60-JqaZ2szOP5E4hee9WpEYZATFlsb2dyTyJ06mtVS3g0rfJNV3Wr_3GkIijImqg/s1600/Fingerprint.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="500" data-original-width="1118" height="286" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_AobUuDj3V9Jj1SChLBTS1Q-mTfKoP7Rq0bvT4L4fqNfqaqKM36rolOvSPwtSMhsJkXyb5JV6YW60-JqaZ2szOP5E4hee9WpEYZATFlsb2dyTyJ06mtVS3g0rfJNV3Wr_3GkIijImqg/s640/Fingerprint.png" width="640" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Note the Finger Print:<o:p></o:p></div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
<strong><span style="background: white; color: #222222; font-family: "helvetica" , "sans-serif"; font-size: 10.5pt; line-height: 115%;">Fingerprint: </span></strong><span style="background: white; color: #222222; font-family: "helvetica" , "sans-serif"; font-size: 10.5pt; line-height: 115%;">xx:yy:11:33:44:yy:77:pp:dd:tt:<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
</div>
Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-37208293368803868332019-11-16T17:47:00.004+05:302019-11-16T17:47:49.916+05:30DST Upgrade to Version 31 from 18<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<span style="color: #1f497d;">Bring down Apps - Downtime needed for DB on the step 5) of the upgrade.</span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<b><span style="color: #1f497d;">1) Check for conflicts – There Should not be any .</span></b></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<span style="color: #1f497d;">cd /.../27015449</span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<span style="color: #1f497d;">$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDeta<wbr></wbr>il -ph ./</span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<b><span style="color: #1f497d;">2) Apply the patch 27015449 - Does not need downtime.</span></b></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<span style="color: #1f497d;">cd /.../27015449</span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<span style="color: #1f497d;">$ORACLE_HOME/OPatch/opatch apply</span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<b><span style="color: #1f497d;">3) Check current version - Will be 18.</span></b></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<span style="color: #1f497d;">SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value</span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<span style="color: #1f497d;">FROM DATABASE_PROPERTIES</span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<span style="color: #1f497d;">WHERE PROPERTY_NAME LIKE 'DST_%'</span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<span style="color: #1f497d;">ORDER BY PROPERTY_NAME;</span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<b><span style="color: #1f497d;">4) As SYS User run below script from the zip file- Does not need downtime.</span></b></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<b><span style="color: #1f497d;"><br /></span></b></div>
<div class="MsoNormal" style="background-color: white;">
<b style="color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;"><span style="color: #1f497d;">From MOS Download, </span></b><span style="background-color: transparent;"><span style="color: #1f497d; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: x-small;"><b>DBMS_DST_scriptsV1.9.zip </b></span></span></div>
<div class="MsoNormal" style="background-color: white;">
<span style="background-color: transparent;"><span style="color: #1f497d; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: x-small;"><b><br /></b></span></span></div>
<table border="0" cellpadding="0" cellspacing="0" id="kmPgTpl:r1:0:tl5" style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 11px; width: 100%px;" summary=""><tbody>
<tr id="kmPgTpl:r1:0:rl12"><td align="left" id="kmPgTpl:r1:0:cf49"><span class="p_AFHoverTarget xq" id="kmPgTpl:r1:0:ol22" style="color: black; font-size: 14.3px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>Scripts to update the RDBMS DST (timezone) version in an 11gR2 or 12c database . (Doc ID 1585343.1)<br /></label></span></td></tr>
</tbody></table>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<span style="color: #1f497d;">@upg_tzv_check.sql</span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<b><span style="color: #1f497d;">5) As SYS user run below script from the zip file. Bring down Apps and run the script.</span></b></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<b><span style="color: #1f497d;"><br /></span></b></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<b><span style="color: #1f497d;">-- DB will be automatically bounced 2 times by this script and does not prompt before bounce - Make sure you have enough downtime on DB and Apps.</span></b></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<span style="color: #1f497d;">@upg_tzv_apply.sql</span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<b><span style="color: #1f497d;">6) Check Final upgraded version - should be 31.</span></b></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<span style="color: #1f497d;">SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value</span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<span style="color: #1f497d;">FROM DATABASE_PROPERTIES</span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<span style="color: #1f497d;">WHERE PROPERTY_NAME LIKE 'DST_%'</span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<span style="color: #1f497d;">ORDER BY PROPERTY_NAME;</span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small;">
<span style="color: #1f497d;">Bounce DB and bring up Apps.</span></div>
</div>
Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-90662963514272658312019-11-16T17:35:00.000+05:302019-11-16T17:35:11.125+05:30Patch 6078836 for Apache Startup Issue<div dir="ltr" style="text-align: left;" trbidi="on">
Issue 1:<br />
<br />
error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory<br />
<br />
Issue 2:<br />
<br />
apps/tech_st/10.1.3/Apache/Apache/libexec/mod_ossl.so into server:<br />
/10.1.3/Apache/Apache/libexec/mod_ossl.so: undefined symbol: dbm_firstkey<br />
<div>
<br /></div>
<div>
Fixes:</div>
<div>
<br /></div>
<div>
As root user,</div>
<div>
<br /></div>
<div>
# cd 6078836</div>
<div>
<div>
# cp libdb.so.2 /usr/lib/</div>
</div>
<div>
<div>
# yum install -y gdbm-devel.i686</div>
</div>
<div>
<div>
# ln -s /usr/lib/libdb-4.7.so /usr/lib/libdb-4.3.so</div>
</div>
<div>
<br /></div>
</div>
Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-89044324709816337302019-11-16T17:24:00.000+05:302019-11-16T17:28:45.275+05:30Open Apache and Weblogic ports for Public access on OCI Compute<div dir="ltr" style="text-align: left;" trbidi="on">
On OCI Compute Instance,<br />
Even if Ingress rule is added to allow traffic for a port, The port itself still needs to be opened on the instance using with IPTABLES or FIREWALL-CMD.<br />
<br />
As root user, execute the below commands to open the port 8008 or 7001, as required for EBS Login page or Weblogic port on EBS 12.2.<br />
<br />
<br />
Start Firewall Daemon if not already running.<br />
<br />
<br />
# systemctl start firewalld<br />
<br />
# systemctl status firewalld<br />
<br />
Should show: Active: active (running) since .....<br />
<br />
<br />
# iptables -I INPUT -p tcp -m state --state NEW,ESTABLISHED -m tcp --dport 8008 -m comment --comment "Required for EBS Login page Access. " -j ACCEPT<br />
<br />
# firewall-cmd --zone=public --add-rich-rule 'rule family=ipv4 source address=0.0.0.0/0 port port=8008 protocol=tcp accept' --permanent ;<br />
<br />
<br /></div>
Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-60414134268560579362019-11-16T17:18:00.000+05:302019-11-16T17:18:48.513+05:30DOM Synonym issue on ADADMIN <div dir="ltr" style="text-align: left;" trbidi="on">
Re-Create Grants and Synonyms from ADADMIN is failing with below error.<br />
<br />
new 2: ad_apps_private.create_grants_and_synonyms(1,'DOM','APPLSYS','APPS','FALSE');<br />
begin<br />
*<br />
ERROR at line 1:<br />
ORA-20000: ORA-06550: line 1, column 20:<br />
PLS-00225: subprogram or cursor 'NUMERIC_DOMINATES' reference is out of scope<br />
ORA-06550: line 1, column 7:<br />
PL/SQL: Statement ignored:create_grants_and_synonyms(1,DOM,APPLSYS,APPS):<br />
create_base_gs(DOM,APPS): In Grants<br />
Loop:create_grant(DOM,APPS,DOM_ATTACHMENT_ENTITIES,ALL,TRUE,):<br />
do_apps_ddl(DOM,GRANT ALL ON "DOM_ATTACHMENT_ENTITIES" TO APPS WITH GRANT<br />
OPTION):<br />
ORA-06512: at line 5<br />
<br />
Fix: Drop the Synonym in PDB.<br />
<br />
select * from all_synonyms where synonym_name = 'DOM';<br />
<br />
<br />
OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME DB_LINK<br />
------------ ---------------- --------------- ---------------------- ---------------------------------------------------<br />
PUBLIC DOM LBACSYS NUMERIC_DOMINATES<br />
<br />
<br />
SQL> drop public synonym dom;<br />
<br />
Synonym dropped.<br />
<br />
To drop the synonym in PDB use below Statement.<br />
<br />
SQL> exec dbms_pdb.exec_as_oracle_script('drop public synonym dom');<br />
<br />
PL/SQL procedure successfully completed.<br />
<br />
SQL> select object_name,object_type,status,owner from dba_objects where object_name = 'DOM';<br />
<br />
no rows selected<br />
<div>
<br /></div>
</div>
Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-228224592176785652019-11-16T17:10:00.003+05:302019-11-16T17:11:02.144+05:30Forms Error ORA-1017: Invalid Username/Password after DB bounce on OCI<div dir="ltr" style="text-align: left;" trbidi="on">
Forms connectivity fails once DB is bounced on OCI DbaaS Instance.<br />
<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfUrmqD82HHng0-97LNf_X8znBHazS5KSdAIZiihf3xCgEPK8n79RGQbN2tac2PhwBlUN8VFF62fGC2kvhA522AtT5NadsoeFy_craxS6g90DiuOfkp7PN2eHJVRtcK7ohg5nM_kEIIw/s1600/Invalid+Username.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="161" data-original-width="419" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfUrmqD82HHng0-97LNf_X8znBHazS5KSdAIZiihf3xCgEPK8n79RGQbN2tac2PhwBlUN8VFF62fGC2kvhA522AtT5NadsoeFy_craxS6g90DiuOfkp7PN2eHJVRtcK7ohg5nM_kEIIw/s1600/Invalid+Username.png" /></a></div>
<br />
<br />
Fix is to start the Service on PDB. and Re-login to the Apps front-end.<br />
<br />
<br />
SQL>alter session set container=PDBNAME;<br />
<br />
SQL> exec dbms_service.start_service('PDBNAME');<br />
<br />
PL/SQL procedure successfully completed.<br />
<br />
SQL> alter system register;<br />
<br />
<br /></div>
Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com2tag:blogger.com,1999:blog-1991691992703627006.post-68221282106427914722019-11-16T16:23:00.000+05:302019-11-16T17:12:41.534+05:30Cross Platform Migration of EBS Database using XTTS Incremental Backup -- From AIX to Linux 64-bit on OCI DbaaS PDB Instance<div dir="ltr" style="text-align: left;" trbidi="on">
<div>
<span style="background-color: transparent; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"></span><br />
<div>
<span style="background-color: transparent; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span style="font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"></span></span><br />
<div>
<span style="background-color: transparent; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span style="font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span id="docs-internal-guid-581e9cb1-7fff-7991-6c2b-c91024af38ce"></span></span></span><br />
<div style="text-align: left;">
<span style="background-color: transparent; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span style="font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span id="docs-internal-guid-581e9cb1-7fff-7991-6c2b-c91024af38ce"><span style="font-family: "calibri" , sans-serif;"></span></span></span></span><br />
<div>
<span style="background-color: transparent; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span style="font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span id="docs-internal-guid-581e9cb1-7fff-7991-6c2b-c91024af38ce"><span style="font-family: "calibri" , sans-serif;"><span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: 14.3px; text-align: right;"></span></span></span></span></span><br />
<div>
<span style="background-color: transparent; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span style="font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span id="docs-internal-guid-581e9cb1-7fff-7991-6c2b-c91024af38ce"><span style="font-family: "calibri" , sans-serif;"><span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: 14.3px; text-align: right;"><span id="docs-internal-guid-5eff03a2-7fff-2f30-02b7-aefb4ae74deb"><span id="docs-internal-guid-bef2990e-7fff-aecb-aaf7-3f5b344c1354"></span></span></span></span></span></span></span><br />
<div style="text-align: left;">
<span style="background-color: transparent; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span style="font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span id="docs-internal-guid-581e9cb1-7fff-7991-6c2b-c91024af38ce"><span style="font-family: "calibri" , sans-serif;"><span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: 14.3px; text-align: right;"><span id="docs-internal-guid-5eff03a2-7fff-2f30-02b7-aefb4ae74deb"><span id="docs-internal-guid-bef2990e-7fff-aecb-aaf7-3f5b344c1354"><span style="background-color: transparent; font-family: "calibri" , sans-serif; font-size: 11pt; vertical-align: baseline; white-space: pre-wrap;"><span id="docs-internal-guid-50961168-7fff-6a3f-262c-daf1353641ac"><span style="background-color: transparent; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><b>References:</b></span></span></span></span></span></span></span></span></span></span></div>
<span style="background-color: transparent; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span style="font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span id="docs-internal-guid-581e9cb1-7fff-7991-6c2b-c91024af38ce"><span style="font-family: "calibri" , sans-serif;"><span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: 14.3px; text-align: right;"><span id="docs-internal-guid-5eff03a2-7fff-2f30-02b7-aefb4ae74deb"><span id="docs-internal-guid-bef2990e-7fff-aecb-aaf7-3f5b344c1354">
</span></span></span></span></span></span></span>
<div style="text-align: left;">
<span style="background-color: transparent; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span style="font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span id="docs-internal-guid-581e9cb1-7fff-7991-6c2b-c91024af38ce"><span style="font-family: "calibri" , sans-serif;"><span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: 14.3px; text-align: right;"><span id="docs-internal-guid-5eff03a2-7fff-2f30-02b7-aefb4ae74deb"><span id="docs-internal-guid-bef2990e-7fff-aecb-aaf7-3f5b344c1354"><span style="background-color: transparent; font-family: "calibri" , sans-serif; font-size: 11pt; vertical-align: baseline; white-space: pre-wrap;"><span style="background-color: transparent; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;">
E-Business Suite 12.1 Platform Migration from On-Premises to Oracle Cloud using Transportable Tablespaces with 12cR1 (Doc ID 2473448.1)
Using Transportable Tablespaces to Migrate Oracle EBS Release 12.0 or 12.1 Using Oracle Database 12.1.0 (Doc ID 1945814.1)
12C - Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 2005729.1)
Using Transportable Tablespaces to Migrate Oracle EBS Release 12.2 Using Oracle Database 12.1.0 (Doc ID 2157661.1)
Interoperability Notes Oracle EBS 12.2 with Oracle Database 12c Release 1 (Doc ID 1926201.1)
V4 Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 2471245.1)</span></span></span></span></span></span></span></span></span></div>
<span style="background-color: transparent; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span style="font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span id="docs-internal-guid-581e9cb1-7fff-7991-6c2b-c91024af38ce"><span style="font-family: "calibri" , sans-serif;"><span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: 14.3px; text-align: right;"><span id="docs-internal-guid-5eff03a2-7fff-2f30-02b7-aefb4ae74deb"><span id="docs-internal-guid-bef2990e-7fff-aecb-aaf7-3f5b344c1354">
<div style="text-align: left;">
<span style="background-color: transparent; font-family: "calibri" , sans-serif; font-size: 11pt; vertical-align: baseline; white-space: pre-wrap;"><span style="background-color: transparent; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;">
=============================================================================
On Source Instance - EBS version- 12.1.3 and DB version 12.1.0.2
=============================================================================
1. Apply Patches required for XTTS on source AIX instance.
Apply Patch 20863688
Apply AD and TXK patches required for PDB configuration
1. Run adgrants.sql from patch 23569686.
2. Apply AD.DELTA.8 patch 23569686.
3. Apply TXK.DELTA.4 patch 27135427.
4. Copy appsutil.zip to DB Home and run autoconfig on DB and then on Apps.
5. Apply patch 23645824.
6. Apply patch 27102203.
7. Copy appsutil.zip to DB Home and run autoconfig on DB and then on Apps.
8. Run adpreclone.pl on DB and Apps.
2. Perform TTS checks on tablespaces.
SYS,SYSTEM,UNDO,TEMP - tablespaces will not be included for TTS.
a)
exec sys.dbms_tts.transport_set_check('CTXSYS,USERS,APPS_TS_ARCHIVE,APPS_TS_INTERFACE,APPS_TS_MEDIA,APPS_TS_NOLOGGING,APPS_TS_QUEUES,APPS_TS_SEED,APPS_TS_SUMMARY,APPS_TS_TOOLS,APPS_TS_TX_DATA,APPS_TS_TX_IDX,AUDIT_DATA,,INTERIM,NOETIX_DATA,NOETIX_DW,NOETIX_USERS,TOOLS',TRUE,TRUE);
select * from sys.transport_set_violations;
b) Run auxttspre.sql which also does the TTS checks and generates files required for migration.
Copy from $AU_TOP/patch/115/sql to DB node and Run auxttspre.sql which creates the par files and sql files to be used for export/import.
3. Review the log file and fix all the violations.
Most of the fixes would be rebuilding INDEXES in same tablespace as the TABLE. Some times it may be required to move the TABLE instead.
alter index SYSTEM.DEF$_CALLDEST_N2 rebuild tablespace SYSTEM;
alter index SYSTEM.I_REPCAT$_SNAPGROUP1 rebuild tablespace SYSTEM;
alter table SYSTEM.REPCAT$_REPCAT move tablespace system;
alter table SYSTEM.REPCAT$_REPGROUP_PRIVS move tablespace system;
4. Download rman_xttconvert_VER4.3.zip from Doc ID: 2471245.1
5. Update xtt.properties file
tablespaces=
platformid=6 (for AIX)
src_scratch_location=
dest_datafile_location=+DATA
dest_scratch_location=
asm_home=/u01/app/12.2.0.1/grid
asm_sid=+ASM1
parallel=8
rollparallel=4
getfileparallel=4
desthost=
destconnstr=
desttmpdir=
dumpdir=
usermantransport=1
6. Prepare Phase
Take first full backup of the Instance.
export TMPDIR=/Backup_Location/temp
nohup $ORACLE_HOME/perl/bin/perl xttdriver.pl --backup &
Take a backup of the text files under TMPDIR each time a backup is completed.
7. Roll Forward Phase.
Once above backup is restored on Target instance, Take an Incremental backup as needed till we have reached downtime or cutover time.
nohup $ORACLE_HOME/perl/bin/perl xttdriver.pl --bkpinc &
8. Final Incremental Backup - Down time begins here
Bring Down Apps Services and Keep all the Tablespaces in Read-Only mode.
Ex: alter tablespace APPS_TS_ARCHIVE read only;
Take a final INCR backup --
nohup $ORACLE_HOME/perl/bin/perl xttdriver.pl --bkpincr &
In the same Window of read-only status of tablespaces ie. DO NOT switch to READ-WRITE between the above INCR backup step and below metadata step.
Take an export dump of metadata ---
expdp system/Tach0_m3t3r parfile=auexpfulltts.dat
auexpfulltts.dat -- would be generated above by auxttspre.sql, verify and modify as needed.
directory=dmpdir
metrics=y
dumpfile=xttsfulltts%U.dmp
filesize=1048576000
tablespaces=
=============================================================================
On Target Instance - DbaaS PDB Instance with ASM
=============================================================================
1. Apply the Latest PSU to both Grid and DB homes.
2. Maintain the same DST version on both source and target. In my case, I have upgraded the source DST to version-31, as OCI instance has 31 already.
3. Apply fixes required for XTTS issues and errors.
20345554 - MAIN_LINUX.X64 LRGDBCONZDVST HANGS WITH ORA-03113 (p20345554_12102181016ProactiveBP_Generic.zip)
18672264 - ORA-39083, ORA-31000 FROM IMPDP FOR XMLSCHEMA (p18672264_121020_Generic.zip)
28307854 - ORA-3106 IMPORTING PACKAGE BODY WITH IMPDP AFTER APPLYING 12.1.0.2.180417DBBP(already included in jan 2019 Bundle Patch)
23278750: ORA-01000 AND ORA-39029 ERRORS WHILE DOING TTS IMPORT WITH DP (p23278750_12102170117ProactiveBP_Linux-x86-64.zip)
4. Check and Enable Database components/options as required to maintain same as Source.
a) Enable Partitioning .
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk part_on
make -f ins_rdbms.mk ioracle
b) Create 9idata directory
perl ORACLE_HOME/nls/data/old/cr9idata.pl
c) Install APS/MGD and XOQ db components -- Run the sqls both on CDB and PDB.
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk olap_on ioracle
@?/olap/admin/olap.sql SYSAUX TEMP
@$ORACLE_HOME/rdbms/admin/catmgd.sql
@$ORACLE_HOME/rdbms/admin/utlrp.sql
5. Run scripts to prepare the SYS/SYSTEM schemas for EBS DB migration.
sqlplus / as sysdba @audb1210.sql
sqlplus system/*** @ausy1210.sql
sqlplus system/*** @aujv1210.sql
sqlplus system/*** @aumsc1210.sql SYSAUX TEMP
sqlplus / as sysdba @adstats.sql
6. Run datapatch.
7. Create Users,roles and grants using DDL generated on source.
Take spool of below statements on Source and run the generated spool on Target.
-- USERS
select 'create user '||name||' identified by values '''||password||''';' from user$ where spare4 is null and password is not null
union
select 'create user '||name||' identified by values '''||spare4||';'||password||''';' from user$ where spare4 is not null and password is not null;
-- ROLES
select dbms_metadata.get_ddl('ROLE', ROLE) from dba_roles where ORACLE_MAINTAINED='N';
--- GRANTS
select (case
when ((select count(*)
from dba_role_privs
where grantee = u.username) > 0)
then dbms_metadata.get_granted_ddl ('ROLE_GRANT', u.username)
else to_clob (' -- Note: No granted Roles found!')
end ) from dba_users u where username not in (select name from system.logstdby$skip_support where action=0)
UNION ALL
select (case
when ((select count(*)
from dba_sys_privs
where grantee = u.username) > 0)
then dbms_metadata.get_granted_ddl ('SYSTEM_GRANT', u.username)
else to_clob (' -- Note: No System Privileges found!')
end ) from dba_users u where username not in (select name from system.logstdby$skip_support where action=0)
/
================================================================================
Copy the backups taken on source and the text files under TMPDIR to Target
=================================================================================
8. Update xtt.properties file as needed for target
destconnstr -
9. Restore the First Full Backup
export TMPDIR=/backup_Location/temp
nohup $ORACLE_HOME/perl/bin/perl xttdriver.pl --restore &
10. Recover the First Incremental Backup.
nohup $ORACLE_HOME/perl/bin/perl xttdriver.pl --recover &
11. Recover the Final INCR Backup.
nohup $ORACLE_HOME/perl/bin/perl xttdriver.pl --recover &
12. Transport Phase. Import the Metadata .
NOTE: Once the tablespaces are plugged in which usually take about few minutes once IMPDP is started, Assign default Tablespaces and Quotas for all the users.
Use below statements to create spool files on source and run the spool on Target.
select ' alter user '|| username ||' default tablespace '|| DEFAULT_TABLESPACE ||';' from dba_users;
select 'ALTER USER '||username||' QUOTA UNLIMITED ON '||TABLESPACE_NAME ||';' from dba_ts_quotas;
impdp userid=\'sys/****@PDBSID as sysdba\' parfile=auimpfulltts.dat
parfile --
directory=XTTSDUMP
metrics=y
dumpfile=xttsfulltts%U.dmp
logfile=impfulltts.log
transport_datafiles='+DATA/apps_special_230.dbf',
'+DATA/apps_ts_archive_212.dbf',
'+DATA/apps_ts_archive_213.dbf',
..
..
'+DATA/apps_ts_media_40.dbf'
13. Make tablespaces READ WRITE.
Ex: alter tablespace APPS_TS_MEDIA read write;
14. Export and Import remaining objects .
expdp directory=dmpdir userid=\"/ as sysdba\" full=y logfile=exp_objects.log parallel=6 dumpfile=impdp_objects_%U.dmp include=CONTEXT,DB_LINK,FUNCTION,PACKAGE,PROCEDURE,QUEUE,RULE,SEQUENCE,SYNONYM,TRIGGER,TYPE,VIEW,MATERIALIZED_VIEW,JAVA_CLASS,JAVA_RESOURCE
impdp directory=dmpdir userid=\'sys/****@PDBSID as sysdba\' logfile=imp_objects.log dumpfile=impdp_objects_%U.dmp parallel=6 TRANSFORM=SEGMENT_ATTRIBUTES:n TRANSFORM=OID:n
15. Bring in Global Temporary Tables and Indexes as below.
SELECT dbms_metadata.get_ddl('TABLE', table_name, owner) || ';'
FROM dba_tables WHERE temporary = 'Y'
AND owner not in (select name from system.logstdby$skip_support where action=0) ORDER BY owner, table_name;
SELECT dbms_metadata.get_ddl('INDEX', INDEX_name, owner) || ';' output
FROM dba_indexes where table_name in (SELECT table_name FROM dba_tables WHERE temporary = 'Y'
AND owner not in (select name from system.logstdby$skip_support where action=0)) ORDER BY owner, index_name;
16. Copy SQL profiles - Only Enabled profiles will be copied.
on source
--------------------
select name,status from dba_sql_profiles;
exec DBMS_SQLTUNE.CREATE_STGTAB_SQLPROF(table_name=>'PROFILES_SRC',schema_name=>'APPS');
conn apps/XXXXXXXX
EXEC DBMS_SQLTUNE.PACK_STGTAB_SQLPROF (profile_category => '%', staging_table_name => 'PROFILES_SRC');
exp tables=PROFILES_SRC apps/XXXXXX
this will create dumpfile expdat.dmp
copy this file to target database server
on target
------------
imp tables=PROFILES_SRC apps/XXXXXX
EXEC DBMS_SQLTUNE.UNPACK_STGTAB_SQLPROF(replace => TRUE,staging_table_name => 'PROFILES_SRC');
select name,status from dba_sql_profiles;
17. Identify and Bring in Missing objects using DDL or EXPDP.
18 Compile Invalids.
19. Reset Advanced Queues
Run auque2.sql on target- this is generated on source when we run auque1.sql
20. Copy appsutil.zip from Source Apps node to target DB node.
21. Configure PDB - Run txkPostPDBCreationTasks.pl
. ./txkSetCfgCDB.env dboraclehome=/u01/app/oracle/product/12.1.0.2/dbhome_1
export ORACLE_PDB_SID=XXXX
cd /u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/bin
perl txkPostPDBCreationTasks.pl -dboraclehome=/u01/app/oracle/product/12.1.0.2/dbhome_1
-outdir=/u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/log
-cdbsid=cabcebsd -pdbsid=abcd -appsuser=apps -dbport=1521 -servicetype =dbaas
This script will Bounce Listener, generate TNS for CDB and PDB, Bounces DB, generates Context File, cleans Node information, runs autoconfig and finally runs adgrants.sql
22. Re-Compile Invalids.
23. Run adcfglone on Apps tier. -- Apps is a Compute Instance on OCI.
perl adcfgclone.pl appsTier
There will be issues related to grants, CTX packages and JTF objects which needs to be fixed for autoconfig to be successful.
24. Create DB links, DBA directories, Register Custom Tops.
25. Bring up Apps services.
</span></span></div>
</span></span></span></span></span></span></span></div>
<span style="background-color: transparent; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span style="font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span id="docs-internal-guid-581e9cb1-7fff-7991-6c2b-c91024af38ce"><span style="font-family: "calibri" , sans-serif;"><span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: 14.3px; text-align: right;">
</span></span></span></span></span></div>
<span style="background-color: transparent; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span style="font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span id="docs-internal-guid-581e9cb1-7fff-7991-6c2b-c91024af38ce"><span style="font-family: "calibri" , sans-serif;">
</span></span></span></span></div>
<span style="background-color: transparent; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span style="font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span id="docs-internal-guid-581e9cb1-7fff-7991-6c2b-c91024af38ce">
</span></span></span></div>
<span style="background-color: transparent; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;"><span style="font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;">
</span></span></div>
<span style="background-color: transparent; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline;">
</span></div>
</div>
Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0tag:blogger.com,1999:blog-1991691992703627006.post-82853768778027336312019-04-12T21:18:00.001+05:302019-04-18T21:28:47.472+05:30Resources Needed for Lift and Shift of EBS instance from on-prem to OCI<div dir="ltr" style="text-align: left;" trbidi="on">
Important resources to be created in the tenancy and OCI console as pre-requisites for EBS Cloud Manager Instance creation.<br />
<br />
1. Compartments<br />
2. Groups and policies.<br />
3. Users and API keys.<br />
4. Network resources<br />
<br />
<ul style="text-align: left;">
<li>VCN</li>
<li>Gateways</li>
<li>Route Tables</li>
<li>Security Lists</li>
<li>Subnets </li>
<li>Load Balancers</li>
</ul>
<div>
<br /></div>
<div>
Understanding the terminology:</div>
<div>
<br /></div>
<br />
<div>
<br /></div>
<div>
<div>
Tenancy - When you sugnup for OCI, a tenancy is created which acts as root compartment for all your cloud resources.</div>
<div>
<br /></div>
<div>
Compartment -- Logical groups or a Collection of resources like instances,VCNs, Block Volumes. </div>
<div>
Any additional compartment created will be under the root compartment(tenancy).</div>
<div>
<br /></div>
<div>
Region is a localized geographic area.</div>
<div>
Availability domain is one or more data centers located within a region. A region is composed of several availability domains.</div>
<div>
<br /></div>
<div>
VCN - Virtual Cloud Network which has subnets,security lists,route tables,Gateways to support access for instances with in and </div>
<div>
outside of Cloud Network as well.</div>
<div>
<br /></div>
<div>
Instance - A virtual machine or host running in Cloud.</div>
<div>
Image - A template of Operating System and optional Softwares </div>
<div>
that can be used to provision instances directly instead of manual installation using OS softwares.</div>
<div>
Shape - Combination of CPU,Memory and Network Speed to choose while provisioning instances.</div>
<div>
<br /></div>
<div>
Key Pair - Used for authentication, Upload public key to OCI and private is on your laptop,</div>
<div>
The combination works for accessins instance on OCI</div>
<div>
<br /></div>
<div>
SSH Key pair -- Used to provide access for SSH access to instances.</div>
<div>
API signing key pair - Used for submitting API requests, the key will be in PEM format.</div>
<div>
<br /></div>
<div>
Block Volume - Virtual block storage like physical HDD, attached to instances.</div>
<div>
Object Storage - Store and manage data as files,example: backups are taken to object storage.</div>
<div>
<br /></div>
<div>
Bucket - Logical container inside object storage which holds the data and files.</div>
<div>
<br /></div>
<div>
OCID - Unique identifier automatically created for each cloud resource while creating the resource itself. </div>
<div>
They are used when accessing instances from OCICLI or APIs</div>
</div>
<div>
<br /></div>
</div>
Kiran Alehttp://www.blogger.com/profile/00730611452910860754noreply@blogger.com0