Install Oracle 10.2.01 on OpenSuSE 10.3

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 命令不出错为止。