它可以使用大部分oracle所提供的命令方式

解决方案 »

  1.   

    在sqlplus中能做的,它都能做。
      

  2.   

    嘿嘿: svrgmrl <> svrmgrl
      

  3.   

    来点实际的东西:
    http://216.239.33.100/search?q=cache:mlmM6WPxdLsC:www.lslnet.com/linux/docs/admin.htm+svrmgr%2Boracle%2B%E4%BB%8B%E7%BB%8D&hl=zh-CN&lr=lang_zh-CN|lang_zh-TW&ie=UTF-8&inlang=zh-CN高级工具:详细介绍 svrmgrl
    启动方法:
    [oracle@lin /ora]$ svrmgrl 
    Oracle Server Manager Release 3.1.5.0.0 - Production
    Oracle8i Enterprise Edition Release 8.1.5.0.1 - Production
    With the Partitioning and Java options
    PL/SQL Release 8.1.5.0.0 – Production
    如何获得使用帮助
    打入help,得到: 下面是简单的语法描述,详细资料请看Oracle Server Manager User's Guide.
    SVRMGR> help
    STARTUP      [DBA] [FORCE] [PFILE=filespec] [EXCLUSIVE | SHARED]
    [MOUNT dbname | OPEN dbname] [NOMOUNT] 
    SHUTDOWN     [NORMAL | IMMEDIATE | ABORT] 
    MONITOR      For graphical modes only, bring up a monitor 
    ARCHIVE LOG  [START] [STOP] [LIST] [NEXT] [<n>] [ALL] ['destination'] 
    RECOVER      { [DATABASE [MANUAL] ] | [TABLESPACE ts-name [,tsname]] } 
    CONNECT      [username [/password] ] [INTERNAL] ['@'instance-spec]
    DISCONNECT 
    SET          options: INSTANCE, ECHO, TERMOUT, TIMING, NUMWIDTH, CHARWIDTH
    SHOW         LONGWIDTH, DATEWIDTH, AUTOPRINT and for SHOW: ALL, SPOOL
    EXIT
    REM
    SQL statements can also be executed.
    以系统用户oracle登录:
    SVRMGR> connect internal
    Connected.
    关闭数据库,现在尝试一下?!
    SVRMGR> shutdown
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    启动数据库吧, 我想给它指定参数,并且打开:
    SVRMGR> startup pfile=/ora/dbs/initora8.ora open ora8
    ORACLE instance started.
    Total System Global Area                         23670160 bytes
    Fixed Size                                          64912 bytes
    Variable Size                                     6656000 bytes
    Database Buffers                                 16777216 bytes
    Redo Buffers                                       172032 bytes
    Database mounted.
    Database opened.
    测试一下啦, 先看看数据库的系统文件吧:
    SVRMGR> select * from system.sysfiles;
    TSNAME                         FNAME                                BLOCKS
    ------------------------------ -------------------------------------------------
    SYSTEM             /u01/app/oracle/oradata/ora8/system01.dbf           89600
    OEM_REPOSITORY     /u01/app/oracle/oradata/ora8/oemrep01.dbf           2560
    RBS                /u01/app/oracle/oradata/ora8/rbs01.dbf              6144
    TEMP               /u01/app/oracle/oradata/ora8/temp01.dbf             5120
    USERS              /u01/app/oracle/oradata/ora8/users01.dbf            5120
    INDX               /u01/app/oracle/oradata/ora8/indx01.dbf             5120
    6 rows selected.
    嗯, 感觉不错, 我会了,谢谢。现在退出休息一下吧。
    SVRMGR> exit
    Server Manager complete.