How do you manage Oracle databases for a novice Oracle database? First of all, from the simplest startup and shutdown database, the following is a brief introduction to the sequence of starting and closing Oracle databases.
First, the Oralce start order:
1. Start the listener first (corresponding port 1521):
[] #lsnrctl start
2. Start Oracle instance:
[] #sqlplus/as sysdba (carriage return)
Sql>startup
--Starts with the default database instance in the environment variable $ORACLE _sid
--If multiple instances are started: Export Oracle_sid=ctaudit
[] #sqlplus/as sysdba (carriage return)
Sql>startup
3, Start EM (corresponding port 1158), Isqlplus (corresponding port 5560):
[] #emctl start Dbconsole
[] #isqlplusctl start
Ii. sequence of Oracle Closures
1, first close em,isqlplus:
[] #emctl Stop Dbconsole
[] #isqlplusctl stop
2, turn off the monitoring:
[] #lsnrctl stop
3. Close Oracle Instance:
[] #sqlplus/as sysdba (carriage return)
Sql>shutdown Immediate
The above is a small series to introduce the Oracle database to start and close the sequence of examples to explain, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!