Manually create the database (including oraclerac)

Manually create databases (including oracle rac) the The easiest way is to use dbca to generate database building scripts, and then manually execute these scripts. The specific process is as follows 1, Manually create relevant directories and environment variables [sql] #!/bin/sh the OLD_UMASK=`umask` umask 0027 mkdir -p /oracle/app/oracle/admin/hrdb/adump mkdir -p /oracle/app/oracle/admin/hrdb/dpdump mkdir -p /oracle/app/oracle/admin/hrdb/hdump mkdir -p /oracle/app/oracle/admin/hrdb/pfile mkdir -p /oracle/app/oracle/cfgtoollogs/dbca/hrdb umask ${OLD_UMASK} www.2cto.com ORACLE_SID=hrdb1; export ORACLE_SID PATH=$ORACLE_HOME/bin:$PATH; export PATH Whether to use the database to start automatically, here is set to false echo You should Add this entry in the /etc/oratab: hrdb:/oracle/app/oracle/product/11.2.0/db_1:N the 2. Create parameter files and password files [sql] password file /oracle/app/oracle/product/11.2.0/db_1/bin/orapwd file=/oracle/app/oracle/product/11.2.0/db_1/dbs/orapwhrdb1 force=y Parameter file $ORACLE_HOME/dbs/inithrdb1.ora *.audit_file_dest='/oracle/app/oracle/admin/hrdb/adump' *.audit_trail='db' *.cluster_database=false *.compatible='11.2.0.0.0' *.cpu_count=8 *.create_stored_outlines='' *.db_block_size=8192 *.db_create_file_dest=’#39;+DATA’ *.db_domain=’#39;’ *.db_name=’#39;hrdb’ *.db_recovery_file_dest='+FRA' *.db_recovery_file_dest_size=107374182400 *.diagnostic_dest='/oracle/app/oracle' hrdb1.instance_number=1 *.log_archive_format='%t_%s_%r.dbf' *.nls_language='SIMPLIFIED CHINESE' *.nls_territory='CHINA' *.open_cursors=1000 *.pga_aggregate_target=1610612736 *.processes=500 www.2cto.com *.remote_listener='dtydb-scan2:1521' *.sga_target=4399824896 the Boot to nomount state sqlplus “/as sysdba” the startup nomount pfile=”/oracle/app/oracle/product/11.2.0/db_1/dbs/inithrdb1.ora”; the 3. Start building the library [sql] CREATE DATABASE “hrdb” MAX INSTANCES 32 MAXLOGHISTORY 1 MAXLOGFILES 192 MAXLOGMEMBERS 3 MAXDATAFILES 1024 DATAFILE SIZE 700M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE SIZE 600M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE SIZE 20M AUTOEXTEND ON NEXT 640K…