Showing posts with label Oracle Database. Show all posts

Thursday, March 25, 2021

Migrating EBS to a Pluggable Database (PDB) on Oracle 19c: A Step-by-Step Experience

Migrating an Oracle E-Business Suite (EBS) database to a Pluggable Database (PDB) architecture is a critical step in modernizing and aligning with Oracle’s multitenant strategy. Recently, I completed a seamless migration of the OMMCLN EBS instance into a PDB under the OMCDB container, using Oracle's provided utilities. Here's a detailed breakdown of the journey — from pre-checks to the final plug-in and verification.

Environment Overview

Oracle Database Version: 19.0.0
EBS SID: OMMCLN
Target CDB: OMCDB
Server Host: db04.domainname.com
Operating System: Linux

Step 1: Run Pre-PDB Conversion Checks

oramcl @ db04.domainname.com/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/bin >sh PDB_descb.sh

Enter the APPS Password

Script Name : txkOnPremPrePDBCreationTasks.pl

Script Version : 120.0.12020000.15

Started : Thu Mar 25 09:25:44 uae 2021

Log File : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/txkOnPremPrePDBCreationTasks.log

-----------

Values used

-----------

DB Oracle Home : /d03/app/oracle/product/19.0.0/dbhome_1

OUT Directory : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log

Skip DB shutdown : No

EBS SID : OMMCLN

APPS Schema Username : apps

Is RAC? : No

Logical Hostname :

=========================

Validating oracle home...

=========================

Oracle Home: /d03/app/oracle/product/19.0.0/dbhome_1 exists.

===========================

Validating out directory...

===========================

Out directory: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log exists.

============================

Inside getDBHostDetails()...

============================

DB Hostname : db04

DB Domain : domainname.com

Logical hostname is not passed, hence using physical hostname details.

Logical hostname: db04.domainname.com

==========================

Inside setContextName()...

==========================

CONTEXT_NAME: OMMCLN_db04

============================

Inside setFileLocations()...

============================

=====================

Inside getDBName()...

=====================

Generating SQL file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/get_db_name.sql

SQL output file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/get_db_name.out

Spool File : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/spool_get_db_name.log

==========================

Inside executeSQLFile()...

==========================

Executing the SQL...

Execute SYSTEM command : sqlplus -s /nolog @/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/get_db_name.sql

==============================

Inside searchFileContents()...

==============================

log_file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/get_db_name.out

pattern: ERROR

=============================

Could not find the pattern...

=============================

Removing the file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/get_db_name.sql

EXIT STATUS: 0

Getting the value of DB Name...

db_name: OMMCLN

PDB_DESC_XML: /d03/app/oracle/product/19.0.0/dbhome_1/dbs/OMMCLN_PDBDesc.xml

INITPARAM_FILE: /d03/app/oracle/product/19.0.0/dbhome_1/dbs/OMMCLN_initparam.sql

DATATOP_FILE: /d03/app/oracle/product/19.0.0/dbhome_1/dbs/OMMCLN_datatop.txt

========================

Inside getDBVersion()...

========================

DB_VERSION = db190

=============================

Shutting down the database...

=============================

Shutdown mode : IMMEDIATE

Generating SQL file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/shutdown_IMMEDIATE.sql

SQL output file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/shutdown_IMMEDIATE.out

==========================

Inside executeSQLFile()...

==========================

Executing the SQL...

Execute SYSTEM command : sqlplus -s /nolog @/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/shutdown_IMMEDIATE.sql

==============================

Inside searchFileContents()...

==============================

log_file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/shutdown_IMMEDIATE.out

pattern: ERROR

=============================

Could not find the pattern...

=============================

EXIT STATUS: 0

SQL execution went through successfully.

LOG FILE: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/shutdown_IMMEDIATE.out.

========================

Starting the database...

========================

Startup mode : MOUNT

Generating SQL file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/startup_MOUNT.sql

SQL output file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/startup_MOUNT.out

==========================

Inside executeSQLFile()...

==========================

Executing the SQL...

Execute SYSTEM command : sqlplus -s /nolog @/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/startup_MOUNT.sql

==============================

Inside searchFileContents()...

==============================

log_file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/startup_MOUNT.out

pattern: ERROR

=============================

Could not find the pattern...

=============================

EXIT STATUS: 0

SQL execution went through successfully.

LOG FILE: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/startup_MOUNT.out.

==================================

Inside createPDBDescriptorXML()...

==================================

Inside backupPDBDescriptorXML()...

==================================

File /d03/app/oracle/product/19.0.0/dbhome_1/dbs/OMMCLN_PDBDesc.xml does not exist.

Generating SQL file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/create_pdb_desc_xml.sql

SQL output file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/create_pdb_desc_xml.out

==========================

Inside executeSQLFile()...

==========================

Executing the SQL...

Execute SYSTEM command : sqlplus -s /nolog @/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/create_pdb_desc_xml.sql

==============================

Inside searchFileContents()...

==============================

log_file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/create_pdb_desc_xml.out

pattern: ERROR

=============================

Could not find the pattern...

=============================

EXIT STATUS: 0

PDB Descriptor XML /d03/app/oracle/product/19.0.0/dbhome_1/dbs/OMMCLN_PDBDesc.xml created successfully.

LOG FILE: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/create_pdb_desc_xml.out.

=============================

Shutting down the database...

=============================

Shutdown mode : IMMEDIATE

Generating SQL file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/shutdown_IMMEDIATE.sql

SQL output file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/shutdown_IMMEDIATE.out

==========================

Inside executeSQLFile()...

==========================

Executing the SQL...

Execute SYSTEM command : sqlplus -s /nolog @/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/shutdown_IMMEDIATE.sql

==============================

Inside searchFileContents()...

==============================

log_file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/shutdown_IMMEDIATE.out

pattern: ERROR

=============================

Could not find the pattern...

=============================

EXIT STATUS: 0

SQL execution went through successfully.

LOG FILE: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_PRE_PDB_Thu_Mar_25_09_25_39_2021/shutdown_IMMEDIATE.out.

****************************************************************************************

* *

* IMPORTANT NOTE: DO NOT START THE DB TILL THE DATA FILES ARE MIGRATED *

* *

* IF DB IS STARTED, THEN PDB DESCRIPTOR XML GENERATED BECOMES INVALID *

* *

****************************************************************************************

Exiting from the script.

Ended: Thu Mar 25 09:36:59 uae 2021

=====

Step 2: Run the PDB Creation Script

