Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Basic operation of Oracle

2025-04-01 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report