Windows2000服务器下安装Oracle9i与10g

数据库 Oracle
想用Windows2000建设网站,Oracle 9i/10g安装搭建数据库后台的新手,不防进来看一看,想必你会有很多收获。

以下文章是针对想用Windows2000建设网站,Oracle 9i/10g安装搭建数据库后台的新手,高手可绕开。具体安装步骤如下:
操作系统:windows2000 server
软件oracle9i+oracle10G102
步骤:(先装9i再装10g)
1、先安装oracle9i,完成后关闭所有服务。
2、安装oracle10G,安装的路径与9i路径不一致,完成。
3、重启系统(个人行为),修改oracle9i监听程序端口listener.ora(1522)并修改tnsnames.ora、snmp_ro.ora文件中的相关端口。

安装完9i后发现可以登录,但点击时出现“ORACLE不可用”
方法:sqlplus /nolog
     conn sys/sys as sysdba
     startup
     执行以上命令后,就可以登入了

装完10G且修改好9i的监听程序端口后,进入9i同样出现“ORACLE不可用”,用一中的方法不行,执行tnsping orcl9i发现指向的10G的目录

方法一:我的电脑->属性->高级->环境变量->path;修改path值将"oracle9i\...\bin"放到"oracle10g\...\bin"前,重启系统再使用问题一的方法就可以了。

方法二:不修改path值,修改10g下的tnsnames.ora文件,将9i中的配置拷入10的tnsnames.ora,同样修改9i的tnsnames.ora文件。再使用命令启动9i数据库(修改后的tnsnames.ora文件见下面)
     sqlplus /nolog
     connsys/sys@orcl9ias sysdba
     startup

10G的tnsnames.ora
====================================================

ORCL10G =
   (DEscrīptION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = xt-b271dac81b07)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = orcl10g)
     )
   )
ORCL9I =
   (DEscrīptION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = xt-b271dac81b07)(PORT = 1522))
     )
     (CONNECT_DATA =
       (SERVICE_NAME = ORCL9I)
     )
   )
EXTPROC_CONNECTION_DATA =
   (DEscrīptION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
     )
     (CONNECT_DATA =
      (SID = PLSExtProc)
       (PRESENTATION = RO)
     )
   )

====================================================

9i的tnsnames.ora
====================================================

ORCL10G =
   (DEscrīptION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = xt-b271dac81b07)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = orcl10g)
     )
   )
ORCL9I =
   (DEscrīptION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = xt-b271dac81b07)(PORT = 1522))
     )
     (CONNECT_DATA =
       (SERVICE_NAME = ORCL9I)
     )
   )
INST1_HTTP =
   (DEscrīptION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = xt-b271dac81b07)(PORT = 1522))
     )
     (CONNECT_DATA =
       (SERVER = SHARED)
       (SERVICE_NAME = MODOSE)
       (PRESENTATION =http://HRService)
    )
   )
EXTPROC_CONNECTION_DATA =
   (DEscrīptION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
     )
     (CONNECT_DATA =
       (SID = PLSExtProc)
       (PRESENTATION = RO)
     )
   )

如果感兴趣可以留意网站上相关的文章。

【编辑推荐】

  1. Oracle性能诊断不能不知的秘籍
  2. 使用dtu远程连接Oracel 9i数据库的方法
  3. Oracle多表查询优化的代码示例
  4. Oracle更改的默认端口号剖析
  5. Oracle ERP上线准备的5个经验浅谈
责任编辑:佚名
相关推荐

2011-05-13 11:14:18

2009-11-19 10:32:41

Oracle 10g服

2011-03-15 17:05:30

2010-04-19 15:04:28

升级Oracle10g

2011-05-13 11:21:51

linuxoracle 10g安装

2011-03-15 17:17:54

2010-04-28 11:00:55

2010-04-15 13:14:18

linux下Oracl

2010-04-29 17:13:51

Oracle 10g

2010-04-13 14:53:01

Oracle9i和Or

2010-04-01 09:22:31

Oracle9i分析函

2010-02-05 09:06:14

Ubuntu Orac

2011-08-17 16:28:31

Windows SerOracle 10g

2010-05-06 10:52:36

Oracle9i

2009-09-07 09:03:47

VMWare安装Ora

2010-04-14 16:09:51

Oracle 10g归

2010-04-15 14:47:50

Oracle 10g

2010-09-17 09:39:31

Oracle 10g

2010-07-21 10:33:21

2011-08-17 14:41:12

Oracle 10g透SQL Server
点赞
收藏

51CTO技术栈公众号