After copying data files (or validating the existing ones), I proceeded to create the PDB using:

Key Inputs & Defaults:

Data directories: /d01, /d02, /d03
Copy Data Files: No
TDE: Disabled

Core Phases Executed:

Compatibility & Validation

PDB Descriptor XML checked
Charset and plugin violation checks passed
_PDB_NAME_CASE_SENSITIVE set to TRUE

PDB Creation

Created PDB using descriptor XML
Successfully converted from non-CDB to PDB

Cleanup & Finalization

Closed and reopened PDB
Saved PDB state

oramcl @ db04.domainname.com/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/bin >sh PDB_creation.sh

TDE is not enabled, WALLET credentials and SECRET KEY are not required.

Script Name : txkCreatePDB.pl

Script Version : 120.0.12020000.35

Started : Thu Mar 25 20:12:57 uae 2021

Log File : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/txkCreatePDB.log

-----------

Values used

-----------

Database Oracle Home : /d03/app/oracle/product/19.0.0/dbhome_1

CDB SID : OMCDB

PDB SID : OMMCLN

Non-CDB Name :

Non-CDB data directory :

PDB data directory :

Non-CDB undo tablespace :

PDB undo tablespace :

Copy data files : no

OUT Directory : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log

Ignore PDB State : No

Service Type : onpremise

Is TDE enabled : No

DB Unique Name : OMCDB

Prompt secret key : no

=========================

Validating oracle home...

=========================

Oracle Home: /d03/app/oracle/product/19.0.0/dbhome_1 exists.

===========================

Validating out directory...

===========================

Out directory: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log exists.

=============================

Validating DB service type...

=============================

Service Type: onpremise

Service type is valid.

============================

Inside getDBHostDetails()...

============================

DB Hostname : db04

DB Domain : domainname.com

============================

Inside setFileLocations()...

============================

PDB_DESC_XML: /d03/app/oracle/product/19.0.0/dbhome_1/dbs/OMMCLN_PDBDesc.xml

========================

Inside loadDataTops()...

========================

Reading the data tops from file /d03/app/oracle/product/19.0.0/dbhome_1/dbs/OMMCLN_datatop.txt

Processing entry for DATA_TOP_1-->/d01/app/oracle/oradata

Processing entry for DATA_TOP_2-->/d02/app/oracle/oradata

Processing entry for DATA_TOP_3-->/d03/app/oracle/oradata

============================

Inside promptDataTopDir()...

============================

Number of DATA_TOPs: 3

DATA_TOP_3

===========

Enter the non-CDB data top [/d03/app/oracle/oradata]:

Enter the corresponding PDB data top [/d03/app/oracle/oradata]:

DATA_TOP_1

===========

Enter the non-CDB data top [/d01/app/oracle/oradata]:

Enter the corresponding PDB data top [/d01/app/oracle/oradata]:

DATA_TOP_2

===========

Enter the non-CDB data top [/d02/app/oracle/oradata]:

Enter the corresponding PDB data top [/d02/app/oracle/oradata]:

======================

Inside setASMFlag()...

======================

data_first_char: /

DATA_ASM_FLAG: 0

Not checking keystore as TDE is not enabled.

============================

Inside validateDataTops()...

============================

================================

Validating data top directory...

================================

Data top directory /d02/app/oracle/oradata exists.

================================

Validating data top directory...

================================

Data top directory /d01/app/oracle/oradata exists.

================================

Validating data top directory...

================================

Data top directory /d03/app/oracle/oradata exists.

**** Setting ORACLE_SID to OMCDB for PDB Creation.

========================

Inside getDBVersion()...

========================

DB_VERSION = db190

**** Setting ORACLE_SID to OMCDB for PDB Creation.

=============================

Shutting down the database...

=============================

Shutdown mode : IMMEDIATE

Generating SQL file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/shutdown_IMMEDIATE.sql

SQL output file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/shutdown_IMMEDIATE.out

==========================

Inside executeSQLFile()...

==========================

Executing the SQL...

Execute SYSTEM command : sqlplus -s /nolog @/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/shutdown_IMMEDIATE.sql

==============================

Inside searchFileContents()...

==============================

log_file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/shutdown_IMMEDIATE.out

pattern: ERROR

=============================

Could not find the pattern...

=============================

EXIT STATUS: 0

SQL execution went through successfully.

LOG FILE: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/shutdown_IMMEDIATE.out.

========================

Starting the database...

========================

Startup mode : NONE

Generating SQL file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/startup_NONE.sql

SQL output file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/startup_NONE.out

==========================

Inside executeSQLFile()...

==========================

Executing the SQL...

Execute SYSTEM command : sqlplus -s /nolog @/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/startup_NONE.sql

==============================

Inside searchFileContents()...

==============================

log_file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/startup_NONE.out

pattern: ERROR

=============================

Could not find the pattern...

=============================

EXIT STATUS: 0

SQL execution went through successfully.

LOG FILE: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/startup_NONE.out.

=================================

Inside checkPDBCompatibility()...

=================================

File /d03/app/oracle/product/19.0.0/dbhome_1/dbs/OMMCLN_PDBDesc.xml exists.

Generating SQL file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/create_pdb_compatible.sql

SQL output file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/create_pdb_compatible.out

==========================

Inside executeSQLFile()...

==========================

Executing the SQL...

Execute SYSTEM command : sqlplus -s /nolog @/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/create_pdb_compatible.sql

==============================

Inside searchFileContents()...

==============================

log_file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/create_pdb_compatible.out

pattern: ERROR

=============================

Could not find the pattern...

=============================

EXIT STATUS: 0

PDB compatability check executed successfully.

LOG FILE: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/create_pdb_compatible.out.

==================================

Inside checkCharSetViolations()...

==================================

File /d03/app/oracle/product/19.0.0/dbhome_1/dbs/OMMCLN_PDBDesc.xml exists.

Generating SQL file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/check_char_set_violations.sql

SQL output file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/check_char_set_violations.out

==========================

Inside executeSQLFile()...

==========================

Executing the SQL...

Execute SYSTEM command : sqlplus -s /nolog @/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/check_char_set_violations.sql

==============================

Inside searchFileContents()...

==============================

log_file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/check_char_set_violations.out

pattern: ERROR|WARNING

=============================

Could not find the pattern...

=============================

EXIT STATUS: 0

No CHARACTER violations in the plugged in PDB 'OMMCLN'. Proceed further.

====================================

Inside checkPDBPluginViolations()...

====================================

