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

[oracle11g] overall startup and shutdown

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

Share

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

1. Shut down the database

[default orcl] sqlplus / nologconn sys/sys as sysdba;shutdown immediate;-- disable all instance lsnrctl stop

two。 The database instance that is closed separately cannot be started at present

[uu] sqlplus / nologconn sys/sys@uu as sysdba;shutdown immediate;-- close yourself, and you can't start after closing--! [uu2] sqlplus / nologconn sys/sys@uu2 as sysdba;shutdown immediate;-- close yourself, you can't start after shutting down!

3. Start the database

[session1] lsnrctl startsqlplus / nologconn sys/sys as sysdba;startup;-start all instances and start each instance separately to learn [session2] lsnrctl status

4. Check which instance is being used

SQL > select instance_name from vault instance

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