Shulou(Shulou.com)06/01 Report--

I. start and shut down the database

1. How to start the database

Sqlplus / as sysdba-log in to the database

SQL > startup-start the database

two。 How to confirm that the database has been started

Method 1:

Ps-ef | grep pmon

Method 2:

Sqlplus / as sysdba-log in to the database

SQL > select status from vault instance;-query database status

STATUS

-

OPEN-indicates that the database has been started

3. How to close the database

Sqlplus / as sysdba

SQL > shutdown immediate

II. Automatic start of configuration database

1. Modify the configuration file / etc/oratab

Orcl:/oracle/app/db:Y

two。 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: to ensure that the current environment can call the graphical interface)

1. Start the listener

Lsnrctl start

two。 Path:

/ oracle/app/db/sqldeveloper

. / sqldeveloper.sh

3. Unlock the user

Alter user scott account unlock;-unlock the user

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.