A) Download 10201_database_linux32.zip from Oracle website.B) Download 10gR2_openSUSE102_introduction.pdf and ora.rpm from ftp ftp.novelŀcomC) Install Oracle, following quick steps:1. Install openSUSE 10.2 with “C/C++ Development” selection.2. Download and Install orarun package.3. Enable and set password for newly created user oracle by orarun.4. Set updated kernel parameters by executing /etc/init.d/oracle start.5. Download and unzip Oracle 10gR2 Database SW.Edit file database/install/oraparam.ini to add “SuSE-10” to line #39.6. login as user oracle and run Oracle Universal Installer “database/runInstaller”.Troubleshooting:1) installer error:———————————————————————————————oracle@Martin:~/database> ./runInstallerStarting Oracle Universal Installer…Checking installer requirements…Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1, asianux-2 or SuSE-10PassedAll installer requirements met.Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-05-08_09-11-56AM. Please wait …oracle@Martin:~/database> java: xcb_xlib.c:52: xcb_xlib_unlock: Assertion `c->xlib.lock’ failed.———————————————————————————————Solution :
- export LIBXCB_ALLOW_SLOPPY_LOCK=1
- run runInstaller again 2) 在安装完成末期,需要root用户运行两个脚本,完了之后,我遇到一个错误对话框,点击过去之后好像没有发现安装失败,安装目前正常More SQL scripts:http://cs-netlab-01.lynchburg.edu/courses/Oracle/SQLPlus.htmSQL> CREATE TABLESPACE AMP2 DATAFILE ‘/opt/oracle/oradata/orcl/AMP.dbf’ SIZE 200M;Tablespace created.SQL> CREATE USER AMP IDENTIFIED BY ca12342 DEFAULT TABLESPACE AMP3 QUOTA UNLIMITED ON AMP;User created.SQL> GRANT CONNECT, RESOURCE TO AMP;Grant succeeded.SQL> GRANT CREATE SESSION, CREATE TABLE TO AMP;Grant succeeded.How to start oracle em manully?可能出现的错误如下,没有ORACLE_SID的 环境变量, 可能网络地址和环境发生变化,比如主机名修改等.oracle@Martin:~/product/10.2/db_1/bin> ./emctl start dbconsoleTZ set to PRCEM Configuration issue. /opt/oracle/product/10.2/db_1/localhost_orcl not found.oracle@Martin:~/product/10.2/db_1/bin> ./emctl start dbconsoleTZ set to PRCOC4J Configuration issue. /opt/oracle/product/10.2/db_1/oc4j/j2ee/OC4J_DBConsole_localhost_orcl not found.修正方式:oracle@Martin:~/product/10.2/db_1/oc4j/j2ee> cp -R OC4J_DBConsole_Martin.bmc.com_orcl OC4J_DBConsole_localhost_orcloracle@Martin:~/product/10.2/db_1> cp -R Martin.bmc.com_orcl/ localhost_orcloracle@Martin:~/product/10.2/db_1> bin/emctl start dbconsoleTZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://Martin.bmc.com:1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 10g Database Control ………………………. started.——————————————————————Logs are generated in directory /opt/oracle/product/10.2/db_1/localhost_orcl/sysman/log启动了后访问: http://localhost:1158/em/手工启动Oracle实例的方法1) sqlplussqlplus /nologconnect sys/manager as sysdbastartup2) rcoracle需要修改如下几个文件:/etc/oraInst.loc /etc/oratab / /etc/sysconfig/oracle /opt/oracle/product/10.2/db_1/bin/dbstart /usr/sbin/rcoracle 修改这些文件中的路径等信息知道 rcoracle start 命令不出错为止。