Home > Database > Mysql Tutorial > body text

Oracle的一些有用程序

WBOY
Release: 2016-06-07 17:05:16
Original
961 people have browsed it

首先以Oracle用户登录 1、 $/oracle/oracle/app/product/101/bin/dbstart:启动数据库。 2、 $/oracle/oracle/app/product

首先以Oracle用户登录

  1、 $/oracle/oracle/app/product/101/bin/dbstart:启动数据库。

  2、 $/oracle/oracle/app/product/101/bin/dbshut:关闭数据库。

  3、 $/oracle/oracle/app/product/101/bin/dbca:数据库配置助理,进行数据库安装、删除和修改。

  4、 $/oracle/oracle/app/product/101/bin/netca:数据库网络服务配置管理。

  5、 $/oracle/oracle/app/product/101/bin/netmgr:数据库网络服务和监听配置助理.

  6、 $/oracle/oracle/app/product/101/bin/sqlplus:可运行SQL,进行数据库操作,并可起停数据库。运行sqlplus命令,输入sys用户和口令登陆以后,,运行如下命名:

  〉shutdown immediate 立即关闭数据库

  〉startup 启动数据库

  7、 $/oracle/oracle/app/product/101/bin/lsnrctl start:启动数据库监听

  $/oracle/oracle/app/product/101/bin/lsnrctl stop:关闭数据库监听

  $/oracle/oracle/app/product/101/bin/lsnrctl status:察看数据库监听

  8、emctl stop dbconsole  关闭oracle EM管理

linux

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!