Chinaunix首页 | 论坛 | 博客
  • 博客访问: 287396
  • 博文数量: 60
  • 博客积分: 1437
  • 博客等级: 中尉
  • 技术积分: 632
  • 用 户 组: 普通用户
  • 注册时间: 2011-02-10 14:12
文章存档

2012年(7)

2011年(53)

分类: Oracle

2011-02-13 14:56:09

silent模式下升级数据库到10.2.0.5的版本会遇到如下错误:
[oracle@nicoa Disk1]$ ./runInstaller -silent  -responseFile=/orasoft/Disk1/response/patchset.rsp  ORACLE_HOME=$ORACLE_HOME  ORACLE_HOME_NAME=OraDb10g_home1
Starting Oracle Universal Installer...
 
Checking installer requirements...
 
Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, redhat-6, UnitedLinux-1.0, asianux-1, asianux-2, asianux-3, enterprise-4, enterprise-5 or SuSE-11
                                      Passed
 
 
All installer requirements met.
 
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-02-13_02-27-57PM. Please wait ...[oracle@nicoa Disk1]$ Oracle Universal Installer, Version 10.2.0.5.0 Production
Copyright (C) 1999, 2010, Oracle. All rights reserved.
 
You can find a log of this install session at:
 /u01/app/oracle/oraInventory/logs/installActions2011-02-13_02-27-57PM.log
.................................................................................................... 100% Done.
 
 
Loading Product Information
.................................................................................................................. 100% Done.
 
SEVERE:Values for the following variables could not be obtained from the command line or response file(s):
  MYORACLESUPPORT_USERNAME(MyOracleSupportUsername)
Silent install cannot continue.

[oracle@nicoa Disk1]$

这时候可以修改patchset.rsp  文件中的MYORACLESUPPORT_USERNAME
#------------------------------------------------------------------------------
# Name       : MYORACLESUPPORT_USERNAME
# Datatype   : String
# Description: My Oracle Support username .
#
#  Example   : MYORACLESUPPORT_USERNAME="username"
#------------------------------------------------------------------------------
MYORACLESUPPORT_USERNAME=nico.wang@oracle.com
 
#------------------------------------------------------------------------------
# Name       : MYORACLESUPPORT_PASSWORD
# Datatype   : String
# Description: Stores the My Oracle Support password.
#
# Example    : MYORACLESUPPORT_PASSWORD="password"
#------------------------------------------------------------------------------
MYORACLESUPPORT_PASSWORD=******

然后继续,这个我之前升级过一次,但是今天怎么都不行,我就直接在命令行里加入这个参数,然后就可以了:
[oracle@nicoa Disk1]$ ./runInstaller -silent  -responseFile=/orasoft/Disk1/response/patchset.rsp  ORACLE_HOME=$ORACLE_HOME  ORACLE_HOME_NAME=OraDb10g_home1 MYORACLESUPPORT_USERNAME=nico.wang@oracle.com
Starting Oracle Universal Installer...
 
Checking installer requirements...
 
Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, redhat-6, UnitedLinux-1.0, asianux-1, asianux-2, asianux-3, enterprise-4, enterprise-5 or SuSE-11
                                      Passed
 
 
All installer requirements met.
 
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-02-13_02-55-01PM. Please wait ...[oracle@nicoa Disk1]$ Oracle Universal Installer, Version 10.2.0.5.0 Production
Copyright (C) 1999, 2010, Oracle. All rights reserved.
 
You can find a log of this install session at:
 /u01/app/oracle/oraInventory/logs/installActions2011-02-13_02-55-01PM.log
.................................................................................................... 100% Done.
 
 
Loading Product Information
.................................................................................................................. 100% Done.
 
Metalink Password not provided so not validating the credentials
 
Starting execution of Prerequisites...
Total No of checks: 8
 
