oracle的启动与关闭 - iTePub Tech Article

1)启动服务器 dbstart

2)关闭服务器 dbshut

3)网络监听服务(请参考联接)lsnrctl

1)启动服务器

[oracle@lin /ora]$ dbstart

该命令校验用户身份后，调用SVRMGR工具,完成一下工序：

启用缺省参数文件init<ora8>.ora， 初始化内存，登录，打开数据库。

如果需要更多的控制参数，请看svrmgrl工具。

2)关闭服务器

[oracle@lin /ora]$ dbshut

该命令校验用户身份，调用SVRMGR工具,完成一下工序：

SVRMGR> Connected.

SVRMGR> Database closed.

Database dismounted.

ORACLE instance shut down.

SVRMGR>

Server Manager complete.

Database "ora8" shut down.

3)网络监听服务

启动： lsnrctl start

停止： lsnrctl stop

[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.

在你第一次使用数据库时，它的至少有两个管理员账户：

sys / change_on_install, 不要像以前那样，给一个自己都不知道的口令。切记：在你安装webdb时，需要它。

system / manager 系统缺省的管理员，记住再给它建造一个工具表空间,作为他的却省表空间：tools.

现在试一下sqlplus：

[oracle@lin /ora]$ sqlplus system/manager

SQL*Plus: Release 8.1.5.0.0 - Production on Sun Nov 7 10:08:30 1999

SQL> select * from tab;

SQL>  select * from sys.tab;

SQL> exit

最后提一下，Oracle+Linux 需要内存128MB，如果你运行了Apache Web进程的，那更需要内存。

[oracle@lin /ora]$ free

             total       used       free     shared    buffers     cached

Mem:        192984     116904      76080      53212       5652      78064

-/+ buffers/cache:      33188     159796

Swap:       530104          0     530104