Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 
 

Advanced Oracle UNIX Utilities and Shell Scripts

Oracle Database Tips by Donald Burleson

Advanced Oracle Utilities: The Definitive Reference by Rampant TechPress is written by top Oracle database experts (Bert Scalzo, Donald Burleson, and Steve Callan).  The following is an excerpt from the book.

UNIX Utilities and Shell Scripts

The table below lists the UNIX binaries provided through Oracle 10gR2, a brief description, and the version of Oracle that first made it available.  

 

Binary

Description

First Available

adapters

Installed Network Adapters

(7.3.4)

agentctl

Agent Control Utility

9.0.1

agtctl

Agent Control Utility

8.1.5

bulkmodify

Oracle Internet Directory bulk modify

8.1.6

cmadmin

Connection Manager Administrator

8.1.6

cmctl

Connection Manager Control Utility

8.1.6

cmgw

Connection Manager Gateway

8.1.6

coraenv

Oraenv command for Cshell

(7.3.4)

csscan

Character Set Scanner

8.1.7

ctxkbtc

InterMedia

8.1.5

ctxload

InterMedia

(7.3.4)

ctxsrv

InterMedia

(7.3.4)

cursize

Cursor Size Tool

8.0

dbca

Database Creation Assistant

9.0.1

dbfmig

Datafile Migrator

8.1.5

dbfsize

Datafile Size

(7.3.4)

dbhome

displays Oracle$HOME

(7.3.4)

dbshut

shuts down Oracle

(7.3.4)

dbsnmp

Intelligent Agent

8.0

dbsnmpj

Intelligent Agent Job Processor (not Java or JRE)

9.0.1

dbsnmpwd

Intelligent Agent

9.0.1

dbstart

Starts Oracle

(7.3.4)

dbua

Database Upgrade Assistant

9.2.0

dbv

Verifies datafiles

(7.3.4)

debugproxy

Oracle JVM Debugging

8.1.7

demobld

Table Build for Oracle Developer demo

(7.3.4)

demodrop

Table drop for Oracle Developer demo

(7.3.4)

deploync

JAR file deployment

8.1.7

dgmgrl

Data Manager

9.0.1

dropjava

Drops java objects

8.1.5

dumpsga

Dumps SGA contents

9.2.0

echodo

Echo command and print it

(7.3.4)

Ela

Enterprise Login Assistant

9.0.1

Emca

(Enterprise Manager?)

9.0.1

emwebsite

(Enterprise Manager?)

9.0.1

Esm

Enterprise Security Manager Command Line Utility

9.2.0

Exp

Export

(7.3.4)

extproc

External Process Agent

8.0

extractlib

Extract objects from a list of libraries

(7.3.4)

fmputl

File mapping

9.2.0

fmputlhp

File mapping

9.2.0

genagtsh

Agent shared library generation

8.1.5

genclntsh

Generate shared client library for OCI, Pro*C and XA

(7.3.4)

genksms

Generate ksms.s to relocate SGA

8.0

gennfgt

Generate list of native network libraries - nnfgt.o

8.0

gennttab

Generate list of SQL*Net protocol adapters  -Output written to ntcontab.s

8.0

genoccish

Generate OCCI shared object

9.2.0

gensyslib

Generate list of operating system libraries to be linked into executables. Output written to $ORACLE_HOME/lib/sysliblist

(7.3.4)

helpins

Install SQL*Plus help system

(7.3.4)

hsalloci

Heterogeneous Agent

8.1.5

hsdepxa

Heterogeneous Agent

8.1.5

hsodbc

Heterogeneous Services ODBC

8.1.6

hsots

Heterogeneous Services Oracle Transaction Service

8.1.5

imp

Import

(7.3.4)

isqlplus

Browser based SQL*Plus interface

9.2.0

jpub   

Publish Java classes

8.1.5

kgmgr

Net Configuration Assistant

8.1.6

kgpmon

Unknown

8.1.5

ldapadd

LDAP management

8.1.6

ldapaddmt

LDAP management

8.1.6

ldapbind

LDAP management

8.1.6

ldapcompare

LDAP management

8.1.6

ldapdelete

LDAP management

8.1.6

ldapmoddn

LDAP management

8.1.6

ldapmodify

LDAP management

8.1.6

ldapmodifymt

LDAP management

8.1.6

ldapsearch

LDAP management

8.1.6

ldifmigrator

OID Migration Tool

9.2.0

ldifwrite

Oracle Internet Directory - write LDIF file

8.1.6

lmsgen

Binary message file generation

8.1.5

loadjava

loads java objects

8.1.5

loadpsp

loads pl/sql server pages

8.1.6

