zxv10iptv多媒体解决方案oracle10g数据库安装指导

1、ZXV10 IPTV多解决方案Oracle 10g数据库安装指导中兴通讯地址：市科技南路55号：518057：(86) 755 26770801技术支持：电子邮件：法律本资料著作权属中兴通讯所有。著作权人，任何或个人不得以任何方式摘录、或翻译。对本手册中的印刷错误及与资料不符之处会及时改进。这些改动不再事先通知，但会编入新版手册兴通讯保留最终解释权。Copyright 2010 ZTE CORPORATION.版本号：产品版本：V3.04.07物料代码：SJ-20110121170210-009发布日期：20110125(R1.0)目录前言手册说明本手册介绍中兴IPTV系统Oracle数据库的

2、安装过程。读者对象本手册适合现场开局使用。内容简介本书的主要内容如下表所示。本书约定1. 鼠标操作约定2. 安全符号约定在本手册中可能出现下列安全符号，它们所代表的含义如下。安全符号意义格式意义单击快速按下并鼠标的左键双击连续两次快速按下并鼠标的左键右击快速按下并鼠标的右键拖动按住鼠标的左键不放，移动鼠标章名概要第1章 安装概述及准备工作本章介绍IPTV系统Oracle数据库的安装概述及准备工作第2章 安装Oracle10g（企业版）本章介绍IPTV系统安装Oracle10g（企业版）的过程第3章 安装Oracle10.2.0.1（客户端）本章介绍IPTV系统安装Oracle10.2.0.1（

3、客户端）的过程第4章 安装过程常见问题本章介绍IPTV系统安装过程中的常见问题安全符号意义表示若忽视安全告诫，就有可能发生损坏设备或导致人身的严重事故警告表示若忽视安全告诫，就有可能发生损坏设备或导致人身的事故注意表示若忽视安全告诫，就有可能导致设备损坏、数据丢失、设备性能降低以及其它不可预知的安全符号意义提示表示该内容是特别提示的信息说明表示该内容是正文的附加信息1安装概述及准备工作1.1 概述在安装Oracle 10g数据库之前需要进行一系列的准备工作，准备完成后才能进行相应的安装。1.2 安装准备工作1.2.1及环境准备SuSE Linux Entrise Edition已安装。安装。d

4、ba用户组、zxin10用户、oracle用户已经创建，.bash_profile配智能网置文件已具备。Oracle 10g安装文件和补丁包。 32bit：10201_database_linux32.zip，p8202632_10205_linux.zip 64bit：10201_database_linux_x86_64.cpio，p8202632_10205_Linux-x86-64.zip默认安装配置文件：install_10201_ee.rsp：Oracle10.2.0.1企业版默认安装配置文件install_10201_se.rsp：Oracle10.2.0.5标准版默认安装配置文

5、件install_10205.rsp：oracle10.2.0.1升级到102.0.5版本的静默安装配置文件（适用准版和企业版）这些文件在DB产品包中的 install/OracleInstall/目录下。1.2.2 创建 setup 用户1. 创建setip用户root# useradd setup # passwd setup2. 创建setup目录并赋予权限# mkdir /home/setup#n setup:users /home/setup#od 777 /home/setup1.2.3 上传1. 将默认安装配置文件install_10201_ee.rsp，install_1020

6、1_se.rsp，install_10201.rsp以 ASC方式上传到/home/setup/install/oracle目录下。如果目录不存在，请执行如下命令创建。# mkdir -p /home/setup/install/oracle# dos2unix install_10201_ee.rsp install_10201_ee.rsp install_10205.rsp2. 以安装32bit的oracle为例。将 Oracle 10g 的安装文件 10201_database_linux32.zip 上 传 到 DB 服 务 器 的/home/setup/install/oracle

7、目录下，并解压10201_database_linux32.zip。 root# unzip 10201_database_linux32.zip64位oracle版本上传过程类似，解压命令如下： root# cpio -idmv 10201_database_linux_x86_64.cpio3.将 Oracle 10g 的补丁文件 p8202632_10205_linux.zip 上传到 DB 服务器的 /home/setup/install/oracle目录下，并解压p8202632_10205_linux.zip root# unzip p8202632_10205_linux.zip

