分享
 
 
 

Oracle 9.2.0.1 on redhat 8 精装版

王朝oracle·作者佚名  2008-05-18
窄屏简体版  字體: |||超大  

1、 系统

oracle 9.2.0.1 ,red hat 8.0。

历时大概2-3小时。

欢迎访问:www.huangpuzhuang.com

www.huangpuzhuang.com/bbs

2、 取得软件

不管你是偷是抢、还是down,取得Linux9i_Disk1.cpio.gz、Linux9i_Disk2.cpio.gz、Linux9i_Disk3.cpio.gz这三张盘。复制道硬盘,解压缩:

gunzip Linux9i_Disk1.cpio.gz

cpio -idmv < lnx_920_disk1.cpio

对三张盘都做如此操作,则硬盘形成Disk1、Disk2、Disk3三个目录。

还要设置信号量

[root@dbserver install]# cat /proc/sys/kernel/shmmax

33554432

[root@dbserver root]# echo `expr 1024 \* 1024 \* 512` > /proc/sys/kernel/shmmax

[root@dbserver root]# cat /proc/sys/kernel/shmmax

536870912

我的内存是1g

3、 添加用户

先建立相关目录:

mkdir /opt/oracle

mkdir /opt/oracle/product

mkdir /opt/oracle/product/9.2.0.1

groupadd dba

useradd -g dba oracle

passwd oracle

chown -R oracle.dba /opt/oracle

以oracle 设置环境变量:

以oracle登陆xwindowz,设置 Oracle 环境

以 Oracle 用户进入,编辑  $HOME/.bash_profile:

# Oracle Environment

export ORACLE_BASE=/opt/oracle

export ORACLE_HOME=/opt/oracle/product/9.2.0.1

export ORACLE_SID=cihz

PATH= $PATH: $ORACLE_HOME/bin

4、 开始安装

进入Disk1,运行runInstaller,如果说找不到什么libstdc 什么的问题,应该安装

compat-libstdc++-7.3-2.96.110.i386.rpm

[root@dbserver oracle]# rpm -ivh compat-libstdc++-7.3-2.96.110.i386.rpm

warning: compat-libstdc++-7.3-2.96.110.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e

Preparing... ########################################### [100%]

1:compat-libstdc++ ########################################### [100%]

过程中出现:

"Error in invoking target install of makefile /oracle/product/9.2.0/ctx/lib/ins_ctx.mk",

解决办法:

打开文件 $ORACLE_HOME/ctx/lib/env_ctx.mk,把" $(LDLIBFLAG)dl"加到INSO_LINK参数中:

INSO_LINK = -L $(CTXLIB)  $(LDLIBFLAG)m  $(LDLIBFLAG)dl  $(LDLIBFLAG)sc_ca  $(LDLIBFLAG)sc_fa

 $(LDLIBFLAG)sc_ex  $(LDLIBFLAG)sc_da  $(LDLIBFLAG)sc_ut  $(LDLIBFLAG)sc_ch  $(LDLIBFLAG)sc_fi

 $(LLIBCTXHX)  $(LDLIBFLAG)c -Wl,-rpath, $(CTXHOME)lib  $(CORELIBS)  $(COMPEOBJS)

然后回到安装界面按重试retry,就可以继续安装。

5、 手工建库

先写个initcihz.ora ,放到dbs,如果你的sid是cihz的话

启动instance:

SQL> startup nomount

ORACLE instance started.

Total System Global Area 70062220 bytes

Fixed Size 450700 bytes

Variable Size 62914560 bytes

Database Buffers 6553600 bytes

Redo Buffers 143360 bytes

SQL>

SQL> CREATE DATABASE cihz

USER SYS IDENTIFIED BY cihz

USER SYSTEM IDENTIFIED BY cihz

LOGFILE GROUP 1 ('/opt/oracle/oradata/cihz/redo01a.log','/opt/oracle/oradata/cihz/redo01b.log') SIZE 5M,

GROUP 2 ('/opt/oracle/oradata/cihz/redo02a.log','/opt/oracle/oradata/cihz/redo02b.log') SIZE 5M,

GROUP 3 ('/opt/oracle/oradata/cihz/redo03a.log','/opt/oracle/oradata/cihz/redo03b.log') SIZE 5M

MAXLOGFILES 15

MAXLOGHISTORY 10

MAXDATAFILES 1024

MAXINSTANCES 255

CHARACTER SET ZHS16GBK

DATAFILE '/opt/oracle/oradata/cihz/system01.dbf' SIZE 500M

EXTENT MANAGEMENT LOCAL

DEFAULT TEMPORARY TABLESPACE temp

TEMPFILE '/opt/oracle/oradata/cihz/temp01.dbf'

SIZE 500M REUSE

UNDO TABLESPACE undotbs

DATAFILE '/opt/oracle/oradata/cihz/undo01.dbf'

SIZE 500M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;

2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 CREATE DATABASE cihz

*

ERROR at line 1:

ORA-30014: operation only supported in Automatic Undo Management mode

出错了,在init里增加如下:

UNDO_MANAGEMENT=AUTO

UNDO_TABLESPACE=undotbs

SQL> shutdown

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup nomount

ORACLE instance started.

Total System Global Area 70062220 bytes

Fixed Size 450700 bytes

Variable Size 62914560 bytes

Database Buffers 6553600 bytes

