Oracle Tutorial: Start services and listening commands in linux

Source: Internet
Author: User

  Fire Station Building Institute (LieHuo. Net) Database TechnologyOracle is the world's leading information management software developer and is well known for its complex relational database products. Oracle database products are used by the top 1000 companies in the Fortune ranking. Many large websites also use Oracle Systems. Oracle's relational database is the world's first database that supports the SQL language.

In linux, how does one start the service and listen to commands? First, you must log on as an oracle user:

1. Start the database:

Reference content is as follows:
Oracle @ suse92: ~> Sqlplus/nolog

SQL * Plus: Release 9.2.0.4.0-Production on Fri Jan 20 02:29:37 2006

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

SQL> connect/as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 135352820 bytes
Fixed Size 455156 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 679936 bytes
Database mounted.

2. Shut down the database:
Reference content is as follows:
Oracle @ suse92: ~> Sqlplus/nolog

SQL * Plus: Release 9.2.0.4.0-Production on Fri Jan 20 02:29:37 2006

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

SQL> connect/as sysdba
Connected to an idle instance.
SQL> shutdwon abort;

3. Start the listener

Reference content is as follows:
Oracle @ suse92: ~> Lsnrctl start

4. Stop the listener.
Reference content is as follows:
Oracle @ suse92: ~> Lsnrctl stop

5. View listener status
Reference content is as follows:
Oracle @ suse92: ~> Lsnrctl
LSNRCTL> status
LSNRCTL> exit

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.