RHEL AS 4 under manual in ORACLE 10g database on the bare equipment operation

May 20 posted in Oracle (RSS), 211 views.

Have been used in the previous DBCA to create database using DBCA, however bare in the use of equipment always pass, so want to pass the database manually to the database of the way built on the bare device. Through the manual to understand database structure of ORACLE database .
Assumption here has been able to install the linux operating system, ORACLE software, it is no longer detailed software installation steps. Can refer to:
ORACLE 10G for RHEL AS 4 install (http://blog.chinaunix.net/u/28641/showart_1087570.html)
In the cited article, the attention here to only install the software, not the establishment of databases.

After the completion of the installation of oracle software to start manually the database based on the bare device.
Related to the environment:
ORACLE_BASE: / opt / oracle
ORACLE_HOME: / opt/oracle/product/10.2.0/ora10g
ORACLE_SID: ora10g

1. The establishment of the relevant directory

- Diagnosis of Contents
[oracle @ rhel47 ~] $ mkdir-p $ ORACLE_BASE/admin/ora10g/adump
[oracle @ rhel47 ~] $ mkdir-p $ ORACLE_BASE/admin/ora10g/bdump
[oracle @ rhel47 ~] $ mkdir-p $ ORACLE_BASE/admin/ora10g/cdump
[oracle @ rhel47 ~] $ mkdir-p $ ORACLE_BASE/admin/ora10g/udump
[oracle @ rhel47 ~] $ mkdir-p $ ORACLE_BASE/admin/ora10g/pfile

- Data file storage directory
[oracle @ rhel47 ~] $ mkdir-p $ ORACLE_BASE/oradata/ora10g

2. To create data files bare equipment

- Create a logical volume.
[root @ rhel47 ~] # lvcreate-L 608M-n lvsystem vg00
[root @ rhel47 ~] # lvcreate-L 408M-n lvsysaux vg00
[root @ rhel47 ~] # lvcreate-L 108M-n lvtemp vg00
[root @ rhel47 ~] # lvcreate-L 108M-n lvundotbs vg00
[root @ rhel47 ~] # lvcreate-L 60M-n lvredoa1 vg00
[root @ rhel47 ~] # lvcreate-L 60M-n lvredoa2 vg00
[root @ rhel47 ~] # lvcreate-L 60M-n lvredoa3 vg00

- Bare of equipment, in order to reboot the system after the entry into force, the following command to be added to / etc / rc.local file.
[root @ rhel47 vg00] # raw / dev/raw/raw1 / dev/mapper/vg00-lvsystem
[root @ rhel47 vg00] # raw / dev/raw/raw2 / dev/mapper/vg00-lvsysaux
[root @ rhel47 vg00] # raw / dev/raw/raw3 / dev/mapper/vg00-lvtemp
[root @ rhel47 vg00] # raw / dev/raw/raw4 / dev/mapper/vg00-lvundotbs
[root @ rhel47 vg00] # raw / dev/raw/raw5 / dev/mapper/vg00-lvredoa1
[root @ rhel47 vg00] # raw / dev/raw/raw6 / dev/mapper/vg00-lvredoa2
[root @ rhel47 vg00] # raw / dev/raw/raw7 / dev/mapper/vg00-lvredoa3

- Change is the main bare equipment: a group, to take effect after the restart, the following command into / etc / rc.local file.
[root @ rhel47 raw] # chown oracle: dba / dev / raw / raw *

- Data files in the directory link to the bare device.
[oracle @ rhel47 ora10g] $ ln-s / dev/raw/raw1 rlvsystem
[oracle @ rhel47 ora10g] $ ln-s / dev/raw/raw2 rlvsysaux
[oracle @ rhel47 ora10g] $ ln-s / dev/raw/raw3 rlvtemp
[oracle @ rhel47 ora10g] $ ln-s / dev/raw/raw4 rlvundotbs
[oracle @ rhel47 ora10g] $ ln-s / dev/raw/raw5 rlvredoa1
[oracle @ rhel47 ora10g] $ ln-s / dev/raw/raw6 rlvredoa2
[oracle @ rhel47 ora10g] $ ln-s / dev/raw/raw7 rlvredoa3

3. To create a document ORACLE parameters $ ORACLE_HOME/dbs/initora10g.ora

Copy $ ORACLE_HOME / dbs / init.ora to $ ORACLE_HOME/dbs/initora10g.ora (that is, ora $ (ORACLE_SID). Ora). As a result of its own version of the init.ora low, it is recommended to use the init.ora with other documents, such as the establishment of a database using dbca generated init $ (ORACLE_SID). ora file as a template.
Amended to read as follows parameters.
db_name = ora10g
shared_pool_size = 100000000
control_files = (/ opt/oracle/oradata/ora10g/control01.ctl, / opt/oracle/oradata/ora10g/control02.ctl, / opt/oracle/oradata/ora10g/control03.ctl)
undo_management = AUTO
undo_tablespace = UNDOTBS

4. Create a password file

[oracle @ rhel47 ~] $ orapwd file = $ ORACLE_HOME/dbs/orapwora10g password = root123 entries = 5 force = y

5. Ora10g.sql script file to create database

- Note the use of reuse parameters, shut down automatically extended.
[oracle @ rhel47 ~] $ cat>> ora10g.sql <<EOF
CREATE DATABASE ora10g
LOGFILE
GROUP 1 ( '/ opt/oracle/oradata/ora10g/rlvredoa1') SIZE 50M,
GROUP 2 ( '/ opt/oracle/oradata/ora10g/rlvredoa2') SIZE 50M,
GROUP 3 ( '/ opt/oracle/oradata/ora10g/rlvredoa3') SIZE 50M REUSE
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
NOARCHIVELOG
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/ opt/oracle/oradata/ora10g/rlvsystem' SIZE 600M REUSE AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/ opt/oracle/oradata/ora10g/rlvsysaux' SIZE 400M REUSE AUTOEXTEND OFF
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/ opt/oracle/oradata/ora10g/rlvtemp' SIZE 100M REUSE AUTOEXTEND OFF
UNDO TABLESPACE "UNDOTBS"
DATAFILE '/ opt/oracle/oradata/ora10g/rlvundotbs' SIZE 100M REUSE AUTOEXTEND OFF;

EOF

6. The implementation of database

oracle @ rhel47 ~] $ sqlplus / nolog

