Oracle create database syntax

Source: Internet
Author: User

Here are several ways to manually issue the "create database" syntax for Oracle:

  • Extremely minimal manual database creation

  • OMF minimal manual create database syntax

  • Standard Oracle create database syntax

Extremely minimal manual database creation

 

1. Set your oracle_sid

 

Export oracle_sid = test

Export ORACLE_HOME =/path/to/Oracle/home

 

2. Create a minimal init. ora

 

# $ ORACLE_HOME/dbs/init <Sid>. ora Control_files = (/path/to/control1.ctl,/path/to/control2.ctl,/path/to/control3.ctl)Undo_management = autoUndo_tablespace = undotbs1Db_name = testDB _ block_size = 8192Sga_max_size = 1073741824 # One gigSga_target = 1073741824 # One gig

 

3. Create a password file

 

$ ORACLE_HOME/bin/orapwd file = $ ORACLE_HOME/dbs/pwd <Sid>. ora Password = Oracle entries = 5

 

4. Start the instance

 

Sqlplus/As sysdba

Startup nomount

 

5. Create the database

 

Create Database TestLogfile group 1 ('/path/to/redo1.log') size 100 m,Group 2 ('/path/to/redo2.log') size 100 m,Group 3 ('/path/to/redo3.log') size 100 mCharacter Set we8iso8859p1National Character Set utf8Datafile '/path/to/system. dbf' size 500 m autoextend on next 10 m maxsize unlimited extent management localSysaux datafile '/path/to/sysaux. dbf' size 100 m autoextend on next 10 m maxsize UnlimitedUndo tablespace undotbs1 datafile '/path/to/undotbs1.dbf' size 100 mDefault temporary tablespace temp tempfile '/path/to/temp01.dbf' size 100 m;

 

Note:There's some other things you can do here, like "archivelog" "set time_zone =" and "user SYS identified by password" and "user system identified by password"

 

6. Run catalog and catproc 

@? /Rdbms/admin/CATALOG. SQL

@? /Rdbms/admin/catproc. SQL
 

7. Change passwords

Alter user SYS identified by whatever;

Alter user system identified by whatever;

OMF minimal manual create database syntax

 

1. Set your oracle_sid

 

Export oracle_sid = testExport ORACLE_HOME =/path/to/Oracle/home

 

2. Create a minimal init. ora

 

# $ ORACLE_HOME/dbs/init <Sid>. ora Control_files = (/path/to/control1.ctl,/path/to/control2.ctl,/path/to/control3.ctl)Undo_management = autoDb_name = testDB _ block_size = 8192Sga_max_size = 1073741824 # One gigSga_target = 1073741824 # One gigDb_create_file_dest =/path/to/datafile/location # OMFDb_create_online_log_dest_1 =/path/to/First/redo_and_control_file/location # OMFDb_create_online_log_dest_2 =/path/to/Second/redo_and_control_file/location # OMFDb_recovery_file_dest =/path/to/flash/recovery/area # OMF# Note it's a good idea to also have background_dump_dest, user_dump_dest, and core_dump_dest here well

 

3. Create a password file

 

$ ORACLE_HOME/bin/orapwd file = $ ORACLE_HOME/dbs/pwd <Sid>. ora Password = Oracle entries = 5

 

4. Start the instance

 

Sqlplus/As sysdba

Startup nomount

 

5. Create the database

 

Create Database TestCharacter Set we8iso8859p1National Character Set utf8Undo tablespace undotbs1Default temporary tablespace temp;

 

You can even do this and it will work, the ultimate in minimalism:

 

Create Database test;

 

Note: There's some other things you can do here, like "archivelog" "set time_zone =" and "user SYS identified by password" and "user system identified by password"

 

NOTE 2: This is so minimal because you are using Oracle managed files as seen in #2

 

6. Run catalog and catproc

@? /Rdbms/admin/CATALOG. SQL

@? /Rdbms/admin/catproc. SQL

Standard create database syntax

After creating your init. ora file with the appropriate parameters you can use the "create database" command in SQL * Plus to create a database:

Make sure that your have your $ ORACLE_HOME and $ oracle_sid set properly and that you sign-on as sysdba:

Startup nomount;

Create controlfile reuse Database "oldlsq" noresetlogs
Noarchivelog
Maxlogfiles 16
Maxlogmembers 2
Maxdatafiles 240
Maxinstances 1
# Maxloghistory 113
Logfile
Group 1 ('/U03/oradata/oldlsq/log1a. dbf ',
'/U03/oradata/olslsq/log1b. dbf') size 30 m,
Group 2 ('/u04/oradata/oldlsq/log2a. dbf ',
'/U04/oradata/oldlsq/log2b. dbf') size 30 m
Datafile
'/U01/oradata/oldlsq/system01.dbf ',
'/U01/oradata/oldlsq/mydatabase. dbf'
;


This is just an abbreviated sample of the Oracle create database Command and there are available more options:

{
Function onmousedown ()
{
Return CLK (this. href, '','', 'res', '1 ','')
}
} "Href =" oracle_tips_db_copy.htm "> clone/copy Oracle with create database Command

{
Function onmousedown ()
{
Return CLK (this. href, '','', 'res', '2 ','')
}
} "Href =" oracle_news/2004_12_31_server_configuration.htm "> server configuration in Oracle Database 10g

Oracle create database documentation

{
Function onmousedown ()
{
Return CLK (this. href, '','', 'res', '1 ','')
}
} "Href =" o10g_20.htm "> Oracle 10g automatic create database dbca

{
Function onmousedown ()
{
Return CLK (this. href, '','', 'res', '2 ','')
}
} "Href =" oracle_news/2004_2_8_rittman.htm "> Oracle9i dbca database creation assistant templates

{
Function onmousedown ()
{
Return CLK (this. href, '','', 'res', '3 ','')
}
} "Href =" t_oracle10g_389_rac_database_.htm "> RAC grid database creation dbca

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.