File /d03/app/oracle/product/19.0.0/dbhome_1/dbs/OMMCLN_PDBDesc.xml exists.

Generating SQL file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/check_pdb_plugin_violations.sql

SQL output file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/check_pdb_plugin_violations.out

==========================

Inside executeSQLFile()...

==========================

Executing the SQL...

Execute SYSTEM command : sqlplus -s /nolog @/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/check_pdb_plugin_violations.sql

==============================

Inside searchFileContents()...

==============================

log_file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/check_pdb_plugin_violations.out

pattern: ERROR

=============================

Could not find the pattern...

=============================

EXIT STATUS: 0

No violations for the database 'OMMCLN' to be plugged in. Proceed further.

======================================

Inside checkPDBCaseSensitiveParam()...

======================================

Generating SQL file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/get_case_sensitive_param.sql

SQL output file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/get_case_sensitive_param.out

Spool File : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/spool_get_case_sensitive_param.log

==========================

Inside executeSQLFile()...

==========================

Executing the SQL...

Execute SYSTEM command : sqlplus -s /nolog @/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/get_case_sensitive_param.sql

Removing the file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/get_case_sensitive_param.sql

=============================

Inside searchFileContents()...

==============================

log_file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/get_case_sensitive_param.out

pattern: ERROR

=============================

Could not find the pattern...

=============================

EXIT STATUS: 0

Getting the parameter value.

Parameter _PDB_NAME_CASE_SENSITIVE is set to TRUE.

=======================================

Inside createPDBUsingDescriptorXML()...

=======================================

File /d03/app/oracle/product/19.0.0/dbhome_1/dbs/OMMCLN_PDBDesc.xml exists.

==================================

Inside checkPDBAlreadyCreated()...

==================================

Generating SQL file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/check_pdb_created.sql

SQL output file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/check_pdb_created.out

Spool File : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/spool_check_pdb_created.log

==========================

Inside executeSQLFile()...

==========================

Executing the SQL...

Execute SYSTEM command : sqlplus -s /nolog @/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/check_pdb_created.sql

Removing the file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/check_pdb_created.sql

==============================

Inside searchFileContents()...

==============================

log_file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/check_pdb_created.out

pattern: ERROR

=============================

Could not find the pattern...

=============================

EXIT STATUS: 0

Checking for PDB: OMMCLN

================================

Inside genDataTopMappingStr()...

================================

dir_mapping_str: '/d02/app/oracle/oradata', '/d02/app/oracle/oradata',

'/d01/app/oracle/oradata', '/d01/app/oracle/oradata',

'/d03/app/oracle/oradata', '/d03/app/oracle/oradata'

Generating SQL file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/create_pdb_using_desc_xml.sql

SQL output file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/create_pdb_using_desc_xml.out

PDB will be created using the existing non-CDB database files.

==========================

Inside executeSQLFile()...

==========================

Executing the SQL...

Execute SYSTEM command : sqlplus -s /nolog @/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/create_pdb_using_desc_xml.sql

==============================

Inside searchFileContents()...

==============================

log_file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/create_pdb_using_desc_xml.out

pattern: ERROR|SP2-0027

=============================

Could not find the pattern...

=============================

EXIT STATUS: 0

PDB is successfully created using descriptor XML /d03/app/oracle/product/19.0.0/dbhome_1/dbs/OMMCLN_PDBDesc.xml

LOG FILE: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/create_pdb_using_desc_xml.out.

==============================

Inside convertNonCDBToPDB()...

==============================

Generating SQL file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/convert_noncdb_to_pdb.sql

SQL output file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/convert_noncdb_to_pdb.out

==========================

Inside executeSQLFile()...

==========================

Executing the SQL...

Execute SYSTEM command : sqlplus -s /nolog @/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/convert_noncdb_to_pdb.sql

===========================

Inside searchSpoolFile()...

===========================

Spool file passed: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/spool_convert_noncdb_to_pdb.log

EXIT STATUS: 0

PDB conversion completed successfully.

LOG FILE: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/convert_noncdb_to_pdb.out.

================

Close the PDB...

================

==========================

Inside checkPDBStatus()...

==========================

Generating SQL file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/check_pdb_status.sql

SQL output file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/check_pdb_status.out

==========================

Inside executeSQLFile()...

==========================

Executing the SQL...

Execute SYSTEM command : sqlplus -s /nolog @/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/check_pdb_status.sql

==============================

Inside searchFileContents()...

==============================

log_file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/check_pdb_status.out

pattern: MOUNTED

================

Pattern found...

================

EXIT STATUS: 1

PDB already closed. Do nothing.

==================

Opening the PDB...

==================

Generating SQL file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/open_PDB.sql

SQL output file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/open_PDB.out

==========================

Inside executeSQLFile()...

==========================

Executing the SQL...

Execute SYSTEM command : sqlplus -s /nolog @/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/open_PDB.sql

==============================

Inside searchFileContents()...

==============================

log_file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/open_PDB.out

pattern: ERROR|WARNING

=============================

Could not find the pattern...

=============================

EXIT STATUS: 0

PDB opened successfully.

LOG FILE: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/open_PDB.out.

=======================

Saving the PDB state...

=======================

Generating SQL file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/save_PDB_state.sql

SQL output file : /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/save_PDB_state.out

==========================

Inside executeSQLFile()...

==========================

Executing the SQL...

Execute SYSTEM command : sqlplus -s /nolog @/d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/save_PDB_state.sql

==============================

Inside searchFileContents()...

==============================

log_file: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/save_PDB_state.out

pattern: ERROR

=============================

Could not find the pattern...

=============================

EXIT STATUS: 0

PDB state saved successfully.

LOG FILE: /d03/app/oracle/product/19.0.0/dbhome_1/appsutil/log/TXK_CREATE_PDB_Thu_Mar_25_20_12_57_2021/save_PDB_state.out.

Exiting from the script.

Ended: Thu Mar 25 21:07:54 uae 2021

========

Final Result: Migration Success!

The process wrapped up cleanly with zero errors or warnings across all stages. The PDB OMMCLN was successfully plugged into the OMCDB container, opened, and its state persisted.

Key Logs:

txkOnPremPrePDBCreationTasks.log
txkCreatePDB.log
SQL output files for each step

Lessons & Best Practices

