Oracle Exadata Storage Cell Rescue Using the internal Flash Drive

Oracle Exadata Troubleshooting

17 December 2019   0 Comment

While working on the Exadata Storage cell insert, the attachment failed due to the internal USB drive in the storage cell. Oracle uses the internal USB drive to automatically back up the Exadata Storage cell. We do not have to back up the storage cell manually. In this article, I will show you how to […]

Read More

Celldisk and Griddisk are Not Created Automatically on Oracle Full Rack Exadata Cell Node

Oracle Exadata Troubleshooting

9 December 2019   0 Comment

In this post we will demonstrate how to create the Cell Disk and Grid disks manually, add them to the respective ASM Disk Group on Oracle Full Rack Exadata Cell Node. The Exadata Machine is expected to be up and running and the storage cell containing the failed drive to boot and be available. If […]

Read More

Big DBA as one of the Top 100 Oracle Blogs on the web.

BigDBA is on the Top 100 Oracle Blogs list.

8 December 2019   0 Comment

Today I received an email from Anuj Agarwal, founder of Feedspot .Thank you for your attention. I will try to be worthy. BigDBA is on the Top 100 list. For detailed list; https://blog.feedspot.com/oracle_blogs/

Read More

How to configure yum server in Oracle linux 5,6,7

redhat-oracle-linux

6 December 2019   0 Comment

In this article, we will learn how to congure yum server in dierent Oracle Linux versions. YUM repository is a software package manager which allows you to easily install, update or delete RPMs. Most of the required RPM packages come along with the Linux installer CD. But! if you have internet connection, you can congure […]

Read More

ORA-01565: ERROR IN IDENTIFYING FILE – ORA-01031: insufficient privileges startup

How to fix Oracle

5 December 2019   0 Comment

The solution for Oracle Database insufficient privileges generic error is as follows. [[email protected] ~]$ srvctl start asm; [[email protected] ~]$ crsctl stat res -t SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file ‘+DATA/ORCL/PARAMETERFILE/spfileORCL.ora’ ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL/PARAMETERFILE/spfileORCL.ora ORA-15056: additional error message ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL/PARAMETERFILE/spfileORCL.ora […]

Read More

Step-by-step Installation for Verıtas InfoScale Enterprise With Microsoft SQL Server Cluster

Verıtas Infoscale Enterprıse

  0 Comment

1- Veritas InfoScaleVeritas InfoScale Availability is a comprehensive high availability and disaster recovery center solution that protects critical business services from planned and unplanned outages. 2- Advantages of Veritas InfoScaleVeritas InfoScale Advantages: The InfoScale family of products is installed on an on-premises disc media. This product is especially active in disk virtualization, brand-independent inter-disk data […]

Read More

Oracle Enterprise Manager 12c Cloud Control Command Line İnterface “CLI”

oracle-cloud-control

4 December 2019   0 Comment

Oracle Enterprise Manager 12c is one of the Cloud Control Database management tools. It is a database management tool developed by Oracle for managing databases and operating systems independently from one place. Enterprise Manager Grid Control, which was previously called Enterprise Manager 12c & 13C Cloud Control is the new name of the management tool. […]

Read More

How To Recreate SGA & PGA İn Oracle Database

oracle sga & pga recreate

2 December 2019   0 Comment

SGA = also known as shared memory space. This is the area where data and control information generated on the Ram is stored when Oracle Instance is started. It is not allowed to be used by another application until the database is closed. When turned off, the memory space returns to the source system. This […]

Read More

Oracle Migrating Table Columns from Longs to CLOB

longs-to-clob

  0 Comment

The purpose of LOB (Large Object) Data Types is to store large data. Ex. document (txt, word, excel, xml), pictures, video, audio and so on. This type of data was previously held in data types such as long, raw, long raw, and nowadays large objects are held in data types such as BLOB, CLOB, NCLOP. […]

Read More

How to fix ORA-03113: end-of-file on communication channel Process ID: 194555 Session ID: 1537 Serial number: 3

How to fix Oracle

1 December 2019   0 Comment

ORA-03113: end-of-file on communication channel Process ID: 194555 Session ID: 1537 Serial number: 3 ERROR: failed to establish dependency between database TEDAS and diskgroup resource ora.DATAC1.dg SQL> shu immediate; SQL> alter database nomount; SQL> alter database mount; SQL> select * from v$log; SQL> alter database clear unarchived logfile group 50; SQL> alter database clear unarchived […]

Read More