Oracle - IT Tutorial

Oracle EBS

October, 2019

3 October
What is Index and Why Should We Use Index?

Indexes are used to access data in the table faster. A book is like a table of contents. When searching for a topic in the book, we can quickly find …
Read More »
1 October
Oracle Virtual Private Database (VPD) -2

DBMS_RLS Package We use DBMS_RLS to create, modify, or delete security policies with VPD. The DBMS_RLS.ADD_POLICY procedure allows us to create a VPD security policy. The definition of parameters used in …
Read More »

September, 2019

29 September
Oracle Virtual Private Database (VPD) – 1

Virtual Private Database allows us to define constraints on tables and views based on row and column security policies. It should not be considered as a separate database because of the …
Read More »
24 September
Oracle Parameter Files – Spfile Usage

Spfile The parameter file that it used to configure the instance when the database was opened. When the database is created, the spfile <ORACLE_SID> .ora file is created under the …
Read More »
24 September
Required Parameters For Oracle Database

When the database is first created, there are some basic parameters that are most necessary. We can see these parameters with the following query, SQL> select name from v$parameter where …
Read More »
22 September
PasswordFile – orapwd utility in Oracle

Hello everyone, in this tutorial we gonna examine PasswordFile – orapwd utility in Oracle. The password file is an optional file. It’s use has some advantages.
Read More »
10 September
ORA-27048: skgfifi: file header information is invalid ORA-19625: error identifying file in Oracle XTTS Convert Step

Hi, When I use Oracle XTTS for Cross platform migration, I got ” ORA-27048: skgfifi: file header information is invalid ” error.
Read More »
8 September
Oracle SQL Developer Web

Hi everyone, Today i will show you how to connect SQL Developer Web. Oracle SQL Developer allows database users and administrators to do their database tasks in fewer clicks and …
Read More »
6 September
What Is In-Memory?

Hi everyone, Today i try to explain Oracle Database 12c In-Memory. In-Memory is a very important subject for Database and DWH. Oracle DB to store data in row format at …
Read More »

August, 2019

16 August
OCI Error !! – [Errno 12] Timeout on https://www.ksplice.com/yum/uptrack/ol/7Server/x86_64/repodata/repomd.xml:

Hi friends, i want to explain OCI (Oracle Cloud Infrastructure yum problem and solution method. If you currently using Oracle Cloud, you should know basic Cloud Architecture. Oracle takes most …
Read More »
15 August
[FATAL] [INS-10101] The given response file response/grid_install.rsp is not found.

Hi friends, We may need to install Oralce database or grid without using an GUI. To do this, we need to edit the rsp file and start the installation from …
Read More »
9 August
Oracle Cloud Add Disk To Virtual Machine

Hi, we will see how to add disk to the machine we created in Oracle Cloud. The best advantage to using Cloud, when you need to new one no physical …
Read More »
7 August
Oracle Cloud Create Virtual Machine And Connect

Hi everyone, in this tutorial i will show you how to create Virtual Machine on Oracle Cloud. Oracle Linux 8 Installation Oracle organizes many events to promote cloud products …
Read More »
7 August
Python connect Oracle Database

Hi everyone, today i will show you how to connect Oracle database using python. Python is very popular and easy to learn programing language. We may need to connect to …
Read More »
7 August
RMAN-00554: initialization of internal recovery manager package failed and RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied

Hi friends, Today i want to show you some possible error while installing Data Guard. In Data Guard installation we need to connect auxilary database(standby) from Primary. connect auxiliary …
Read More »
1 August
ORA-12547: TNS:lost contact Error

When I connect to Oracle database, I got ” ORA-12547: TNS:lost contact ” error.
Read More »

July, 2019

4 July
ORA-12631: Username retrieval failed on Windows login with sqlplus

Hi, You can get ” ORA-12631: Username retrieval failed ” error when login Oracle database.
Read More »

June, 2019

28 June
ORA-00020: maximum number of processes exceeded and alter system set processes

Sometimes you may get ” ORA-00020: maximum number of processes exceeded ” error while login oracle database via sqlplus and Application may encounter TNS errors.
Read More »
26 June
How to Install Enterprise Manager Cloud Control 13c ( EM 13c ) Agents on Microsoft Windows Target Hosts

I will explain How to Install Enterprise Manager Cloud Control 13c ( EM 13c ) Agents on Microsoft Windows Target Hosts in this article. Let’s review the Install EM Cloud …
Read More »
25 June
ORA-01180: can not create datafile 1 ORA-01110 RMAN-03002 Error Solution During RMAN Restore Operation

Hi, When I try to create Test database from Production via RMAN Restore, I got ” ORA-01180: can not create datafile 1 ORA-01110 RMAN-03002 ” errors.
Read More »
21 June
What is the Database Auditing in Oracle

I will explain What is the Oracle Database Auditing in this article.
Read More »
18 June
Oracle SQL Tutorials – Chapter 3 (Part 3 of 3)
CONVERSION FUNCTIONS TO_CHAR (DATE) TO_CHAR(date, ‘format’) It’s case-sensitive and must be written between quotes. It must contain a valid date format. Let’s list the hire dates of employees like below. …
Read More »
18 June
Oracle SQL Tutorials – Chapter 3 (Part 2 of 3)
NUMERIC FUNCTIONS ROUND Let’s try some different usages of the ROUND function. SELECT ROUND (45.923), ROUND (45.943, 1), ROUND (45.924, 2), ROUND (44.923, -1), ROUND (55.923, -2) FROM DUAL; …
Read More »
18 June
Oracle SQL Tutorials – Chapter 3 (Part 1 of 3)
Chapter 3 – Single Row Functions Charcter Functions Numeric Functions Date Functions Converting Functions NVL Function Decode Function CASE Statement SQL FUNCTIONS SQL Functions can be classiifed under 2 …
Read More »