Performing check for CertifiedVersions
Checking operating system requirements ...
Expected result: One of redhat-6,redhat-5,redhat-4,redhat-3,SuSE-11,SuSE-10,SuSE-9,asianux-3,asianux-2,asianux-1
Actual Result: redhat-5
Check complete. The overall result of this check is: Passed
 
 
Check complete: Passed
=======================================================================
Performing check for Packages
Checking operating system package requirements ...
Checking for make-3.81; found make-1:3.81-3.el5.        Passed
Checking for binutils-2.17.50.0.6; found binutils-2.17.50.0.6-14.el5.   Passed
Checking for gcc-4.1.1; found gcc-4.1.2-48.el5. Passed
Checking for libaio-0.3.106; found libaio-0.3.106-5.    Passed
Checking for libstdc++-4.1.1; found libstdc++-4.1.2-48.el5.     Passed
Check complete. The overall result of this check is: Passed
 
 
Check complete: Passed
=======================================================================
Performing check for Kernel
Checking kernel parameters
Checking for semmsl=250; found semmsl=250.      Passed
Checking for semmns=32000; found semmns=32000.  Passed
Checking for semopm=100; found semopm=100.      Passed
Checking for semmni=128; found semmni=128.      Passed
Checking for shmmax=1073741824; found shmmax=4398046511104.     Passed
Checking for shmmni=4096; found shmmni=4096.    Passed
Checking for shmall=2097152; found shmall=1073741824.   Passed
Checking for file-max=101365; found file-max=65536.     Failed <<<<
Checking for VERSION=2.6.18; found VERSION=2.6.18-194.el5.      Passed
Checking for ip_local_port_range=9000 - 65500; found ip_local_port_range=1024 - 65000.  Failed <<<<
Checking for rmem_default=1048576; found rmem_default=262144.   Failed <<<<
Checking for rmem_max=1048576; found rmem_max=262144.   Failed <<<<
Checking for wmem_default=262144; found wmem_default=262144.    Passed
Checking for wmem_max=262144; found wmem_max=262144.    Passed
Check complete. The overall result of this check is: Failed <<<<
 
 
Check complete: Failed <<<<
Problem: The kernel parameters do not meet the minimum requirements (see above).
Recommendation: Perform operating system specific instructions to update the kernel parameters.
 
=======================================================================
Performing check for GLIBC
Checking Recommended glibc version
Expected result: ATLEAST=2.5-12 NOT_EQUALS=2.5-18
Actual Result: 2.5-49
Check complete. The overall result of this check is: Passed
 
 
Check complete: Passed
=======================================================================
Performing check for TotalMemory
Checking physical memory requirements ...
Expected result: 922MB
Actual Result: 1000MB
Check complete. The overall result of this check is: Passed
 
 
Check complete: Passed
=======================================================================
Performing check for SwapSpace
Checking available swap space requirements ...
Expected result: 1500MB
Actual Result: 2015MB
Check complete. The overall result of this check is: Passed
 
 
Check complete: Passed
=======================================================================
Performing check for checkToInstallCCR
Checking the Components installed in Oracle Home
Check complete. The overall result of this check is: Passed
 
 
Check complete: Passed
=======================================================================
Performing check for CompatibilityChecks
Checking for Oracle Home incompatibilities ...
Check complete. The overall result of this check is: Passed
 
 
Check complete: Passed
=======================================================================
PrereqChecks complete
 
 
Analyzing dependencies
...................................................................................................... 100% Done.
 
 
-----------------------------------------------------------------------------
Summary
Global Settings
    Source: /orasoft/Disk1/stage/products.xml
    Oracle Home: /u01/app/oracle/product/10.2.0/db_1 (OraDb10g_home1)
Product Languages
   English
Space Requirements
   / Required 1.49GB (includes 54MB temporary) : Available 8.58GB
