它可以使用大部分oracle所提供的命令方式
解决方案 »
- 插入数据时去重,怎样做的效率高一些?
- 用一个数据库去连接另外一个数据库
- oracle中查询语句的问题?
- 急!求教高手关于linux下 oracle10g rac双实例无法同时启用的问题!!!
- oracle10g安装
- 求oracle11g的注册表安装信息!谢谢!
- oracle的逻辑判断(在表不存在期望的数据的判断)
- oracle9i客户端连接服务器端的问题
- “ORA-12560: TNS: 协议适配器错误”如何解决?
- oracle9i与oracle11查询日期
- 在JSP中有没有像ASP中的response.end语句?
- 如何在Win2000下卸载Oracle developer,注册表中的一个键值删不掉?
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.