深入理解Oracle universal installer(oui) View more presentations from Maclean Liu
|
|||||
|
Oracle Database 11g在OUI下的安装流程图: Oracle Universal Installer是一种基于Java的图形界面应用程序，OUI为Oracle软件的安装、管理提供了统一的接口。在Unix平台上安装Oracle database software时，因为实际操作系统的差异，往往会出现OUI无法正常启动的问题，在这里我列出几种常见的启动问题和解决方案。 1.Itanium Montecito processors引起的JRE问题:在安腾平台上执行runInstaller启动OUI时会出现Java HotSpot错误如下： An unexpected error has been detected by HotSpot Virtual Machine: SIGILL (0×4) at pc=0x2000000000039a4070 pid=11459 tid=2305843009213968960 原因是9iR2,10gR1/R2自带的JRE在Montecito处理器相关的操作系统如Windows/Linux Itanium上存在Bug，该Bug在SUN JDK版本1.4.2_11(b02)中得到修复；如果遇到以上问题，那么可以follow 以下Metalink文档: How To Install Oracle RDBMS Software On Itanium Servers With Montecito Processors [ID 400227.1] How To Identify A Server Which Has Itanium2 (Montecito, Montvale, Tukwila….) Processors . . . → Read More: Unix平台上OUI启动常见问题 尝试把桌面迁移到Fedora 14上，在安装11g r1数据库软件时遭遇了libnnz11.so: could not read symbols: Invalid operation错误，OUI部分日志如下: INFO: gcc -o /u01/app/maclean/product/11.1.0/db_1/sysman/lib/emdctl -L/u01/app/maclean/product/11.1.0/db_1/lib/ -L/u01/app/maclean/product/11.1.0/db_1/sysman/lib/ -L/u01/app/maclean/product/11.1.0/db_1/lib/stubs/ `cat /u01/app/maclean/product/11.1.0/db_1/lib/sysliblist` -Wl,-rpath,/u01/app/maclean/product/11.1.0/db_1/lib -lm `cat /u01/app/maclean/product/11.1.0/db_1/lib/sysliblist` -ldl -lm -L/u01/app/maclean/product/11.1.0/db_1/lib /u01/app/maclean/product/11.1.0/db_1/sysman/lib//s0nmectl.o -lnmectl – INFO: lclntsh -L/u01/app/maclean/product/11.1.0/db_1/lib -L/u01/app/maclean/product/11.1.0/db_1/sysman/lib/ -lnmemso -lcore11 -Wl,-rpath,/u01/app/maclean/product/11.1.0/db_1/lib/:/u01/app/maclean/product/11.1.0/db_1/sysman/lib/:/u01/app/maclean/product/11.1.0/db_1/jdk/jre/lib/i386/client:/u01/app/maclean/product/11.1.0/db_1/jdk/jre/lib/i386 -L/u01/app/maclean/product/11.1.0/db_1/jdk/jre/lib/i386/client -L/u01/app/maclean/product/11.1.0/db_1/jdk/jre/lib/i386 -z lazyload -ljava -ljvm -lverify -z nolazyload -Wl,-rp INFO: ath,/u01/app/maclean/product/11.1.0/db_1/lib/:/u01/app/maclean/product/11.1.0/db_1/sysman/lib/:/u01/app/maclean/product/11.1.0/db_1/jdk/jre/lib/i386/client:/u01/app/maclean/product/11.1.0/db_1/jdk/jre/lib/i386 -Wl,–allow-shlib-undefined `cat /u01/app/maclean/product/11.1.0/db_1/lib/sysliblist` -ldl -lm INFO: /usr/bin/ld: /u01/app/maclean/product/11.1.0/db_1/sysman/lib//libnmectl.a(nmectlt.o): . . . → Read More: 11gr1 installation failed on Fedora 14 with libnnz11.so could not read symbols Siebel Performance Tuning Guide > Tuning Operating Systems for Performance > Tuning Siebel Business Applications for HP-UX > Tuning Kernel Settings for HP-UX — http://download.oracle.com/docs/cd/E14004_01/books/PerformTun/PerformTunOS11.html#wp1243470 Modify the HP-UX kernel parameters to values like those shown below (suggested guidelines). Use the HP-UX System Administration Manager (SAM) tool to make these changes. nproc 4096 – 4096 . . . → Read More: Oracle Recommended Kernel Parameter settings for HP Itanium v3 11.31 Oracle Database Resource Manager Oracle Database Resource Manager allows you to Distribute CPU resources among different classes of users Automatically terminate or prevent ‘runaway’ queries Control the degree of parallelism Limit the undo space used by a class of users Limit the amount of time a session can be idle Consumer Groups Sessions are grouped . . . → Read More: Using Oracle Database Resource Manager 有客户发邮件来表示新建user后，尝试使用该user登录时sqlplus会出现如下警告: Error accessing PRODUCT_USER_PROFILE Warning: Product user profile information not loaded! You may need to run PUPBLD.SQL as SYSTEM PRODUCT_USER_PROFILE是Oracle 10g中一个用来显示记录那些不希望用户可以在sqlplus执行命令的权限表，该表一般会在数据库创建时在system模式下被建立；显然用户的这个数据库可能是以手工创建数据库的方式create出来的，而在最后执行脚本的阶段没有执行建立该表的pupbld.sql脚本，该脚本一般位于$ORACLE_HOME/sqlplus/admin目录下: [maclean@rh2 admin]$ pwd /s01/10gdb/sqlplus/admin [maclean@rh2 admin]$ cat pupbld.sql — – Copyright (c) Oracle Corporation 1988, 2003. All Rights Reserved. — – NAME — pupbld.sql — – DESCRIPTION — Script to install the SQL*Plus PRODUCT_USER_PROFILE . . . → Read More: Error accessing PRODUCT_USER_PROFILE? 这是一张550G的大表，表上还包括了CLOB和BLOB对象；我们来观察下Oracle drop这样一个大表时的具体表现: SQL> select * from v$version; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bi PL/SQL Release 10.2.0.4.0 – Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 – Production NLSRTL Version 10.2.0.4.0 – Production SQL> show parameter recyclebin NAME TYPE VALUE ———————————— ———– —————————— recyclebin string OFF /* 为了避免被flashback table骚扰，关闭了recyclebin回收站功能 */ . . . → Read More: Dropping Very Large Table In Oracle |
|
||||
|
Copyright © 2012 Oracle Clinic – Maclean Liu的个人技术博客 - All Rights Reserved |
|||||
最新评论