Oracle 11.2 creates databases on bare Devices

Source: Internet
Author: User

Oracle 11.2 create a database on a bare device 1 Overview .... 12. Install the database software .. 13. Create a database using the script .. 14 confirm the information after completion .. 3 1 Overview Oracle 11.2 Oracle Universal Installer (OUI) and Database Configuration Assistant (DBCA) no longer support OCR and Voting Disks) put it on the raw/block device. However, the command line method still supports bare devices. For some special requirements, the following methods can be used to store data files in a database on a bare device: 1. if the database before 11.2 uses a bare device, you can continue to use the bare device after upgrading to 11.2. 2. Create a database using the command line method. 3. After the database is created, create a tablespace in SQLPLUS on the bare device. The test case in this article uses the command line method to create a database on a bare device. The test environment in this article is Linux (OEL5), and the steps for creating a bare device at the operating system level are omitted in this article. Note: oracle will not support bare devices in later versions, including OUI, DBCA, and command line. 2. During database software installation, only install the software without creating a database. 3. Create a database using a script. 1. run the dbca script to create a database. The process is the same as that before when DBCA creates a database. In the last step, only the database creation script is selected. 2. After completing the preceding steps, create a database script under $ ORACLE_BASE/admin/orl3/scripts/: [oracle @ serha scripts] $ ls CreateDBCatalog. SQL CreateDB. SQL lockAccount. SQL orcl3. SQL CreateDBFiles. SQL init. ora orcl3.sh postDBCreation. SQL 2. manually edit the database creation script to replace the file system where the data file is located with the bare device: CreateDB. SQL CreateDBFiles. SQL 3 Init. ora Note: Modify the above script as needed. 3. manually create a database and run it as an oracle user: $ ORACLE_BASE/admin/orl3/scripts/orcl3.sh 4. confirm the information.

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.