Redo Buffers 143360 bytes

SQL> CREATE DATABASE cihz

USER SYS IDENTIFIED BY cihz

USER SYSTEM IDENTIFIED BY cihz

LOGFILE GROUP 1 ('/opt/oracle/oradata/cihz/redo01a.log','/opt/oracle/oradata/cihz/redo01b.log') SIZE 5M,

GROUP 2 ('/opt/oracle/oradata/cihz/redo02a.log','/opt/oracle/oradata/cihz/redo02b.log') SIZE 5M,

GROUP 3 ('/opt/oracle/oradata/cihz/redo03a.log','/opt/oracle/oradata/cihz/redo03b.log') SIZE 5M

MAXLOGFILES 15

MAXLOGHISTORY 10

MAXDATAFILES 1024

MAXINSTANCES 255

CHARACTER SET ZHS16GBK

DATAFILE '/opt/oracle/oradata/cihz/system01.dbf' SIZE 500M

EXTENT MANAGEMENT LOCAL

DEFAULT TEMPORARY TABLESPACE temp

TEMPFILE '/opt/oracle/oradata/cihz/temp01.dbf'

SIZE 500M REUSE

UNDO TABLESPACE undotbs

DATAFILE '/opt/oracle/oradata/cihz/undo01.dbf'

SIZE 500M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;

2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 CREATE DATABASE cihz

*

ERROR at line 1:

ORA-01213: MAXINSTANCES may not exceed 63

SQL>

*

ERROR at line 1:

ORA-01501: CREATE DATABASE failed

ORA-01222: MAXINSTANCES of 63 requires MAXLOGFILES be at least 126, not 15

按照错误提示修改过来就行了。

建立其他表空间:

CREATE TABLESPACE users LOGGING

DATAFILE '/opt/oracle/oradata/cihz/users01.dbf'

SIZE 100M

EXTENT MANAGEMENT LOCAL;

CREATE TABLESPACE tools LOGGING

DATAFILE '/opt/oracle/oradata/cihz/tools01.dbf'

SIZE 100M

EXTENT MANAGEMENT LOCAL;

接下来的数据字典:

@/opt/oracle/product/9.2.0.1/rdbms/admin/catalog.sql

@/opt/oracle/product/9.2.0.1/rdbms/admin/catproc.sql

6、 测试

CREATE TABLESPACE cihz

DATAFILE '/opt/oracle/oradata/cihz/cihz01.dbf'

SIZE 500M ;

create user cihz identified by cihz

default tablespace cihz

TEMPORARY TABLESPACE temp

SQL> conn cihz/cihz

ERROR:

ORA-01045: user CIHZ lacks CREATE SESSION privilege; logon denied

Warning: You are no longer connected to ORACLE.

SQL> conn system/cihz

Connected.

SQL> grant connect ,resource to cihz;

Grant succeeded.

SQL> conn cihz/cihz

Error accessing PRODUCT_USER_PROFILE

Warning: Product user profile information not loaded!

You may need to run PUPBLD.SQL as SYSTEM

Connected.

SQL>

SQL> conn system/cihz

Connected.

SQL> @/opt/oracle/product/9.2.0.1/sqlplus/admin/pupbld.sql

DROP SYNONYM PRODUCT_USER_PROFILE

Synonym created.

SQL> conn cihz/cihz

Connected.

SQL> create table test(

2 a number,

3 b varchar2(20),

4 c blob

5 );

Table created.

SQL> insert into test (a,b)values (2,'asf');

1 row created.

SQL>

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
2023年上半年GDP全球前十五强
 百态   2023-10-24
美众议院议长启动对拜登的弹劾调查
 百态   2023-09-13
上海、济南、武汉等多地出现不明坠落物
 探索   2023-09-06
印度或要将国名改为“巴拉特”
 百态   2023-09-06
男子为女友送行,买票不登机被捕
 百态   2023-08-20
手机地震预警功能怎么开?
 干货   2023-08-06
女子4年卖2套房花700多万做美容:不但没变美脸,面部还出现变形
 百态   2023-08-04
住户一楼被水淹 还冲来8头猪
 百态   2023-07-31
女子体内爬出大量瓜子状活虫
 百态   2023-07-25
地球连续35年收到神秘规律性信号,网友:不要回答!
 探索   2023-07-21
全球镓价格本周大涨27%
 探索   2023-07-09
钱都流向了那些不缺钱的人,苦都留给了能吃苦的人
 探索   2023-07-02
倩女手游刀客魅者强控制(强混乱强眩晕强睡眠)和对应控制抗性的关系
 百态   2020-08-20
美国5月9日最新疫情:美国确诊人数突破131万
 百态   2020-05-09
荷兰政府宣布将集体辞职
 干货   2020-04-30
倩女幽魂手游师徒任务情义春秋猜成语答案逍遥观:鹏程万里
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案神机营:射石饮羽
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案昆仑山:拔刀相助
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案天工阁:鬼斧神工
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案丝路古道:单枪匹马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:与虎谋皮
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:李代桃僵
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:指鹿为马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:小鸟依人
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:千金买邻
 干货   2019-11-12
 
推荐阅读
 
 
 
>>返回首頁<<
 
靜靜地坐在廢墟上,四周的荒凉一望無際,忽然覺得,淒涼也很美
© 2005- 王朝網路 版權所有