Oratop is a text based user interface tool for monitoring basic database operations in real time. In this article we will explain how to use oratop tool . There are two ways we can install oratop. MTEHOD 1:( using TFACTL): Now oracle is providing oratop, tfactl, oswatcher, orachk etc as […]

You can also refer – How to install TFACTL    1. Check tfactl status with version: tfactl status 2. Check tfactl tool status: tfactl toolstatus 3. Get config details: tfactl print config 4. List of user having access to tfactl: tfactl access lsusers 6. changing property of a user: tfactl access promote -user oracle 5.Adding […]

Recently oracle has bundled both  Trace file analyzer(TFA /TFACTL) and orachk into Autonomous health framework popularly known as AHF. So just installing ahf setup will take care of both tfa and orachk including few other monitor tools. STEPS TO INSTALL/UPGRADE AHF Download the AHF tool from oracle support. – DOWNLOAD AHF ENVIRONMENT – SOLARIS 2 NODE […]

A new utility oraversion has been introduced in Oracle 18c, Which provides Oracle database version/release related information.   HELP: oraversion -help This program prints release version information. These are its possible arguments: -compositeVersion: Print the full version number: a.b.c.d.e. -baseVersion: Print the base version number: a.0.0.0.0. -majorVersion: Print the major version number: a. -buildStamp: Print […]

The password file stores a list of usernames and passwords that are allowed to remotely authenticate as SYSDBA over the network. Oracle must use this file to authenticate them, not the normal list of passwords stored in the database. And for this authentication to use password file, the value of REMOTE_LOGIN_PASSWORDFILE should be EXCLUSIVE or […]

OSWATCHER is an oracle utility used to capture performance metrics from the operating system. We can get it easily from oracle website, and it doesnt need additional license. In this article, we will show ,how to install oswatcher utility and its application. 1. Download oswatcher from oracle support. OSWatcher (Doc ID 301137.1) 2. Copy and […]

ASMlib driver is required on  Linux operating systems, to enable a disk readable by ASM. Without ASMLIB, disks can’t be used at asm disks. Below are the steps for configuring ASMlib and marking disks as ASM.   Download Asmlib: You can download these rpm packages directly from OTN: http://www.oracle.com/technetwork/server-storage/linux/downloads/index-088143.html Else, if your system is registered […]

   Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database. This was developed by the sql developer Team. It contains very useful features. We can say it is the advanced version of SQL* utility,     Installation: Download the sqlcl tool from oracle website. Download link – http://www.oracle.com/technetwork/developer-tools/sqlcl/downloads/index.html   […]

The Oracle Database Security Assessment Tool, commonly know as DBSAT tool is used to scan the complete database and provide report security configuration and vulnerability list. The DBSAT has two components: The collector – Its job is to collect information by running different SQL and os command against database The Reporter – It will analyze […]