8、64位oracle补丁文件上传过程类似，解压命令如下： root# unzip p6810189_10205_Linux-x86-64.zip4. 给install文件夹赋予权限：root#od -R 777 /home/setup/install5. 无论是安装企业版还是标准版，都必须升级到10.2.0.5版本。2安装 ORACLE10g（企业版）2.1 安装 oracle10.2.0.12.1.1 执行安装oracle$ cd /home/setup/install/oracle/database$./runInstaller-silent-responseFile/home/setup/

9、install/oracle/install_10201_ee.rsp-ignoresysprereqs2.1.2 安装过程以下为oracle10.2.0.1安装过程，参考。Starting Oracle Universal Installer. Checking installer requirements.Checking operating system ver asianux-2Failed Oracle Universal Installer, Ver Production10.2.0.1.0Copyright (C) 1999, 2005, Oracle.You can find

10、a log of this install sess.at:/home/oracle/zxindbf/oraInventory/logs/installActions2010-11-02_05-24-23PM.log. 100% Done.Loading Product Information. 100% Done.yzing dependencies.Starting execution of Prerequisites. Total No of checks: 11Performing check for CertifiedVersChecking operating system req

11、uirements . Expected result: One of redhat-3,redhat-4,SuSE-9Actual Result: SuSE-SUSE Linux Ent rise Server 11 (x86_64) Check complete. The overall result of this check is: Failed Check complete: Failed Problem: Oracle Database 10g is not certified on the current operating system.mendation: Make sure

12、 you are installing the software on the correct platform.=Performing check for PackagesChecking operating system package requirements .Check complete. The overall result of this check is: Not executed Check complete: Not executed OUI-18001: The operating system Linux Ver supported.SuSE-SUSE Linux En

13、trise Server 11 (x86_64) is notmendation: Install the required packages before continuing with the installation.=Performing check for Kernel Checking kernel parametersCheck complete. The overall result of this check is: Not executed Check complete: Not executed OUI-18001: The operating system Linux

14、Ver supported.SuSE-SUSE Linux Entrise Server 11 (x86_64) is notmendation: Perform operating system specific instructions to update the kernel parameters.=Performing check fLIBCCheckingmended glibc verCheck complete. The overall result of this check is: Not executed Check complete: Not executed OUI-1

15、8001: The operating system Linux Ver supported.SuSE-SUSE Linux Entrise Server 11 (x86_64) is notmendation: You may actually have installed packages which have obsoleted these, in which case youcan sucsfully continue with the install. If you have not, it is the readme to find out how to get the missi

16、ng packages.mendedt you do not continue. Refer to=Performing check for TotalMemory Checking physical memory requirements . Expected result: 922MBActual Result: 1688MBCheck complete. The overall result of this check is: Passed Check complete: Passed=Performing check for SwapSpaceChecking available sw

17、ap space requirements . Expected result: 2532MBActual Result: 2055MBCheck complete. The overall result of this check is: Failed Check complete: Failed Problem: The system does nove the required swap space.mendation: Make more swap space available to perform the install.=Performing check for DetectIf

18、DHCPAssignedIP Checking Network Configuration requirements .Actual Result: Unknown Host Exception has Occurred :linux11-DB: linux11-DB. Check complete. The overall result of this check is: Not executed Check complete: Not executed Oracle Universal Installer, Ver Production10.2.0.5.0Copyright (C) 199

19、9, 2010, Oracle.You can find a log of this install sess.at:/home/oracle/zxindbf/oraInventory/logs/installActions2010-11-02_05-54-05PM.log. 100% Done.Loading Product Information. 100% Done.Starting execution of Prerequisites. Total No of checks: 8Performing check for CertifiedVersChecking operating s

20、ystem requirements .Expectedresult:Oneofredhat-6,redhat-5,redhat-4,redhat-3,SuSE-11,SuSE-10,SuSE-9,asianux-3,asianux-2,asianux-1 Actual Result: SuSE-11Check complete. The overall result of this check is: Passed Check complete: Passed=Performing check for PackagesChecking operating system package req