Pre-Validation Is Critical
Running PDB_descb.sh ensures all parameters, paths, and Oracle Home settings are correct before you even begin the plug-in process.
Pay Attention to Oracle’s Warnings
Especially the one about not starting the database before PDB creation. It can invalidate the XML descriptor.
TDE Awareness
If TDE (Transparent Data Encryption) is enabled, you’ll need wallet credentials. Ours was disabled, which simplified the process.
Use Oracle’s Tools
The TXK scripts (txkCreatePDB.pl, txkOnPremPrePDBCreationTasks.pl) abstract many of the complex steps involved in this migration.

Friday, January 4, 2019

ORA-29278 SMTP Error – When Oracle Says Service Not Available

If you’ve ever tried sending emails from an Oracle database using UTL_SMTP, you’ve probably seen some cryptic errors pop up when something's not quite right.

We had encountered a classic:

`ORA-29278: SMTP transient error: 421 Service not availableORA-06512: at "SYS.UTL_SMTP", line 57ORA-06512: at "SYS.UTL_SMTP", line 140ORA-06512: at "SYS.UTL_SMTP", line 633ORA-06512: at line 1ORA-24247: network access denied by access control list (ACL)`

Error: ORA-29278: SMTP transient error: 421 Service not available ORA-06512: at "SYS.UTL_SMTP", line 57 ORA-06512: at "SYS.UTL_SMTP", line 140 ORA-06512: at "SYS.UTL_SMTP", line 633 ORA-06512: at line 1 ORA-24247: network access denied by access control list (ACL).Possible cause: Please check your Alert settings. If the problem persists, contact Integra Support

Step by step — until the alert email finally came through

Issue:

The root cause was a network ACL (Access Control List) restriction. Since Oracle 11g, network operations from the database require explicit permissions via ACLs.

In this case:

Oracle couldn't reach the SMTP server at <Ip address>:25
The database user AMHOME lacked proper ACL permissions

Creating and Assigning ACLs for the Particular Database user

Here’s the complete setup we executed to resolve the issue:

Step 1 Create ACL

BEGIN
  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL
         (acl                =>  'ccgmail.xml',
          description    =>  'CCGMAIL',
          principal        =>  'AMHOME',
          is_grant          =>  true,
          privilege        =>  'connect');  -- for connect 

  DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE
           (acl              =>  'ccgmail.xml',
            Principal    =>  'AMHOME',
            is_grant      =>  true,
            privilege     =>  'resolve'); -- for resolve 

  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL
            (acl                =>  'ccgmail.xml',
             host              =>  '<Ip address>',  
      lower_port   =>   25);
END;

Step 2 Add Privileges

We granted both connect and resolve privileges to allow outbound connections and DNS resolution:

BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE
( acl => 'ccgmail.xml',
principal => 'AMHOME',
is_grant => TRUE,
privilege => 'connect');
END;

commit;

BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE
(acl => 'ccgmail.xml',
Principal => 'AMHOME',
is_grant => true,
privilege => 'resolve');
END;
commit;

Step 3 Assign ACL to the SMTP Host and Port

BEGIN
  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL
        (acl                 =>  'ccgmail.xml',
         Host             =>  '192.168.80.16',
         lower_port  =>   '25');
END;
commit;

Note: Be sure to commit after each block to save changes.

Verify ACLs

To confirm everything was in place: SELECT * FROM dba_network_acls;

 select * from dba_network_acls;

SMTP server domain:   192.168.80.16 Port:   25

This showed our ccgmail.xml properly linked to the host and port.

Once all ACLs were in place, we tested sending an email using Oracle’s alert system:

From:	palaneandavar@domainname.ae	To:	palaneandavar@domainname.ae
Subject:	Integra: Alerts Test
Status	Your test email has been sent successfully to palaneandavar@domainname.ae

SMTP server: 192.168.80.16
Port: 25
From/To: palaneandavar@domainname.ae

Result:

Status: Your test email has been sent successfully to palaneandavar@domainname.ae

Pro Tips

ACL entries are case-sensitive for the principal (user/schema) name.
Don’t forget to grant both connect and resolve privileges — missing one can cause silent failures.
Always commit after changes to ACLs.
If your SMTP server is external or behind a firewall, ensure it's reachable from the DB host.
Still Getting ORA-29278?

If the error persists even after ACL configuration:

Double-check SMTP availability from the server itself using telnet <host> 25
Confirm no firewall rules are blocking the port
Make sure Oracle Listener or Network Services are not imposing restrictions

Wrapping Up

What looked like an intimidating ORA error turned out to be a straightforward ACL misconfiguration. With a few precise PL/SQL blocks and a bit of patience, we were back to sending alert emails like clockwork.

Lesson learned: Oracle doesn’t just trust anyone to send emails — you have to earn it with the right ACLs!

Have a similar use case with different ports or external domains? Drop a comment or reach out — happy to help fine-tune your setup.

Till next time, keep those emails flowing and the errors at bay.

Monday, November 12, 2018

Configuring a Standby Database Using RMAN Active Duplication

Setting up a physical standby database is critical for disaster recovery and high availability in Oracle environments. In this guide, we’ll walk through creating a standby database using RMAN Active Duplication, streaming data directly from the primary database over the network without the need for backup files.

In this exercise we use Oracle Database, with the following configuration:

Primary DB: OMTSTCCB
Standby DB: OMDRCCB

Step 1: Enable Force Logging on the Primary

Force Logging ensures that all changes, including direct path loads, are logged in the redo logs and can be propagated to the standby database.

Enable the database with the Force logging mode.

SQL> ALTER DATABASE FORCE LOGGING;

Database altered.

Step 2: Verify Archive Log Mode

SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

Step 3: Check and Add Redo Log Groups

We need to add the standby redo logs (SRLs), which are required for the standby database to receive redo data from the primary:

Check the Log and logfile details

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- ----------
1 1 4 52428800 512 1 NO CURRENT 13738981 30-AUG-17 2.8147E+14 0
2 1 2 52428800 512 1 YES ACTIVE 13738966 30-AUG-17 13738976 30-AUG-17 0
3 1 3 52428800 512 1 YES ACTIVE 13738976 30-AUG-17 13738981 30-AUG-17 0

SQL>

SQL> select * from v$logfile;

GROUP# STATUS TYPE MEMBER IS_ CON_ID

---------- ------- ------- -------------------------------------------------- --- ----------

3 ONLINE /u03/app/oracle/oradata/OMTSTCCB/redo03.log NO 0

2 ONLINE /u03/app/oracle/oradata/OMTSTCCB/redo02.log NO 0

1 ONLINE /u03/app/oracle/oradata/OMTSTCCB/redo01.log NO 0

Add the Stand by redo log in the Primary

