Install Oracle database 19c

 Step-by-Step Installation of Oracle 19c (Release 3) on Linux 8 Download Software

All prerequisite configurations have already been completed, including memory allocation, swap configuration, kernel parameter settings, creation of required groups and users, and profile setup.

Download Software 

https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html

 Unzip Software

Invoke ./runInstaller

Start the Oracle Universal Installer by issuing the  command.

Note :- Use of any information or materials provided on this website is solely at your own risk. The content is intended for educational purposes only

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

 Log in to Oracle Cloud Console

•     Go to the Oracle Cloud Console
•     Log in with your Oracle Cloud credentials.

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.

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: - 

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

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;

}

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

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