New Installations (86 products)
   Oracle Notification Service Patch 10.2.0.5.0
   Database Configuration and Upgrade Assistants Patch 10.2.0.5.0
   Character Set Migration Utility Patch 10.2.0.5.0
   Oracle Database 10g Patch 10.2.0.5.0
   Oracle JDBC/OCI Instant Client Patch 10.2.0.5.0
   Oracle Database 10g Patch 10.2.0.5.0
   Enterprise Manager plugin Common Files Patch 10.2.0.5.0
   SQL*Plus 10.2.0.5.0
   HAS Common Files Patch 10.2.0.5.0
   HAS Files for DB Patch 10.2.0.5.0
   Oracle Java Client Patch 10.2.0.5.0
   Oracle JVM Patch 10.2.0.5.0
   Oracle Internet Directory Client Patch 10.2.0.5.0
   iSQL*Plus 10.2.0.5.0
   Oracle Advanced Security Patch 10.2.0.5.0
   Oracle Net Patch 10.2.0.5.0
   Oracle Net Listener Patch 10.2.0.5.0
   Oracle Wallet Manager Patch 10.2.0.5.0
   Precompiler Common Files Patch 10.2.0.5.0
   Secure Socket Layer Patch 10.2.0.5.0
   Oracle ODBC Driver Patch 10.2.0.5.0
   Oracle OLAP Patch 10.2.0.5.0
   Oracle OLAP API Patch 10.2.0.5.0
   OLAP SQL Scripts Patch 10.2.0.5.0
   Oracle interMedia Client Option Patch 10.2.0.5.0
   Oracle Database 10g interMedia Files Patch 10.2.0.5.0
   Oracle interMedia Patch 10.2.0.5.0
   PL/SQL Embedded Gateway Patch 10.2.0.5.0
   Oracle XML Development Kit Patch 10.2.0.5.0
   Oracle Text Patch 10.2.0.5.0
   Oracle Clusterware RDBMS Files Patch 10.2.0.5.0
   Database SQL Scripts Patch 10.2.0.5.0
   Oracle 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.0
   Oracle Starter Database Patch 10.2.0.5.0
   Sample Schema Data Patch 10.2.0.5.0
   Oracle interMedia Locator RDBMS Files Patch 10.2.0.5.0
   Oracle Call Interface (OCI) Patch 10.2.0.5.0
   Oracle OLAP RDBMS Files Patch 10.2.0.5.0
   PL/SQL 10.2.0.5.0
   Oracle Recovery Manager Patch 10.2.0.5.0
   Oracle Database Utilities Patch 10.2.0.5.0
   Oracle interMedia Locator Patch 10.2.0.5.0
   XML Parser for Java Patch 10.2.0.5.0
   Assistant Common Files Patch 10.2.0.5.0
   Oracle 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
   Oracle interMedia Java Advanced Imaging Patch 10.2.0.5.0
   SQLJ Runtime Patch 10.2.0.5.0
   XML Parser for Oracle JVM Patch 10.2.0.5.0
   Enterprise Manager Agent DB 10.2.0.5.0
   Enterprise Manager Baseline 10.2.0.5.0
   Oracle Enterprise 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.0
   Precompiler Required Support Files Patch 10.2.0.5.0
   Oracle RAC Required Support Files-HAS Patch 10.2.0.5.0
   RDBMS Required Support Files for Instant Client Patch 10.2.0.5.0
   RDBMS Required Support Files Patch 10.2.0.5.0
   SQL*Plus Required Support Files Patch 10.2.0.5.0
   SSL Required Support Files for InstantClient Patch 10.2.0.5.0
   Installation Common Files Patch 10.2.0.5.0
   Oracle 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.0
   Oracle Message Gateway Common Files Patch 10.2.0.5.0
   Enterprise Manager Agent Core Patch 10.2.0.5.0a
   Enterprise Manager Common Core Patch 10.2.0.5.0a
   Enterprise Manager Repository Core patch 10.2.0.5.0a
   Oracle Containers for Java 10.2.0.5.0
   Enterprise Manager Repository DB 10.2.0.5.0
   Oracle LDAP administration patch 10.2.0.5.0
   Oracle Required Support Files 32 bit Patch 10.2.0.5.0
   JDBC Common Files 10.2.0.5.0
   Database Workspace Manager 10.2.0.5.0
   Oracle interMedia Annotator 10.2.0.5.0
   Enterprise Manager Minimal Integration 10.2.0.5.0
   Parser Generator Required Support Files 10.2.0.5.0
   Buildtools Common Files 10.2.0.5.0
   Oracle UIX 2.2.24.6.0
   Bali Share 1.1.19.0.0
   Oracle Real Application Testing 10.2.0.5.0
   Oracle Configuration Manager 10.3.2.1.0
