Hi Dears, In this article, we will see Manage SQL Profile in Oracle Database A SQL profile is a collection of auxiliary statistics on a query, including all tables and columns referenced in the query. The profile is stored in the data dictionary. The optimizer… Read More
Hi Dears, In this article, we will see Resource Manager in Oracle Resource Manager is an enterprise edition feature which will restrict sessions consuming high resources. We can assign shares to sessions depends on priority of session. We can restrict degree of parallelism for group… Read More
Hi Dears, In this article, we will see Configure Active DataGuard and DG BROKER. Oracle Active Data Guard allows DBAs and users to run real-time queries on a physical standby system for reporting. Queries and reports can be offloaded from the production system to… Read More
Hi Dears, In this article, we will see Difference between ROWID and ROWID BATCHED in Oracle. TABLE ACCESS BY INDEX ROWID BATCHED is new execution plan operation introduced in oracle 12c to improve performace by make efficient and minimal read writes to the disk. It… Read More
Hi Dears, In this article, we will see Silent Installation of Oracle 19c Database on AWS. Hardware Requirements: Yum Packages to install in server:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 |
yum install -y oracle-epel-release-el7 yum install -y oracle-database-preinstall-19c yum install -y bc yum install -y binutils yum install -y compat-libcap1 yum install -y compat-libstdc++-33 yum install -y dtrace-modules yum install -y dtrace-modules-headers yum install -y dtrace-modules-provider-headers yum install -y dtrace-utils yum install -y elfutils-libelf yum install -y elfutils-libelf-devel yum install -y fontconfig-devel yum install -y glibc yum install -y glibc-devel yum install -y ksh yum install -y libaio yum install -y libaio-devel yum install -y libdtrace-ctf-devel yum install -y libXrender yum install -y libXrender-devel yum install -y libX11 yum install -y libXau yum install -y libXi yum install -y libXtst yum install -y libgcc yum install -y librdmacm-devel yum install -y libstdc++ yum install -y libstdc++-devel yum install -y libxcb yum install -y make yum install -y net-tools # Clusterware yum install -y nfs-utils # ACFS yum install -y python # ACFS yum install -y python-configshell # ACFS yum install -y python-rtslib # ACFS yum install -y python-six # ACFS yum install -y targetcli # ACFS yum install -y smartmontools yum install -y sysstat yum install -y unixODBC yum install -y chrony |
User/group Creation:
|
1 2 3 4 5 6 7 8 9 10 11 12 |
groupadd -g 650 oinstall groupadd -g 651 dbaoper groupadd -g 652 dba groupadd -g 653 asmadmin groupadd -g 654 asmoper groupadd -g 655 asmdba groupadd -g 656 backupdba groupadd -g 54325 dgdba groupadd -g 658 kmdba groupadd -g 659 racdba useradd oracle -u 1330 -d /home/oracle -m -p $(echo “password” | openssl passwd -1 -stdin) -g oinstall -G dbaoper,dba,asmdba,backupdba,dgdba,kmdba,racdba,ssh_in useradd grid -u 1331 -d /home/grid -m -p $(echo “password” | openssl passwd -1 -stdin) -g oinstall -G dbaoper,dba,asmadmin,asmoper,asmdba,ssh_in |
Setup Filesystem:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
mkdir /u01/app/stage mkdir -p /u01/app/oraInventory mkdir -p /arch/oradata mkdir -p /data/control mkdir -p /arch/control mkdir -p /data/oradata mkdir -p /arch/archive mkdir -p /u01/app/oracle/tde/testpdb1 mkdir -p /arch/redolog mkdir -p /arch/flash mkdir -p /arch/archive chown -R oracle:oinstall /data /arch cd /u01/app/ chown -R oracle:oinstall * |
Download Software from Oracle Site: Software installation by using attached response file: a) Unzip… Read More
Hello Readers, In this article, we will see Recovery models in SQL Server. 1. Take backup of the primary database
|
1 2 3 4 5 6 7 8 9 10 |
run { allocate channel ch1 device type disk maxpiecesize 2G; allocate channel ch2 device type disk maxpiecesize 2G; backup incremental level 0 cumulative database format ='/rman/dbbackups/DB_BKP/full_%d_%T_df_%f_%s' tag 'INCREMENTAL LEVEL 0'; release channel ch1; release channel ch2; } allocate channel for maintenance type disk; delete noprompt obsolete device type disk; release channel; |
2. Create standby control file from primary database.
|
1 |
RMAN> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/tmp/ForStandbyCTRL.bck'; |
3. Transfer backup pieces along with control file from primary server to standby server.… Read More
Dear Readers, In this article, we will see the Autonomous Health Framework. AHF includes number of diagnostic tools in a single bundle and helps us to gather various types og information like upgrading info. , oracheck….. AHF combines Trace file analyzer(TFA), orachk etc.., which oracle… Read More
Dear Readers, In this article, we will see the Transport Plan from One Database to Another Database in Oracle . Transport Good Execution Plan(Hash Plan) from one database to another database Requirement: ETL was taking longer period of time in Prod database where as in… Read More
Dear Readers, In this article, we will see the STANDALONE to RAC Conversion. 1)Take the existing database backup using the crontab job 2) Take the database information. (i.e datafile,tempfile,redolog & Controlfile) 3) Take the pfile backup to any location from spfile. 4) Export the SID… Read More
Dear Readers, In this article, we will see the following Install Python Boto3 On AWS EC2. Collecting Cluster Health Monitor Data 👉 Oracle recommends that you run the diagcollection.sh script on all nodes in the cluster to collect Cluster Health Monitor data. 👉 Running the… Read More
