January 13, 2010 at 09:14Install 10.2.0.1 x86_64 on CentOS 5.1 x86_64
This is a work instruction equipped with all the scripts necessary for the full work, including for auto start base and additional services.
The instruction does not contain a direct description of the actions in OracleInstaller since the specialist installing this configuration already clearly knows what to do.
The article is not mine, the author needs an invite, but for some reason the article does not post in the sandbox.
1. create users and groups
we do under the root
# we will decide on the installation directories
traditionally
mount arrays or sections for oracle in the root
/ u00
/ u01
...
in our case:
/ u00 - the partition for the Oracle database
/ u01 - the partition for http
/ u02 - the directory for the Oracle
database is placed on / u02 and we create tablespaces on / u00
on the remaining sections we throw only control files
2. Deception installer
make a copy of the file / etc / redhat-release
cp redhat-release redhat-release1
do a trick - otherwise the
echo redhat-4> redhat-release installer does not start
3. Add the limits
to /etc/security/limits.conf
4. add to /etc/pam.d/login
session required /lib/security/pam_limits.so
5. deliver packages : 6. install kernel parameters Add to /etc/sysctl.conf - #for oracle kernel.shmmni = 4096 # semaphores: semmsl semmns semopm semmni kernel.sem = 250 32000 100 128 fs.file-max = 65535 net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default = 262144 check # sysctl -p net.ipv4.ip_forward = 0 net. ipv4.conf.default.rp_filter = 1 net.ipv4.conf.default.accept_source_route = 0 kernel.sysrq = 0 kernel.core_uses_pid = 1 net.ipv4.tcp_syncookies = 1 kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
7. set .bash_profile for the oracle user first replace the database_name with SID 8. Go directly to the installation under the user oracle and run the installation / in This instruction does not cover the work in the installer itself because it is simple and transparent / install sh runInstaller
advanced
custom
... we
select the components we
install,
we execute the scripts as root
.
9. Creating database creation scripts.
If there are database templates for DBCA, then you need to put them in
/ assistants / dbca / templates
in X-dbca
and create the database generation scripts.
I draw attention to:
you need to set the correct encoding,
for example, CL8MSWIN1251
and national AL16UTF16
10. to avoid the error, check
$ sqlplus / nolog
SQL * Plus: Release 10.2.0.1.0 - Production on Sun Jul 29 10:32:44 2007
Copyright © 1982, 2005, Oracle. All rights reserved.
SQL> conn sys as sysdba
Enter password:
oraclemerl: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: lost contact
must be set to
libaio-0.3.103-3.X86_64.RPM
or older
11 start creating a
11.1 run database creation scripts
11.2 check for files listener
the sqlnet.ora
the tnsnames.ora
sample files
the sqlnet.ora the tnsnames.ora database_name replaced by the SID, ip_bazy - the ip from which the server interface will be available database if the file is not present - they can create handles or the wizard ./netmgr 12. make the database autostart 12.1 copy the oratab file to / etc / and correct the name and path to the database in it
example oratab
12.2 file copy oracle file to /etc/init.d/
12.3 check for dbstart (should be in / bin /)
12.4 check serivce oracle start / stop commands
12.5 make links:
ln -s /etc/init.d/oracle /etc/rc2.d/S99oracle
ln -s /etc/init.d/oracle /etc/rc3.d/S99oracle
ln -s /etc/init.d/oracle /etc/rc4.d/S99oracle
ln -s / etc / init.d / oracle /etc/rc0.d/K01oracle
ln -s /etc/init.d/oracle /etc/rc6.d/K01oracle
12.6 check how the
logs start up when the server starts / stops and burns into / var / log / oracle
13. Oracle iSQL * plus
start manual - isqlplusctl start
stop manual - isqlplusctl stop
installation service
copy fileoraisql in /etc/init.d/
manage the service - service oraisql start | stop | restart
look at port 5561 for
those server_name : 5561 / isqlplus / and http: // server_name: 5561 / isqlplus / dba.uix auto start
-stop service
make links
ln -s /etc/init.d/oraisql /etc/rc2.d/S99oraisql
ln -s /etc/init.d/oraisql /etc/rc3.d/S99oraisql
ln -s /etc/init.d/oraisql / etc /rc4.d/S99oraisql
ln -s /etc/init.d/oraisql /etc/rc0.d/K01oraisql
ln -s /etc/init.d/oraisql /etc/rc6.d/K01oraisql
14. Oracle Enterprise Manager
start manual
emctl start dbconsole
stop manual
emctl stop dbconsole
installation service
copy fileoraemc in /etc/init.d/
manage the service - service oraemc start | stop | restart
look at server_name : 1158 / em / auto start
-stop service
make links
ln -s /etc/init.d/oraemc /etc/rc2.d / S99oraemc
ln -s /etc/init.d/oraemc /etc/rc3.d/S99oraemc
ln -s /etc/init.d/oraemc /etc/rc4.d/S99oraemc
ln -s /etc/init.d/ oraemc /etc/rc0.d/K01oraemc
ln -s /etc/init.d/oraemc /etc/rc6.d/K01oraemc
The instruction does not contain a direct description of the actions in OracleInstaller since the specialist installing this configuration already clearly knows what to do.
The article is not mine, the author needs an invite, but for some reason the article does not post in the sandbox.
1. create users and groups
we do under the root
groupadd oinstall
useradd -g oinstall oracle
passwd oracle# we will decide on the installation directories
traditionally
mount arrays or sections for oracle in the root
/ u00
/ u01
...
in our case:
/ u00 - the partition for the Oracle database
/ u01 - the partition for http
/ u02 - the directory for the Oracle
database is placed on / u02 and we create tablespaces on / u00
on the remaining sections we throw only control files
mkdir -p /u02/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u02
mkdir -p /u00/oradata
chown -R oracle.oinstall /u00
mkdir -p /u01/oradata
chown -R oracle.oinstall /u012. Deception installer
make a copy of the file / etc / redhat-release
cp redhat-release redhat-release1
do a trick - otherwise the
echo redhat-4> redhat-release installer does not start
3. Add the limits
to /etc/security/limits.conf
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 655364. add to /etc/pam.d/login
session required /lib/security/pam_limits.so
5. deliver packages : 6. install kernel parameters Add to /etc/sysctl.conf - #for oracle kernel.shmmni = 4096 # semaphores: semmsl semmns semopm semmni kernel.sem = 250 32000 100 128 fs.file-max = 65535 net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default = 262144 check # sysctl -p net.ipv4.ip_forward = 0 net. ipv4.conf.default.rp_filter = 1 net.ipv4.conf.default.accept_source_route = 0 kernel.sysrq = 0 kernel.core_uses_pid = 1 net.ipv4.tcp_syncookies = 1 kernel.msgmnb = 65536
compat-db-4.2.52-5.1.i386.rpm
compat-db-4.2.52-5.1.x86_64.rpm
compat-gcc-34-3.4.6-4.x86_64.rpm
"compat-gcc-34-c++-3.4.6-4.x86_64.rpm"
"compat-libstdc++-33-3.2.3-61.i386.rpm"
"compat-libstdc++-33-3.2.3-61.x86_64.rpm"
gcc-4.1.2-14.el5.x86_64.rpm
glibc-2.5-18.i686.rpm
glibc-2.5-18.x86_64.rpm
libaio-0.3.106-3.2.i386.rpm
libaio-0.3.106-3.2.x86_64.rpm
libXp-1.0.0-8.1.el5.i386.rpm
libXp-1.0.0-8.1.el5.x86_64.rpm
make-3.81-1.1.x86_64.rpm
openmotif22-2.2.3-18.i386.rpm
openmotif22-2.2.3-18.x86_64.rpm
setarch-2.0-1.1.x86_64.rpm
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
7. set .bash_profile for the oracle user first replace the database_name with SID 8. Go directly to the installation under the user oracle and run the installation / in This instruction does not cover the work in the installer itself because it is simple and transparent / install sh runInstaller
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_HOME=/u02/app/oracle/product/10.2.0/db_1 ; export ORACLE_HOME
ORACLE_BASE=/u00/oradata ; export ORACLE_BASE
ORACLE_TERM=xterm ; export ORACLE_TERM
ORACLE_SID=имя_базы ; export ORACLE_SID
TNS_ADMIN=$ORACLE_HOME/network/admin ; export TNS_ADMIN
ORACLE_DOC=$ORACLE_HOME/doc ; export ORACLE_DOC
ORACLE_SID=имя_базыl ; export ORACLE_SID
NLS_LANG=AMERICAN_AMERICA.CL8MSWIN1251 ; export NLS_LANG
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:ORACLE_HOME/lib
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
export PATH
unset USERNAMEadvanced
custom
... we
select the components we
install,
we execute the scripts as root
.
9. Creating database creation scripts.
If there are database templates for DBCA, then you need to put them in
/ assistants / dbca / templates
in X-dbca
and create the database generation scripts.
I draw attention to:
you need to set the correct encoding,
for example, CL8MSWIN1251
and national AL16UTF16
10. to avoid the error, check
$ sqlplus / nolog
SQL * Plus: Release 10.2.0.1.0 - Production on Sun Jul 29 10:32:44 2007
Copyright © 1982, 2005, Oracle. All rights reserved.
SQL> conn sys as sysdba
Enter password:
oraclemerl: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: lost contact
must be set to
libaio-0.3.103-3.X86_64.RPM
or older
11 start creating a
11.1 run database creation scripts
11.2 check for files listener
the sqlnet.ora
the tnsnames.ora
sample files
the sqlnet.ora the tnsnames.ora database_name replaced by the SID, ip_bazy - the ip from which the server interface will be available database if the file is not present - they can create handles or the wizard ./netmgr 12. make the database autostart 12.1 copy the oratab file to / etc / and correct the name and path to the database in it
NAMES.DIRECTORY_PATH= (TNSNAMES)
имя_базы =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip_базы)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = имя_базы)
)
)
example oratab
имя_базы:/u02/app/oracle/product/10.2.0/db_1:Y12.2 file copy oracle file to /etc/init.d/
12.3 check for dbstart (should be in / bin /)
12.4 check serivce oracle start / stop commands
12.5 make links:
ln -s /etc/init.d/oracle /etc/rc2.d/S99oracle
ln -s /etc/init.d/oracle /etc/rc3.d/S99oracle
ln -s /etc/init.d/oracle /etc/rc4.d/S99oracle
ln -s / etc / init.d / oracle /etc/rc0.d/K01oracle
ln -s /etc/init.d/oracle /etc/rc6.d/K01oracle
12.6 check how the
logs start up when the server starts / stops and burns into / var / log / oracle
13. Oracle iSQL * plus
start manual - isqlplusctl start
stop manual - isqlplusctl stop
installation service
copy fileoraisql in /etc/init.d/
manage the service - service oraisql start | stop | restart
look at port 5561 for
those server_name : 5561 / isqlplus / and http: // server_name: 5561 / isqlplus / dba.uix auto start
-stop service
make links
ln -s /etc/init.d/oraisql /etc/rc2.d/S99oraisql
ln -s /etc/init.d/oraisql /etc/rc3.d/S99oraisql
ln -s /etc/init.d/oraisql / etc /rc4.d/S99oraisql
ln -s /etc/init.d/oraisql /etc/rc0.d/K01oraisql
ln -s /etc/init.d/oraisql /etc/rc6.d/K01oraisql
14. Oracle Enterprise Manager
start manual
emctl start dbconsole
stop manual
emctl stop dbconsole
installation service
copy fileoraemc in /etc/init.d/
manage the service - service oraemc start | stop | restart
look at server_name : 1158 / em / auto start
-stop service
make links
ln -s /etc/init.d/oraemc /etc/rc2.d / S99oraemc
ln -s /etc/init.d/oraemc /etc/rc3.d/S99oraemc
ln -s /etc/init.d/oraemc /etc/rc4.d/S99oraemc
ln -s /etc/init.d/ oraemc /etc/rc0.d/K01oraemc
ln -s /etc/init.d/oraemc /etc/rc6.d/K01oraemc
