• views: 317
• date: 18 January 2022
• posted by: voska89

What you'll learn
Oracle EBS DBA
Freshers and Experienced EBS DBA's
Upgrade database from 12c to 19c
Cloud DBA's
Requirements
Oracle EBS DBA
Description
The course will help you to upgrade Oracle Database from 12c to 19c, here are the course contents
Upgrading Oracle EBS Database to 19c. 3
About the Upgrade. 3
Environment: 3
Here are support notes that we are going to follow.. 5
Let's download 19.3 from below links. 5
Highlevel Steps. 6
Before the Database Installation. 6
After the Database Upgrade. 6
Convert Database to Multitenant Architecture. 6
Before the Database Installation. 7
Run hcheck.sql 7
Apply required patches on R12.2.x. 8
Migrate Autoconfig to DB Tier: 10
Create the initialization parameter setup files: 11
Install Oracle Database 19c. 12
Install vncserver. 12
Disable firewall in Linux 7. 12
Upgrade Oracle Home from 19.3 to 19.12. 24
Apply the latest 19c Database Patches: 27
Create the nls/data/9idata directory. 28
Create appsutil and copy it to the database tier. 28
Install JRE 8. 29
Create the container database - DEVCDB. 29
Create the CDB MGDSYS schema. 53
Create the CDB TNS Files: 54
Shutdown the CDB now.. 56
Database upgrade. 57
Store the UTL_FILE_DIR parameter values. 57
Drop SYS.ENABLED$INDEXES. 59
Remove the MGDSYS schema (not applicable for our version) 59
Shut down the database listener. 60
Database Pre-Upgrade Steps: 60
Run the Pre-upgrade Tool: 61
Make changes to initDEV.ora file as follows. 73
Upgrade the database instance. 75
Issues and Solutions. 85
Perform patch post-install instructions. 88
After the Database Upgrade. 88
Run adgrants.sql 88
Grant create procedure privilege on CTXSYS. 89
Compile invalid objects. 89
Grant datastore access. 89
Convert Database to Multitenant Architecture: 91
Run the post PDB script 102
Modify initialization parameters: 108
How to Connect as SYSDBA without password into a PDB directly. 119
Verify ETCC patches are applied. 121
References: 122
Who this course is for
Who want to upgrade from 12c to 19c

Homepage

https://www.udemy.com/course/upgrade-oracle-ebs-database-to-19c/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.