Hello Friends , In this post we will see the upgradation steps from 12.2 to 19c Note : Before starting the upgrade a patch needs to be appli...
Read More
Grid Installation for Standalone server 12cR2
Hello Friends, Below are the steps for Grid installation on standalone server 12cR2 Step by step. For Prerequisite Steps : Follow below link...
Read More
How to Create Local HTTP Yum/DNF Repository on OEL 8
Create Folders for Copy of packages from ISO to local drive [root@Dm01db08 oracle]# mkdir -p /oracle/repo [root@Dm01db08 Packages]# mkdir -...
Read More
How to insert object in Oracle Database
Step by step insert image file in database Step 1: Create table with image or photo column having BLOB data type. SQL> desc IMAGE.photo...
Read More
How To Rename Tablespace In Oracle
See the below example to rename the tablespace : Check the tablespace name before rename : SQL> select tablespace_name from dba_tablespa...
Read More
Oracle RAC database Switchover steps
Hello Friend's In this post we will discuss about Switchover and Switchback procedure simplified in Oracle 12c. Check the below link fo...
Read More
Find OCR & voting disk location
Voting Disk : It manage information about node membership. Each voting disk must be accessible by all nodes in the cluster. If any node is n...
Read More
password has expired : ORA-28001
Issue : To Reset the same same password to the user which it was using before password expiry ORA-28001: the password has expired The user...
Read More
Oracle Rac Service creation & Tns file example
Tns-file example : # tnsnames.ora Network Configuration File: /oracle/app/orawork/product/12.1.0.2/db_1/network/admin/tnsnames.ora # Genera...
Read More
Automatically Generate Hourly AWR report Script - Oracle – AWR, ASH and ADDM reports for RAC
Hello All, Any one can use the below script to generate Multiple Awr reports for between specific snap id of oracle Awr Save the below code ...
Read More
Subscribe to:
Posts (Atom)