SQL * Plus: Release 10.2.0.1.0 - Production on Sat Feb 7 13:01:13 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect sys/root123 as sysdba
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 134217728 bytes
Fixed Size 1218100 bytes
Variable Size 125831628 bytes
Database Buffers 4194304 bytes
Redo Buffers 2973696 bytes
SQL> start ora10g.sql

Database created.

7. To create data dictionary, PACKAGE package.

- Are still under the SYS user, the two statements must spend a longer period of time, need to be patient .....................
SQL> start / opt/oracle/product/10.2.0/ora10g/rdbms/admin/catalog.sql

SQL> start / opt/oracle/product/10.2.0/ora10g/rdbms/admin/catproc.sql

Done here, to manually install on essentially completed. The following to manually configure and monitor DBCONSOLE

8. Configured to monitor

Copy $ (ORACLE_HOME) / network / admin / samples / tnsname.ora to $ (ORACLE_HOME) / network / admin / increase / modify the relevant information.
ORA10G =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.80.47) (PORT = 1521))
)
(CONNECT_DATA =
(SID = ora10g)
(SERVER = DEDICATED)
)
)

Copy $ (ORACLE_HOME) / network / admin / samples / sqlnet.ora to $ (ORACLE_HOME) / network / admin / increase / modify the relevant information.
SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH = (TNSNAMES)

Then, through the command to start listening.
[oracle @ rhel47 ~] $ lsnrctl start
Confirmed that the normal start.

9. DBCONSOLE configuration

DBCONSOLE needed to configure this tool emca ..
The establishment of the Treasury, the relevant information here, including the need for ORACLE_SID, listening port number, SYS and SYSMAN user password.
[oracle @ rhel47 ~] $ emca-repos create

Configuration database, where the relevant information, including the need for ORACLE_SID, listening port number, SYS, DBSNMP and SYSMAN user password.
[oracle @ rhel47 ~] $ emca-config dbcontrol db

Here .. take some time after the completion of, dbconsole automatically start .. using the following command to check.
[oracle @ rhel47 ~] $ emctl status dbconsole

Http://rhel47:1158/em the way through (OEM) access control ..

(OVER)