lsnrctl

Listener control

(7.3.4)

lxchknlb

Net Configuration Assistant

(7.3.4)

lxegen

NLS Calendar

(7.3.4)

lxinst

NLS Data Install

(7.3.4)

mapsga

Provides SGA map

9.2.0

maxmem

Displays RAM stats

(7.3.4)

Mig

Migrate

(7.3.4)

migprep

Migrate Prepare

8.1.5

moda

 

9.2.0

names

Oracle Names

8.1.6

namesctl

Oracle Names Control

8.1.6

ncomp

Native Compiler (Java)

8.1.7

netca

Net Configuration Assistant

8.1.5

netmgr

Net Assistant

9.0.1

Nid

Set new database ID

9.2.0

Nmu7q28

Oracle Intelligent Agent

9.0.1

nmudg

Oracle Intelligent Agent

9.0.1

nmumigr8

Oracle Data Gatherer

9.0.1

ociconv

Convert OCI source from short (8.0.1) to long (8.0.2) function names

8.0

Ocm

Oracle Change Manager

9.0.1

odisrv

Oracle Internet Directory

9.0.1

odisrvreg   

Oracle Internet Directory

9.0.1

oemLaunchOms

Oracle Mgmt. Server

9.0.1

oemapp

Oracle Enterprise Manager

8.1.6

oemctl

OEM Control

9.0.1

Oemevent

Oracle Intelligent Agent

8.1.5

oerr

Error Lookup

(7.3.4)

oidadmin

Oracle Internet Directory

8.1.6

oidctl

Oracle Internet Directory

8.1.7

oidldapd

Oracle Internet Directory

9.2.0

oidmon

Oracle Internet Directory

8.1.7

oidpasswd

Oracle Internet Directory

8.1.6

oidprovtool

Oracle Internet Directory

9.2.0

oidreconcile

Oracle Internet Directory

8.1.7

oidrepld

Oracle Internet Directory

9.2.0

ojspc

JSP Compiler

9.0.1

okdstry

Delete Kerberos ticket

8.1.7

okinit

New Kerberos ticket

8.1.7

oklist

Check Kerberos ticket

8.1.6

onrsd

Oracle Names

8.0

oracg

Class Generator

9.0.1

oracle

Oracle executable

(7.3.4)

oradism

Dynamic ISM

9.0.1

oraenv

Manages environment

(7.3.4)

orapwd

Manages passwords

(7.3.4)

oratclsh

TCL Shell

8.0

oraxml

XML Processor

9.0.1

oraxsl

XSLT Processor

9.0.1

osh

Called from oraenv

8.0

otrccol

Oracle trace collector

(7.3.4)

otrccref

Oracle trace purge collect.dat file

(7.3.4)

otrcfmt

Oracle trace format

(7.3.4)

otrcrep

Oracle trace report

(7.3.4)

ott

Object Type Translator

8.0

ott8

Object Type Translator

9.0.1

Owm

Oracle Wallet Manager

8.1.6

passwdconvert

Unknown

9.2.0

Proc

Pro*C

(7.3.4)

procob

Pro*COBOL

(7.3.4)

procob18

Pro*COBOL

8.1.6

Profor

Pro*Fortran

8.1.6

relink

Relink executables

8.1.5

Rman

Recovery Manager

8.0

rtsora

COBOL Runtime System

(7.3.4)

runInstaller

Net Configuration Assistant

8.1.5

sbttest

Media Manager

8.1.5

schema

XML validation

9.0.1

schemasync

synchronizes schema elements; used with Oracle Directory Server

9.2.0

Sqlj

SQLJ 

8.1.5

sqlldr

SQL*Loader

(7.3.4)

sqlplus

SQL*Plus

(7.3.4)

statusnc

Native Compilation Status

8.1.7

symfind

Symbolic find

(7.3.4)

sysresv

Shared Memory / Semaphores

8.1.5

tkprof

Trace output formatter

(7.3.4)

tns2nis

TNS NIS Mapping

8.1.6

tnslsnr

TNS Listener

(7.3.4)

tnsping

Listener pinger

(7.3.4)

transx

XML

9.2.0

trcasst

Trace Assistant

8.0

trcroute

Network analysis

(7.3.4)

tstshm

Shared memory

(7.3.4)

Umu

LDAP

9.2.0

unzip

Unzip utility

9.2.0

Wrap

PL/SQL encrypter

(7.3.4)

Xml

XML / XSL processing

9.0.1

xmlcg

XML processing

9.2.0

Xsql

XSQL Pages

9.0.1

zip

Zip Utility

9.2.0

Table 1.3:  List of UNIX Binaries


 

 

��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.