DB TOOLS

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:

For displaying specific information.

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

Skip to toolbar