Manual upgrading Oracle database 11gR2 to 18c If you want to know how we upgrade an 11.2.0.4 database to 18.0.0.0.0 using DBUA, click here. This article explains how to upgrade 11.2.0.3 and above, and 12.1.0.1, 12.2.0.1 to 18.0.0.0.0 manually. Manually upgrading to 18c There are many DBAs who don’t want to follow the recommended way of an upgrade […]
Monthly Archives: March 2018
Tablespaces Info for upgrading to 18c
To help you keep track of your tablespace allocations, the following AUTOEXTEND tablespaces are expected to successfully EXTEND during the upgrade process. Tablespace Size Min Size For Upgrade ———- ———- ———– SYSAUX 490 MB 718 MB SYSTEM 750 MB 1194 MB TEMP 54 MB 150 MB UNDOTBS1 85 MB 446 MB Minimum tablespace sizes for […]
MONITORING ALERT LOG
Today we are going to have look at the “MONITORING ALERT LOG ORA-ERRORS”. With help of this script DBA can monitor all the ORA-Errors from the alert log and used to send to our mailboxes, he schedules this through a cronjob. Being DBA we all are aware of the importance of Alert Log. For managing the backup […]
First Look of OEM 18c
In this article, we will try to find the new things with Oracle OEM 18c. I already installed Oracle OEM18c. After deploying the agent, we log in with sys user. First thing, we can able to see Forward Listener in Oracle 18c, which can explain in later posts. After that, we can see more parameter […]
Fast Application Notification[FAN] Benefits :
For DBA, if a database is up and running, everything seems beautiful..!! But once a state change happens in a database, we don’t know will it take 2 min to overcome it or it will eat our infinite time. When we talk about Oracle RAC, we know there are multiple resources are available to give […]
Converting an Administrator-Managed Database to a Policy-Managed Database
In this article, We can convert Administrator managed database to Policy managed database : First of all, let’s check the configuration of the database : [oracle@rac1 ~]$ srvctl config database -d demo Database unique name: demo Database name: demo Oracle home: /appndb/oracle/product/11.2.0/db_1 Oracle user: oracle Spfile: +DATA/demo/spfiledemo.ora Domain: Start options: open Stop options: immediate Database […]
Relocating Service in Oracle RAC
In this article, we will see Relocation of Service from One Instance to another Instance. I have service called myservice already running at orcl1 instance. Let us check status of myservice [oracle@rac1 ~]$ srvctl status service -d orcl -s myservice Service myservice is running on instance(s) orcl1 [oracle@rac1 ~]$ Now relocate service from orcl1 to […]
Creating Deleting and Modifying Services in Oracle RAC
1.Creating Service in Oracle RAC : Step 1: To create a service in Oracle RAC [oracle@rac1 ~]$ srvctl add service -d orcl -s myservice -r orcl1 -a orcl2 -P BASIC Here I have created service named myservice with preferred instance orcl1 and available instance orcl2. To check all available parameters of service creation : [oracle@rac1 […]
Installing Oracle 18c Database on Cloud in 3-clicks
This article shows how to create Oracle 18c database in Oracle Database Cloud Service database deployment with simple steps. Create a New Instance of Oracle Database Cloud Service Log in to your Oracle Cloud services account, go to the Oracle Database Cloud Service page, and create a new service:- For Instance Name enter Cloud18c. – From the Software Release list, […]
Apply Patch on Oracle 18c Database
In this post, we are going to apply bug fix patch for testing in Oracle 18c Database. First of all, we can download latest opatch utility from support. Doc ID 274526.1 -> How To Download And Install The Latest OPatch (6880880) Version. Check the version from new OPatch utility. [oracle@18c ~]$ opatch version OPatch Version: […]