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 […]
oracle
How to Start/Stop/Relocate SCAN listener in Oracle 11gR2 RAC
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 […]
How to determine which user is using what rollback segment?
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 […]
CentOS/RHEL7 – Tuned Profiles Oracle
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, […]
tuned-adm and Oracle
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 […]
ORA-00214: control file inconsistent with file
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 […]
Steps to relink Oracle Forms 12c in Linux/UNIX
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 […]
Steps to relink Oracle Libraries
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 | | […]
Create Password file for database in ASM Diskgroup – Oracle 12c RAC only
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 […]
What is SQL Server Operating System ( SQLOS)
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 […]