Manually creating Oracle instances under Windows

Environment version:

Oracle 11g R2

Windows 7 Ultimate Edition X32

Steps Directory:

1. Determine the database and instance name

2. Confirm the database authentication method

3. Create a database initialization parameter file

4. Create an instance

5. Connect and launch the instance

6. Creating a database using Create databases

7. Create a database-attached table space

8. Run the script to create a data dictionary view

9. Create a server initialization file

Specific implementation:

1. Determine the database and instance name

Db_name = dbbymanual

SID = dbbymanual

2. Determine the database authentication method

There are two types of authentication methods for database authentication:

A. System certification

B. Password Authentication

This implementation adopts the system authentication method.

3. Create a database initialization file

The database initialization parameter files provided by ORACLE are placed in the Initsmpl.ora file under $oracle_home\admin\sample\pfile, and we create the Initdbbymanual.ora using the Modify template method. Saved in the location you specify (to be used).

The parameters are as follows:

Shared Server Settings

Dispatchers= "(protocol=tcp) (service=dbbymanual)

Instance Name

Instance=dbbymanual

Security and audit settings

Remote_login_passwordfile=exclusive

Sort Area Size Setting

pga_aggregate_target=25165824

sort_area_size=524288

Global Database name settings

Db_domain= ""

Db_name=dbbymanual

Control files

Control_files= ("D:\oracle\oradata\DBBYMANUAL\CONTROL01. CTL ",

"D:\oracle\oradata\DBBYMANUAL\CONTROL02. CTL ",

"D:\oracle\oradata\DBBYMANUAL\CONTROL03. CTL ")

SGA Area Settings

Java_pool_size =33554432

large_pool_size=8388608

shared_pool_size=50331648

Cursor and library Cache settings

open_cursors=300

Fallback segment and undo table space Settings

Undo_management=auto

undo_retention=10800

Undo_tablespace=undotbs

Diagnostics and tracking information settings

Background_dump_dest=d:\oracle\admin\dbbymanual\bdump

Core_dump_dest=d:\oracle\admin\dbbymanual\cdump

Timed_statistics=true

User_dump_dest=d:\oracle\admin\dbbymanual\udump

User process settings

processes=150

Buffer and database size settings

db_block_size=8192

db_cache_size=25165824

Db_file_multiblock_read_count=16

4. Create an instance

Start-cmd, open the DOS interface

Set oracle_sid = dbbymanual;

Create a dbbymanual database with the Oradim command

Oradmin-new-sid dbbymanual-intpwd Dbbymanual-startmode manual-pfile D:\oracle\ora92\database

Note: Oradmin is a tool that Oracle provides to manage instances, create, modify, delete, start, and close an instance, and execute the C:\ORADMIN help command to see how the command is used.

5. Connect and launch the instance

C:\sqlplus/nolog

Sql>connect sys/mynewdb as SYSDBA;

Sql>startup Nomount;

6. Creating a database using the Create DB statement

Sql>create DATABASE dbbymanual

Maxinstances 1

Maxloghistory 1

Maxlogfiles 5

Maxlogmembers 5

Maxdatafiles 100

DataFile ' D:\oracle\oradata\DBBYMANUAL\system.dbf ' size 50M

UNDO tablespace undotbs datafile ' D:\oracle\oradata\DBBYMANUAL\undotbs.dbf ' size 50M autoextend on NEXT 5120K MAXSIZE Unli mited

DEFAULT Temporary tablespace tempts

CHARACTER SET Us7ascii

National CHARACTER SET AL16UTF16

LOGFILE GROUP 1 (' D:\oracle\oradata\DBBYMANUAL\redo01.log ') size 100M,

Group 2 (' D:\oracle\oradata\DBBYMANUAL\redo02.log ') size 100M, Group 3 (' D:\oracle\oradata\DBB Ymanual\redo03.log ') size 100M;

While executing the CREATE DATABASE statement, the $ORACLE_HOME\RDBMS\ADMIN\SQL.BSQ script is executed automatically, creating the system tablespace and system fallback segments, establishing SYS and system accounts, establishing a data dictionary base table, Establish a data dictionary index, create predefined roles, and so on.

7. Create additional table spaces

There are only system, UNDOTBS, and temptbs three table spaces in the database created with the CREATE DATABASE statement, and additional table spaces need to be created:

Sql>create tablespace Users

DataFile ' d:\oracle\oradata\DBBYMANUAL\users01.dbf ' size 100M

Reuse Autoextend on next 1280K maxsize unlitited extend management local;

Sql>create tablespace Index

DataFile ' d:\oracle\oradata\DBBYMANUAL\index01.dbf ' size 100M

Reuse Autoextend on next 1280K MaxSize Unlimited extend management local;

8. Run the script to create a data dictionary view

sql>@d:\oracle\ora92\rdbms\admin\catalog.sql;

sql>@d:\oracle\ora92\rdbms\admin\catproc.sql;

9. Create a server initialization parameter file

Sql>create spfile from file= ' D:\oracle\ora92\database\initDBBYMANUAL.ora ';

Executing this statement creates a server initialization parameter file named Spfiledbbymanual.ora under the $oracle_home\database directory.

Need to restart database

Sql>shutdown immediate;

Sql>connect sys/dbbymanual as SYSDBA;

Sql>startup

This article is from the "Love Coffee" blog, please be sure to keep this source http://4837471.blog.51cto.com/4827471/1584351

Create an Oracle instance manually under Windows