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