Company environment RedHatAS5 installation Oracle10g documentation

Company environment RedHatAS5 installation Oracle10g documentation

Company environment RedHat AS5 installation of Oracle 10 Gb documentation

Patch for Oracle10gR2
Run patch2 first

Rpm-Uvh compat-libstdc ++-3.2-1. i386.rpm

-Rw-r -- 1 root 3016394 Aug 20 binutils-2.17.50.0.6-6.0.1.el5.i386.rpm
-Rw-r -- 1 root 410476 Aug 20 compat-binutils215-2.15.92.0.2-24.i386.rpm
-Rw-r -- 1 root 4256 Aug 20 compat-libcwait-2.1-1.i386.rpm
-Rw-r -- 1 root 3552095 Aug 20 compat-libstdc ++-3.2-1. i386.rpm
-Rw-r -- 1 root 88787 Aug 20 compat-libstdc ++-egcs-1.1.2-1.i386.rpm
-Rw-r -- 1 root 3840 Aug 20 compat-oracle-el5-1.0-5.i386.rpm
-Rw-r -- 1 root 15427327 Aug 20 16:15 fonts-chinese-3.02-12.el5.noarch.rpm
-Rw-r -- 1 root 1079629 Aug 20 openmotif21-2.1.30-11.EL5.i386.rpm
-Rw-r -- 1 root 122314 Aug 20 openmotif21-debuginfo-2.1.30-11.EL5.i386.rpm
-Rw-r -- 1 root 10662 Aug 20 xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm

[Root @ patches] # rpm-Uvh compat-libstdc ++-3.2-1. i386.rpm
Error: Failed dependencies:
Libstdc ++ = 4.1.2-42. el5 is needed by (installed) libstdc ++-devel-4.1.2-42.el5.i386
Libstdc ++ = 4.1.2-42. el5 is needed by (installed) gcc-c ++-4.1.2-42. el5.i386
Libstdc ++. so.6 is needed by (installed) libusb-0.1.12-5.1.i386
Libstdc ++. so.6 is needed by (installed) db4-4.3.29-9.fc6.i386
Libstdc ++. so.6 is needed by (installed) libtiff-3.8.2-7.el5.i386
Libstdc ++. so.6 is needed by (installed) beecrypt-4.1.2-10.1.1.i386
Libstdc ++. so.6 is needed by (installed) flac-1.1.2-28.el5_0.1.i386
Libstdc ++. so.6 is needed by (installed) pcre-6.6-2.el5_1.7.i386
Libstdc ++. so.6 is needed by (installed) aspell-0.60.3-7.1.i386
Libstdc ++. so.6 is needed by (installed) groff-1.18.1.1-11.1.i386
Libstdc ++. so.6 is needed by (installed) festival-1.95-5.2.1.i386
Libstdc ++. so.6 is needed by (installed) iptstate-1.4-1.1.2.2.i386
Libstdc ++. so.6 is needed by (installed) ttmkfdir-3.0.9-23.el5.i386
Libstdc ++. so.6 is needed by (installed) dvd + rw-tools-7.0-0.el5.3.i386
Libstdc ++. so.6 is needed by (installed) libmusicbrainz-2.1.1-4.1.i386
Libstdc ++. so.6 is needed by (installed) cdrdao-1.2.1-2.i386
Libstdc ++. so.6 is needed by (installed) mesa-libGLU-6.5.1-7.5.el5.i386
Libstdc ++. so.6 is needed by (installed) opensp-1.5.2-4.i386
Libstdc ++. so.6 is needed by (installed) openjade-1.3.2-27.i386
Libstdc ++. so.6 is needed by (installed) cups-1.2.4-11.18.el5.i386
Libstdc ++. so.6 is needed by (installed) RedHat-lsb-3.1-12.3.EL.i386
Libstdc ++. so.6 is needed by (installed) hpijs-1.6.7-4.1.el5_0.3.i386
Libstdc ++. so.6 is needed by (installed) poppler-0.5.4-4.4.el5_1.i386
Libstdc ++. so.6 is needed by (installed) lftp-3.5.1-2.fc6.i386
Libstdc ++. so.6 is needed by (installed) coolkey-1.1.0-6.el5.i386
Libstdc ++. so.6 is needed by (installed) gmp-4.1.4-10.el5.i386
Libstdc ++. so.6 is needed by (installed) libstdc ++-devel-4.1.2-42.el5.i386
Libstdc ++. so.6 is needed by (installed) libicu-3.6-5.11.1.i386
Libstdc ++. so.6 is needed by (installed) boost-1.33.1-10.el5.i386
Libstdc ++. so.6 is needed by (installed) swig-1.3.29-2.el5.i386
Libstdc ++. so.6 is needed by (installed) doxygen-1.4.7-1.1.i386
Libstdc ++. so.6 is needed by (installed) systemtap-0.6.2-1.el5.i386
Libstdc ++. so.6 is needed by (installed) oprofile-0.9.3-16.el5.i386
Libstdc ++. so.6 is needed by (installed) frysk-0.0.1.2008.03.19.rh1-1.el5.i686
Libstdc ++. so.6 is needed by (installed) xulrunner-1.9-0.beta5.6.el5.i386
Libstdc ++. so.6 is needed by (installed) ghostscript-8.15.2-9.1.el5_1.1.i386
Libstdc ++. so.6 is needed by (installed) yelp-2.16.0-18.el5.i386
Libstdc ++. so.6 is needed by (installed) firefox-3.0-0.beta5.6.el5.i386
Libstdc ++. so.6 is needed by (installed) evince-0.6.0-8.el5.i386
Libstdc ++. so.6 is needed by (installed) vnc-server-4.1.2-9.el5.i386
Libstdc ++. so.6 is needed by (installed) xulrunner-devel-1.9-0.beta5.6.el5.i386
Libstdc ++. so.6 is needed by (installed) sound-juicer-2.16.0-3.el5.i386
Libstdc ++. so.6 is needed by (installed) scim-libs-1.4.4-39.el5.i386
Libstdc ++. so.6 is needed by (installed) scim-1.4.4-39.el5.i386
Libstdc ++. so.6 is needed by (installed) scim-tables-0.5.6-7.i386
Libstdc ++. so.6 is needed by (installed) scim-bridge-0.4.5-7.el5.i386
Libstdc ++. so.6 is needed by (installed) wvdial-1.54.0-5.2.2.1.i386
Libstdc ++. so.6 is needed by (installed) scim-pinyin-0.5.91-16.el5.i386
Libstdc ++. so.6 is needed by (installed) scim-chewing-0.3.1-11.el5.i386
Libstdc ++. so.6 is needed by (installed) scim-chinese-standard-0.0.2-1.el5.i386
Libstdc ++. so.6 is needed by (installed) stardict-2.4.5-5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) libusb-0.1.12-5.1.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) db4-4.3.29-9.fc6.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) libtiff-3.8.2-7.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) beecrypt-4.1.2-10.1.1.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) flac-1.1.2-28.el5_0.1.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) pcre-6.6-2.el5_1.7.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) aspell-0.60.3-7.1.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) groff-1.18.1.1-11.1.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) festival-1.95-5.2.1.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) iptstate-1.4-1.1.2.2.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) ttmkfdir-3.0.9-23.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) DVDs + rw-tools-7.0-0.el5.3.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) libmusicbrainz-2.1.1-4.1.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) cdrdao-1.2.1-2.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) mesa-libGLU-6.5.1-7.5.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) opensp-1.5.2-4.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) openjade-1.3.2-27.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) cups-1.2.4-11.18.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) hpijs-1.6.7-4.1.el5_0.3.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) poppler-0.5.4-4.4.el5_1.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) coolkey-1.1.0-6.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) gmp-4.1.4-10.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) libicu-3.6-5.11.1.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) boost-1.33.1-10.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) swig-1.3.29-2.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) doxygen-1.4.7-1.1.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) oprofile-0.9.3-16.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) frysk-0.0.1.2008.03.19.rh1-1.el5.i686
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) xulrunner-1.9-0.beta5.6.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) yelp-2.16.0-18.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) evince-0.6.0-8.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) vnc-server-4.1.2-9.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) xulrunner-devel-1.9-0.beta5.6.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) scim-libs-1.4.4-39.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) scim-1.4.4-39.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) scim-tables-0.5.6-7.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) scim-bridge-0.4.5-7.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) scim-pinyin-0.5.91-16.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) scim-chewing-0.3.1-11.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) scim-chinese-standard-0.0.2-1.el5.i386
Libstdc ++. so.6 (CXXABI_1.3) is needed by (installed) stardict-2.4.5-5.i386
Libstdc ++. so.6 (CXXABI_1.3.1) is needed by (installed) opensp-1.5.2-4.i386
Libstdc ++. so.6 (CXXABI_1.3.1) is needed by (installed) vnc-server-4.1.2-9.el5.i386
Libstdc ++. so.6 (CXXABI_1.3.1) is needed by (installed) scim-pinyin-0.5.91-16.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) libusb-0.1.12-5.1.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) db4-4.3.29-9.fc6.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) libtiff-3.8.2-7.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) beecrypt-4.1.2-10.1.1.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) flac-1.1.2-28.el5_0.1.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) pcre-6.6-2.el5_1.7.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) aspell-0.60.3-7.1.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) groff-1.18.1.1-11.1.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) festival-1.95-5.2.1.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) iptstate-1.4-1.1.2.2.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) ttmkfdir-3.0.9-23.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) DVDs + rw-tools-7.0-0.el5.3.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) libmusicbrainz-2.1.1-4.1.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) cdrdao-1.2.1-2.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) mesa-libGLU-6.5.1-7.5.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) opensp-1.5.2-4.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) openjade-1.3.2-27.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) cups-1.2.4-11.18.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) hpijs-1.6.7-4.1.el5_0.3.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) poppler-0.5.4-4.4.el5_1.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) coolkey-1.1.0-6.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) gmp-4.1.4-10.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) libicu-3.6-5.11.1.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) boost-1.33.1-10.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) swig-1.3.29-2.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) doxygen-1.4.7-1.1.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) systemtap-0.6.2-1.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) oprofile-0.9.3-16.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) xulrunner-1.9-0.beta5.6.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) yelp-2.16.0-18.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) firefox-3.0-0.beta5.6.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) vnc-server-4.1.2-9.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) xulrunner-devel-1.9-0.beta5.6.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) scim-libs-1.4.4-39.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) scim-1.4.4-39.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) scim-tables-0.5.6-7.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) scim-bridge-0.4.5-7.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) scim-pinyin-0.5.91-16.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) scim-chewing-0.3.1-11.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) scim-chinese-standard-0.0.2-1.el5.i386
Libstdc ++. so.6 (GLIBCXX_3.4) is needed by (installed) stardict-2.4.5-5.i386
Libstdc ++. so.6 (GLIBCXX_3.4.5) is needed by (installed) boost-1.33.1-10.el5.i386
/Usr/lib/libstdc ++. so.6 is needed by (installed) libstdc ++-devel-4.1.2-42.el5.i386
[Root @ patches] #

