JD Edwards CNC

With Oracle 12C, we have concept of Multitenant DB where we have a CDB and multiple PDBs What is a PDB and CDB? Below are the high level details for PDB and CDB, please check on Google for more information on CDB and PDBs. A Container database (CDB) is made up of the following containers: There is one root container which stores the Oracle supplied metadata like the PL/SQL data dictionary packages and the common users. This root container is referred to as CDB$ROOT. One seed Pluggable Database (PDB) which is a system supplied template which can be used to create new PDB’s. This seed PDB is called PDB$SEED. Some of the characteristics of a CDB There is a separate SYSTEM and SYSAUX tablespace for the root container of the CDB and each PDB Thee is only one UNDO tablespace for the entire CDB There is only one set of control files and online redo logs files for the entire CDB. Individual PDB’s have their own data files (which contain the user data), but do not have distinct redo log or cont...

Changing the Weblogic Admin user password is a 3 step procedure. Please follow the steps in order. The only JD Edwards component affected will be server manager console. 1. Disable user lockout : Log in to the Administrative Console. In the Domain Structure tree, click Security Realms. In the Realms table, click myrealm. Select tab "User Lockout" From the top left, click "Lock & Edit" Uncheck box next to "Lockout Enabled" Click save at the bottom of the section Select "Activate Changes" at the top left. Restart Admin Server 2. Update new Admin Server password for user weblogic : Log in to the Administrative Console. In the Domain Structure tree, click Security Realms. In the Realms table, click myrealm. Select the Users and Groups tab. In the table of available users, click weblogic. Select the Passwords tab. Enter and re-enter a new password for this user. Click Save. Open file in text editor (notepad) the boot.properties file with the new v...

My earlier post discussed about Provisioning JDE on OCI where we have to create the VMs manually and install WLS/DB etc manually. Oracle JD Edwards EnterpriseOne recently announced a Reference Architecture  for implementing JD Edwards EnterpriseOne on Oracle Cloud Infrastructure with preconfigured security and high availability (HA).  JD Edwards has automated this reference architecture to accelerate the deployment of JD Edwards EnterpriseOne Applications 9.2 including the latest enhancements and patches with Tools 9.2.3 on Oracle Cloud Infrastructure and reduce the total cost of implementation. JD Edwards Reference Architecture Automation for OCI Provisioning of JD Edwards reference architecture on OCI leverages Terraform automation for Infrastructure provisioning (Creating VCN, VMs, DBS, Storage, Load Balancer, and Security) and One-Click Provisioning automation to deploy JD Edwards EnterpriseOne components. The target environment provisioned using the Reference Archit...

In Oracle9i release 2, the FORCE LOGGING option was introduced.  If force logging is enabled, all the database changes will be logged in redo log files, even for nologging operations. The above means that if FORCE LOGGING is enabled at a higher level, the NOLOGGING at a lower level has no effect.  The FORCE LOGGING option can be set at the database level or the tablespace level.  The precedence is from database to tablespace.  If a tablespace is created or altered to have FORCE LOGGING enabled, any change in that tablespace will go into the redo log and be usable for recovery.  Similarly, if a database is created or altered to have the FORCE LOGGING enabled, any change across the database, with exception of temporary segments and temporary tablespace, will be available in redo logs for recovery.  The FORCE LOGGING option can be set at database creation time or later using the alter database command.  To set FORCE LOGGING during the database creation, s...

Deploy JD Edwards on Oracle Cloud Infrastructure: ================================================= In my previous post , we discussed about process flow and MTRs required for installing JDE in OCI. Let's get started with the actual steps involved in provisioning the JDE on OCI. We can divide the provisioning into 3 parts:     1. Create the required compute instances     2. Setup One-Click Provisioning (OCP) server     3. Run the Orchestration from OCP Console Before we begin, Generate Secure SHell (SSH) Key Pairs.  On your local Microsoft Windows Local Systems use the PuTTY key generator for generating SSH key pairs. The utility is available at this link: http://www.putty.org Generate the Private and Public key pairs, it is recommended to generate at least 2 key pairs. Also, make sure you have access to the required compartments and permissions for the Cloud Console. The minimum recommended size for each Linux-based server type except th...

You can use the Oracle Cloud Infrastructure (also called "IaaS" - Infrastructure as a Service) to deploy JD Edwards EnterpriseOne using the JD Edwards EnterpriseOne One-Click Provisioning Server. This server features a web-based JD Edwards Provisioning Console interface that enables the provisioning of a fully functional suite of interconnected Linux-based servers and a Microsoft Windows-based machine.  For Linux-based servers, the required core servers are the Database Server (either Compute or as a service (DBaaS, hereafter referred to in this document as DB Systems), the Enterprise Server, the HTML Web Server, and the Application Interface Service (AIS) Server. The One-Click Provisioning Server includes the JD Edwards Server Manager Console (SMC). One-Click Provisioning will also deploy the required Deployment Server into a Microsoft Window environment. All servers running in the Oracle Cloud Infrastructure are virtual machines that are functionally equivalent to their...

Creating a compute instance: Before proceeding with the instance creation, please note that Compartments, Availability Doamin (AD), VCN etc. were created.  Follow the below steps to create a compute instance. Log in to the Oracle Cloud Infrastructure portal. On the Oracle Cloud web console, choose Compute, and within that, Instances. Click the Launch Instance button on the Instances page. Note that you can create an instance only within a predefined compartment. You will need to create a new compartment or choose from compartments that you have created earlier. Enter the name for the instance and select from the options in each field.  Oracle Bare Metal Cloud Services is hosted in regions and availability domains. Choose the AD details. IMAGE: This is the operating system you want installed on the instance. You can choose from the various Oracle, Linux, or Windows options. You can also choose a custom image if you have already created one. A custom image is one that you have c...

In my earlier post (OCI -Part1 ), we have gone through OCI basic details, let's dive deep more into it. Before that, we need to u nderstand the following concepts and terminology to help you get started with Oracle Cloud Infrastructure.  Note: OCI is re-branding of Bare Metal Cloud Service (BMCS) BARE METAL HOST Oracle Cloud Infrastructure provides you control of the physical host (“bare metal”) machine. Bare metal compute instances run directly on bare metal servers without a hypervisor. When you provision a bare metal compute instance, you maintain sole control of the physical CPU, memory, and network interface card (NIC). You can configure and utilize the full capabilities of each physical machine as if it were hardware running in your own data center. You do not share the physical machine with any other tenants. REGIONS AND AVAILABILITY DOMAINS  Oracle Cloud Infrastructure is physically hosted in regions and availability domains. A region is a localized geographic area, an...

Oracle Cloud Infrastructure(OCI) =========================== OCI is part of IaaS Service model , where OCI is re-branding of Bare Metal Cloud Service (BMCS).  We all know that Oracle has recently started the  second generation of infrastructure-as-a-service ( IaaS ), called the Oracle Bare Metal Cloud  or Bare-metal Cloud services, which Oracle said are very high performance servers provided to Customer at low cost.       At a very high level, the Oracle Bare Metal cloud is a collection of cloud services designed to allow the user to build an environment capable of handling apps, services, databases, and more in a highly-available cloud ecosystem.             Their architecture revolves around a high-performance compute environment which gives users the ability to provision storage, compute (physical hardware as needed), and integrate flexible virtual networks into the cloud platform.     ...