Install Oracle 10.2.01 on OpenSuSE 10.3

Reading time ~1 minute



A) Download 10201_database_linux32.zip from Oracle website.

B) Download 10gR2_openSUSE102_introduction.pdf and ora.rpm from ftp ftp.novelŀcom

C) 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> ./runInstaller
Starting 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-10
Passed

All 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.htm

    SQL> CREATE TABLESPACE AMP
    2 DATAFILE ‘/opt/oracle/oradata/orcl/AMP.dbf’ SIZE 200M;

    Tablespace created.

    SQL> CREATE USER AMP IDENTIFIED BY ca1234
    2 DEFAULT TABLESPACE AMP
    3 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 dbconsole
    TZ set to PRC
    EM Configuration issue. /opt/oracle/product/10.2/db_1/localhost_orcl not found.

    oracle@Martin:~/product/10.2/db_1/bin> ./emctl start dbconsole
    TZ set to PRC
    OC4J 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_orcl

    oracle@Martin:~/product/10.2/db_1> cp -R Martin.bmc.com_orcl/ localhost_orcl

    oracle@Martin:~/product/10.2/db_1> bin/emctl start dbconsole
    TZ set to PRC
    Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
    Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
    http://Martin.bmc.com:1158/em/console/aboutApplication
    Starting 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) sqlplus

    sqlplus /nolog

    connect sys/manager as sysdba

    startup

    2) rcoracle

    需要修改如下几个文件:/etc/oraInst.loc  /etc/oratab /  /etc/sysconfig/oracle /opt/oracle/product/10.2/db_1/bin/dbstart /usr/sbin/rcoracle 修改这些文件中的路径等信息知道 rcoracle start 命令不出错为止。

互联网规模的超融合平台

什么是互联网规模?什么是web scale风格?看下Nutanix的亮点。 阅读全文

2017DevOps采用和趋势现状-信息图

Published on February 11, 2017