创建相关数据目录
mkidr -p $ORACLE_BASE/admin/$ORACLE_SID/{a,b,c,d,u}dump
mkdir -p $ORACLE_BASE/oradata/$ORACLE_SID
mkdir -p $ORACLE_BASE/flash_recovery_area

创建参数文件
*.audit_file_dest='/u01/oracle/admin/oranode1/adump'
*.background_dump_dest='/u01/oracle/admin/oranode1/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/oracle/oradata/oranode1/control01.ctl','/u01/oracle/oradata/oranode1/control02.ctl','/u01/oracle/oradata/oranode1/control03.ctl'
*.core_dump_dest='/u01/oracle/admin/oranode1/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_flashback_retention_target=43200
*.db_name='oranode1'
*.db_recovery_file_dest='/u01/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=30G
*.dispatchers='(PROTOCOL=TCP) (SERVICE=oranode1XDB)'
*.global_names=TRUE
*.job_queue_processes=10
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=4G
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/oracle/admin/oranode1/udump'

创建数据库
CREATE DATABASE oranode1
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/u01/oracle/oradata/oranode1/redo01.log') SIZE 50M,
      GROUP 2 ('/u01/oracle/oradata/oranode1/redo02.log') SIZE 50M,
      GROUP 3 ('/u01/oracle/oradata/oranode1/redo03.log') SIZE 50M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u01/oracle/oradata/oranode1/system01.dbf' SIZE 325M EXTENT MANAGEMENT LOCAL AUTOEXTEND ON MAXSIZE UNLIMITED
SYSAUX DATAFILE '/u01/oracle/oradata/oranode1/sysaux01.dbf' SIZE 325M AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TABLESPACE users01 DATAFILE '/u01/oracle/oradata/oranode1/usertbs.dbf' SIZE 10M AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/u01/oracle/oradata/oranode1/temp01.dbf' SIZE 50M AUTOEXTEND ON MAXSIZE UNLIMITED
UNDO TABLESPACE undotbs1 DATAFILE '/u01/oracle/oradata/oranode1/undotbs01.dbf' SIZE 200M AUTOEXTEND ON MAXSIZE UNLIMITED;

运行相关脚本
@?/rdbms/admin/catalog.sql       （建数据字典视图）
@?/rdbms/admin/catproc.sql       （建存储过程包）
@?/rdbms/admin/catblock.sql       （建锁相关的几个视图）
@?/rdbms/admin/catoctk.sql       （建密码工具包dbms_crypto_toolkit）
@?/rdbms/admin/owminst.plb    （建工作空间管理相关对象，如dmbs_wm）
@?/sqlplus/admin/pupbld （以system用户执行）

配置网络
listener.ora
SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
   (PROGRAM = extproc)
)
(SID_DESC =
   (GLOBAL_DBNAME = pod)
   (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
   (SID_NAME = pod)
)
  )
LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
)
  )
LISTENER1 =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
)
  )

tnsname.ora
POD =
  (DESCRIPTION =
(ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = POD)
)
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
(ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
   (SID = PLSExtProc)
   (PRESENTATION = RO)
)
)

ITPub博客

oracle 10g手工建库

最新文章