Oracle Database HOWTO : «Ø¥ß¤@­Ó¸ê®Æ®w
Previous: ¦w¸Ë Oracle ³n¥ó
Next: ¦b¦øªA¾¹¤W³]©w SQL*Net

3. «Ø¥ß¤@­Ó¸ê®Æ®w

Oracle ¦øªA¾¹²{¤w¦w¸Ë¤F¡A§Ú­Ì»Ý­n«Ø¥ß¤@­Ó¸ê®Æ®w¨Ó´ú¸Õ¥¦¡C

¦pªG§A¨Ï¥Î Oracle 7.2.x ©Î¤§«eª©¥»¡A½Ð¾\Ū¤U­±ªººÃÃø±Æ¸Ñ³¡¤À¡C

3.1. «Ø¥ßªì©lÀÉ (Initialisation File)

§â $ORACLE_HOME/dbs/init.ora §Û¨ì $ORACLE_HOME/dbs/initorcl.ora:


$ cd $ORACLE_HOME/dbs
$ cp init.ora initorcl.ora

¥[¤W¥H¤U¼Æ¦æ¡G

db_name = orcl
COMPATIBLE=7.3.3.0.0

3.2. «Ø¥ß¸ê®Æ®w¦w¸Ë©R¥O½Z

¦b $ORACLE_HOME/dbs ¥Ø¿ý¤U«Ø¥ß¤@­Ó¦W¬° makedb.sql ªº©R¥O½ZÀÉ¡G


connect internal
startup nomount
set echo on
spool makedb.log
create database orcl
	maxinstances 1
	maxlogfiles  8
	datafile '$ORACLE_HOME/dbs/orcl_syst_01.dbf' size 40M reuse
	logfile
		'$ORACLE_HOME/dbs/orcl_redo_01.dbf' size 1M reuse,
		'$ORACLE_HOME/dbs/orcl_redo_02.dbf' size 1M reuse,
		'$ORACLE_HOME/dbs/orcl_redo_03.dbf' size 1M reuse;
@$ORACLE_HOME/rdbms/admin/catalog.sql
create tablespace rollback
	datafile '$ORACLE_HOME/dbs/orcl_roll_01.dbf' size 8.5M reuse;
create tablespace temp
	datafile '$ORACLE_HOME/dbs/orcl_temp_01.dbf' size 5M reuse 
	temporary;
create tablespace users
	datafile '$ORACLE_HOME/dbs/orcl_user_01.dbf' size 10M reuse;
create rollback segment r1 tablespace rollback
	storage ( optimal 5M );
alter rollback segment r1 online;
connect system/manager
@$ORACLE_HOME/rdbms/admin/catdbsyn.sql
connect internal
@$ORACLE_HOME/rdbms/admin/catproc.sql
connect system/manager
@$ORACLE_HOME/sqlplus/admin/pupbld.sql
spool off
exit

3.3. °õ¦æ¸ê®Æ®wªº¦w¸Ë¦w¥O½Z

¶}©l svrmgrl ¤Î°õ¦æ©R¥O½Z¡J


$ cd $ORACLE_HOME/dbs
$ svrmgrl

Oracle Server Manager Release 2.3.3.0.0 - Production

Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.

Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> startup nomount
ORACLE instance started.
Total System Global Area       4313312 bytes
Fixed Size                       41876 bytes
Variable Size                  4140364 bytes
Database Buffers                122880 bytes
Redo Buffers                      8192 bytes
SVRMGR> @makedb
<loads of messages>
SVRMGR> exit
Server Manager complete.

3.4. ±Ò°Ê¸ê®Æ®w

¶}©l®É¡A§Ú­Ì­n¿Ë¤â±Ò°Ê¸ê®Æ®w¡]§Ú­Ìµy«á·|§â³o¤u¥ó¦Û°Ê¤Æ¡^¡C­n±Ò°Ê Oracle ªº¸ê®Æ®w¡A§Ú­Ì­n¨Ó¤º³¡³s±µ (connected internally) ¤Fªº±¡ªp¤U°õ¦æ startup «ü¥O¡G


$ svrmgrl