Upgrades (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.05
Already Installed (84 products)
   Oracle Notification Service 10.1.0.3.0
   Database Configuration and Upgrade Assistants 10.2.0.1.0
   Character Set Migration Utility 10.2.0.1.0
   Oracle Database 10g 10.2.0.1.0
   Oracle JDBC/OCI Instant Client 10.2.0.1.0
   Oracle Database 10g 10.2.0.1.0
   Enterprise Manager plugin Common Files 10.2.0.1.0
   SQL*Plus 10.2.0.1.0
   HAS Common Files 10.2.0.1.0
   HAS Files for DB 10.2.0.1.0
   Oracle Java Client 10.2.0.1.0
   Oracle JVM 10.2.0.1.0
   Oracle Internet Directory Client 10.2.0.1.0
   iSQL*Plus 10.2.0.1.0
   Oracle Advanced Security 10.2.0.1.0
   Oracle Net 10.2.0.1.0
   Oracle Net Listener 10.2.0.1.0
   Oracle Wallet Manager 10.2.0.1.0
   Precompiler 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 10.2.0.1.0
   Oracle OLAP API 10.2.0.1.0
   OLAP SQL Scripts 10.2.0.1.0
   Oracle interMedia Client Option 10.2.0.1.0
   Oracle Database 10g interMedia Files 10.2.0.1.0
   Oracle interMedia 10.2.0.1.0
   PL/SQL Embedded Gateway 10.2.0.1.0
   Oracle XML Development Kit 10.2.0.1.0
   Oracle Text 10.2.0.1.0
   Oracle Clusterware RDBMS Files 10.2.0.1.0
   Database SQL Scripts 10.2.0.1.0
   Oracle 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.0
   Oracle Starter Database 10.2.0.1.0
   Sample Schema Data 10.2.0.1.0
   Oracle interMedia Locator RDBMS Files 10.2.0.1.0
   Oracle Call Interface (OCI) 10.2.0.1.0
   Oracle OLAP RDBMS Files 10.2.0.1.0
   PL/SQL 10.2.0.1.0
   Oracle Recovery Manager 10.2.0.1.0
   Oracle Database Utilities 10.2.0.1.0
   Oracle interMedia Locator 10.2.0.1.0
   XML Parser for Java 10.2.0.1.0
   Assistant Common Files 10.2.0.1.0
   Oracle JDBC Thin Driver for JDK 1.2 10.2.0.1.0
   Oracle JDBC Thin Driver for JDK 1.4 10.2.0.1.0
   Oracle interMedia Java Advanced Imaging 10.2.0.1.0
   SQLJ Runtime 10.2.0.1.0
   XML Parser for Oracle JVM 10.2.0.1.0
   Enterprise Manager Agent DB 10.2.0.1.0
   Enterprise Manager Baseline 10.2.0.1.0
   Oracle Enterprise Manager Console DB 10.2.0.1.0
   XDK Required Support Files 10.2.0.1.0
   Agent Required Support Files 10.2.0.1.0
   DBJAVA Required Support Files 10.2.0.1.0
   LDAP Required Support Files 10.2.0.1.0
   Precompiler Required Support Files 10.2.0.1.0
   Oracle RAC Required Support Files-HAS 10.2.0.1.0
   RDBMS Required Support Files for Instant Client 10.2.0.1.0
   RDBMS Required Support Files 10.2.0.1.0
   SQL*Plus Required Support Files 10.2.0.1.0
   SSL Required Support Files for InstantClient 10.2.0.1.0
   Installation Common Files 10.2.0.1.0
   Oracle 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.0
   Oracle Message Gateway Common Files 10.2.0.1.0
   Enterprise Manager Agent Core 10.2.0.1.0
   Enterprise Manager Common Files 10.2.0.1.0
   Enterprise Manager Repository Core 10.2.0.1.0
   Oracle Containers for Java 10.2.0.1.0
   Enterprise Manager Repository DB 10.2.0.1.0
   Oracle LDAP administration 10.2.0.1.0
   Oracle Required Support Files 32 bit 10.2.0.0.0
   JDBC Common Files 10.2.0.1.0
   Database Workspace Manager 10.2.0.1.0
   Oracle interMedia Annotator 10.2.0.1.0
   Enterprise Manager Minimal Integration 10.2.0.1.0
   Parser Generator Required Support Files 10.2.0.1.0
   Buildtools Common Files 10.2.0.1.0
   Oracle UIX 2.1.22.0.0
   Bali Share 1.1.18.0.0
-----------------------------------------------------------------------------
 
 
Deinstall in progress (Sunday, February 13, 2011 2:55:18 PM CST)
...............................................................   0% Done.
...............................................................  14% Done.
...............................................................  28% Done.
...............................................................  42% Done.
...............................................................  56% Done.
...............................................................  70% Done.
...............................................................  85% Done.
...                                                             100% Done.
 
Deinstall successful
 
Installation in progress (Sunday, February 13, 2011 2:55:19 PM CST)
...............................................................  14% Done.
...............................................................  28% Done.
...............................................................  42% Done.
...............................................................  56% Done.
...............................................................  70% Done.
...............................................................  85% Done.
.............                                                    88% Done.
Install successful
 
Linking in progress (Sunday, February 13, 2011 2:56:56 PM CST)
...                                                              88% Done.
Link successful
 
Setup in progress (Sunday, February 13, 2011 2:58:00 PM CST)
...........                                                     100% Done.
Setup successful
 
End of install phases.(Sunday, February 13, 2011 2:58:06 PM CST)
Starting to execute configuration assistants
Configuration assistant "Oracle Configuration Manager Configuration" succeeded
WARNING:
The following configuration scripts need to be executed as the "root" user.
#!/bin/sh
#Root script to run
/u01/app/oracle/product/10.2.0/db_1/root.sh
To execute the configuration scripts:
    1. Open a terminal window
    2. Log in as "root"
    3. Run the scripts
 
The installation of Oracle Database 10g Release 2 Patch Set 4 was successful.
Please check '/u01/app/oracle/oraInventory/logs/silentInstall2011-02-13_02-55-01PM.log' for more details.
 
[oracle@nicoa Disk1]$
提示要运行root.sh脚本:
[root@nicoa response]# /u01/app/oracle/product/10.2.0/db_1/root.sh
Running Oracle 10g 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]:
The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying coraenv to /usr/local/bin ...
 
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.
[root@nicoa response]#
这样就升级好了:
[oracle@nicoa Disk1]$ sqlplus /nolog
 
SQL*Plus: Release 10.2.0.5.0 - Production on Sun Feb 13 15:02:01 2011
 
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.
 
SQL>

阅读(3981) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~