
P67
4.1.4ڴ
(ļμļС4.1.4ڡ)
1
mkdir -p /home/oracle/product/10.2.0/admin/oradb/adump
mkdir -p /home/oracle/product/10.2.0/admin/oradb/bdump
mkdir -p /home/oracle/product/10.2.0/admin/oradb/cdump
mkdir -p /home/oracle/product/10.2.0/admin/oradb/dpdump
mkdir -p /home/oracle/product/10.2.0/admin/oradb/udump
mkdir -p /home/oracle/product/10.2.0/admin/oradb/pfile
mkdir -p /home/oracle/product/10.2.0/oradata/oradb
2
ORACLE_BASE=/home/oracle/product/10.2.0
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/db_1
export ORACLE_HOME
ORACLE_SID=oradb
export ORACLE_SID
3.
--initoradb.ora
oradb.__db_cache_size=188743680
oradb.__java_pool_size=4194304
oradb.__large_pool_size=4194304
oradb.__shared_pool_size=83886080
oradb.__streams_pool_size=0
*.audit_file_dest='/home/oracle/product/10.2.0/admin/oradb/adump'
*.background_dump_dest='/home/oracle/product/10.2.0/admin/oradb/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/home/oracle/product/10.2.0/oradata/oradb/control01.ctl','/home/oracle/product/10.2.0/oradata/oradb/control02.ctl','/home/oracle/product/10.2.0/oradata/oradb/control03.ctl'
*.core_dump_dest='/home/oracle/product/10.2.0/admin/oradb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='oradb'
*.db_recovery_file_dest='/home/oracle/product/10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=oradbXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=285212672
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/home/oracle/product/10.2.0/admin/oradb/udump'
4.
orapwd file=$ORACLE_HOME/dbs/orapworadb.ora password=syspwd
5.
sqlplus /nolog
CONN / AS SYSDBA
startup pfile=/home/oracle/product/10.2.0/db_1/dbs/initoradb.ora nomount
CREATE DATABASE oradb
  datafile '/home/oracle/product/10.2.0/oradata/oradb/system01.dbf' size 500M reuse autoextend on next 10240K maxsize unlimited
  extent management local
  sysaux datafile '/home/oracle/product/10.2.0/oradata/oradb/sysaux01.dbf' size 300M reuse autoextend on next 10240K maxsize unlimited
  default temporary tablespace temp
  tempfile '/home/oracle/product/10.2.0/oradata/oradb/temp01.dbf' size 20M reuse autoextend on next 640K maxsize unlimited
  undo tablespace UNDOTBS1
  datafile '/home/oracle/product/10.2.0/oradata/oradb/undotbs01.dbf' size 100M reuse autoextend on next 5120K maxsize unlimited
  logfile group 1 ('/home/oracle/product/10.2.0/oradata/oradb/redo01.log') size 50M,
  group 2 ('/home/oracle/product/10.2.0/oradata/oradb/redo02.log') size 50M,
  group 3 ('/home/oracle/product/10.2.0/oradata/oradb/redo03.log') size 50M
  CHARACTER SET ZHS16GBK;
6.
CONN / AS SYSDBA
@$ORACLE_HOME/rdbms/admin/catalog.sql 
@$ORACLE_HOME/rdbms/admin/catproc.sql
CONN system/systempwd
@$ORACLE_HOME/sqlplus/admin/pupbld.sql
7
CONN / AS SYSDBA
CREATE TABLESPACE users
  DATAFILE '$ORACLE_BASE/oradata/oradb/users01.dbf' SIZE 20M;
@$ORACLE_HOME/rdbms/admin/utlsampl.sql
CONN scott/tiger
8
--listener.ora
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
  )

