************************************************************
show parameter global_name
alter system set global_names=false;
如果global_name為flase的情況下,如下步驟:
1.配置listener
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME =sid1)
(ORACLE_HOME = D:/oracle/ora10g)
(SID_NAME = sid1)
)
(SID_DESC =
(PROGRAM =hsodbc)
(SID_NAME = SQL Server_SID)
(ORACLE_HOME = d:/oracle/ora10g)
)
)
LISTENER =
/*
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
*/有可能要這段
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
注意紅色的與藍色的地方;
2.配置tnsnames.ora:
增加如下的一個tnsname:
test01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SQL Server_SID)
)
(HS = OK)
)
注意紅色的地方;
3.增加初始化文件:
在%oracle_home%/hs/admin/下,創建一個以init<SQL Server_SID>.ora文件,內容如下:
如果global_name為true的情況下要加以下兩句:
HS_DB_NAME = =SQL Server_name
HS_DB_DOMAIN =域名
否則隻要以下兩句:
HS_FDS_CONNECT_INFO=SQL Server_SIDHS_FDS_TRACE_LEVEL=OFF
4. 重新啟動 listener
5.create public database link link_name connect to user identified by ****** using 'test01';
6. 這樣就可以了。
按照这个搞了一天 sap后台数据库也没有连接到 sql server 上 。择机再搞