Hi Readers Finally, I’ve successfully passed 1Z0-074, Upgrade Oracle DBA 11g or 12c to 12c R2. It was almost more than 3 months that I’ve been preparing for this. The Exam contains 75 questions related to Oracle Database 12cR2 New Features. To earn this certification you need to get 63% marks. This was the result of […]
In the last post, we installed Oracle 19c Database Software by running RPM Package. Now, we are going to create and configure a Database with default Setting.Log in as root and run the below command to configure an Oracle Database instance.
[root@oracle19c dbhome_1]# /etc/init.d/oracledb_ORCLCDB-19c configure
Configuring Oracle Database ORCLCDB.
[FATAL] [DBT-06103] The port (1,521) is already in use.
ACTION: Specify a free port.
Database configuration failed.
To resolve the above error, make sure /etc/hosts has configured properly and ping […]
Oracle 19c can be installed on Oracle Linux using an RPM. This article describes the RPM installation of Oracle Database 19c 64-bit on Oracle Linux 7 (OL7) 64-bit. The naming convention for RPM packages is name–version–release.architecture.rpm. Installing Oracle Database RPM Manually Login as Root and Download and install the Oracle Preinstallation RPM
[root@oracle19c sw]# curl -o oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 18244 100 18244 0 0 85585 0 --:--:-- --:--:-- --:--:-- 85652
[root@oracle19c sw]# yum -y localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
Loaded plugins: langpacks, ulninfo
Examining oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm: oracle-database-preinstall-18c-1.0-1.el7.x86_64
oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm: does not update installed package.
Nothing to do
Download the .rpm […]
I am listing here 55 articles which I write and are published on the different Oracle Technology Network (OTN), different Oracle User Group (OUG) and ToadWorld. OTN Spanish Oracle Cloud: Creación de Configuración Oracle RAC en Cloud Oracle Cloud: Creando base de datos en la nube en base a “backup” existente (Parte I) Oracle Cloud: […]
Database 18c Patch As of the Release date (16-Jan-2019), the only Oracle Database 18 software that is available is 18.1.0 for on-premise Exadata. Then afterwards, it was available for on-premise as well. More Info: Database 18 Proactive Patch Information (Doc ID 2369376.1) OPatch Utility Information You must use the OPatch utility version 126.96.36.199.14 or later to apply this patch. Oracle […]
Manual upgrading Oracle database 11gR2 to 19c If you want to know how we upgrade an 188.8.131.52 database to 184.108.40.206.0 using DBUA, click here. This article explains how to upgrade 220.127.116.11 and above, and 18.104.22.168, 22.214.171.124, 18c to 126.96.36.199.0 manually. Manually upgrading to 19c There are many DBAs who don’t want to follow the recommended […]
Written by Oracle Certified Master Skant Gupta and Oracle Certified Professional Mohit Sharma are diligently planned to direct the readers about the usage of Oracle Autonomous Database. The primary target audience is Oracle DBAs and Oracle Cloud DBA’s. This book has been diligently planned for all levels of DBA experts. Coming right from the real-world […]
In this post, you use the ADMIN user schema. You store the Auth Token created in the previous post along with the username, as a credential under an ADMIN schema. Connect to ADMIN user using SQL Developer. Use the create_credential procedure of the DBMS_CLOUD package to store the object store credentials in your ADMIN schema. Set the […]
In this post, we are going to stop & start the ADWC database on OCI. We assume that you must have OCI account with valid credentials and compartments. Stopping your ADWC instance Go to the Cloud Console you used during the provisioning exercise and open the Instances screen. Click the Instance Name (SKANTADWC). Click Stop. […]
In this post, you will use the service console to monitor your ADWC instance. As ADWC only accepts secure connections to the database, you need to download a wallet file containing your credentials first. The wallet is downloaded from the ADWCservice console. On the Instances page, find your database and click “Service Console” in the actions […]