sql2k,将在后面创建数据库联接时用到。

sql2k =

(DESCRIPTION=

     (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))

     (CONNECT_DATA=(SID=hssql2k))

     (HS=OK)

 )

重新启动侦听,并且察看服务状态

LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-JUL-2003 12:49:

30

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SAM)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Produ

tion

Start Date                02-JUL-2003 11:08:31

Uptime                    0 days 1 hr. 41 min. 2 sec

Trace Level               off

Security                  OFF

SNMP                      OFF

Listener Parameter File   d:\oracle\ora81\network\admin\listener.ora

Listener Log File         d:\oracle\ora81\network\log\listener.log

Services Summary...

  ORCL          has 1 service handler(s)

  ORCL          has 3 service handler(s)

  PLSExtProc            has 1 service handler(s)

  hssql2k               has 1 service handler(s)

The command completed successfully

LSNRCTL>

Hssql2k的侦听服务已经正常运行了。

第四步 修改数据库启动参数文件

修改数据库启动参数文件，设置global_names=false,如果设置为true(缺省),那么数据库连接名和全局数据库名一样，这将会导致ORA-02085的错误。

第五步 创建访问non-oracle数据库的连接(Database Link)

   在sqlplus中,执行create database link命令。Connect to 指定了连接到SQL SERVER的用户名和密码。

SQL>create public database link sql2k connect to sa identified by manager using ‘sql2k’;

Database link created.

第六步 测试

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production

With the Partitio

上一页  [1] [2] [3]  下一页