关闭

Windows2000下手工安装数据库

标签: windowsoraclesystemconstraintscharacter数据库
782人阅读 评论(0) 收藏 举报
分类:

        发现了一个问题,在windows 2000上安装Oracle8170的时候,setup.exe执行后没有反应,最后只好用ora9201的OUI来安装Oracle8170,真是祸不单行,安装到98%的时候hung住,图形界面上是显示正在copy make.dat0,检查了一下,发现ORACLE_HOME下sqlplus.exe,oci.dll等重要文件已经存在了,但是开始菜单里面还没出现安装数据库的选项,再察看了一下安装日志,发现有下列错误:

java.lang.LinkageError: loader constraints violated when linking ssclusterRegisterw32 class
 at ssCreateItemw32.installAction(ssCreateItemw32.java:215)
 at oracle.sysman.oii.oiis.OiisCompActions.doActionWithException(OiisCompActions.java:1357)
 at oracle.sysman.oii.oiis.OiisCompActions.doActionImpl(OiisCompActions.java:1157)
 at oracle.sysman.oii.oiis.OiisCompActions.doAction(OiisCompActions.java:604)
 at CompActions.doActionP3ntCreateItem2(CompActions.java:212)
 at CompActions.stateChangePhase2Actions(CompActions.java:180)
 at oracle.sysman.oii.oiic.OiicInstallActionsPhase$OiilActionThr.run(OiicInstallActionsPhase.java:619)
 at oracle.sysman.oii.oiic.OiicInstallActionsPhase.executeProductPhases(OiicInstallActionsPhase.java:2199)
 at oracle.sysman.oii.oiic.OiicInstallActionsPhase.doInstalls(OiicInstallActionsPhase.java:2077)
 at oracle.sysman.oii.oiic.OiicInstallActionsPhase$OiInstRun.run(OiicInstallActionsPhase.java:2945)
 at java.lang.Thread.run(Unknown Source)

google了一下,解释说是jre的版本问题,没办法,只好手工安装了,现把整个过程纪录如下:

环境:windows2000 pro, Oracle8170, SID=satest, Oracle_HOME=e:/oracle/ora81

1.create the folders need by init.ora,don't forget subfolder
2.copy a init.ora ,modify the content to match your environment.

3.create file pwd<SID>.ora

>orapwd file=e:/oracle/ora81/database/PWDsatest.ora password=oracle entries=5

>oradim -new -sid satest -startmode manual -pfile "e:/Oracle/ora81/database/initsatest.ora"

4.update sqlnet.ora in order to you can login with internal account

sqlnet.ora: SQLNET.AUTHENTICATION_SERVICES=(NTS)
create a group named ora_dba in OS, add the current user to this group as a member.

5.create database,include controlfile, system TBS,RBS TBS,TEMP TBS.
>set ORACLE_SID=satest


>svrmgrl
connect INTERNAL/oracle
startup nomount pfile="e:/Oracle/ora81/database/initsatest.ora"
CREATE DATABASE satest
LOGFILE 'e:/Oracle/oradata/satest/redo01.log' SIZE 2048K,
'e:/Oracle/oradata/satest/redo02.log' SIZE 2048K,
'e:/Oracle/oradata/satest/redo03.log' SIZE 2048K
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE 'e:/Oracle/oradata/satest/system01.dbf'
SIZE 58M REUSE AUTOEXTEND ON NEXT 640K
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET zht16big5
NATIONAL CHARACTER SET utf8;

ALTER TABLESPACE SYSTEM DEFAULT STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 50);

ALTER TABLESPACE SYSTEM MINIMUM EXTENT 64K;
CREATE TABLESPACE RBS DATAFILE 'e:/Oracle/oradata/satest/rbs01.dbf' SIZE 256M REUSE
AUTOEXTEND ON NEXT 5120K
MINIMUM EXTENT 512K
DEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 4096);

CREATE TABLESPACE sadata DATAFILE 'e:/Oracle/oradata/satest/sadata01.dbf' SIZE 128M REUSE
AUTOEXTEND ON NEXT 1280K
MINIMUM EXTENT 128K
DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0);

CREATE TABLESPACE TOOLS DATAFILE 'e:/Oracle/oradata/satest/tools01.dbf' SIZE 64M REUSE
AUTOEXTEND ON NEXT 320K
MINIMUM EXTENT 32K
DEFAULT STORAGE ( INITIAL 32K NEXT 32K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0);

CREATE TABLESPACE TEMP DATAFILE 'e:/Oracle/oradata/satest/temp01.dbf' SIZE 32M REUSE
AUTOEXTEND ON NEXT 640K
MINIMUM EXTENT 64K
DEFAULT STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS
UNLIMITED PCTINCREASE 0) TEMPORARY;

alter user sys temporary tablespace TEMP;

CREATE PUBLIC ROLLBACK SEGMENT RBS0 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS1 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS2 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS3 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS4 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS5 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS6 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS7 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS8 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS9 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS10 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS11 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS12 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS13 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS14 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS15 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS16 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS17 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS18 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS19 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS20 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS21 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS22 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS23 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS24 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );

 

@e:/Oracle/Ora81/Rdbms/admin/catalog.sql;
@e:/Oracle/Ora81/Rdbms/admin/catexp7.sql
@e:/Oracle/Ora81/Rdbms/admin/catproc.sql
@e:/Oracle/Ora81/Rdbms/admin/caths.sql

connect system/manager
@D:/Oracle/Ora81/sqlplus/admin/pupbld.sql

connect internal/oracle
@e:/Oracle/Ora81/Rdbms/admin/catrep.sql
exit

7.create sql online help.
>sqlplus system/manager @e:/Oracle/Ora81/sqlplus/admin/help/helpbld.sql helpus.sql

8.adjust user system's default TBS and temporary tablespace.
>sqlplus /nolog
conn / as sysdba
alter user system default tablespace tools quota unlimited on tools;
alter user system temporary tablespace TEMP;

9.set start mode of service satest to auto.
oradim -edit -sid satest -startmode auto 

10.update %PATH%,add e:/oracle/ora81/bin in the ahead .

11.copy a listener.ora ,modfity it to match your environment.

>"lsnrctl start" command to start listener,then open services panel set the  "OracleOraHome81TNSListener" startmode to auto.

如果上面步骤都没问题的话,数据库就算建立好了,其中第5步的脚本可以使用Oracle建立数据库的工具产生。

注意的地方:

1.用这个脚本建立的数据库中包含了dbsnmp,outln,sys,system这四个用户,所有的密码都是缺省的。

2.所有的TBS都是dictionary的管理,autoextend是打开的,redo只有2M,不适合用在大型的生产方面,如果需要的话就需要修改这方面的参数。 

3.如果安装文件已经损坏,不能使用,可以使用拷贝的办法,从其他机器上copy一份安装好的oracle文件过来,包括$ORACLE_HOME下面的所有东西,然后把注册表部分导出,按要求修改后导入到新机器上即可。

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:268902次
    • 积分:3846
    • 等级:
    • 排名:第8276名
    • 原创:113篇
    • 转载:16篇
    • 译文:0篇
    • 评论:34条
    最新评论