DB TOOLS

How to use oratop tool for oracle database monitoring

           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 […]

Useful TFACTL commands

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 […]

How to install trace file analyzer( TFACTL)

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 […]

oraversion utility in oracle 18c – New feature

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 […]

orapwd tool for password file in oracle

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 tool for collecting server diagnostic information

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 […]

oracleasm utility for ASMLIB

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 […]

SQLCL UTILITY IN ORACLE

   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   […]

Oracle database Security Assessment Tool

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 […]