How to graphically create an Oracle database

Source: Internet
Author: User

Some points to be aware of

1. If you use an Oracle client to access the server, you must write the host name of the server (the name of the computer)
How Oracle Creates a database

2. Navigate how to remote Oracle database

E:\app\lenovo\product\11.1.0\client_1\BIN the Oci.dll file below to replace the naviaget corresponding file

There are ways to create a database

1. Create a configuration or delete a database by running the Oracle database configuration Assistant (you can also enter DBCA at the command line);
2. Create a database using the command line method
3. Create a configuration or delete a database by running a custom batch script (or Create_oracle_sid.bat (Create_oracle_sid.sql))

A graphical way to create a database

Method/Step

  1. 1

    Start from the Windows desktop → programs → Oracle-<ORACLE_HOME_NAME> → configuration and transpose tools → Database configuration Assistant command, Open the Welcome screen of the Database Configuration Assistant dialog box, click the Next button in the interface

  2. 2

    To enable the CREATE database option, click the Next button to enter the Step 2: Database Templates interface

  3. 3

    To enable the general purpose or transaction processing option, click the Next button to enter the "Step 3: Database Identity" interface

  4. 4

    Set the global database name for the new database in the Step 3: Database Identity interface, which is set to MYORCL, and the database instance name (SID) defaults to the global database name and MYORCL

  5. 5

    Once the password is set, click the Next button to enter the "Step 6: Storage Options" interface, where the "file system" option is enabled

  6. 6

    Click the Next button to go to the "Step 7: Database files where" interface. Once you've set up your storage location, click the Next button and go to the step

  7. 7

    ¤ Use the default settings, click the "Next" button to enter the "Step 9: Database Content" interface, which can be configured for example scenarios and custom scripts. With the default settings, click the Next button to enter the Step 10: Initialize Parameters interface, which allows you to configure memory, resizing, character set, and connection mode. With the default settings, click the Next button to enter the "Step 11: Security Settings" interface, where the default settings, the "preserve enhanced 11g Default security settings" option are enabled. ¤ Click the "Next" button to go to the "Step 12: Automatic Maintenance Task" screen, in which the "Enable Automatic maintenance task" option is selected.

  8. 8

    Click the Next button to enter the "Step 13: Database Storage" interface, where you can specify the storage parameters of the database, click the "Next" button to enter the "Step 14: Create Options" interface

  9. 9

    Click the Finish button to start creating a new database by clicking the OK button in the confirmation dialog box that pops up

    Ii. creating a database using the command line method

    Connect/as SYSDBA

    STARTUP pfile= ' C:oracleadmininit_testorcl.ora ' nomount;

    CREATE DATABASE testorcl datafile '/u02/oracle/testorcl/system01.dbf ' SIZE 100M

    LOGFILE GROUP1 ('/u01/oracle/testorcl/redo1a.log ', '/u02/oracle/testorcl/redo1b.log ') SIZE 500K, GROUP2 ('/u01/oracle /testorcl/redo1a.log ', '/u02/oracle/testorcl/redo1b.log ') SIZE 500K CHARACTER SET zhs16cgb231280;

    --Convert the database directly from an out-of-build state to an open state

    ALTER DATABASE OPEN;

    --delete database (dropping a)

    SPOOL C:drop_database. BAT

    SELECT ' DEL ' | | NAME Delete database related data file from V$datafile;

    SELECT ' DEL ' | | MEMBER Delete Data refactoring log file from V$logfile; SPOOL OFF;

    Advantages: Can be familiar with the creation of instructions, the creation of principles, shortcomings: Simple configuration, requires memorizing command-line instructions;

    3. Create a custom batch or SQL script (Create_oracle_sid.bat or Create_oracle_sid.sql) by running it

    --create_oracle_sid.bat

    Set oracle_sid= Oracle_sid.

    Del C:oracle8idatabasepwdoracle_sid.ora

    C:oracle8ibinoradim-new-sid Oracle_sid. -intpwd Oracle-startmode Manual

    -pfile C:oracle8iadminoracle_sidpfileinit.ora

    C:ORACLE8IBINSVRMGRL @c:winntprofilesadministratorlboracle_sidrun.sql

    C:ORACLE8IBINSVRMGRL @c:winntprofilesadministratorlboracle_sidrun1.sql

    C:oracle8ibinoradim-edit-sid Oracle_sid-startmode Auto

    --oracle_sidrun.sql Spool

    C:oracle8iadminoracle_sidcreatecreatedb

    Set echo on

    Connect internal/oracle

    Startup Nomount Pfile=c:oracle8iadminoracle_sidpfileinit.ora

    CREATE DATABASE Oracle_sid

    LOGFILE ' C:oracle8ioradataoracle_sidredo01.log ' SIZE 1024K,

    ' C:oracle8ioradataoracle_sidredo02.log ' SIZE 1024K

    Maxlogfiles 32

    Maxlogmembers 2

    Maxloghistory 1

    DataFile ' c:oracle8ioradataoracle_sidsystem01.dbf ' SIZE 50M reuse

    Maxdatafiles 254

    Maxinstances 1

    CHARACTER SET Zht16big5

    National CHARACTER SET Zht16big5;

    Spool off

    --oracle_sidrun1.sql

    Spool C:ORACLE8IADMINORACLE_SIDCREATECREATEDB1

    Set echo on

    Connect internal/oracle

    ALTER DATABASE datafile ' c:oracle8ioradataoracle_sidsystem01.dbf ' autoextend on;

    CREATE ROLLBACK SEGMENT sysrol tablespace "SYSTEM" STORAGE (INITIAL 100K NEXT 100K);

    ALTER ROLLBACK SEGMENT "Sysrol" ONLINE;

    Another thing I want to say is that after you create a new global database:

    The password for SYS is: change_on_install

    The password for system is: Manager

    The first servers that are started are:

    Oracleorahome90agent

    Oracleorahome90tnslistener

    Oracleservice (Your database name: For example, the database you created and the SID name: New, this is new)

How to graphically create an Oracle database

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.