Author: Onur Çınar

4 Dec by Onur Çınar Tags: , , , ,

How to Start Oracle Database Automatically When Linux Server Is Started

  In this article, I will share linux scripts with you for staring database automatically when operating system is started. My environment is: Oracle 11.2.0.4 database on Oracle Enterprise Linux 6.5 First of all, we must set Oracle environment variables in a profile file. [crayon-5c1923e49e64f604441345/] This script must be run as a OS service so, […]
4 Dec by Onur Çınar Tags: , ,

Oracle DB 11.2.0.4 Installation – Error in invoking target ‘agent nmhs of makefile ins_emagent.mk’

  In this article, I will show you hot to solve “Error in invoking target ‘agent nmhs of makefile ins_emagent.mk”  while you try to install Oracle 11.2.0.4 Database on a Oracle Enterprise Linux operating system. The error is: You must edit $ORACLE_HOME/sysman/lib/ins_emagent.mk file, and change below line. [crayon-5c1923e49eac1834400565/] Change line 176 as shown in below. […]
26 Oct by Onur Çınar Tags: , ,

Oracle – Recreate Central Inventory in Clustareware in Linux

  In this article, I will show you how to recreate oracle central inventory in Real Application Clusters. This is not an usual routine work for DBAs. It should be used when your inventory is corrupted. For example, you may encounter by executing opatch command. [crayon-5c1923e49ee89888338577/]   We assume that you set Oracle Home properly. […]
17 Oct by Onur Çınar Tags: ,

Oracle Password Expired Error

  In this article, I will show you how to change users’ password expire policy. By default, all created users in Oracle Database will be expired in periodic times. Password expired settings are defined in SQL Profiles. You can list expired user by executing below command. [crayon-5c1923e49f4ff292748444/]   As you see, “OCINAR” user had expired. I […]