• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

oracle

Log file locations for Enterprise Manager Cloud Control 13c (OMS)

by admin

OMS is a web-based application that communicates with the agents and the Oracle Management Repository to collect and store information about all the targets on the various agents. The OMS is also responsible for rendering the user interface for the console. Like the agent, the OMS can be controlled via both the EM13c console and […]

Filed Under: oracle

How to Start/Stop/Relocate SCAN listener in Oracle 11gR2 RAC

by admin

Check listener status (login to grid home) 1. Check the cluster resource status: $ crsctl stat res -t ——————————————————————————– NAME TARGET STATE SERVER STATE_DETAILS ——————————————————————————– Local Resources ——————————————————————————– ora.DATA.dg ONLINE ONLINE node1 ONLINE ONLINE node2 ora.FRA.dg ONLINE ONLINE node1 ONLINE ONLINE node2 ora.LISTENER.lsnr ONLINE ONLINE node1 ONLINE ONLINE node2 ora.asm ONLINE ONLINE node1 Started ONLINE […]

Filed Under: oracle

How to determine which user is using what rollback segment?

by admin

What is a Rollback Segment? A rollback segment is made up of multiple extents that consist of several ‘rollback entries’ which keeps undo information for transactions. Rollback segments are needed for: Read-consistant database information. Database recovery. Rolling back uncommitted transactions. How does Oracle determine which rollback segment to use? The rules are: 1. Always assign […]

Filed Under: oracle

CentOS/RHEL7 – Tuned Profiles Oracle

by admin

Tuned is a set of tools and a daemon that tunes your system’s settings automatically depending on its usage. It periodically collects data from its components through plugins, which it uses to change system settings according to the current usage. You can find the system’s tuned profiles used in /lib/tuned/. When you create your own, […]

Filed Under: CentOS/RHEL, CentOS/RHEL 7, CentOS/RHEL 8, Linux, oracle

tuned-adm and Oracle

by admin

To offer the best possible performance right from the start, CentOS/RHEL 7 and 8 come with tuned. It offers a daemon that monitors system activity and provides some profiles. In the profiles, an administrator can automatically tune a system for the best possible latency, throughput, or power consumption. Based on the properties of an installed […]

Filed Under: CentOS/RHEL, CentOS/RHEL 7, CentOS/RHEL 8, Linux, oracle

ORA-00214: control file inconsistent with file

by admin

The ORA-00214 error causes An ORA-00214 is issued whenever Oracle detects an inconsistency between two mirrored copies of the control file. All copies of the control file must have the same internal sequence number for Oracle to start up the database or shut it down in normal or immediate mode. If the database is running […]

Filed Under: oracle

Steps to relink Oracle Forms 12c in Linux/UNIX

by admin

On Linux/Unix platforms, the Oracle software is delivered in the form of object files that are compressed into archive files. These files will be linked, or compiled, with operating system libraries to generate executables. This linking process happens during the installation. You might have observed that many prerequisite OS packages are asked for during the […]

Filed Under: oracle

Steps to relink Oracle Libraries

by admin

Oracle relink utility is used to manually relink Oracle product executables. You must set the ORACLE_HOME environment variable before executing relink. relink invokes the appropriate makefile based on the parameter passed to it. Note: relink isn’t available, nor is it needed, on Windows platforms. Syntax: relink all | oracle | network | client | | […]

Filed Under: oracle

Create Password file for database in ASM Diskgroup – Oracle 12c RAC only

by admin

There are two ways to authenticate users to the database. One way is to use OS authentication and put the responsibility on the operating system to make sure that users logging in are the correct users and that they have the appropriate privileges. The other way is to use a password file. Oracle provides a […]

Filed Under: oracle

What is SQL Server Operating System ( SQLOS)

by admin

SQLOS provides user-level operating system services (hence the name “SQLOS”) to the rest of the server. Components in the SQL Server Engine make use of the services provided by SQLOS to schedule individual or multiple tasks, allocate memory, and so forth. In the past, scalability was the major issue in SQL Server because it supported […]

Filed Under: MS SQL, oracle

« Previous Page
Next Page »

Primary Sidebar

Recent Posts

  • grpck command – Remove corrupt or duplicate entries in the /etc/group and /etc/gshadow files.
  • xxd command – Expressed in hexadecimal form
  • sesearch: command not found
  • macof: command not found

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright