ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Windows2000下手工安装数据库

Windows2000下手工安装数据库

原创 Linux操作系统 作者:xin2v 时间:2009-03-19 14:07:51 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.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下面的所有东西,然后把注册表部分导出,按要求修改后导入到新机器上即可。

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/10325341/viewspace-573078/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2009-03-19

  • 博文量
    45
  • 访问量
    73626