Sunday, 9 February 2025

Step-by-Step Guide to Create an Autonomous Database in Oracle OCI

 Log in to Oracle Cloud Console

Navigate to Autonomous Database Section



Click on Create Autonomous Database

    Click on Create Autonomous Database and select correct Compartment


Fill Out the Create Autonomous Database Form

  • Compartment
  • Display Name
  • Database Type
  • Deployment Type
  • Database Version
  • License Type


Configure Database Options

  • Admin Password
  • Storage
  • Auto Scaling
  • Network
  • Backup & Restore



Click on Create Autonomous Database 



Wait for the Database to be Provisioned

    OCI will now provision your Autonomous Database. This can take a few minutes.



    Once the database is ready, you'll see its status as Running on the console.







Monday, 17 June 2024

CREATE NEW PDB BY CLONING AN EXISTING PDB

 Pre-Checks: -




 Close existing Pluggable Database PRODPDB: -


Open existing Pluggable Database PRODPDB in Read-Only: -


Create new directory at os level: -


CREATE NEW PDB (PRODPDB1) BY CLONING AN EXISTING PDB (PRODPDB): -


OPEN NEW PLUGGABLE DATABASE PRODPDB1: -


Close existing PLUGGABLE DATABASE FROM PRODPDB Read only MODE: -



Open existing PLUGGABLE DATABASE PRODPDB Read write MODE: -



Verification: - 


CautionYour use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only.

Saturday, 17 February 2024

Recovery from complete loss of all online redo log files using RMAN

Database name and version 

Member logfile Name

Remove redo log file for safer side I'm taking as backup.


Note: - If one or all of the online redo logfiles are delete then the database hangs and in the alert log file we can see the following error message:

Shutdown the database

Mount the database!

Using RMAN connect to the target database.

Recover database!

run {

set until sequence 12;

restore database;

recover database;

alter database open resetlogs;

}



CautionYour use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only.

Sunday, 28 January 2024

How to get WebLogic URL in EBS R12.2

Hello, everyone, Today I will show you how to find WebLogic URL, it just by extracting some parameters from the application context file.


Go to application tier and invoke application run file system environment file

[oracle@ebsapps ]$cd /u01/oracle/PROD/fs1/EBSapps/appl

[oracle@ebsapps appl]$ . APPSPROD_prod.env 

[oracle@ebsapps appl]$ grep -i "wls_admin" $CONTEXT_FILE


         <wls_admin_host oa_var="s_wls_admin_host">prod</wls_admin_host>

<wls_admin_domain oa_var="s_wls_admin_domain">testing.com</wls_admin_domain>

<wls_admin_user oa_var="s_wls_admin_user">weblogic</wls_admin_user>

<wls_adminport oa_var="s_wls_adminport" oa_type="PORT" base="7001" step="1" range="-1" label="WLS Admin Server Port">7001< wls_adminport>

 

So from the above output the url should look like this


http://prod.testing.com:7001/console


We can also find out the url using command


[oracle@ebsapps appl]$ echo "http://"$(cat $CONTEXT_FILE | grep s_webhost | cut -d '>' -f2 | cut -d '<' -f1)"."$(cat $CONTEXT_FILE | grep s_wls_admin_domain | cut -d '>' -f2 | cut -d '<' -f1)":"$(cat $CONTEXT_FILE | grep s_wls_adminport | cut -d '>' -f2 | cut -d '<' -f1)"/console"


http://prod.testing.com:7001/console

Sunday, 25 June 2023

Recreate the Oracle E-Business Suite (EBS) WLS (WebLogic Server) Domain

In order to have the EBS WLS domain recreated please do the following after taking a full backup of your environment:

1. In the Database Tier do the following:

    1.1. Log into the database tier.
    1.2. Source the environment.
    1.3  Ensure that database and listener are up and running. 

2. In the Applications Tier do the following:

    2.1. Source the RUN file system environment.
    2.2. Stop all middle tier services using $ADMIN_SCRIPTS_HOME/adstpall.sh.
    2.3. Ensure that no process is running from RUN file system.
    2.4. Take a backup of the context file.  Update s_adminservertimeout context variable value to 4000 and run AutoConfig.
    2.5. Execute below command:

        $ $FND_TOP/bin/txkrun.pl -script=ChkEBSDependecies -server=ALL_SERVERS

   Below prompts are shown by the script:

Enter the full path of Applications Context File [DEFAULT - ]: Complete path of the RUN context file
Enter the server start mode for the domain [DEFAULT - prod]: prod
Enter the APPS schema password :
Enter weblogic admin server password :

    Output(example):- 

      SUCCESS: VALID FMW HOME /u03/oracle/PROD/fs1/FMW_Home
      SUCCESS: VALID OHS HOME /u03/oracle/PROD/fs1/FMW_Home/webtier
      SUCCESS: VALID Node Manager Port 5553
      SUCCESS: VALID Node Manager Type plain
      SUCCESS: VALID Admin Server Port 7001
      SUCCESS: VALID OACORE Managed Server Port 7201
      SUCCESS: VALID FORMS Managed Server Port 7401
      SUCCESS: VALID OAFM Managed Server Port 7605
      SUCCESS: VALID FORMS-C4WS Managed Server Port 7807
      SUCCESS: VALID JRF TEMPLATE /u03/oracle/PROD/fs1/FMW_Home/oracle_common/common/templates/applications/jrf_template_11.1.1.jar
      SUCCESS: VALID EM TEMPLATE /u03/oracle/PROD/fs1/FMW_Home/oracle_common/common/templates/applications/oracle.em_11_1_1_0_0_template.jar
      SUCCESS: VALID EM EBS PLUGIN TEMPLATE /u03/oracle/PROD/fs1/FMW_Home/Oracle_EBS-app1/common/templates/applications/oracle.emai_ebs_template_11.1.1.jar
      SUCCESS: VALID UIX LIBRARY /u03/oracle/PROD/fs1/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix11.war
      SUCCESS: VALID PORTLET TEMPLATE /u03/oracle/PROD/fs1/FMW_Home/oracle_common/common/templates/applications/oracle.portlet_component_template_11.1.1.jar
      SUCCESS: VALID OWSM TEMPLATE /u03/oracle/PROD/fs1/FMW_Home/oracle_common/common/templates/applications/oracle.wsmpm_template_11.1.1.jar

    2.6. Recreate the domain by following below steps:  

        $ cd $FND_TOP/patch/115/bin
        $ perl txkEBSDomainConfig.pl

    2.7. Start the services and check the WLS domain is fine. 

Note:- when running txkEBSDomainConfig.pl you will be prompted "Enter the server start mode for the domain [DEFAULT - prod]:".Choose the default value of prod. Oracle Web Logic Server can be run in two different modes, either prod or dev, and the recommended option is to choose prod as it is safer. The dev mode allows to deploy unsigned java classes but is quicker than prod.


Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only