Oracle's basic operations

First, start and close the database

1. How to start a database

Sqlplus/as SYSDBA---login database

Sql> Startup---Start the database

2. How to confirm that the database has been started

Method One:

Ps-ef | grep Pmon

Method Two:

Sqlplus/as SYSDBA ---login database

Sql> select status from V$instance; ---Querying database status

STATUS

------------

OPEN---Indicates that the database has started to complete

3. How to close a database

Sqlplus/as SYSDBA

sql> shutdown Immediate

Second, the automatic start of the configuration database

1. Modify/etc/oratab This configuration file

Orcl:/oracle/app/db:y

2. Modify $oracle_home/bin/dbstart

VI +78 $ORACLE _home/bin/dbstart

Oracle_home_listner=$1

Modified to:

oracle_home_listner=/oracle/app/db

3. Edit/etc/rc.local

Add the following command

Su-oracle "-C Dbstart"

Third, about the use of Sqldeveloper tools (premise: Ensure that the current environment can invoke the graphical interface)

1. Start the Listener

Lsnrctl start

2. Path:

/oracle/app/db/sqldeveloper

./sqldeveloper.sh

3. Unlocking the user

Alter user Scott account unlock; --Unlocking the user

This article is from "Rookie Talent" blog, please be sure to keep this source http://omphy.blog.51cto.com/7921842/1884500

Oracle's basic operations