Upgrade to Oracle Database 19c from 12c using autoupgrade.jar In this demonstration, I have upgraded Oracle Database from 12.2.0.1 to 19.0.0.0 which is running on Oracle Linux 7.5 There were two methods till 18c for upgrade, 1. DBUA2. Manual – Using preupgrade.jar However, in Oracle Database 19c there’s new method of upgrading the database is introduced. That is using Auto Upgrade utility. Database can directly be upgraded to 19c from below releases.11.2.0.3, 11.2.0.4, 12.1.0.1, 12.1.0.2, 12.2.0.1 and 18 I assume […]
Tag: Profile
Small article on Oracle Profile and how it can be used to limit database resources. In database world, Oracle is one of the most popular and well known databases. Resource control of a particular user across the database is very important aspect to run a successful database. In this small article we’ll see what role ‘Oracle Profile’ plays to make user control easier in a reference with Resource. The way, to control user privileges we can create a role and assign