Good Contents Are Everywhere, But Here, We Deliver The Best of The Best.Please Hold on!
Netsoftmate Blog

Learn form the tech experts

Uncategorized

About ODA Snapshot Database ODA Snapshot Database is created using oakcli command line utility ODA automates the entire snapshot database creation process Snapshot Database is created by taking a snapshot of the Oracle ASM Cluster File System (ACFS) where the source data files reside The Source Database can be: Non-RAC RAC RAC One Node Snapshot Database requires less time and Storage No downtime for source database for creating snapshot database You can create an Oracle RAC database from an Oracle RAC One Node database Create snapshot database feature is notSEE DETAILS

Continue Reading
Uncategorized

Introduction In my previous articles, we have learned how to Create Oracle Database Appliance Database Configuration Parameter file.  If you want to create a database with different database configuration parameter then you must create a database configuration file with your desired parameters. You can use the ‘oakcli create db_config_params’ command to create a database configuration file. The configuration files are created under the locatoin ‘/opt/oracle/oak/install/dbconf’ with a default extension of ‘.dbconf’. Refer to the blog post at on how to create a databsae configuration file http://netsoftmate.blogspot.com/2018/05/oracle-database-appliance-database-configuration-file.html In this article we<a class="more-link" href="https://netsoftmate.c...

Continue Reading
Uncategorized

While creating a tablespace on Oracle Database 11g I ran into a issue related to DB_CREATE_FILE_DEST (OMF parameter).  The DB_CREATE_FILE_DEST parameter was pointing to incorrect ASM Disk Group name which doesn’t existing. The issues was fixed by correcting the DB_CREATE_FILE_DEST parameter to point to the correct ASM Disk Group name. In this article I would like to demonstrate how to fix create tablespace error which is to incorrect DB_CREATE_FILE_DEST parameter. Create Tablespace ran the into the issue as below: The create tablespace failed as the ASM Disk Group +DATA doesn’tSEE DETAILS

Continue Reading
Uncategorized

Overview Oracle Recovery Manager (RMAN) provides a comprehensive foundation for efficiently backing up and recovering the Oracle databases, it provides a common interface, via command line and Enterprise Manager, for backup tasks across different host operating systems, automates administration of your backup strategies. Environment Details Target (Source) details Database Name prod Hostname Snsm-linux02 Ip Address 172.16.110.18 OS Linux Version x86_64 Datafile Location /data2/prod Backup Location /backup/rman_backup Tns details: PROD =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.110.18)(PORT = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)<a class="more-link" href="https://netsoftmate.com/rman-duplicate-...

Continue Reading
Uncategorized

Overview All AWS RDS Instances has DNS name and port number which is also known as endpoint, to establish connection to your AWS DB Instance you require DNS names and port number, we can find endpoint details of AWS RDS Instance through AWS console. In this article we will demonstrate, how to find endpoint details from AWS console. Steps to find endpoint of AWS RDS Instance Login to AWS console please check previous article on how to login AWS console by click on following link http://netsoftmate.blogspot.com/2018/06/how-to-login-aws-console.html From console got toSEE DETAILS

Continue Reading
Uncategorized

Amazon Web Services (AWS) is a secure cloud services platform, It offers compute power, database storage, evolving cloud computing platform provided by Amazon, content delivery and other functionality to help businesses scale up and grow. Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks. To know more about Amazon RDS please visit https://aws.amazon.com/rds/ In this article weSEE DETAILS </...

Continue Reading
Uncategorized

Overview Amazon Web Services (AWS) is a secure cloud services platform, offering compute power, database storage, evolving cloud computing platform provided by Amazon, content delivery and other functionality to help businesses scale and grow. Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks. To know more about Amazon RDS please click here AWS RDS In this article we will demonstrate howSEE DETAILS <span class="more-li...

Continue Reading
Uncategorized

Oracle provides “Exachk” utility to conduct a comprehensive Health Check on Oracle SuperCluster to validate hardware, firmware and configuration. Exachk Utility is available for Oracle Engineered Systems such as Exadata (V2 and above), Exalogic, Exalytics, SuperCluster, MiniCluster, ZDLRA & Big Data.  When Exachk is run from the primary LDOM as user ‘root’ it will discover and run exachk utility for each component: Configuration checks for Compute nodes, Storage cells and InfiniBand Switches Grid Infrastructure, Database and ASM and Operating System software checks When Exachk is run in a Database zoneSEE DETAILS <span clas...

Continue Reading
Uncategorized

ASRexacheck utility can be executed to verify the ASR deployment. Oracle Auto Service Request (ASR) is a secure, scalable, customer-installable software feature of warranty and Oracle Support Services that provides auto-case generation when common hardware component faults occur. It is important to note that, ASR is not a system management or monitoring tool. It is developed & designed to open Oracle Automatic Service Requests when specific hardware faults are detected on Oracle products that are qualified for ASR. Oracle Exadata Database Machine is a qualified production for Oracle ASR. YouSEE DETAILS </...

Continue Reading
Uncategorized

When Oracle ACS build Exadata Database Machine, they use the OEDA file that you sent them over for Exadata Install. The Exadata is built with default ASM Disk Group name DATAC1, RECOC1 & DBFS_DG. If you want to rename the DATAC1 and RECOC1 to something different to match your Organization standards you can do that by using the Oracle renamedg utility. The number Database version required to rename an ASM Disk Group is 11.2. In this article we will demonstrate how to rename ASM Disk Group on Exadata Database MachineSEE DETAILS

