1. 设置ORACLE_SID
é»è®¤çORACLE_SIDæ¯orclï¼æ个人强ç建议起个å¯ä¸ãä¸æä¹çååï¼æ¯å¦**testdbï¼**proddbççï¼å¨Oracleç¨æ·ä¸æ§è¡ï¼
export ORACLE_SID=lxdbtest
2. é建PFILE
å¨$ORACLE_HOME/dbsç®å½ä¸é建pfileï¼initORACLE_SID.oraï¼æ¬ä¾ä¸ºinitlxdbtest.oraï¼ï¼é¤äºä»¥ä¸ä¸ä¸ªåæ°ï¼å
¶å®åæ°é½å¯ä»¥ä¸ç¨è®¾ç½®ï¼ä½¿ç¨é»è®¤å¼ï¼ï¼
db_name=lxdbtest
control_files='/home/oracle/app/oradata/lxdbtest/control01.ctl','/home/oracle/app/oradata/lxdbtest/control02.ctl','/home/oracle/app/oradata/lxdbtest/control03.ctl'
memory_target=2G
为äºå®å
¨èµ·è§ï¼æ§å¶æ件ä¸å®è¦æå®å¤ä»½ï¼å¨ç产åºä¸ï¼è¦æå®ä»¬åå¼æ¾å¨ä¸åçç©çç£çä¸ï¼è¿éå 为æ¯æµè¯åºï¼æ以ææ¾å¨åä¸ä¸ªç£çä¸ã
3. å¯å¨å®ä¾è³nomountç¶æ
æäºpfileå°±å¯ä»¥å¯å¨å®ä¾è³nomountç¶æäºï¼
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 25 21:01:16 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 2137886720 bytes
Fixed Size 2215064 bytes
Variable Size 1224737640 bytes
Database Buffers 905969664 bytes
Redo Buffers 4964352 bytes
SQL>
4. æ§è¡CREATE DATABASEè¯å¥
CREATE DATABASE lxdbtest
LOGFILE GROUP 1
('/home/oracle/app/oradata/lxdbtest/redo01a.log','/data/oradata/lxdbtest/redo01b.log')
SIZE 100M BLOCKSIZE 512,
GROUP 2
('/home/oracle/app/oradata/lxdbtest/redo02a.log','/data/oradata/lxdbtest/redo02b.log')
SIZE 100M BLOCKSIZE 512,
GROUP 3
('/home/oracle/app/oradata/lxdbtest/redo03a.log','/data/oradata/lxdbtest/redo03b.log')
SIZE 100M BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 600
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/home/oracle/app/oradata/lxdbtest/system01.dbf' SIZE 2048M REUSE AUTOEXTEND OFF
SYSAUX DATAFILE '/home/oracle/app/oradata/lxdbtest/sysaux01.dbf' SIZE 2048M REUSE AUTOEXTEND OFF
DEFAULT TABLESPACE users
DATAFILE '/home/oracle/app/oradata/lxdbtest/users01.dbf'
SIZE 2048M REUSE AUTOEXTEND OFF
DEFAULT TEMPORARY TABLESPACE temptbs
TEMPFILE '/home/oracle/app/oradata/lxdbtest/temp01.dbf'
SIZE 2048M REUSE AUTOEXTEND OFF
UNDO TABLESPACE undotbs
DATAFILE '/home/oracle/app/oradata/lxdbtest/undotbs01.dbf'
SIZE 2048M REUSE AUTOEXTEND OFF;
æå ç¹éè¦æ³¨æï¼
1ï¼æ¯ä¸ªæ¥å¿æ件ç»çæ¥å¿è¦æ¾å¨ä¸åçç©çç£çä¸ï¼ä¸ä¸æä¸ä¸ªç£çæåï¼ä¹ä¸ä¼ä¸¢å¤±æ°æ®
2ï¼æ ¹æ®éè¦éæ©åéçå符é
3ï¼å建äº5个åºæ¬ç表空é´ï¼SYSTEM,SYSAUX,é»è®¤è¡¨ç©ºé´ï¼é»è®¤ä¸´æ¶è¡¨ç©ºé´ï¼é»è®¤UNDO表空é´
5. æ ¹æ®éè¦å建åºç¨ç¨åºæéç表空é´
对äºå
³é®ä¸å¡çæ°æ®ï¼åºè¯¥å建åç¬ç表空é´ç»å®ä½¿ç¨ï¼æ好æ表åç´¢å¼åå¼æ¾å¨è¡¨ç©ºé´ï¼
SQL> create tablespace p95169tbs
2 datafile '/home/oracle/app/oradata/lxdbtest/p95169tbs01.dbf' size 10G,
3 '/home/oracle/app/oradata/lxdbtest/p95169tbs02.dbf' size 10G;
Tablespace created.
6. æ建æ°æ®åå
¸è§å¾
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/sqlplus/admin/pupbld.sql
7. ä¿®æ¹system,sysçå¯ç
alter user sys identified by ***;
alter user system identified by ***;
8. å建SPFILE
SQL> create spfile from pfile;
File created.
éå¯æ°æ®åºåï¼å°ä»¥spfileå代pfile.
æåï¼å顺便说ä¸å¦ä½å é¤æ°æ®åºãå¨å é¤æ°æ®åºä¹åï¼æ°æ®åºå¿
é¡»æ¯å¨mountårestricted sessionç¶æï¼å
·ä½å¦ä¸ï¼
SQL> startup mount
SQL> alter system enable restricted session;
System altered.
SQL> drop database;
Database dropped.
æ°æ®åºå é¤æååï¼ææçå¨çº¿æ¥å¿æ件ãæ°æ®æ件é½ä¼ä¸å¹¶è¢«å é¤ï¼ä½å½æ¡£æ¥å¿åå¤ä»½æ件ä¸ä¼è¢«å é¤ã
温馨提示:答案为网友推荐,仅供参考