Basic Usage Netcat Nmap

linux tutorial bigdba

20 November 2020   0 Comment

Netcat has become one of the indispensable tools of system administrators, network administrators and even programmers because it does its job both very simple and very efficient. It is one of the best representatives of the Unix philosophy as well, with its under-defined job well done. Install Netcat Package yum install -y nc Check if […]

Read More

What is Oracle Data Safe

Oracle Data Safe

13 November 2020   0 Comment

Data Safe is a unified control center for your Oracle Databases that helps you understand the sensitivity of your data, assess data-related risks, mask sensitive data, implement and monitor security controls, evaluate user security, monitor user activity, and meet data security compliance requirements. . Whether you are using Oracle Autonomous Database. Data Safe, Oracle Database […]

Read More

Managing Oracle Database Maintenance Tasks

Oracle Software

6 November 2020   0 Comment

Oracle database has started to work proactively since 10G. Working proactively means taking measures by intervening as soon as we receive an alert about the database. As seen in the picture above, it does everything automatically.Automatic Workload Repository (AWR): It is a storage area that keeps the statistical information necessary for the detection and solution […]

Read More

How to Registering Hosts and Deploying the Agent in Oracle Audit Vault Server

Oracle Audit Vault

21 October 2020   0 Comment

Registering Hosts and Deploying the Agent 6.2.2 Audit Vault Agent Requirements Ensure that the host machine has OpenSSL 1.0.1 (or later) installed for Audit Vault Agent [root@sp000dba03 ~]# rpm -qa|grep -i ssl openssl-libs-1.0.2k-19.0.1.el7.x86_64 openssl-1.0.2k-19.0.1.el7.x86_64 JAVA Requirements: Table 2-10 JRE Support Matrix JRE Version Release/Version 1.8 1.8.0_45 and later 11 11.0.3 Starting Oracle Audit Vault and Database […]

Read More

HOW TO RENAME DATABASE IN ORACLE RDBMS

longs-to-clob

4 October 2020   0 Comment

