`
yuky1327
  • 浏览: 125036 次
  • 性别: Icon_minigender_2
  • 来自: 广州
社区版块
存档分类
最新评论

ORACLE bin目录下各文件的意义及使用方法

阅读更多
$cd $ORACLE_HOME/bin
$pwd
/opt/oracle/db01/app/oracle/product/9.2.0/bin
$ls -l | wc -l
     204
$

举例:

$ dbfsize ts_test.dbf

Database file: ts_test.dbf
Database file type: file system
Database file size: 131072 8192 byte blocks
$ dbhome
/opt/ora10g/10.2.0

各工具解释如下:

Binary               First Available         Description
---------            ----------------          --------------------------------
adapters             (7.3.4)                 Installed Network Adapters
agentctl             9.0.1                   Agent Control Utility
agtctl               8.1.5                   Agent Control Utility
bulkmodify           8.1.6                   Oracle Internet Directory bulk
modify
cmadmin              8.1.6                   Connection Manager Administrator
cmctl                8.1.6                   Connection Manager Control
Utility
cmgw                 8.1.6                   Connection Manager Gateway
coraenv              (7.3.4)                 Oraenv command for Cshell
csscan               8.1.7                   Character Set Scanner
ctxkbtc              8.1.5                   InterMedia
ctxload              (7.3.4)                 InterMedia
ctxsrv               (7.3.4)                 InterMedia
cursize              8                       Cursor Size Tool
dbca                 9.0.1                   Database Creation Assistant
dbfmig               8.1.5                   Datafile Migrator
dbfsize              (7.3.4)                 Datafile Size
dbhome               (7.3.4)                 displays Oracle$HOME
dbshut               (7.3.4)                 shuts down Oracle
dbsnmp               8                       Intelligent Agent
dbsnmpj              9.0.1                   Intelligent Agent Job Processor
(not Java or JRE)
dbsnmpwd             9.0.1                   Intelligent Agent
dbstart              (7.3.4)                 Starts Oracle
dbua                 9.2.0                   Database Upgrade Assistant
dbv                  (7.3.4)                 Verifies datafiles
debugproxy           8.1.7                   Oracle JVM Debugging
demobld              (7.3.4)                 Table Build for Oracle Developer
demo
demodrop             (7.3.4)                 Table drop for Oracle Developer
demo
deploync             8.1.7                   JAR file deployment
dgmgrl               9.0.1                   Data Manager
dropjava             8.1.5                   Drops java objects
dumpsga              9.2.0                   Dumps SGA contents
echodo               (7.3.4)                 Echo command and print it
ela                  9.0.1                   Enterprise Login Assistant
emca                 9.0.1                   (Enterprise Manager?)
emwebsite            9.0.1                   (Enterprise Manager?)
Esm                  9.2.0                   Enterprise Security Manager
Command Line Utility
exp                  (7.3.4)                 Export
extproc              8                       External Process Agent
extractlib           (7.3.4)                 Extract objects from a list of
libraries
fmputl               9.2.0                   File mapping
fmputlhp             9.2.0                   File mapping
genagtsh             8.1.5                   Agent shared library generation
genclntsh            (7.3.4)                 Generate shared client library
for OCI, Pro*C and XA
genksms              8                       Generate ksms.s to relocate SGA
gennfgt              8                       Generate list of native network
libraries - nnfgt.o
gennttab             8                       Generate list of SQL*Net protocol
adapters   -Output written to ntcontab.s
genoccish            9.2.0                   Generate OCCI shared object
gensyslib            (7.3.4)                 Generate list of operating system
libraries to be linked into executables. Output written to
$ORACLE_HOME/lib/sysliblist
helpins              (7.3.4)                 Install SQL*Plus help system
hsalloci             8.1.5                   Heterogeneous Agent
hsdepxa              8.1.5                   Heterogeneous Agent
hsodbc               8.1.6                   Heterogeneous Services ODBC
hsots                8.1.5                   Heterogeneous Services Oracle
Transaction Service
imp                  (7.3.4)                 Import
isqlplus             9.2.0                   Browser based SQL*Plus interface
jpub                 8.1.5                   Publish Java classes
kgmgr                8.1.6                   Net Configuration Assistant
kgpmon               8.1.5                   Unknown
ldapadd              8.1.6                   LDAP management
ldapaddmt            8.1.6                   LDAP management
ldapbind             8.1.6                   LDAP management
ldapcompare          8.1.6                   LDAP management
ldapdelete           8.1.6                   LDAP management
ldapmoddn            8.1.6                   LDAP management
ldapmodify           8.1.6                   LDAP management
ldapmodifymt         8.1.6                   LDAP management
ldapsearch           8.1.6                   LDAP management
ldifmigrator         9.2.0                   OID Migration Tool
ldifwrite            8.1.6                   Oracle Internet Directory - write
LDIF file
lmsgen               8.1.5                   Binary message file generation
loadjava             8.1.5                   loads java objects
loadpsp              8.1.6                   loads pl/sql server pages
lsnrctl              (7.3.4)                 Listener control
lxchknlb             (7.3.4)                 Net Configuration Assistant
lxegen               (7.3.4)                 NLS Calendar
lxinst               (7.3.4)                 NLS Data Install
mapsga               9.2.0                   Provides SGA map
maxmem               (7.3.4)                 Displays RAM stats
mig                  (7.3.4)                 Migrate
migprep              8.1.5                   Migrate Prepare
modada               9.2.0
names                8.1.6                   Oracle Names
namesctl             8.1.6                   Oracle Names Control
ncomp                8.1.7                   Native Compiler (Java)
netca                8.1.5                   Net Configuration Assistant
netmgr               9.0.1                   Net Assistant
Nid                  9.2.0                   Set new database ID
Nmu7q28              9.0.1                   Oracle Intelligent Agent
nmudg                9.0.1                   Oracle Intelligent Agent
nmumigr8             9.0.1                   Oracle Data Gatherer
ociconv              8                       Convert OCI source from short
(8.0.1) to long (8.0.2) function names
ocm                  9.0.1                   Oracle Change Manager
odisrv               9.0.1                   Oracle Internet Directory
odisrvreg            9.0.1                   Oracle Internet Directory
oemLaunchOms         9.0.1                   Oracle Mgmt. Server
oemapp               8.1.6                   Oracle Enterprise Manager
oemctl               9.0.1                   OEM Control
Oemevent             8.1.5                   Oracle Intelligent Agent
oerr                 (7.3.4)                 Error Lookup
oidadmin             8.1.6                   Oracle Internet Directory
oidctl               8.1.7                   Oracle Internet Directory
oidldapd             9.2.0                   Oracle Internet Directory
oidmon               8.1.7                   Oracle Internet Directory
oidpasswd            8.1.6                   Oracle Internet Directory
oidprovtool          9.2.0                   Oracle Internet Directory
oidreconcile         8.1.7                   Oracle Internet Directory
oidrepld             9.2.0                   Oracle Internet Directory
ojspc                9.0.1                   JSP Compiler
okdstry              8.1.7                   Delete Kerberos ticket
okinit               8.1.7                   New Kerberos ticket
oklist               8.1.6                   Check Kerberos ticket
onrsd                8                       Oracle Names
oracg                9.0.1                   Class Generator
oracle               (7.3.4)                 Oracle executable
oradism              9.0.1                   Dynamic ISM
oraenv               (7.3.4)                 Manages environment
orapwd               (7.3.4)                 Manages passwords
oratclsh             8                       TCL Shell
oraxml               9.0.1                   XML Processor
oraxsl               9.0.1                   XSLT Processor
osh                  8                       Called from oraenv
otrccol              (7.3.4)                 Oracle trace collector
otrccref             (7.3.4)                 Oracle trace purge collect.dat
file
otrcfmt              (7.3.4)                 Oracle trace format
otrcrep              (7.3.4)                 Oracle trace report
ott                  8                       Object Type Translator
ott8                 9.0.1                   Object Type Translator
owm                  8.1.6                   Oracle Wallet Manager
passwdconvert        9.2.0                   Unknown
proc                 (7.3.4)                 Pro*C
procob               (7.3.4)                 Pro*COBOL
procob18             8.1.6                   Pro*COBOL
Profor               8.1.6                   Pro*Fortran
relink               8.1.5                   Relink exeutables
rman                 8                       Recovery Manager
rtsora               (7.3.4)                 COBOL Runtime System
runInstaller         8.1.5                   Net Configuration Assistant
sbttest              8.1.5                   Media Manager
schema               9.0.1                   XML validation
schemasync           9.2.0                   synchronizes schema elements;
used with Oracle Directory Server
sqlj                 8.1.5                   SQLJ
sqlldr               (7.3.4)                 SQL*Loader
sqlplus              (7.3.4)                 SQL*Plus
statusnc             8.1.7                   Native Compilation Status
symfind              (7.3.4)                 Symbolic find
sysresv              8.1.5                   Shared Memory / Semaphores
tkprof               (7.3.4)                 Trace output formatter
tns2nis              8.1.6                   TNS NIS Mapping
tnslsnr              (7.3.4)                 TNS Listener
tnsping              (7.3.4)                 Listener pinger
transx               9.2.0                   XML
trcasst              8                       Trace Assistant
trcroute             (7.3.4)                 Network analysis
tstshm               (7.3.4)                 Shared memory
umu                  9.2.0                   LDAP
unzip                9.2.0                   Unzip utility
wrap                 (7.3.4)                 PL/SQL encrypter
xml                  9.0.1                   XML / XSL processing
xmlcg                9.2.0                   XML processing
xsql                 9.0.1                   XSQL Pages
zip                  9.2.0                   Zip Utility

--End--
分享到:
评论

相关推荐

    Oracle清理日志流程

    #### 一、Oracle日志清理背景及意义 在Oracle数据库管理过程中,日志文件的管理是一项重要的维护工作。随着数据库的持续运行,各种日志文件(包括警告日志和监听日志等)会不断累积,占用大量磁盘空间,并可能对...

    ORACLE安装之LINUX基础

    例如,`/usr/local/bin`就是一个绝对路径,它明确地指出了从根目录开始到达目标文件或目录的具体路径。 - **相对路径**:相对于当前工作目录的路径。例如,如果你当前所在的目录是`/usr/local/bin`,那么`../lib`...

    动态导入oracle数据库

    - **导出(Export)**:指的是将数据库中的数据或者对象从Oracle数据库中提取出来,并保存为一个二进制文件或文本文件的过程。 - **导入(Import)**:指的是将之前通过导出工具生成的文件重新加载到Oracle数据库中...

    Oracle11g-64bit客户端免绿色安装版

    5. **环境变量设置**:为了使免安装版的Oracle客户端正常工作,可能需要添加环境变量,例如TNS_ADMIN指向tnsnames.ora文件的位置,以及PATH包含Oracle客户端的bin目录,确保系统能找到必要的可执行文件。 6. **PL/...

    在suse下添加oracle 11g自动备份

    Oracle 11g作为一款广泛使用的数据库管理系统,其备份策略对于保障数据的安全性和可用性具有重要意义。本文将详细介绍如何在SUSE Linux操作系统上实现Oracle 11g数据库的自动化备份。 #### 知识点解析 ##### 1. ...

    oracle数据泵服务器备份

    ### Oracle 数据泵服务器备份知识点详解 #### 一、Oracle 数据...通过以上详细介绍,我们可以清晰地了解到如何使用 Oracle 数据泵进行数据库备份与恢复,这对于维护 Oracle 数据库系统的稳定性和可靠性具有重要意义。

    在Ubuntu上安装Oracle JDK

    尽管OpenJDK在多数场景下能够满足需求,但Oracle JDK仍然是一些特定应用的最佳选择。本文将详细介绍如何在Ubuntu上手动安装Oracle JDK,并提供一系列实用步骤确保安装过程顺利。 #### 安装前准备 在开始安装Oracle...

    oracle gateway + informix安装配置文档

    - 创建必要的目录结构以存放Oracle软件和数据文件,例如: ```bash mkdir /home/oracle/app mkdir /home/oracle/app/oracle mkdir /home/oracle/app/oradata mkdir /home/oracle/app/oracle/product chown -R...

    Oracle9i 精简安装程序

    用户只需双击这个文件,就可以启动Oracle9i的安装向导,按照提示进行下一步操作。MSI文件内部包含了所有安装所需的数据和脚本,可以自动处理依赖关系,确保安装过程的顺利进行。 "西西下载.txt"可能是安装指南或者...

    oracle图形使用教程

    - **配置环境变量**:在Windows环境中,运行`dbca`实际上是调用了`$ORACLE_HOME\bin\dbca.bat`批处理文件,该文件设置了必要的环境变量,并通过Java运行时环境启动DBCA。 - **DBCA在UNIX系统中的启动**:在UNIX系统...

    ORACLE9i客户端打包实践.pdf

    总之,Oracle 9i客户端的打包是一个涉及到目录结构、文件精简、配置调整和冲突避免的综合过程,其目标是创建一个高效、易部署且与服务器数据库兼容的客户端版本。这一过程对于优化企业级应用的分发和维护具有重要...

    linux根目录下各文件名的含义.docx

    /opt 目录:该目录是第三方软件在安装时默认会找这个目录,例如安装 Oracle 数据库时就会安装在该目录下。 /tmp 目录:该目录用来存放不同程序执行时产生的临时文件,该目录会被系统自动清理干净。 /proc 目录:该...

    ORACLE自动备份

    3. **PATH**:扩展系统环境变量`PATH`,增加Oracle的bin目录及用户的bin目录。 - **示例**:`$PATH:$ORACLE_HOME/bin:$HOME/bin` - **用途**:使得后续调用Oracle的相关工具时无需指定完整路径。 4. **USERID**:...

    何明 oracle 教程

    - **启动命令**: 通过`cd D:\oracle_10g\product\10.2.0\db_1\BIN`切换到Oracle二进制文件目录,并使用`isqlplusctl start`启动SQL*Plus控制台服务。 - **访问地址**: 可以通过`http://tgh:5560/isqlplus/`或`...

    Oracle数据导入导出imp/exp就相当于oracle数据还原与备份

    这是因为,在 Oracle 8i 版本中,安装目录 ora81\bin 已经被设置为了全局路径,该路径下包含 EXP.EXE 和 IMP.EXE 这两个文件,它们是用来执行导入导出操作的核心程序。 - **Java 编写**: Oracle 本身是使用 Java ...

    最新版 openjdk-15_linux-x64_bin.tar.gz

    4. **安装过程**:在Linux上安装OpenJDK 15通常涉及解压`.tar.gz`文件,进入解压后的目录,然后将Java可执行文件链接到系统的`/usr/bin`目录,以便全局访问。命令行操作可能包括`tar -zxvf openjdk-15_linux-x64_bin...

    实验11使用JSP在ORACLE上实现小型WEB应用系统[整理].pdf

    - 或者直接将这两个驱动文件复制到Web项目的 `WEB-INF/lib` 目录下。 - 同时,也可以将这些驱动文件复制到Tomcat的 `common/lib` 目录下。 #### 实现Java连接并读取Oracle中的数据 接下来,我们将具体探讨如何...

    jdk1.6-bin.zip

    这个压缩包文件"jdk1.6-bin.zip"包含了JDK 1.6版本的二进制文件,适用于Linux操作系统,特别是64位系统。JDK 1.6,也被称为Java SE(标准版)6,发布于2006年,它在Java平台上具有里程碑式的意义,引入了许多新特性...

Global site tag (gtag.js) - Google Analytics