Create an Oracle database instance in Linux

Source: Internet
Author: User
1. Open a terminal in the graphic interface of the Linux server and enter the following command. xhost + 2. Switch to the Oracle user and run the following command: su

1. Open a terminal in the graphic interface of the Linux server and enter the following command. xhost + 2. Switch to the Oracle user and run the following command: su-oracle 3

1. Open a terminal in the graphic interface of the Linux server and enter the following command;

Xhost +

2. Switch to an Oracle user and run the following command:
Su-oracle

3. Specify the variables and values of the database instance. Assume that the SID of the data instance to be created is test.
Export ORACLE_SID = test

4. Use DBCA to create an instance
Dbca

5. Start two instances manually
Su-oracle
Lsnrctl start
-- Assume that one instance is orcl and the other is test.
Export ORACLE_SID = orcl
Sqlplus/as sysdba
Startup
Quit
Export ORACLE_SID = test
Sqlplus/as sysdba
Startup
Quit

6. Automatic start. You can set it in/etc/rc. local and add the following content.
-- Start the default database instance
Su-oracle <lsnrctl start
Sqlplus/as sysdba
Startup
Quit
EOF
-- Start the second database instance
Su-oracle <export ORACLE_SID = test
Sqlplus/as sysdba
Startup
Quit
EOF

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.