linux新建目录student,手动创建 student 数据库

手动创建 student 数据库。

-----------------------------------

实验环境:

数据库名称：student

数据库SID: student

数据库家目录： C:\oracle\

1.在家目录创建数据库所需的目录：

mkdir C:\oracle\product\10.2.0\admin\student\adump

mkdir C:\oracle\product\10.2.0\admin\student\bdump

mkdir C:\oracle\product\10.2.0\admin\student\cdump

mkdir C:\oracle\product\10.2.0\admin\student\dpdump

mkdir C:\oracle\product\10.2.0\admin\student\pfile

mkdir C:\oracle\product\10.2.0\admin\student\udump

mkdir C:\oracle\product\10.2.0\db_1\cfgtoollogs\dbca\student

mkdir C:\oracle\product\10.2.0\db_1\database

mkdir C:\oracle\product\10.2.0\flash_recovery_area

mkdir C:\oracle\product\10.2.0\oradata\student

2.

set ORACLE_SID=student  (实例ID名称)

3.创建数据库相关进程：

C:\oracle\product\10.2.0\db_1\bin\oradim.exe -new -sid student -startmode manual -spfile

C:\oracle\product\10.2.0\db_1\bin\oradim.exe -edit -sid student -startmode auto -srvcstart system  (开

机自动启动)

4.创建设置密码：

orapwd file=C:\oracle\product\10.2.0\db_1\database\PWDstudent.ora password=oracle  (设置密码防盗在database目

录下生成密码文件)

5.连接数据库并创建数据库三大核心文件：

sqlplus

connect sys/oracle as sysdba

startup nomount

将下列带'---'里面的所有内容保存到‘C:\oracle\product\10.2.0\db_1\database\init.ora’

--------

###################################

# Copyright (c) 1991, 2001, 2002 by Oracle Corporation

###################################

nls_language="SIMPLIFIED CHINESE"

nls_territory="CHINA"

# Job Queues

job_queue_processes=10

# Shared Server

dispatchers="(PROTOCOL=TCP) (SERVICE=studentXDB)"

# Miscellaneous

compatible=10.2.0.1.0

# Security and Auditing

audit_file_dest=C:\oracle\product\10.2.0\admin\student\adump

remote_login_passwordfile=EXCLUSIVE

# Sort, Hash Joins, Bitmap Indexes

pga_aggregate_target=16777216

# Database Identification

db_domain=""

db_name=student

# File Configuration

