Oracle 10g startup Em, isqlplus and related command syntax under Oracle Linux

Source: Internet
Author: User

Reprint: http://hancang2000.blog.sohu.com/139239421.html


Oracle_home/bin/emctl Start Dbconsole

$ORACLE _home/bin/isqlplusctl Start

Emctl Common Command syntax:

Emctl start Dbconsole Launch the EM console service, you need to set the ORACLE_SID environment variable before use

Emctl Stop Dbconsole stops the EM console service, you need to set the ORACLE_SID environment variable before use


Use the command-line tool EMCA to create, modify, rebuild, or delete dbcontrol configurations. Using the command line tool, EMCTL can start/Stop the EM console service and view the service status

such as

EMCA Common Command syntax:

Emca-repos Create an EM repository

Emca-repos recreate rebuilding an EM database

Emca-repos drop Delete an em repository

Emca-config Dbcontrol DB Configuration Database Control

Emca-deconfig Dbcontrol db To delete database control configuration

Emca-reconfig Ports reconfigure the ports of the DB control and agent

Note: By viewing the $oracle_home/install/portlist.ini file you can know which port the current Dbcontrol is using, the default Dbcontrol HTTP port 1158,agent Port

3938. If you want to reconfigure the port, you can use the following command:

Emca-reconfig Ports-dbcontrol_http_port 1159

Emca-reconfig Ports-agent_port 3939

Oracle under Linux has a different startup and shutdown from the previous version after 10g
9i has no SVRMGRL, all the management work through the Sqlplus to complete
Start the database step as follows:

Note: $ORACLE _home is the installation path for ORACLE

1, log on as an Oracle user
Su Oracle
2. Start the TNS Listener
$ORACLE _home/bin/lsnrctl Start
3, start the database with Sqlplus
$ORACLE _home/bin/sqlplus/nolog
Sql> Connect System/change_on_install as Sysdba
Sql> Startup


The following appears to indicate that Oracle has successfully started
ORACLE instance started.

Total System Global area 205520896 bytes
Fixed Size 778392 bytes
Variable Size 74456936 bytes
Database buffers 130023424 bytes
Redo buffers 262144 bytes
Database mounted.
Database opened.

4, stop the database with Sqlplus

$ORACLE _home/bin/sqlplus/nolog
Sql> Connect System/change_on_install as Sysdba
sql> shutdown

Note: The shutdown can be turned off option, from the mildest to the most brutal behavior options (shutdown, shutdown transactional, shutdown immediate, shutdown abort)
The command is explained below
Shutdown: Shut down, wait for each user to exit the system war be canceled after exiting to close the database.

Shutdown transactional: Transactional shutdown, waiting for each user to submit a war fallback to the current transaction, and then Oracle cancels the conversation and shuts down after all users have exited the system.

Shutdown immediate: Directly close, cancel all user conversations (prompting fallback), and perform a normal shutdown program.

Shutdown Abort: Terminate shutdown, no automatic checkpoint war log switch when closing database.

Appears as shown below, indicating that Oracle has stopped
Database closed.
Database dismounted.
ORACLE instance shut down.

Share to:
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.