21、uirements .Check complete. The overall result of this check is: Not executed Check complete: Not executed OUI-11108: Packages information not specified.mendation: Install the required packages before continuing with the installation.=Performing check for Kernel Checking kernel parametersChecking for

22、 semmsl=250; found semmsl=1250. Passed Checking for semopm=100; found semopm=100. Passed Checking for semmni=128; found semmni=256. Passed Check complete. The overall result of this check is: Passed Check complete: Passed=Performing check fLIBCCheckingExpected result:mended glibc verActual Result: 2

23、.11.1-0.17.4Check complete. The overall result of this check is: Passed Check complete: Passed=Performing check for TotalMemory Checking physical memory requirements . Expected result: 922MBActual Result: 1688MBCheck complete. The overall result of this check is: Passed Check complete: Passed=Perfor

24、ming check for SwapSpaceChecking available swap space requirements . Expected result: 2532MBActual Result: 2055MBCheck complete. The overall result of this check is: Failed Check complete: Failed Problem: The system does nove the required swap space.mendation: Make more swap space available to perfo

25、rm the install.=Performing check for checkToInstallCCR Checking the Components installed in Oracle HomeCheck complete. The overall result of this check is: Passed Check complete: Passed=Performing check for CompatibilityChecksChecking for Oracle Homepatibilities .Check complete. The overall result o

26、f this check is: Passed Check complete: Passed=PrereqChecks complete yzing dependencies. 100% Done.Summary Global SettingsSource: /home/setup/install/oracle/Disk1/stage/products.xml Oracle Home: /home/oracle/oracle10g (ORACLE_HOME) Product LanguagesSimplified Chi EnglishSpace Requirements/home/ Requ

27、ired 1.44GB : Available 93.25GB/ Required 54MB (only as temporary space) : Available 4.33GB New Installations (86 products)Oracle Notification Service Patch 10.2.0.5.0Database Configuration and Upgrade Assistants Patch 10.2.0.5.0 Character Set Migration Utility Patch 10.2.0.5.0Oracle Database 10g Pa

28、tch 10.2.0.5.0Oracle JDBC/OCI Instant C nt Patch 10.2.0.5.0 Oracle Database 10g Patch 10.2.0.5.0Entrise ManagSQL*Plus 10.2.0.5.0lugin Common Files Patch 10.2.0.5.0HAS Common Files Patch 10.2.0.5.0 HAS Files for DB Patch 10.2.0.5.0 Oracle Java C nt Patch 10.2.0.5.0Oracle JVM Patch 10.2.0.5.0Oracleern

29、et Directory C nt Patch 10.2.0.5.0iSQL*Plus 10.2.0.5.0Oracle Advanced Security Patch 10.2.0.5.0 Oracle Net Patch 10.2.0.5.0Oracle Net ListenOracle Wallet Managatch 10.2.0.5.0atch 10.2.0.5.0piler Common Files Patch 10.2.0.5.0Secure Socket Layatch 10.2.0.5.0Oracle ODBC Drivatch 10.2.0.5.0Oracle OLAP P

30、atch 10.2.0.5.0 Oracle OLAP API Patch 10.2.0.5.0 OLAP SQL Scripts Patch 10.2.0.5.0OracleerMedia C nt Option Patch 10.2.0.5.0 Oracle Database 10gerMedia Files Patch 10.2.0.5.0 OracleerMedia Patch 10.2.0.5.0PL/SQL Embedded Gateway Patch 10.2.0.5.0 Oracle XML Development Kit Patch 10.2.0.5.0 Oracle Tex

31、t Patch 10.2.0.5.0Oracle Clusterware RDBMS Files Patch 10.2.0.5.0Database SQL Scripts Patch 10.2.0.5.0Oracle Data Mining RDBMS Files Patch 10.2.0.5.0 Generic Connectivity Common Files Patch 10.2.0.5.0 Oracle Net Required Support Files Patch 10.2.0.5.0Oracle Starter Database Patch 10.2.0.5.0Sle Schem

32、a Data Patch 10.2.0.5.0OracleerMedia Locator RDBMS Files Patch 10.2.0.5.0Oracle Callerface (OCI) Patch 10.2.0.5.0Oracle OLAP RDBMS Files Patch 10.2.0.5.0PL/SQL 10.2.0.5.0Oracle Recovery Managatch 10.2.0.5.0Oracle Database Utilities Patch 10.2.0.5.0 OracleerMedia Locator Patch 10.2.0.5.0 XML Parser f

33、or Java Patch 10.2.0.5.0 Assistant Common Files Patch 10.2.0.5.0Oracle JDBC Thin Driver for JDK 1.2 Patch 10.2.0.5.0 Oracle JDBC Thin Driver for JDK 1.4 Patch 10.2.0.5.0 OracleerMedia Java Advanced Imaging Patch 10.2.0.5.0 SQLJ Runtime Patch 10.2.0.5.0XML Parser for Oracle JVM Patch 10.2.0.5.0 Entri

34、se Manager Agent DB 10.2.0.5.0Entrise Manager Baseline 10.2.0.5.0Oracle Entrise Manager Console DB 10.2.0.5.0 XDK Required Support Files Patch 10.2.0.5.0 Agent Required Support Files Patch 10.2.0.5.0 DBJAVA Required Support Files Patch 10.2.0.5.0 LDAP Required Support Files Patch 10.2.0.5.0piler Req

35、uired Support Files Patch 10.2.0.5.0 Oracle RAC Required Support Files-HAS Patch 10.2.0.5.0RDBMS Required Support Files for Instant C nt Patch 10.2.0.5.0 RDBMS Required Support Files Patch 10.2.0.5.0SQL*Plus Required Support Files Patch 10.2.0.5.0SSL Required Support Files for InstantC nt Patch 10.2

36、.0.5.0 Installation Common Files Patch 10.2.0.5.0Oracle Globalization Support Patch 10.2.0.5.0 Oracle Core Required Support Files Patch 10.2.0.5.0 Platform Required Support Files 10.2.0.5.0Oracle Message Gateway Common Files Patch 10.2.0.5.0Ent EntEntrise Manager Agent Core Patch 10.2.0.5.0arise Man

37、ager Common Core Patch 10.2.0.5.0arise Manager Reitory Core patch 10.2.0.5.0aOracle Containers for Java 10.2.0.5.0Entrise Manager Reitory DB 10.2.0.5.0Oracle LDAP administration patch 10.2.0.5.0Oracle Required Support Files 32 bit Patch 10.2.0.5.0 JDBC Common Files 10.2.0.5.0Database Workspace Manag

38、er 10.2.0.5.0OracleerMedia Anno or 10.2.0.5.0Entrise Manager Minimalegration 10.2.0.5.0Parser Generator Required Support Files 10.2.0.5.0 Buildtools Common Files 10.2.0.5.0Oracle UIX 2.2.24.6.0Bali Share 1.1.19.0.0Oracle Real Application Testing 10.2.0.5.0 Oracle Configuration Manager 10.3.2.1.0 Upg

39、rades (5 products)Oracle Universal Installer 10.2.0.5.0 Oracle One-Off Patch Installer 10.2.0.4.2 Installer SDK Component 10.2.0.5.0 Java Runtime Environment 1.4.2.14.0 Sun JDK 1.4.2.14.05Already Installed (84 products)Oracle Notification Service 10.1.0.3.0Database Configuration and Upgrade Assistan

40、ts 10.2.0.1.0 Character Set Migration Utility 10.2.0.1.0Oracle Database 10g10.2.0.1.0Oracle JDBC/OCI Instant C nt 10.2.0.1.0 Oracle Database 10g10.2.0.1.0Entrise ManagSQL*Plus 10.2.0.1.0lugin Common Files 10.2.0.1.0HAS Common Files 10.2.0.1.0 HAS Files for DB 10.2.0.1.0 Oracle Java C nt 10.2.0.1.0Or

41、acle JVM 10.2.0.1.0Oracleernet Directory C nt 10.2.0.1.0iSQL*Plus 10.2.0.1.0Oracle Advanced Security 10.2.0.1.0 Oracle Net 10.2.0.1.0Oracle Net Listener 10.2.0.1.0 Oracle Wallet Manager 10.2.0.1.0piler Common Files 10.2.0.1.0 Secure Socket Layer 10.2.0.1.0 Oracle ODBC Driver 10.2.0.1.0 Oracle OLAP 1