[Root @ patches] # rpm-Uvh compat-oracle-el5-1.0-5.i386.rpm
Error: Failed dependencies:
Compat-gcc-34 is needed by compat-oracle-el5-1.0-5.i386
Compat-gcc-34-c ++ is needed by compat-oracle-el5-1.0-5.i386
Openmotif21 is needed by compat-oracle-el5-1.0-5.i386
[Root @ patches] #

[Root @ patches] # rpm-Uvh fonts-chinese-3.02-12.el5.noarch.rpm
Warning: fonts-chinese-3.02-12.el5.noarch.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ######################################## ### [100%]
Package fonts-chinese-3.02-12.el5 is already installed
File/usr/share/fonts/chinese/misc/taipei16.pcf.gz from install of fonts-chinese-3.02-12.el5 conflicts with file from package fonts-chinese-3.02-12.el5
File/usr/share/fonts/chinese/misc/taipei20.pcf.gz from install of fonts-chinese-3.02-12.el5 conflicts with file from package fonts-chinese-3.02-12.el5
File/usr/share/fonts/chinese/misc/taipei24.pcf.gz from install of fonts-chinese-3.02-12.el5 conflicts with file from package fonts-chinese-3.02-12.el5
[Root @ patches] #

[Root @ patches] # rpm-Uvh openmotif21-2.1.30-11.EL5.i386.rpm
Error: Failed dependencies:
LibXp. so.6 is needed by openmotif21-2.1.30-11.EL5.i386