Continue Reading
Uncategorized

We had a failed hard disk on a Exadata Storage cell X6-2. So we scheduled the Oracle Field Engineer to replace the bad disk. Oracle Field Engineer came onsite and replaced the faulty hard disk. Post hard disk replacement we found that the physical disk and luns are created successfully but the Cell disk and Grid disks were not created automatically. When a hard disk is replaced, the lun, cell disk and grid disks are created automatically and grid disks are added to ASM disk group for you without anySEE DETAILS

Continue Reading
Uncategorized

Oracle Exadata Database Machine consists of several components such as Compute nodes, Storage Cells, ILOM, Infiniband Switches, Cisco Switch and PDUs. So we need a tool that can manage all these components from one single console. Oracle Enterprise manager Cloud Control is the recommended best practices for monitoring and managing Exadata Database machine. Once the Exadata database Machine is installed the next step is enable monitoring for it. The following Exadata components can be monitored and managed by OEM: Compute Nodes Storage Cells Infiniband Switches Cisco Switches Power Distribution UnitsSEE DETAILS

Continue Reading
Uncategorized

There are times when you encounter issues related to Database/ASM/Clusterware and Oracle recommends you to apply one-patches to fix the issue. These one-off patches can be applicable to Grid and Oracle Home or in some cases just specific to a particular home. In my cases we were adding Exadata X7-2 Compute nodes and Storage Cells to an Existing Exadata X6-2 Rack, and the prerequisite to do that was to apply the one-off (27965497) to GI home before upgrading the Exadata Cluster. In this article we will demonstrate how to applySEE DETAILS

Continue Reading
Uncategorized

Oracle has released Exachk utility 18c on May 18th, 2018. Let’s quickly check if there are differences in Exachk 18c or it is similar to Exachk 12c. Download latest Exachk 18c utility from MOS note: Oracle Exadata Database Machine exachk or HealthCheck (Doc ID 1070954.1) Changes in Exachk 18.2 can be found at: https://docs.oracle.com/cd/E96145_01/OEXUG/changes-in-this-release-18-2-0.htm#OEXUG-GUID-88FCFBC6-C647-47D3-898C-F4C712117B8B Steps to Execute Exachk 18c on Exadata Database Machine Download the latest Exachk from MOS note. Here I am downloading Exachk 18c. Download Completed Using WinSCP copy the exachk.zip file to Exadata Compute node Copy completed.SEE DETAILS ...

Continue Reading
Uncategorized

You want to execute Operating System or Exadata commands on multiple Exadata Compute nodes and Storage Cell in parallel. To accomplish this you must setup passwordless SSH across compute nodes and storage cells. If SSH equivalence is NOT setup and you execute the dcli command you will see the follow messages. This mean the SSH equivalence is not configured. [root@dm01db01 ~]# dcli -g dbs_group -l root ‘uptime’ The authenticity of host ‘dm01db03 (10.10.10.195)’ can’t be established. RSA key fingerprint is 40:81:3c:6d:ef:e7:1f:d7:a0:df:eb:f5:ea:92:a5:db. Are you sure you want to continue connecting (yes/no)?SEE DETAILS <span class="more-link-ho...

Continue Reading
Uncategorized

Continue Reading
Uncategorized

Oracle GoldenGate Pocket Reference

Continue Reading
Uncategorized

In a Data Guard configuration it is very common to these the ‘UNNAMED File Issue/Error’ on Standby Database when you add new datafile on Primary Database and there is no space available on the standby database server or improper parameter settings related to standby file management. This will result in the following Oracle error messages ORA-01111, ORA-01110, ORA-01157 and cause MRP process to crash resulting in Standby database ‘out of sync’ with primary.  Also note that, If STANDBY_FILE_MANAGEMENT parameter is not configured as ‘AUTO’ in your Data Guard environment andSEE DETAILS <span class="more-link-hover-image"...

Continue Reading
Uncategorized

You want to install some packages on the Exadata Compute nodes running Oracle Enterprise Linux and you don’t have internet access. In those cases you can create a local YUM repository using DVD Image. You simply download the DVD Image on the Desktop/Laptop where you have the internet access, copy it to the server and mount it. In this article we will demonstrate how create a Local YUM Repository using ISO Image on Exadata Database Machines. Prerequisites System with Internet Sufficient space on the server for Oracle Linux DVD ISOSEE DETAILS

Continue Reading
Uncategorized

When you create a database on Oracle Database Appliance (ODA) it uses a ‘default’ database configuration file which consists of a default parameters.  The default database configuration file uses the following parameters: [root@odanode1 ~]# oakcli show db_config_params The available DB configuration files are : default [root@odanode1 ~]# oakcli show db_config_params -conf default -detail DATABASE_BLOCK_SIZE       =>    8192 DATABASE_LANGUAGE         =>    AMERICAN DATABASE_CHARACTERSET     =>    AL32UTF8 DATABASE_TERRITORY        =>    AMERICA COMPONENT_LANGUAGES       =>    en NLS_NCHAR_CHARACTERSET  &nbs...

Continue Reading
PREVIOUS POSTSPage 3 of 10NEXT POSTS