42、0.2.0.1.0Oracle OLAP API 10.2.0.1.0 OLAP SQL Scripts 10.2.0.1.0OracleerMedia C nt Option 10.2.0.1.0Oracle Database 10gerMedia Files 10.2.0.1.0OracleerMedia 10.2.0.1.0PL/SQL Embedded Gateway 10.2.0.1.0 Oracle XML Development Kit 10.2.0.1.0 Oracle Text 10.2.0.1.0Oracle Clusterware RDBMS Files 10.2.0.1

43、.0 Database SQL Scripts 10.2.0.1.0Oracle Data Mining RDBMS Files 10.2.0.1.0 Generic Connectivity Common Files 10.2.0.1.0 Oracle Net Required Support Files 10.2.0.1.0Oracle Starter Database 10.2.0.1.0Sle Schema Data 10.2.0.1.0OracleerMedia Locator RDBMS Files 10.2.0.1.0Oracle Callerface (OCI) 10.2.0.

44、1.0Oracle OLAP RDBMS Files 10.2.0.1.0 PL/SQL 10.2.0.1.0Oracle Recovery Manager 10.2.0.1.0 Oracle Database Utilities 10.2.0.1.0 OracleerMedia Locator 10.2.0.1.0 XML Parser for Java 10.2.0.1.0 Assistant Common Files 10.2.0.1.0Oracle JDBC Thin Driver for JDK 1.2 10.2.0.1.0 Oracle JDBC Thin Driver for J

45、DK 1.4 10.2.0.1.0 OracleerMedia Java Advanced Imaging 10.2.0.1.0 SQLJ Runtime 10.2.0.1.0XML Parser for Oracle JVM 10.2.0.1.0 Entrise Manager Agent DB 10.2.0.1.0 Entrise Manager Baseline 10.2.0.1.0Oracle Entrise Manager Console DB 10.2.0.1.0 XDK Required Support Files 10.2.0.1.0Agent Required Support

46、 Files 10.2.0.1.0 DBJAVA Required Support Files 10.2.0.1.0 LDAP Required Support Files 10.2.0.1.0piler Required Support Files 10.2.0.1.0 Oracle RAC Required Support Files-HAS 10.2.0.1.0RDBMS Required Support Files for Instant C nt 10.2.0.1.0 RDBMS Required Support Files 10.2.0.1.0SQL*Plus Required S

47、upport Files 10.2.0.1.0SSL Required Support Files for InstantC nt 10.2.0.1.0 Installation Common Files 10.2.0.1.0Oracle Globalization Support 10.2.0.1.0 Oracle Core Required Support Files 10.2.0.1.0 Platform Required Support Files 10.2.0.1.0Oracle Message Gateway Common Files 10.2.0.1.0Entrise Manag

48、er Agent Core 10.2.0.1.0Entrise Manager Common Files 10.2.0.1.0Entrise Manager Reitory Core 10.2.0.1.0Oracle Containers for Java 10.2.0.1.0Entrise Manager Reitory DB 10.2.0.1.0Oracle LDAP administration 10.2.0.1.0Oracle Required Support Files 32 bit 10.2.0.0.0 JDBC Common Files 10.2.0.1.0Database Wo

49、rkspace Manager 10.2.0.1.0OracleerMedia Anno or 10.2.0.1.0Entrise Manager Minimalegration 10.2.0.1.0Parser Generator Required Support Files 10.2.0.1.0 Buildtools Common Files 10.2.0.1.0Oracle UIX 2.1.22.0.0Bali Share 1.1.18.0.0Deinstall in progress (Tuesday, November 2, 2010 5:54:35 PM CST). 0% Done

50、. 14% Done. 28% Done. 42% Done. 56% Done. 70% Done. 85% Done. 100% Done.Deinstall sucsfulInstallation in progress (Tuesday, November 2, 2010 5:54:35 PM CST). 14% Done. 28% Done. 42% Done. 56% Done. 70% Done. 85% Done. 88% Done.Install sucsfulLinking in progress (Tuesday, November 2, 2010 5:56:06 PM

51、CST). 89% Done.Link sucsfulSetup in progress (Tuesday, November 2, 2010 5:56:58 PM CST). 100% Done.Setup sucsfulEnd of install phases.(Tuesday, November 2, 2010 5:57:02 PM CST) Starting to execute configuration assistantsConfiguration assistant Oracle Configuration Manager Configuration succeededWAR

