oracle 配置sde,配置多个Oracle实例的sde服务

配置多个Oracle实例的sde服务

一、

创建新的oracle实例sx；

二、

将原来默认安装的ArcGIS\ArcSDE\oracle10gexe文件夹拷贝并重命名为oracle10gexesx，只要设置一下dbinit.sde中的ORACLE_SID使之对应到新创建的数据库实例名sx。

三、配置sde

1、选择Custom

2、去掉Create ArcSDE Service

3、sys user password :sys Net service name

:sx这里为Oracle数据库的服务名

4、创建用户名和用户空间不用修改

5、选择usr custom file 定位到复制出来的那个orcale10gexesx

6、

7、Net service name:sx 为oracle数据库服务

如果通过向导不能成功建立，则通过命令建立

【sdesetup 和sdeservice 为oraclexesx下的命令，需要设置环境变量或者通过dos的

cd 方式转到oraclexesx目录下】。创建ArcSDE和Geodatabase的系统表和存储过程sdesetup -o install -d ORACLE10g

-H " D:\ArcSde\ArcSDE\ora10gexesx " -u sde -p

sde -l

C:\SdeLic.ecp

8、建立sde服务

sdeservice -o create -d oracle10g,SDE -p sde -i

esri_sx -H " D:\ArcSde\ArcSDE\ora10gexesx" -n其中-d 后面SDE为表空间名，-P后面的sde为密码，，-i后为服务名

删除这个服务sdeservice -o delete -i esri_sx

9、windows/system32/drivers/etc/service用txt打开，添加一行(sde的那个服务)，修改掉服务名和端口号。esri_sx

5152/tcp #ArcSDE for Oracle

10、如果在services.msc里面esri_sx服务启动不起来，则要用命令sdemon 命令启动服务

11、如果无法监听，则查看修改E:\oracle\product\10.2.0\db_1

\network\admin\listener.ora

A: listener.ora

# listener.ora Network

Configuration File:

E:\oracle\product\10.2.0\db_1\network\admin\listener.ora

# Generated by Oracle

configuration tools.

SID_LIST_LISTENER

=

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)

(PROGRAM = extproc)

)

)

LISTENER =

(DESCRIPTION_LIST

=

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

(ADDRESS = (PROTOCOL = TCP)(HOST = mtc-b214a9c6a41)(PORT =

1521))

)

)

B: tnsnames.ora

# tnsnames.ora Network

Configuration File:

E:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora

# Generated by Oracle

configuration tools.

SX =

(DESCRIPTION

=

(ADDRESS = (PROTOCOL = TCP)(HOST = mtc-b214a9c6a41)(PORT =

1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = sx)

)

)

ORCL =

(DESCRIPTION

=

(ADDRESS = (PROTOCOL = TCP)(HOST = mtc-b214a9c6a41)(PORT =

1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

EXTPROC_CONNECTION_DATA

=

(DESCRIPTION

=

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)