oracle 10g手工建库

创建相关数据目录
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博客 ” ，链接：http://blog.itpub.net/26052382/viewspace-1098227/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26052382/viewspace-1098227/