--tnsnames.ora
ORADB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oradb)
    )
  )


ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
9.
(1)oratab
orcl:/home/oracle/product/10.2.0/db_1:Y
oradb:/home/oracle/product/10.2.0/db_1:Y
(2)dbstart
ORACLE_HOME_LISTNER=$ORACLE_HOME
(3)dbshut
lsnrctl stop
(4)
vi /etc/init.d/oracle
case "$1" in
start)
echo -n "Start oracle"
su - oracle -c dbstart
echo -n "Starting oracle completed."
;;
stop)
echo -n "Shutdown oracle "
su - oracle -c dbshut
echo -n "Oracle stopped."
;;
restart)
echo -n "Resatrting oracle "
su - oracle -c dbshut
su - oracle -c dbstart
echo -n "Restarting ok."
;;
*)
echo "Usage: 'basename $0' start|stop"
exit 1
esac
(5)
ln -s /etc/rc.d/init.d/oracle /etc/rc.d/rc3.d/S99oracle
ln -s /etc/rc.d/init.d/oracle /etc/rc.d/rc5.d/S99oracle
(6)
sqlplus scott/tiger@orcl
sqlplus scott/tiger@oradb
rootûoracle
[root@localhost ~]# service oracle start
[root@localhost ~]# service oracle restart

P75
4.1
CONN system/systempwd@orcl
DROP TABLESPACE data_ts1 INCLUDING CONTENTS;
CREATE TABLESPACE data_ts1
  DATAFILE '%ORACLE_HOME%\database\data_ts1.dbf' SIZE 50M REUSE
  UNIFORM SIZE 128K;
4.2
CONN system/systempwd@orcl
DROP TABLESPACE temp_ts1 INCLUDING CONTENTS;
CREATE TEMPORARY TABLESPACE temp_ts1
  TEMPFILE '%ORACLE_HOME%\database\temp_ts1.dbf' SIZE 20M REUSE
  UNIFORM SIZE 128K;
4.3
CONN system/systempwd@orcl
DROP USER emp_mgr10 CASCADE;
CREATE USER emp_mgr10 IDENTIFIED BY emp_mgr10pwd
  DEFAULT TABLESPACE data_ts1 TEMPORARY TABLESPACE temp_ts1;
GRANT CONNECT TO emp_mgr10;
CONN scott/tiger@orcl
GRANT SELECT ON emp TO emp_mgr10;
P76
4.4
CONN system/systempwd@orcl
DROP TABLESPACE undo_ts1 INCLUDING CONTENTS;
CREATE UNDO TABLESPACE undo_ts1
  DATAFILE '%ORACLE_HOME%\database\undo_ts1.dbf' SIZE 50M REUSE;
ALTER SYSTEM SET undo_tablespace = undo_ts1;
4.5
CONN system/systempwd@orcl
DROP TABLESPACE bigfile_ts1 INCLUDING CONTENTS;
CREATE BIGFILE TABLESPACE bigfile_ts1 
  DATAFILE '%ORACLE_HOME%\database\bigfile_ts1.dbf' SIZE 50M REUSE;
ALTER USER scott DEFAULT TABLESPACE bigfile_ts1;

SET PAGESIZE 30
COL tablespace_name FORMAT A12
SELECT tablespace_name,block_size,segment_space_management,
       status,contents,allocation_type,bigfile
  FROM dba_tablespaces;

P77
4.6
CONN system/systempwd@orcl
ALTER TABLESPACE data_ts1 
  ADD DATAFILE '%ORACLE_HOME%\database\data_ts2.dbf' SIZE 1M;
ALTER DATABASE 
  DATAFILE '%ORACLE_HOME%\database\data_ts2.dbf' RESIZE 2M ;
ALTER DATABASE DATAFILE '%ORACLE_HOME%\database\data_ts2.dbf'
  AUTOEXTEND ON NEXT 1M MAXSIZE 10M;

COL file_name FORMAT A55
SELECT file_id, file_name, tablespace_name
  FROM dba_data_files
  ORDER BY file_id;

P78
4.7
CONN system/systempwd@orcl
DROP TABLESPACE temp_ts1 
  INCLUDING CONTENTS AND DATAFILES
  CASCADE CONSTRAINTS;
4.8
CONN system/systempwd@orcl
DROP ROLLBACK SEGMENT undo_ts1_rbs1;
CREATE ROLLBACK SEGMENT undo_ts1_rbs1
  TABLESPACE undo_ts1 STORAGE (initial 5K
                               next 5K
                               optimal 500K
                               minextents 15
                               maxextents 100) ;
ALTER ROLLBACK SEGMENT undo_ts1_rbs1 ONLINE;
ALTER ROLLBACK SEGMENT undo_ts1_rbs1 OFFLINE;
DROP ROLLBACK SEGMENT undo_ts1_rbs1;
