Command Setup Oracle Database (RHEL5U5+ORACLE10.2.0)
Install Oracle Software
Unzip oracle software package to /tmp folder
#tar xf database10GR2.tar.gz
Use response template create responsefile
[root@oradb /]# su - oracle
[oracle@oradb ~]$ cd /tmp/database/response/
[oracle@oradb response]$ cp enterprise.rsp /u01/app/oracle/ent.rsp
[oracle@oradb response]$ vi /u01/app/oracle/ent.rsp
UNIX_GROUP_NAME=”dba”
FROM_LOCATION="/tmp/database/stage/products.xml"
ORACLE_HOME="/u01/app/oracle/product/10.2.0/db_1"
ORACLE_HOME_NAME="OraDbHome1”
COMPONENT_LANGUAGES={"en","zh_CN"}
s_nameForDBAGrp="dba"
n_configurationOption=3
Running runInstaller script install software
Open xhost +
[oracle@oradb database]$ ./runInstaller -responsefile /u01/app/oracle/ent.rsp –silent
To register the new inventory please run the script '/u01/app/oracle/oraInventory/orainstRoot.sh' with root privileges.
If you do not register the inventory, you may not be able to update or patch the products you installed.
The following configuration scripts
/u01/app/oracle/product/10.2.0/db_1/root.sh
[root@oradb ~]# cd /u01/app/oracle/oraInventory/
[root@oradb oraInventory]# ./orainstRoot.sh
Changing permissions of /u01/app/oracle/oraInventory to 770.
Changing groupname of /u01/app/oracle/oraInventory to dba.
The execution of the script is complete
[root@oradb oraInventory]# cd /u01/app/oracle/product/10.2.0/db_1/
[root@oradb db_1]# ./root.sh
Running Oracle10 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/10.2.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
[oracle@oradb database]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Feb 27 21:44:43 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initorcl.ora'
[@more@]Create Database
Create parameter file
Use dbca tools create script
Modify init.ora file of dbca script
db_name=updb
background_dump_dest=/u01/app/oracle/admin/updb/bdump
core_dump_dest=/u01/app/oracle/admin/updb/cdump
user_dump_dest=/u01/app/oracle/admin/updb/udump
control_files=("/u01/app/oracle/oradata/updb/control01.ctl", "/u01/app/oracle/oradata/updb/control02.ctl", "/u01/app/oracle/oradata/updb/control03.ctl")
audit_file_dest=/u01/app/oracle/admin/updb/adump
cp init.ora /u01/app/oracle/product/10.2.0/db_1/dbs/initupdb.ora
Modify CreateDB.sql of dbca script
connect "SYS"/"uplooking" as SYSDBA
set echo on
spool /u01/app/oracle/admin/orcl/scripts/CreateDB.log
startup nomount pfile="/u01/app/oracle/product/10.2.0/db_1/dbs/initupdb.ora";
CREATE DATABASE "updb"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/u01/app/oracle/oradata/updb/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/app/oracle/oradata/updb/sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/app/oracle/oradata/updb/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u01/app/oracle/oradata/updb/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/updb/redo01.log') SIZE 51200K,
GROUP 2 ('/u01/app/oracle/oradata/updb/redo02.log') SIZE 51200K,
GROUP 3 ('/u01/app/oracle/oradata/updb/redo03.log') SIZE 51200K
USER SYS IDENTIFIED BY "uplooking" USER SYSTEM IDENTIFIED BY "uplooking";
spool off
Create folder
[oracle@oradb /]$ mkdir –p /u01/app/oracle/oradata/updb/adump
[oracle@oradb /]$ mkdir –p /u01/app/oracle/oradata/updb/bdump
[oracle@oradb /]$ mkdir –p /u01/app/oracle/oradata/updb/cdump
[oracle@oradb /]$ mkdir –p /u01/app/oracle/oradata/updb/udump
[oracle@oradb /]$ mkdir -p /u01/app/oracle/flash_recovery_area
[oracle@oradb /]$ mkdir -p /u01/app/oracle/oradata/updb
Running CreateDB.sql
[oracle@oradb dbs]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Feb 28 00:27:30 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> @/u01/app/oracle/admin/orcl/scripts/CreateDB.sql
Connected to an idle instance.
SQL> spool /u01/app/oracle/admin/updb/scripts/CreateDB.log
SP2-0606: Cannot create SPOOL file "/u01/app/oracle/admin/updb/scripts/CreateDB.log"
SQL> startup nomount pfile="/u01/app/oracle/product/10.2.0/db_1/dbs/initupdb.ora";
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 92276304 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
SQL> CREATE DATABASE "updb"
2 MAXINSTANCES 8
3 MAXLOGHISTORY 1
4 MAXLOGFILES 16
5 MAXLOGMEMBERS 3
6 MAXDATAFILES 100
7 DATAFILE '/u01/app/oracle/oradata/updb/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
8 EXTENT MANAGEMENT LOCAL
9 SYSAUX DATAFILE '/u01/app/oracle/oradata/updb/sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
10 SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/app/oracle/oradata/updb/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
11 SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u01/app/oracle/oradata/updb/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
12 CHARACTER SET WE8ISO8859P1
13 NATIONAL CHARACTER SET AL16UTF16
14 LOGFILE GROUP 1 ('/u01/app/oracle/oradata/updb/redo01.log') SIZE 51200K,
15 GROUP 2 ('/u01/app/oracle/oradata/updb/redo02.log') SIZE 51200K,
16 GROUP 3 ('/u01/app/oracle/oradata/updb/redo03.log') SIZE 51200K
17 USER SYS IDENTIFIED BY "uplooking" USER SYSTEM IDENTIFIED BY "uplooking";
Running Scripts to Build Data Dictionary Views
Connect sys/password as sysdba
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10685580/viewspace-1046591/ ，如需转载，请注明出处，否则将追究法律责任。
