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

Solution: a multi-instance of server oracle has one instance not started. You need to start the tutorial manually.

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

Share

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

Background:

Centos 6.5 deploys two database instances orcl1 and orcl2 within a single server

Orcl1 is running normally, orcl2 link is not up (instance is not started)

Orcl2 needs to be started without affecting the operation of orcl1.

Operation steps: 1. Use oracle user to log in to the host

You can also switch to oracle after root login

Command: su - oracle

2. Switch the ORACLE_SID variable to orcl2

Command: export ORACLE_SID=orcl2

3. sqlplus logged in as sysdba

Command: sqlplus sys/system as sysdba

4. start

Command: Startup

if no error is reported, the startup is successful;

5. Exit sqlplus

Command: QUIT

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