大龙的博客

常用链接

统计

最新评论

oracle数据库的启动,关闭

1. 启动oracle

开启实例:  1. [oracle@localhost ~]$ sqlplus /nolog

                  SQL*Plus: Release 9.2.0.6.0 - Production on Tue Apr 14 14:50:19 2009

                  Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

                  SQL> connect / as sysdba
                  Connected to an idle instance.
                  SQL> startup
                  ORACLE instance started.

                  Total System Global Area  403772836 bytes
                  Fixed Size                   452004 bytes
                  Variable Size             184549376 bytes
                  Database Buffers          218103808 bytes
                  Redo Buffers                 667648 bytes
                  Database mounted.
                  Database opened.
                  SQL> quit
                  Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
                  With the Partitioning and Oracle Data Mining options
                  JServer Release 9.2.0.6.0 - Production

启动监听:2. lsnrctl start
2.关闭oracle
关闭实例: 1.[oracle@localhost ~]$ sqlplus /nolog

            SQL*Plus: Release 9.2.0.6.0 - Production on Tue Apr 14 14:51:45 2009

            Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

            SQL> connect /as sysdba
            Connected.
            SQL> shutdown immediate
            Database closed.
            Database dismounted.
            ORACLE instance shut down.
            SQL> exit
            Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
            With the Partitioning and Oracle Data Mining options
            JServer Release 9.2.0.6.0 - Production

关闭监听: 2. lsnrctl stop


 

posted on 2011-07-11 17:44 大龙 阅读(104) 评论(0)  编辑 收藏 引用


只有注册用户登录后才能发表评论。
网站导航: 博客园   IT新闻   BlogJava   博问   Chat2DB   管理