52、NING:The following configuration scripts need to be executed as the root user. #!/bin/sh#Root script to run/home/oracle/oracle10g/root.shTo execute the configuration scripts:Open a terminal windowLog in as rootRun the scriptsThe installation of Oracle Database 10g Release 2 Patch Set 4 wacsful.Pleas

53、e check /home/oracle/zxindbf/oraInventory/logs/silentInstall2010-11-02_05-54-05PM.log for details.more如果看到有“The installation of Oracle Database 10g Release 2 Patch Set4wassucsful.”等信息，表示升级成功，敲回车键，回到命令行模式，升级完成2.2.3 升级后执行root# /home/oracle/oracle10g/root.sh Running Oracle10 root.sh script.The followin

54、g environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /home/oracle/oracle10gEnter the full pathname of the local bin directory: /usr/local/bin: The file dbhome already exists in y. Overwrite it? (y/n)n: yCopying dbhome to y .The file oraenv already exists in y. Overwrite it? (y/n) n:

55、 yCopying oraenv to y .The file coraenv already exists in y. Overwrite it? (y/n) n: yCopying coraenv to y .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

56、actions will be performed.至此，数据库升级完毕；不过，仅仅是数据库实例的升级和安装，还没有创建数据库；所以无法启动、连接数据库。具体的建库操作请参阅业务安装指导手册（ZXV10 IPTV 多解决方案 DB 数据库服务器安装指导）。注意：如果是安装客户端，需要将业务数据库主机的/home/oracle/oracle10g/network/admnsnames.ora 拷贝到本机的同等目录（必须在业务数据库主机执行完 crdb10g.sh 以后才会产生该文件）；并检查修改zxin连接串的目标地址。至此，客户端的安装已经完成，不需要执行 crdb10g.sh 。2.2.4

57、业务 lib 库的创建zxin10$ ln -s /home/oracle/oracle10g/lib/libclntsh.so.10.1 /home/zxin10/lib/libclntsh.so.9.0$ ln -s /home/oracle/oracle10g/lib/libclntsh.so.10.1 /home/zxin10/lib/libclntsh.so注意：如果是64bit的SUSE系统，安装完 Oracle后，需要做如下zxin10。$ ln -s /home/oracle/oracle10g/lib32/libclntsh.so.10.1 /home/zxin10/lib/

58、libclntsh.so.9.0$ ln -s /home/oracle/oracle10g/lib32/libclntsh.so.10.1 /home/zxin10/lib/libclntsh.so3安装 oracle10.2.0.1(标准版)3.1 执行安装oracle$ cd /home/setup/install/oracle/database$ ./runInstaller -silent -responseFile /home/setup/install/oracle/install_10201_se.rsp-ignoresysprereqs以下省略了具体的安装过程3.2 升级到

59、oracle10.2.0.5执行升级oracle$ cd /home/setup/install/oracle/Disk1$ ./runInstaller -silent -ignoresysprereqs-force -responseFile/home/setup/install/oracle/install_10205.rsp以下省略了具体的安装过程至此，数据库升级完毕；不过，仅仅是数据库实例的升级和安装，还没有创建数据库；所以无法启动、连接数据库。具体的建库操作请参阅业务安装指导手册（ZXV10 IPTV 多解决方案 DB 数据库服务器安装指导）。注意：如果是安装客户端，需要将业务数据

60、库主机的/home/oracle/oracle10g/network/admnsnames.ora 拷贝到本机的同等目录（必须在业务数据库主机执行完 crdb10g.sh 以后才会产生该文件）；并检查修改zxin连接串的目标地址。至此，客户端的安装已经完成，不需要执行 crdb10g.sh 。3.3 安装后执行root# /home/oracle/oracle10g/root.sh Running Oracle10 root.sh script.The following environment variables are set as: ORACLE_OWNER= oracle ORACLE