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

This article mainly introduces how to start and close Oracle under Linux, which has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, let the editor take you to understand it.

Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system of Oracle. It is a leading product in the field of database.

1. Start Oracle under Linux and Oracle Linux. There are two steps:

1) start monitoring

2) start the database instance

1. Log in to the server, switch to oracle, or log in as oracle

[admin@dataserver ~] $su-oracle password: [oracle@dataserver ~] $2. Turn on the listening service

[oracle@localhost ~] $lsnrctl start can view the health status of Oracle listeners through the lsnrctl status command

[oracle@localhost] $lsnrctl status3. Log in to Oracle as SYS

[oracle@localhost] $sqlplus / nologSQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 1 23:29:19 2017Copyright (c) 1982, 2009, Oracle. All rights reserved.SQL > conn / as sysdbaConnected to an idle instance. Switch users:

CONN username / password [AS SYSDBA]. If you are a sys user, you must write AS SYSDBA.

4. Start the instance with the startup command

SQL > startupORACLE instance started.Total System... Database mounted.Database opened.SQL > II. Close Oracle1 under Linux. Close the database instance

SQL > shutdownDatabase closed.Database dismounted.ORACLE instance shut down.SQL > quitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options2. Turn off the listener

[oracle@localhost] $lsnrctl stop Thank you for reading this article carefully. I hope the article "how to start and close Oracle under Linux" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.