Two Best Practice Recreating controlfile DBNEWID utility First let’s see how to change the DB name using manual assumption (By recreating the control file) ASSUMPTİON 1: RE-CREATING CONTROLFILE STEP1:- CREATE CONTROLFILE CREATATION SCRIPT. [oracle@NVMBD1BZY150D00 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed May 24 16:29:40 2014Copyright (c) 1982, 2011, Oracle. All rights […]

Read More

How to change IP of Oracle Exadata in Oracle Linux

Oracle Exadata Troubleshooting

1 October 2020   0 Comment

In this post the changing of IP addresses on an Oracle Exadata Database Machine system. The most common use case for this procedure is when a system is moved, so this document was written with that case in mind. Importantly, system hostnames and domain name changes are not handled by this procedure. Assumptions The grid […]

Read More

How to Connecting PostgreSQL using PHP 7.3 with Basic Ajax Login Script

PostgreSQL PHP7 Login

30 September 2020   0 Comment

You can use Apache(LEMP), PHP, PostgreSQL to build a easy web app. PgAdmin It is an excellent tool to manage PHP PostgreSQL projects. You must upload the postgreSQL extension by editing the php.ini and restart apache service in order to access psql with php. For install PostgreSQL on Redhat and Centos 6,7 Linux we have […]

Read More

How to Install Oracle Enterprise Manager Cloud Control 12cR5 in Red Hat Linux Step by step

Oracle cloud control

24 September 2020   0 Comment

Oracle Enterprise Manager 12c R5 (12.1.0.5) Cloud Control Installation, Configuration and Management Oracle Database 12CR2 Standalone in Red Hat Linux Step by step Database installation is made by adhering to the document. We install the packages required for Oracle Enterprise Manager 12c Cloud Control Installation to our operating system. yum install make-3*yum install binutils-2*yum install […]

Read More

How to Install Oracle Database 12CR2 Standalone in Red Hat Linux Step by step

12c install

  0 Comment

INDEX 1   Downloading Database Files. 2   Database Software. 3   OS Configuration And Preparation. 4   Oracle Installation. 4.1 Prerequisites. 4.2 Add groups. 4.3 Add user Oracle for database software. 4.4 Change password for user Oracle. 5  Manual Setup. 5.1 Additional Setup. 5.2 Installation. First visit: 24 Sep, 2020 | 13:42:08Last visit:  24 Sep, 2020 | 13:42:08 Number of visits: 1 […]

Read More

Oracle RDBMS Database Sql Tuning Best Practices

Oracle Sql Tuning

10 September 2020   0 Comment

Oracle Database SQL PLAN BASELINE is probably the most important performance component of the software in terms of exceptional performance offered by Oracle. This reduces link traffic between the execution plan, database layer database and buffer cache improves. GET THE PLAN OF THE QUESTION AT SHARED POOL select inst_id,SQL_PLAN_BASELINE ,sql_fulltext,sql_profile ,trunc(elapsed_time/decode(executions, 0, 1, executions)/1000000) elapsed_time, […]

Read More

How to resolve Agent Unreachable errors in Enterprise Manager Cloud Control 13c

Oracle cloud control

21 August 2020   0 Comment

I encountered such an error in Enterprise Manager Cloud Control 13C In the Cloud Control Manager Target , you may see issue of rack showing status as “Down” when running “show status” button Please follow the steps below for solition.. Go to the directory where Agent in is installed. <AGENT-HOME>/bin/emctl stop agent Take a backup […]

Read More

ORA-01111: Name For Data File Is Unknown – Rename To Correct File

oracle dataguard

28 July 2020   0 Comment

Today one of the Physical standby database environment faced an case where the Media Recovery MRP process got crashed and the standby database got out of sync. This post describes how to repair multiple or single-correct file of data files. Mon Jul 28 10:26:04 2020MRP0: Background Media Recovery terminated with error 1111ORA-01157: cannot identify/lock data […]

Read More

Exalogic Elastic Cloud IB(InfiniBand) Switch Ports State Shown as Down Status Showing AutomaticHighErrorRate Message

Oracle Exalogic Elastic Cloud

25 June 2020   0 Comment

I encountered such an error in cloud control: Port IBPort[14] is polling for peer port. This could happen when the cable is unplugged from one of the ends or the other end port is disabled. In the Exalogic Elastic Cloud racks, you may see issue of IB ports showing status as “Down” when running “ibstat” […]

Read More

How to Fix Oracle Exalogic X6-2 Elastic Cloud ZFS Storage Multiple correctable ECC errors on a memory DIMM have been detected.

Oracle Exalogic Elastic Cloud

22 June 2020   0 Comment

İs as follows the output of these commands: maintenance hardware list maintenance problems show confirm shell zpool status confirm shell zpool list maintenance hardware show We have a memory problem in Exalogic ZFS Storage cel01 node.Details appearing on the ilom are as follows; İlom > Maintenance > ProblemsDescription Multiple correctable ECC errors on a memory […]

Read More

Understand The Oracle Exadata Cell Offload Feature

Exadata Smart Scan and Cell Offload

1 June 2020   0 Comment

Oracle Exadata Smart Scan and Cell Offloading Smart Scan is probably the most important performance component of the software in terms of exceptional performance offered by Exadata. Smart Scan is a cell offloading feature that is to process into storage cells offload of performing block I / O requests at the database layer. The purpose […]

Read More

How to Create and Configure a Pluggable Database (PDB) in Oracle Database 19c Multitenant Architecture

Oracle Container Database and Pluggable Database

26 May 2020   0 Comment

Hi, in this post I will write about how Oracle Database 19c Multitenant architecture PDB is created with DBCA. Run the DBCA after the CDB Database is set. Then just follow the steps as below. Choose Manage Pluggable Databases Choose Create a Pluggable Database Enter the sys information for the container database. Choose Create a […]

Read More

[INS-00001] Unknown irrecoverable error Oracle 19c Grid Upgrade

grid upgrade

5 May 2020   1 Comment

If you get an error like below while running root.sh file on the installation screen, you need to restart the installation. [root@db~]#/oracle/grid18c/root.shPerforming root user operation for Oracle 18c The following environment variables are set as:ORACLE_OWNER= ora18cORACLE_HOME= /oracle/grid18c Enter the full pathname of the local bin directory: [/usr/local/bin]:The contents of “dbhome” have not changed. No need […]

Read More

How to change Oracle Database NLS DATE FORMAT

How to fix Oracle

22 April 2020   0 Comment

To change the NLS_DATE_FORMAT setting Use the below command, it will help to solve your problems for after restart database. Also, if you do not want to do this at the instance level, you can make session NLS_DATE_FORMAT based on sql queries. ALTER SESSION SET NLS_DATE_FORMAT=’DD-MM-YYYY’; [oraetkb@sp000dba01 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 […]

Read More

Oracle Container Pluggable Database ERROR at line 1: ORA-01157: cannot identify/lock data file 90 – see DBWR trace file ORA-01110: data file 90:

Oracle Container Database and Pluggable Database

14 April 2020   0 Comment

In this post, Pluggable database ORA-01157 error we will examine.I encountered an error on when opening the database like below The data file may have been renamed at the operating system level, moved to a different directory or disk drive with or without awareness.In this case, restore and recover the data file or move the […]

Read More

Oracle Exadata X7 Error A memory component is suspected of causing a fault with a 100% certainty.

Oracle Exadata Troubleshooting

13 April 2020   0 Comment

I encountered an error on Exadata like below. Alert Summary Maintenance A memory component suspected of causing a fault Detailed Alert Information A memory component is suspected of causing a fault with a 100% certainty. Check Cellcli. cellcli > list alerthistory There is no error Check İlom -> show /SYS/MB/P0/D7 /SYS/MB/P0/D7 Targets: PRSNT SERVICE fault_state […]

Read More

ORA-65066: The specified changes must apply to all containers

Oracle Container Database and Pluggable Database

2 April 2020   0 Comment

When I wanted to change the password on the pluggable database user, I got an error like the one below. SQL> alter user test identified by test; alter user test identified by test ERROR at line 1:ORA-65066: The specified changes must apply to all containers View connection information. SQL> show con_nameCON_NAMEPLUG1 Login as sysdba SQL> […]

Read More

Oracle 12c Container RAC Database Pluggable Error ORA-01033

Oracle Container Database and Pluggable Database

31 March 2020   0 Comment

Today I will talk about a problem I encountered in pdbs “ORA-01033” error on Oracle Container Database. Query existing databases running on the container. SELECT inst_id,con_id,name,open_mode FROM gv$pdbs ORDER BY con_id,inst_id If the databases are “ALTER PLUGGABLE DATABASE ALL OPEN” If you opened it with the command, you just opened it on the relevant cdb. […]

Read More

ORA-39083: Object type TABLE:”TEST”.”TEST1″ failed to create with error: ORA-01950: no privileges on tablespace ‘USERS’

How to fix Oracle

29 March 2020   0 Comment

When doing data pump operation with Oracle, you can get an error like below if schema to import is not authorized.This is very common error which comes due to insufficient privileges on tablespace. ORA-39083: Object type TABLE:”TEST”.”TEST1″ failed to create with error: ORA-01950: no privileges on tablespace ‘USERS’ SQL>select USERNAME, DEFAULT_TABLESPACE from dba_users where USERNAME=’test’; […]

Read More

Oracle Database Backup & Recovery Using Recovery Manager(RMAN) TUTORIAL

Rman Tutorial

20 March 2020   0 Comment

Create a Oracle database with the name PRİMARYDB running in ARCHIVELOG mode. For simplicity the database can be created with all files located under one common area: For example “/opt/oracle/oradata/primarydb/” Archive log files can be located at “/opt/oracle/oradata/primarydb/arch” Use small redo log file sizes (1 megabyte) to simulate redo activity. Before using RMAN, we need […]

Read More

ORA-00205 error in identifying control file, check alert log for more info

How to fix Oracle

  0 Comment

When the control file file is deleted or its location changes, when you try to run oracle database, we encountered an error like below. SQL> startupORACLE instance started.ORA-00205: error in identifying control file, check alert log for more info See control file location show parameter control_files NAME TYPE VALUE control_files string +DATAC/TESTDB/CONTROLFILE/cu rrent.814.1034955455 Confirm the […]

Read More

Oracle GoldenGate WARNING OGG-25108 Failed to set the Oracle session tag: ORA-04060: insufficient privileges to execute DBMS_STREAMS.SET_TAG

How Problems with Oracle GoldenGate

22 February 2020   0 Comment

On the Oracle GoldenGate app, you may encounter an error like below when logging in with the goldengate user. The error I encountered occurred in the 11.2.0.4 database on the Oracle 19c GoldenGate version. Oracle Bug fixed in 12.1.2.1.0 and on later versions. Correct it by adding DBMS_STREAMS_ADM.set_tag for 11g DB. Oracle will continue to […]

Read More

Error: Failed to download metadata for repo ‘ol8_baseos_latest’ Linux Rhel8 and Oracle linux 8

Oracle linux 8 Error

19 February 2020   0 Comment

I encountered a problem with yum repository problem on Oracle linux 8, you can produce a solution by doing the following operations. It can also cause the following issues. Incorrect date and time settings Old dnf cache available or expired Proxy address not defined or proxy address specified in /etc/dnf/dnf.conf file is incorrect cd /etc/yum.repos.d […]

Read More

How to use the Oracle Data Guard Switchover Operations

oracle dataguard

16 February 2020   0 Comment

Dataguard Switchover is a planned role change. In other words, it is the transition of the live database to the standby role and the standby database to the live role. We may be doing Dataguard switchover for testing the functionality of our backup database, doing maintenance work in our live database, etc.Dataguard Switchover operation can […]

Read More

Cloning an Oracle Real Application Cluster(RAC) Database Software Home

Oracle Software

6 February 2020   0 Comment

In this post we will demonstrate how to create the Oracle RAC Database Software Clone manually, add them to the respective clone.pl script on Oracle Full Rack Exadata Compute Node. Create a tarball of the source home Node1 cd /u01/app/ orcl /product/orcl_12201tar zcvf /u01/app/ orcl /orcl .tar Node2 cd /u01/app/ orcl /product/orcl_12201tar zcvf /u01/app/ orcl […]

Read More

Exadata and Exalogic Elastic Cloud IB Ports State Shown as Down Along with Infiniband Switch Ports Status Showing AutomaticHighErrorRate Message

Oracle Exadata Troubleshooting

5 February 2020   0 Comment

In the Exadata and Exalogic Elastic Cloud racks, you may see issue of IB ports showing status as “Down” when running “ibstat” command. This issue can of happen on Compute Nodes,İnifiniband Switch or Storage heads. IB port being down on Compute Node can be confirmed by running below command [root@xc000xc-ibb01 ~] # listlinkup Connector 0A […]

Read More

How to fix ORA-01565: error in identifying file ‘?/dbs/spfile@.ora’

How to fix Oracle

28 January 2020   3 comments

While working on an Oracle ASM instance, we may encounter a spfile creation error like the one below. SQL> create pfile=’/u01/ora/inittkitest3.ora’ from spfile; create pfile=’/u01/ora/inittkitest3.ora’ from spfile * ERROR at line 1: ORA-01565: error in identifying file ‘?/dbs/spfile@.ora’ ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 […]

Read More

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. [grid@testdb1 ~]$ srvctl start asm; [grid@testdb1 ~]$ 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