control_files=("C:\oracle\product\10.2.0\oradata\student\control01.ctl", "C:\oracle\product\10.2.0

\oradata\student\control02.ctl", "C:\oracle\product\10.2.0\oradata\student\control03.ctl")

db_recovery_file_dest=C:\oracle\product\10.2.0\flash_recovery_area

db_recovery_file_dest_size=2147483648

# Pools

java_pool_size=50331648

large_pool_size=0

shared_pool_size=83886080

# Cursors and Library Cache

open_cursors=300

# System Managed Undo and Rollback Segments

undo_management=AUTO

undo_tablespace=UNDOTBS1

# Diagnostics and Statistics

background_dump_dest=C:\oracle\product\10.2.0\admin\student\bdump

core_dump_dest=C:\oracle\product\10.2.0\admin\student\cdump

user_dump_dest=C:\oracle\product\10.2.0\admin\student\udump

# Processes and Sessions

processes=20

sessions=27

# Cache and I/O

db_block_size=2048

db_cache_size=50331648

db_file_multiblock_read_count=16

--------

pfile=”C:\oracle\product\10.2.0\db_1\database\init.ora“

将下列带'---'里面的所有内容保存到‘C:\oracle\product\10.2.0\db_1\database\CreateDB.sql’

--------------------

CREATE DATABASE "student"

MAXINSTANCES 8

MAXLOGHISTORY 1

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

DATAFILE 'C:\oracle\product\10.2.0\oradata\student\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT  10240K

MAXSIZE UNLIMITED

EXTENT MANAGEMENT LOCAL

SYSAUX DATAFILE 'C:\oracle\product\10.2.0\oradata\student\sysaux01.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT

10240K MAXSIZE UNLIMITED

SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'C:\oracle\product\10.2.0\oradata\student\temp01.dbf'

SIZE 20M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED

SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE 'C:\oracle\product\10.2.0\oradata\student\undotbs01.dbf' SIZE

150M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED

CHARACTER SET ZHS16GBK

NATIONAL CHARACTER SET AL16UTF16

LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\student\redo01.log') SIZE 51200K,

GROUP 2 ('C:\oracle\product\10.2.0\oradata\student\redo02.log') SIZE 51200K,

GROUP 3 ('C:\oracle\product\10.2.0\oradata\student\redo03.log') SIZE 51200K

--------------------

@C:\oracle\product\10.2.0\db_1\database\CreateDB.sql   (执行命令)

如果不报错，说明数据库创建成功。(到这里数据字典和动态性能视图还没有创建。)

将下列带'---'里面的所有内容保存到‘C:\oracle\product\10.2.0\db_1\database\CreateDBFiles.sql’

-----------------

connect "SYS"/"&&sysPassword" as SYSDBA

set echo on

spool C:\oracle\product\10.2.0\db_1\database\CreateDBFiles.log

CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE 'C:\oracle\product\10.2.0\oradata\student\users01.dbf'

SIZE 5M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT

AUTO;

ALTER DATABASE DEFAULT TABLESPACE "USERS";

spool off

-----------------

@C:\oracle\product\10.2.0\db_1\database\CreateDBFiles.sql   (创建数据字典)

将下列带'---'里面的所有内容保存到‘C:\oracle\product\10.2.0\db_1\database\JServer.sql’

-------------

connect "SYS"/"&&sysPassword" as SYSDBA

set echo on

spool C:\oracle\product\10.2.0\db_1\database\JServer.log

@C:\oracle\product\10.2.0\db_1\javavm\install\initjvm.sql;

@C:\oracle\product\10.2.0\db_1\xdk\admin\initxml.sql;

@C:\oracle\product\10.2.0\db_1\xdk\admin\xmlja.sql;

@C:\oracle\product\10.2.0\db_1\rdbms\admin\catjava.sql;

@C:\oracle\product\10.2.0\db_1\rdbms\admin\catexf.sql;

spool of

-------------

@C:\oracle\product\10.2.0\db_1\database\JServer.sql    (创建 JAVA 动态性能视图)

将下列带'---'里面的所有内容保存到‘C:\oracle\product\10.2.0\db_1\database\xdb_protocol.sql’

-------------

connect "SYS"/"&&sysPassword" as SYSDBA

set echo on

spool C:\oracle\product\10.2.0\db_1\database\xdb_protocol.log

@C:\oracle\product\10.2.0\db_1\rdbms\admin\catqm.sql change_on_install SYSAUX TEMP;

connect "SYS"/"&&sysPassword" as SYSDBA

@C:\oracle\product\10.2.0\db_1\rdbms\admin\catxdbj.sql;

@C:\oracle\product\10.2.0\db_1\rdbms\admin\catrul.sql;

spool off

-------------

@C:\oracle\product\10.2.0\db_1\database\xdb_protocol.sql    (创建 proto 动态性能视图)

将下列带'---'里面的所有内容保存到‘C:\oracle\product\10.2.0\db_1\database\ordinst.sql’

-------------

connect "SYS"/"&&sysPassword" as SYSDBA

set echo on

spool C:\oracle\product\10.2.0\db_1\database\ordinst.log

@C:\oracle\product\10.2.0\db_1\ord\admin\ordinst.sql SYSAUX SYSAUX;

spool off

-------------

@C:\oracle\product\10.2.0\db_1\database\ordinst.sql    (创建 ordinst 动态性能视图)

将下列带'---'里面的所有内容保存到‘C:\oracle\product\10.2.0\db_1\database\interMedia.sql’

-------------

connect "SYS"/"&&sysPassword" as SYSDBA

set echo on

spool C:\oracle\product\10.2.0\db_1\database\interMedia.log

@C:\oracle\product\10.2.0\db_1\ord\im\admin\iminst.sql;

spool off

-------------

@C:\oracle\product\10.2.0\db_1\database\interMedia.sql    (创建 interMedia 动态性能视图)

将下列带'---'里面的所有内容保存到‘C:\oracle\product\10.2.0\db_1\database\postDBCreation.sql’

-------------

connect "SYS"/"&&sysPassword" as SYSDBA

set echo on

spool C:\oracle\product\10.2.0\db_1\database\postDBCreation.log

connect "SYS"/"&&sysPassword" as SYSDBA

set echo on

create spfile='C:\oracle\product\10.2.0\db_1\database\spfiletest.ora' FROM pfile='C:\oracle\test\init.ora';

shutdown immediate;

connect "SYS"/"&&sysPassword" as SYSDBA

startup ;

select 'utl_recomp_begin: ' || to_char(sysdate, 'HH:MI:SS') from dual;

execute utl_recomp.recomp_serial();

select 'utl_recomp_end: ' || to_char(sysdate, 'HH:MI:SS') from dual;

spool C:\oracle\product\10.2.0\db_1\database\postDBCreation.log

exit;

-------------

@C:\oracle\product\10.2.0\db_1\database\postDBCreation.sql    (创建 postDBCreation 动态性能视图)