SQL> alter database add standby logfile '/u03/app/oracle/oradata/OMTSTCCB/redost01.log' size 512M;

Database altered.

SQL> alter database add standby logfile '/u03/app/oracle/oradata/OMTSTCCB/redost02.log' size 512M;

Database altered.

SQL> alter database add standby logfile '/u03/app/oracle/oradata/OMTSTCCB/redost03.log' size 512M;

Database altered.

SQL> select * from v$logfile;

GROUP# STATUS TYPE MEMBER IS_ CON_ID

---------- ------- ------- -------------------------------------------------- --- ----------

3 ONLINE /u03/app/oracle/oradata/OMTSTCCB/redo03.log NO 0

2 ONLINE /u03/app/oracle/oradata/OMTSTCCB/redo02.log NO 0

1 ONLINE /u03/app/oracle/oradata/OMTSTCCB/redo01.log NO 0

4 STANDBY /u03/app/oracle/oradata/OMTSTCCB/redost01.log NO 0

5 STANDBY /u03/app/oracle/oradata/OMTSTCCB/redost02.log NO 0

6 STANDBY /u03/app/oracle/oradata/OMTSTCCB/redost03.log NO 0

6 rows selected.

SQL>

We are able to see the standby log file in the Primary that we had added

=========

Step 4: Duplicate the Database Using RMAN (Active Duplication)

Switch to the standby server and run RMAN with the following command:

From the stand by database after starting the instance in no mount state execute the command

RMAN> duplicate target database for standby from active database nofilenamecheck;

Starting Duplicate Db at 03-SEP-17
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=3763 device type=DISK

contents of Memory Script:
{
backup as copy reuse
targetfile '/u03/app/oracle/product/12.1.0/dbhome_1/dbs/orapwOMTSTCCB' auxiliary format
'/u03/app/oracle/product/12.1.0/dbhome_1/dbs/orapwOMDRCCB' ;
}
executing Memory Script

Starting backup at 03-SEP-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=381 device type=DISK
Finished backup at 03-SEP-17

contents of Memory Script:
{
restore clone from service 'OMTSTCCB' standby controlfile;
}
executing Memory Script

Starting restore at 03-SEP-17
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service OMTSTCCB
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
output file name=/u03/app/oracle/oradata/OMDRCCB/control01.ctl
Finished restore at 03-SEP-17

contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script:
{
set newname for tempfile 1 to
"/u03/app/oracle/oradata/OMDRCCB/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/u03/app/oracle/oradata/OMDRCCB/system01.dbf";
set newname for datafile 2 to
"/u03/app/oracle/oradata/OMDRCCB/cists01.dbf";
set newname for datafile 3 to
"/u03/app/oracle/oradata/OMDRCCB/sysaux01.dbf";
set newname for datafile 4 to
"/u03/app/oracle/oradata/OMDRCCB/undotbs01.dbf";
set newname for datafile 6 to
"/u03/app/oracle/oradata/OMDRCCB/users01.dbf";
restore
from service 'OMTSTCCB' clone database
;
sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u03/app/oracle/oradata/OMDRCCB/temp01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 03-SEP-17
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service OMTSTCCB
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /u03/app/oracle/oradata/OMDRCCB/system01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:15
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service OMTSTCCB
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00002 to /u03/app/oracle/oradata/OMDRCCB/cists01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:15
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service OMTSTCCB
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u03/app/oracle/oradata/OMDRCCB/sysaux01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:05:05
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service OMTSTCCB
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to /u03/app/oracle/oradata/OMDRCCB/undotbs01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service OMTSTCCB
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00006 to /u03/app/oracle/oradata/OMDRCCB/users01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
Finished restore at 03-SEP-17

sql statement: alter system archive log current

contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=5 STAMP=953735223 file name=/u03/app/oracle/oradata/OMDRCCB/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=6 STAMP=953735223 file name=/u03/app/oracle/oradata/OMDRCCB/cists01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=7 STAMP=953735223 file name=/u03/app/oracle/oradata/OMDRCCB/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=8 STAMP=953735223 file name=/u03/app/oracle/oradata/OMDRCCB/undotbs01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=9 STAMP=953735223 file name=/u03/app/oracle/oradata/OMDRCCB/users01.dbf
Finished Duplicate Db at 03-SEP-17

RMAN> exit

As Rman does all the manual task like as below

Copies the password file
Restores the standby control file from the primary
Mounts the standby database
Restores all datafiles via network from primary
Switches to the restored datafile copies
Archives the current log on the primary

All operations are logged with elapsed time, making it easy to monitor the progress and performance.

Final Result

After RMAN finishes the duplication, the standby database (OMDRCCB) is mounted and ready to start managed recovery. This standby is a real-time copy of the primary and can now be integrated into your Data Guard configuration for high availability and disaster recovery.

Notes

NOFILENAMECHECK is used when the primary and standby databases reside on the same storage layout

Ensure the listener and TNS are properly configured for the service names (OMTSTCCB and OMDRCCB).

The Data Guard broker or manual setup can be used to manage log shipping and role transitions after this step.

Conclusion

Using RMAN Active Duplication simplifies the creation of a physical standby by eliminating the need for manual backups or file copies. With just a few steps, a fully functional standby can be created directly from the primary database, making your DR setup faster and more reliable.

Thursday, June 12, 2014

Installing 12c Enterprise manager

Installation of 11g database with EM

Step 1: Install the 11g database with software-only installation mode

The the 11.2.3.3 database as the software only installation and later we can configure the database with the Seeded Template

Step 2: Prepare the EM and DBCA templates.

oracle @ tstapps/u04/seaded_templete >cd /u02/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates

oracle @ tstapps/u02/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates >unzip /u04/seaded_templete/11.2.0.3_Database_Template_for_EM12_1_0_4_HPI.zip

Archive: /u04/seaded_templete/11.2.0.3_Database_Template_for_EM12_1_0_4_HPI.zip

inflating: set_repo_param_11.2.0.3_Database_SQL_for_EM12_1_0_4_Large_deployment.sql

inflating: set_repo_param_11.2.0.3_Database_SQL_for_EM12_1_0_4_Medium_deployment.sql

inflating: set_repo_param_11.2.0.3_Database_SQL_for_EM12_1_0_4_Small_deployment.sql

inflating: shpool_11.2.0.3_Database_SQL_for_EM12_1_0_4.sql

inflating: 11.2.0.3_Database_Template_for_EM12_1_0_4_Large_deployment.dbc

inflating: 11.2.0.3_Database_Template_for_EM12_1_0_4_Medium_deployment.dbc

inflating: 11.2.0.3_Database_Template_for_EM12_1_0_4_Small_deployment.dbc

inflating: 11.2.0.3_Database_Template_for_EM12_1_0_4.dfb

inflating: 11.2.0.3_Database_Template_for_EM12_1_0_4.ctl

oracle @ tstapps/u02/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates >

Step 3: Configure the database with the Dbca according to the number of users accessing the system

Once the database is create Configure the Listener and tns to connect the database from the weblogic ..

Step 4
Install the Enterprise Manager 12c

oraem @ tstapps/u04/apps/oracle/fmw/oms/sysman/jlib >/opt/java6/bin/java -jar emclikit.jar client -install_dir=/u04/apps/oracle/fmw/EMCLI

Oracle Enterprise Manager 12c Release 4.
Copyright (c) 2012, 2014 Oracle Corporation. All rights reserved.

EM CLI client-side install completed successfully.
Execute "emcli help setup" from the EM CLI home (the directory where you have installed EM CLI) for further instructions.
oraem @ tstapps/u04/apps/oracle/fmw/oms/sysman/jlib >

oraem @ tstapps/u04/apps/oracle/fmw/EMCLI >./emcli setup -dir=/u04/apps/oracle/fmw/EMCLI/SETUP -url=https://tstapps.domainname.com:7799/em -user=SYSMAN

Oracle Enterprise Manager 12c Release 4.
Copyright (c) 1996, 2014 Oracle Corporation and/or its affiliates. All rights reserved.

Enter password

Warning: This certificate has not been identified as trusted in the local trust store
--------------------------------------
[
[
Version: V3
Subject: CN=tstapps.domainname.com, C=US, ST=CA, L=EnterpriseManager on tstapps.domainname.com, OU=EnterpriseManager on tstapps.domainname.com, O=EnterpriseManager on tstapps.domainname.com
Signature Algorithm: SHA512withRSA, OID = 1.2.840.113549.1.1.13

Key: Sun RSA public key, 1024 bits
modulus: 109579966219704234110006406303733236725844884000059127340771572209689250936242719174746658790668592916154609818754483288673373654068813162099912669553589493650410550312841319456077872040205850853782240467090618733039915186700707052779146344294681460898430439738694891938108047902037454938505342793782908565921
public exponent: 65537
Validity: [From: Mon Nov 24 08:56:43 GMT+04:00 2014,
               To: Fri Nov 22 08:56:43 GMT+04:00 2024]
Issuer: CN=tstapps.domainname.com, C=US, ST=CA, L=EnterpriseManager on tstapps.domainname.com, OU=EnterpriseManager on tstapps.domainname.com, O=EnterpriseManager on tstapps.domainname.com
SerialNumber: [    936b5864 7a18983c]

Certificate Extensions: 2
[1]: ObjectId: 2.5.29.19 Criticality=true
BasicConstraints:[
CA:true
PathLen:2147483647
]

[2]: ObjectId: 2.5.29.15 Criticality=true
KeyUsage [
DigitalSignature
Non_repudiation
Key_CertSign
Crl_Sign
]

]
Algorithm: [SHA512withRSA]
Signature:
0000: 73 99 D2 88 AD 47 31 E9   BE EB 04 96 D7 44 79 83 s....G1......Dy.
0010: B5 E9 B0 54 3F 5E 28 72   99 31 89 0B 73 F6 FD C8 ...T?^(r.1..s...
0020: 9E 0E 8A EB 66 3A EC 72   C0 81 62 BE B6 03 4F 6A ....f:.r..b...Oj
0030: 6B FA 6F 66 8F 6A 0E E8   B6 52 F0 90 F0 EF 6F 08 k.of.j...R....o.
0040: 52 59 D3 83 CA 7D E8 86   50 95 01 D0 67 20 D4 B1 RY......P...g ..
0050: C9 97 DC B0 FF 83 AE 44   BA 3A 0D 7E 7F 70 C9 AB .......D.:...p..
0060: FF 9C 03 63 AE F4 55 9B   4C 74 47 60 33 1D E5 70 ...c..U.LtG`3..p
0070: 36 EC 76 F7 6B 77 17 58   6D 43 AD F2 30 EB 90 2C 6.v.kw.XmC..0..,

]
--------------------------------------
Warning: This certificate could be compromised

Warning: This certificate has not been identified as trusted in the local trust store
--------------------------------------
[
[
Version: V3
Subject: CN=tstapps.domainname.com
Signature Algorithm: SHA512withRSA, OID = 1.2.840.113549.1.1.13

Key: Sun RSA public key, 1024 bits
modulus: 137689552006624453421122670544003500177504583070199134715720091582560289275088846286198018337654831494888584462232334122475147426368056079752899280438831425191191457179881748757493880109752494876436285796851033866050328702804665382129465012052946985008470596755143921734083083037764194411990517826273700443501
public exponent: 65537
Validity: [From: Mon Nov 24 08:56:47 GMT+04:00 2014,
               To: Fri Nov 22 08:56:47 GMT+04:00 2024]
Issuer: CN=tstapps.domainname.com, C=US, ST=CA, L=EnterpriseManager on tstapps.domainname.com, OU=EnterpriseManager on tstapps.domainname.com, O=EnterpriseManager on tstapps.domainname.com
SerialNumber: [    0422a727 c484b252 94]

Certificate Extensions: 3
[1]: ObjectId: 2.5.29.19 Criticality=true
BasicConstraints:[
CA:false
PathLen: undefined
]

[2]: ObjectId: 2.5.29.15 Criticality=true
KeyUsage [
DigitalSignature
Non_repudiation
Key_Encipherment
Key_Agreement
]

[3]: ObjectId: 2.5.29.14 Criticality=false
SubjectKeyIdentifier [
KeyIdentifier [
0000: 8F FE 14 0B DB 9C 83 39   3D 17 C1 1D 05 83 BB 68 .......9=......h
0010: 46 D4 38 05                                        F.8.
]
]

]
Algorithm: [SHA512withRSA]
Signature:
0000: 83 0F 28 16 57 92 08 2C   C2 19 DD 4C 07 C3 28 ED ..(.W..,...L..(.
0010: 9A 3C 78 A8 57 55 CA 26   FC EF 35 53 21 6E FF 7F .<x.WU.&..5S!n..
0020: AC A2 74 F6 AB 29 C5 92   8B 9F 04 65 17 B9 BB A9 ..t..).....e....
0030: 50 85 9A 7D 2D 38 8C 36   E9 53 58 EA A5 FE A2 3C P...-8.6.SX....<
0040: AF A9 6B 7A 9A 65 0D 26   4A 45 1B 43 E9 66 E4 8C ..kz.e.&JE.C.f..
0050: 67 9B 49 73 38 B1 63 7E   6A 81 5D DB F3 78 5A 9E g.Is8.c.j.]..xZ.
0060: 5B 1B 5B F5 C2 82 7A 39   F1 80 21 BD 06 AD C5 94 [.[...z9..!.....
0070: 5B E1 0F 15 24 5F 6A 0B   75 3B 67 6B 1E CD B2 DE [...$_j.u;gk....

]
--------------------------------------
Do you trust the certificate chain? [yes/no] yes
Emcli setup successful
oraem @ tstapps/u04/apps/oracle/fmw/EMCLI >

oraem @ tstapps/u04/apps/oracle/fmw/EMCLI >./emcli import_update_catalog -file=/u04/apps/p9348486_112000_Generic.zip -omslocal
Processing catalog for Middleware Profiles and Gold Images
Processing update: Middleware Profiles and Gold Images - Three Fusion Middleware Provisioning Profiles with different heap size configuration
Processing catalog for Agent Software
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for HP-UX PA-RISC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for HP-UX PA-RISC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for HP-UX PA-RISC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for HP-UX PA-RISC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Linux x86
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Linux x86
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Linux x86
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Linux x86
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Linux x86-64
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Linux x86-64
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Linux x86-64
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Linux x86-64
Processing update: Agent Software - Agent Software (12.1.0.4.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for IBM: Linux on System z
Processing update: Agent Software - Agent Software (12.1.0.3.0) for IBM: Linux on System z
Processing update: Agent Software - Agent Software (12.1.0.2.0) for IBM: Linux on System z
Processing update: Agent Software - Agent Software (12.1.0.1.0) for IBM: Linux on System z
Processing update: Agent Software - Agent Software (12.1.0.3.0) for HP-UX Itanium
Processing update: Agent Software - Agent Software (12.1.0.2.0) for HP-UX Itanium
Processing update: Agent Software - Agent Software (12.1.0.1.0) for HP-UX Itanium
Processing catalog for Management Connector
Processing update: Management Connector -
             IBM TEC Connector - 12.1.0.3.0

Processing update: Management Connector -
             IBM TEC Connector - 12.1.0.2.0

Processing update: Management Connector -
             Microsoft SCOM R2 Connector - 12.1.0.3.0

Processing update: Management Connector -
             Microsoft SCOM R2 Connector - 12.1.0.2.0

Processing update: Management Connector -
             Microsoft SCOM preR2 Connector - 12.1.0.3.0

Processing update: Management Connector -
             Microsoft SCOM preR2 Connector - 12.1.0.2.0

Processing update: Management Connector -
             Microsoft SCOM 2012 Connector - 12.1.0.1.0

Processing update: Management Connector - BMC Remedy 7.6, 8.0, 8.1 Service Desk Connector - 12.1.0.3.0
Processing update: Management Connector - BMC Remedy 7.6.04 Service Desk Connector - 12.1.0.2.0
Processing update: Management Connector - BMC Remedy Change Management Connector - 12.1.0.1.0
Processing update: Management Connector -
            IBM Tivoli Netcool/OMNIbus Connector - 12.1.0.3.0

Processing update: Management Connector -
            IBM Tivoli Netcool/OMNIbus Connector - 12.1.0.2.0

Processing update: Management Connector -
             HP Service Manager 9 Connector - 12.1.0.1.0

Processing update: Management Connector -
             HP Service Manager 7.1 Connector - 12.1.0.2.0

Processing update: Management Connector -
             HP Service Manager 7.0 Connector - 12.1.0.2.0

Processing update: Management Connector -
             HP Operations Manager UNIX Connector - 12.1.0.3.0

Processing update: Management Connector -
             HP Operations Manager UNIX Connector - 12.1.0.2.0

Processing update: Management Connector -
             CA Service Desk Connector - 12.1.0.3.0

Processing update: Management Connector -
             CA Service Desk Connector - 12.1.0.2.0

Processing catalog for Extensibility Development Kit
Processing catalog for Plug-in
Processing update: Plug-in - Enterprise Manager for Oracle Virtual Desktop Infrastructure
Processing update: Plug-in - Enterprise Manager for Oracle Virtual Desktop Infrastructure
Processing update: Plug-in - Enterprise Manager for Oracle Utilities provides management and monitoring for the Oracle Utilities area.
Processing update: Plug-in - Application Management Pack for Oracle Utilities provides management and monitoring for the Oracle Utilities area
Processing update: Plug-in - Application Management Pack for Oracle Utilities provides management and monitoring for the Oracle Utilities area
Processing update: Plug-in - Enterprise Manager for Oracle Enterprise Taxation and Policy Management provides management and monitoring for the Oracle Enterprise Taxation and Policy Management area.
Processing update: Plug-in - Application Management Pack for Oracle Enterprise Taxation and Policy Management provides management and monitoring for the Oracle Enterprise Taxation and Policy Management area
Processing update: Plug-in - Application Management Pack for Oracle Enterprise Taxation and Policy Management provides management and monitoring for the Oracle Enterprise Taxation and Policy Management area
Processing update: Plug-in - Enables management capabilities for Oracle VM in Enterprise Manager.
Processing update: Plug-in - Enterprise Manager for Zero Data Loss Recovery Appliance provides comprehensive management functionality for Zero Data Loss Recovery Appliance.
Processing update: Plug-in - Enterprise Manager for Sun Ray Software
Processing update: Plug-in - Enterprise Manager for Oracle ZFS Storage Appliances
Processing update: Plug-in - Enterprise Management Plug-in for Oracle ZFS Storage Appliances
Processing update: Plug-in - Management Plug-in for the Sun ZFS Storage Appliance Family
Processing update: Plug-in - Management Plug-in for the Sun ZFS Storage Appliance Family
Processing update: Plug-in - Enterprise Manager for OUD
Processing update: Plug-in - Enterprise Manager for Oracle Key Manager
Processing update: Plug-in - Enterprise Manager for Oracle Flash Storage System
Processing update: Plug-in - Enterprise Manager for Oracle Instant Messaging Server is used for monitoring/managing the Oracle Instant Messaging Server
Processing update: Plug-in - Enterprise Manager for MySQL Database
Processing update: Plug-in - Enterprise Manager for Oracle Tuxedo
Processing update: Plug-in - Enterprise Manager for Oracle Tuxedo
Processing update: Plug-in - Management Pack for Oracle Tuxedo 12.1.0.1.0
Processing update: Plug-in - Enterprise Manager for Oracle GoldenGate
Processing update: Plug-in - Enterprise Manager for Oracle GoldenGate
Processing update: Plug-in - Enterprise Manager for Sybase ASE. Plugin provides comprehensive monitoring Sybase ASE Environments.
Processing update: Plug-in - Enterprise Manager for Ops Center Infrastructure stack
Processing update: Plug-in - Enterprise Manager for Ops Center Infrastructure stack
Processing update: Plug-in - Ops Center Infrastructure stack management plug-in.
Processing update: Plug-in - Ops Center Infrastructure stack management plug-in.
Processing update: Plug-in - Enterprise Manager for Microsoft SQL Server
Processing update: Plug-in - Enterprise Manager for DB2. Plugin provides comprehensive monitoring of DB2 environments.
Processing update: Plug-in - Enterprise Manager for Oracle TimesTen In-Memory Database
Processing update: Plug-in - Enterprise Manager for Oracle Communications enables management of Oracle Communications products
Processing update: Plug-in -
                Enterprise Manager for Pillar Axiom

Processing update: Plug-in - Enterprise Manager for PeopleSoft
Processing update: Plug-in - Enterprise Manager for PeopleSoft
Processing update: Plug-in -
    Enterprise Manager for Jdedwards EnterpriseOne consists of monitoring and management for Oracle Jdedwards EnterpriseOne system.

Processing update: Plug-in - Oracle Jdedwards EnterpriseOne Plugin consists of monitoring and management for Oracle Jdedwards EnterpriseOne system.
Processing update: Plug-in - Enterprise Manager for Oracle E-Business Suite consists of System Management and Change Management Feature Sets
Processing update: Plug-in - Oracle Application Management Pack for Oracle E-Business Suite consists of System Management and Change Management Feature Sets
Processing update: Plug-in - Oracle Application Management Pack for Oracle E-Business Suite consists of System Management and Change Management Feature Sets
Processing catalog for Test Data Management templates
Processing update: Test Data Management templates - Mask template Fusion Rel v1.x Combined All Family
Processing update: Test Data Management templates - Data Masking template for Oracle E-Business suite 12.1.3 (Standard Model)
Processing update: Test Data Management templates - Data Masking template for Oracle E-Business suite 12.1.3 (JG model)
Processing update: Test Data Management templates - Preparation script required for Oracle E-Business Suite masking process
Processing update: Test Data Management templates - ADM template Fusion Rel v1.x Combined All Family
Processing update: Test Data Management templates - Application Data Model Template for Oracle E-Business Suite 12.1.3(Standard Model)
Processing update: Test Data Management templates - Application Data Model Template for Oracle E-Business Suite 12.1.3(JG Model)
Processing catalog for Informational
Processing update: Informational - Announcing New and Updated Cloud Management Capabilites for Database, Infrastructure, and Testing
Processing update: Informational - Enterprise Manager Cloud Control 12c Release 2 Plug-in Update 1 (12.1.0.2) now available on OTN
Processing update: Informational - Enterprise Manager Cloud Control 12C white papers available now on Oracle Technology Network
Processing update: Informational - Integration of Oracle Business Intelligence (BI) Publisher 11.1.1.5.0 with Enterprise Manager Cloud Control 12.1.0.1
Processing update: Informational - Management of Oracle VM 3.1.1 now available with Oracle Enterprise Manager 12c
Processing update: Informational - Oracle Enterprise Manager Cloud Control Mobile now available for Apple iPhone
Processing catalog for Provisioning Bundle

Successfully uploaded the Self Update catalog to Enterprise Manager. Use the Self Update Console to view and manage updates.
oraem @ tstapps/u04/apps/oracle/fmw/EMCLI >

Thursday, March 25, 2021

Migrating EBS to a Pluggable Database (PDB) on Oracle 19c: A Step-by-Step Experience

Environment Overview

Step 1: Run Pre-PDB Conversion Checks

Step 2: Run the PDB Creation Script

Key Inputs & Defaults:

Core Phases Executed:

Compatibility & Validation

PDB Creation

Cleanup & Finalization

Final Result: Migration Success!

Key Logs:

Lessons & Best Practices

Friday, January 4, 2019

ORA-29278 SMTP Error – When Oracle Says Service Not Available

ORA-29278: SMTP transient error: 421 Service not availableORA-06512: at "SYS.UTL_SMTP", line 57ORA-06512: at "SYS.UTL_SMTP", line 140ORA-06512: at "SYS.UTL_SMTP", line 633ORA-06512: at line 1ORA-24247: network access denied by access control list (ACL)

Issue:

Creating and Assigning ACLs for the Particular Database user

Step 1 Create ACL

Step 2 Add Privileges

Step 3 Assign ACL to the SMTP Host and Port

Verify ACLs

Still Getting ORA-29278?

Wrapping Up

Monday, November 12, 2018

Configuring a Standby Database Using RMAN Active Duplication

Step 1: Enable Force Logging on the Primary

Step 2: Verify Archive Log Mode

Step 3: Check and Add Redo Log Groups

Step 4: Duplicate the Database Using RMAN (Active Duplication)

RMAN> duplicate target database for standby from active database nofilenamecheck;

Final Result

Notes

Conclusion

Thursday, June 12, 2014

Installing 12c Enterprise manager

Installation of 11g database with EM

Step 3: Configure the database with the Dbca according to the number of users accessing the system

Step 4 Install the Enterprise Manager 12c

oraem @ tstapps/u04/apps/oracle/fmw/oms/sysman/jlib >/opt/java6/bin/java -jar emclikit.jar client -install_dir=/u04/apps/oracle/fmw/EMCLI

oraem @ tstapps/u04/apps/oracle/fmw/EMCLI >./emcli setup -dir=/u04/apps/oracle/fmw/EMCLI/SETUP -url=https://tstapps.domainname.com:7799/em -user=SYSMAN

`ORA-29278: SMTP transient error: 421 Service not availableORA-06512: at "SYS.UTL_SMTP", line 57ORA-06512: at "SYS.UTL_SMTP", line 140ORA-06512: at "SYS.UTL_SMTP", line 633ORA-06512: at line 1ORA-24247: network access denied by access control list (ACL)`

Step 4
Install the Enterprise Manager 12c