Oracle Server Manager Release 2.3.3.0.0 - Production

Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.

Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> startup
ORACLE instance started.
Total System Global Area       4313316 bytes
Fixed Size                       41876 bytes
Variable Size                  4140368 bytes
Database Buffers                122880 bytes
Redo Buffers                      8192 bytes
Database mounted.
Database opened.
SVRMGR> exit
Server Manager complete.

3.5. °±¤î¸ê®Æ®w

¥ý¦®Án©ú¡A¦b¥¼Ãö³¬¤@­Ó Oracle ¸ê®Æ®wªº±¡ªp¤U­«·s±Ò°Ê Linux «Ü¦³¥i¯à·|¨Ï¸ê®Æ®w·l·´¡C

¦]¦¹¡A¦b§Ú­Ì°õ¦æ Linux ªº shutdown «ü¥O«e³Ì¦n¥ýÃö³¬¸ê®Æ®w¡G


$ svrmgrl

Oracle Server Manager Release 2.3.3.0.0 - Production

Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.

Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SVRMGR> exit
Server Manager complete.

3.6. «Ø¥ß¤º©w¥Î¤á (Default User)

¦b«Ø¥ß¸ê®Æ®w®É¡A·|¦Û°Ê²£¥Í¨â­Ó¯S§Oªº¥Î¤á¡G


Username		Password

SYSTEM			MANAGER
SYS			change_on_install

³o¨Ç¥Î¤á³q±`¬O¥Î¨Ó«O¦s¼Ð·Çªº¸ê®Æ¦r¨å (data dictionary) ¸ê®Æ¦b¸ê®Æ®w¤¤¡CºÉ§Ö§â±K½X­×§ï¬O¤@­Ó¦n¥D·N¡C

¥i¥H³o¼Ë°µ¡G


sqlplus system/manager

SQL*Plus: Release 3.3.3.0.0 - Production on Sat Feb 21 12:43:33 1998

Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.


Connected to:
Oracle7 Server Release 7.3.3.0.0 - Production Release

SQL> alter user system identified by <newpassword>;

User altered.

SQL> alter user sys identified by <newpassword>;

User altered.

SQL> exit;
Disconnected from Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - Production

¥Î¤á system/manager ´N¦p UNIX ¤¤ªº root¡A¦]¦¹§Ú­Ì­n«Ø¥ß¥t¤@­ÓÅv¤O¸û¤Öªº¥Î¤á¥H¨¾·l¥¢¡C¡]°OµÛ­n¥ý¶}±Ò¸ê®Æ®w¤~«Ø¥ß¥Î¤á¡C¡

³s±µ¨ì SQL*Plus ¤Î«Ø¥ß¥Î¤á¡G


$ sqlplus system/manager

SQL*Plus: Release 3.3.3.0.0 - Production on Sat Feb 21 12:43:33 1998

Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.


Connected to:
Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - Production

SQL> create user <user> identified by <psw> 
  2  default tablespace users 
  3  temporary tablespace temp;

User created.

SQL> grant connect, resource to <user>

Grant succeeded.

SQL> exit
Disconnected from Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - Production

¨t²Î¤¤¤w¦³¤@­Ó·s¥Î¤á¡A§A¥i¥H¥Î¥L¨Ó¸Õ¥Î·s¨t²Î¡C­nñ¤J Oracle ¸ê®Æ®w¡G


$ sqlplus <user>/<password>

¦pªG³o¦b¨S¦³¿ù»~°T®§ªº±¡ªp¤U§¹¦¨¡A§A¤w¦³¤@­Ó¹B§@¤¤ªº Oracle ¸ê®Æ®w¡C¦pªG§A¥u·|±q³o³¡¹q¸£³s±µ¨ì³o¸ê®Æ®w¡A¦Ó¤£·|±q¨ä¥L¦a¤è¡A§A¥i¥ð®§¤F¡I

¤£¹L¡A¦pªG§A¹³¤j³¡¤À¤H¯ë·Q³]©wºôµ¸³n¥ó¨Ï§A¥i¥H±q¨ä¥L¹q¸£³s±µ¡A½ÐÄ~ÄòŪ¤U¥h¡C


Oracle Database HOWTO : «Ø¥ß¤@­Ó¸ê®Æ®w
Previous: ¦w¸Ë Oracle ³n¥ó
Next: ¦b¦øªA¾¹¤W³]©w SQL*Net