Install Oracle 10g on SuSE 10
这次的经历是自己找来的，在安装了10g的那台机上升级下内存也便能忽悠那群友，不过想想还是折腾下吧，给移到配置好点的Server上面，他们用起来顺心，我自己也能折腾点经验。
132的系统是SuSE10.2的，之前已经安装了Oracle 9i，这就意味着必须先卸载掉9i，本以为安装10g的runInstaller能够卸载掉9i，可尝试了好久都是出现exception：
An unexpected exception has been detected in native code outside the VM.
Unexpected Signal : 11 occurred at PC=0xB7F22591
Function=(null)
Library=/lib/ld-linux.so.2
NOTE: We are unable to locate the function name symbol for the error
just occurred. Please refer to release documentation for possible
reason and solutions.
Current Java thread:
at java.lang.ClassLoader$NativeLibrary.find(Native Method)
at java.lang.ClassLoader.findNative(Unknown Source)
- locked <0xa6fe1b20> (a java.util.Vector)
at ssOiGenClassux22.deleteLink(Native Method)
at sscreateLinkux.deinstallAction(sscreateLinkux.java:127)
at oracle.sysman.oii.oiif.oiifw.OiifwDeinstallPhaseWCCE.doComponentDeinstalls(OiifwDeinstallPhaseWCCE.java:2046)
at oracle.sysman.oii.oiif.oiifw.OiifwDeinstallPhaseWCCE.doOperation(OiifwDeinstallPhaseWCCE.java:405)
at oracle.sysman.oii.oiif.oiifb.OiifbCondIterator.iterate(OiifbCondIterator.java:171)
at oracle.sysman.oii.oiif.oiifw.OiifwActionsPhaseWCDE.doOperation(OiifwActionsPhaseWCDE.java:606)
at oracle.sysman.oii.oiic.OiicDeinstallSession$OiicActionsThread.run(OiicDeinstallSession.java:2431)
Dynamic libraries:
08048000-08056000 r-xp 00000000 08:03 11228596 /tmp/OraInstall2010-03-01_05-17-06PM/jre/1.4.2/bin/java
......
Heap at VM Abort:
Heap
def new generation total 768K, used 567K [0xa6450000, 0xa6520000, 0xa6fd0000)
eden space 704K, 71% used [0xa6450000, 0xa64cde70, 0xa6500000)
from space 64K, 99% used [0xa6510000, 0xa651fff8, 0xa6520000)
to
相关文档：
首先去http://metalink.oracle.com 下载相关的补丁包,因为是64位for windows的包是p6810189_10204_MSWIN-x86-64.zip,下载地址:
ftp://updates.oracle.com/6810189/p6810189_10204_MSWIN-x86-64.zip
操作如下.
(1) Oracle推荐在升级之前先做一个全库的备份；
(2) 停止所有的Oracle服务
emctl stop dbconsole
isqlplusc ......
过程中的事务
定义过程p1
create or replace procedure p1
as
begin
insert into student values(5,'xdh','m',sysdate);
rollback;
end;
定义过程p2
create or replace procedure p2
as
begin
update student set stu_sex = 'a' where stu_id = 3;
p1;
end;
执行过程p2
exec p2;
执行完毕发现 ......
数据库触发器
触发器语句
制定触发器定时、事件、表名及类型
触发器主体
是pl/sql快或对过程的调用
触发器限制
可以通过when子句实现
DML(insert update delete)
DDL(create alter drop)
数据库操作(servererror logo ......
Oracle管理员的两种认证方法
注意：重要
parameter 中remote_login_passwordfile
1、alter system set remote_login_passwordfile= none scope =spfile；
含义：非密码认证（此时仅os认证 ）
2、alter system set remote_login_passwordfile= exclusive ......
需要大量oracle测试数据时，可以使用以下方法。
DECLARE
i INT;
BEGIN
i := 0;
WHILE(i < 100000)
LOOP
i := i + 1;
INSERT INTO TEST_TABLE(ID, XM) VALUES(i, '姓名' || i);
END LOOP;
COMMIT;
END; ......