Create unix account

Password1
Oratest1/oraapp01

Groupadd-g 401 dba
Useradd-u 501-d/home/oratest1-g dba oratest1
Passwd oratest1

Configure kernel parameters for oracle10g

Vi/etc/sysctl. conf
# Controls the maximum shared segment size, in bytes
Kernel. shmmax = 4294967295

# Controls the maximum number of shared memory segments, in pages
Kernel. shmall = 268435456

# Added in 2009/08/21
Kernel. shmmni = 4096
# Semaphores: semmsl, semmns, semopm, semmni
Kernel. sem = 250 32000 100 128
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

Refreshing...
[Root @ ~] #/Sbin/sysctl-p

Vi/etc/security/limits. conf
# Use for oracle
* Soft nproc 2047
* Hard nproc 16384
* Soft nofile 1024
* Hard nofile 65536

Add the following content at the end of the line vi/etc/pam. d/login:
Session required pam_limits.so

During installation, ignore the parameter determined by the operating system./runInstaller-ignoresysprereqs

Forged as version 4, or cannot be installed! After the installation is complete, change it back.
Vi/etc/redhat-release
Red Hat Enterprise Linux Server release 5.2 (Tikanga)

Changed:
Redhat-4

Installation Error Due to settings of hosts and DNS:
An unexpected exception has been detected in native code outside the VM.
Unexpected Signal: 11 occurred at PC = 0x312613
Function = index + 0x63
Library =/lib/i686/nosegneg/libc. so.6

Current Java thread:
At oracle.net. common. NetGetEnv. getDNSDomain (Native Method)
At oracle.net. ca. ConfigureProfile. setdefaproprofileparams (Unknown Source)
At oracle.net. ca. InitialSetup. setupConfigObjects (Unknown Source)
At oracle.net. ca. InitialSetup. (Unknown Source)
At oracle.net. ca. NetCA. main (Unknown Source)

Change hosts and resolv. conf:
[Root @ etc] # cat/etc/hosts
# Do not remove the following line, or various programs
# That require network functionality will fail.
#127.0.0.1 zkrapp01 localhost. localdomain localhost
: 1 localhost6.localdomain6 localhost6
88.0.33.17 zj-zkrapp01 localhost. localdomain localhost
[Root @ etc] # cat resolv. conf
# Domainname zking.com
# Nameserver 66.0.32.5
# Nameserver 66.0.32.6
[Root @ etc] #

Select database character set: ZHS16GBK
1 * select * from V $ NLS_PARAMETERS
SQL>/

PARAMETER VALUE
------------------------------------------------------------
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
NLS_CURRENCY $
NLS_ISO_CURRENCY CHINA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT YYYY-MM-DD HH24: MI: SS
NLS_DATE_LANGUAGE SIMPLIFIED CHINESE
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_TIME_FORMAT HH. MI. SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH. MI. SSXFF AM
NLS_TIME_TZ_FORMAT HH. MI. SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH. MI. SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE

19 rows have been selected.

Generate database creation scripts:/home/oratest1/admin/test1/scripts

OEM:
The database control URL is: 1158/em

[Root @ etc] # cd/home/oratest1
[Root @ oratest1] # cd oraInventory
[Root @ oraInventory] # ls *. sh
OrainstRoot. sh
[Root @ oraInventory] #./orainstRoot. sh
Changing permissions of/home/oratest1/oraInventory to 770.
Changing groupname of/home/oratest1/oraInventory to dba.
The execution of the script. is complete
[Root @ oraInventory] # cd ..
[Root @ oratest1] # pwd
/Home/oratest1
[Root @ oratest1] # cd ora10g
[Root @ ora10g] # ls *. sh
Root. sh
[Root @ ora10g] #./root. sh
Running Oracle10 root. sh script...

The following environment variables are set:
ORACLE_OWNER = oratest1
ORACLE_HOME =/home/oratest1/ora10g

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
Database Configuration Assistant when a database is created
Finished running generic part of root. sh script.
Now product-specific root actions will be saved med.
[Root @ ora10g] #