Process instance analysis for Oracle Database Configuration

Source: Internet
Author: User
Tags oracle database installation dedicated server

The following is a detailed analysis of the actual operations of the Oracle database installation and configuration process, including how to use the Oracle Database Configuration assistant to create a database and how to create a user, how to export all objects and table data in an Oracle database.

1. Use the Database Configuration assistant to create a database

1. Create a database

2. Select the template [Transaction Management]

3. database information [Global Database Name | SID [SALEDB]

4. database connection options [dedicated server mode]

5. initialization parameters

6. database storage

7. Create option [Create Database]

2. Create a user

Log on to the PL/SQL developer tool to activate SQL plus and run the SQL statement.

1. CREATE a USER [create user saleuser [USER name] identified by saleuser [Password] default tablespace users temporary tablespace temp quota umlimited on users]

2. authorize [grant dbac to saleuser [user name]

Iii. Export all objects and table data of the Oracle database

D: \ Oracle \ ORA92 \ BIN> [exp saleuser [user name]/SALEUSER [Password] @ Oracle_SERVER_SALE [Oracle service name] FILE = D: \ SALEDB. dmp owner = (SALEUSER [user name])]

4. Import all objects and table data of the Oracle database

D: \ Oracle \ ORA92 \ BIN> [imp saleuser [user name]/SALEUSER [Password] @ Oracle_SERVER_SALE [Oracle service name] FILE = D: \ SALEDB. dmp full = Y]

5. Basic import and export functions provided by PL/SQL DEVELOPER are as follows:

1. Export all database objects to the SQL File

2. There is no function procedure option to export the selected table to the DMP file)

3. There is no function procedure option to import the DMP file to the database)

6. Configure the service name

Start | Oracle | ORA HOME92 | configuration and migration tools | net manager | Oracle net configuration | Local | service name

7. Install the Oracle database

Oracle 9I has three disks, A \ B \ C. After mounting disk A | disk B, you must manually select disk B | disk C. During the installation process, select the default value. You only need to manually enter Step 1 [Database ID | global Oracle Database Name | SID] And enter ORCL. If the Oracle instance [database] exists, you can use ORCL2 or other names. After installation, you must set the database configuration assistant. Set the SYS password to SYS and the SYSTEM password to SYSTEM.

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.