在安装oracle9i数据库时,会让你填写全局数据库名和sid,请问这两个能不能不一样,根据下面这个tnsnames.ora文件,我要配置的全局数据库名和SID分别是什么。谢谢.
# TNSNAMES.ORA Network Configuration File: D:\orant\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wylwh)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)ORC9 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wylwh)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orc9.lwh)
)
)ntoramy.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wylwh)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orc9.lwh)
)
)ntora.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =133.133.130.2)(PORT = 1521))
)
(CONNECT_DATA =
(sid = orcl)
)
)tbntora.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 133.133.130.3)(PORT = 1521))
)
(CONNECT_DATA =
(Sid = orcl)
)
)
ntora8.world =
(DESCRIPTION =
(ADDRESS= (PROTOCOL = BEQ)(PROGRAM = oracle80)(ARGV0 = oracle80ORCL)(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))'))
(CONNECT_DATA = (SID = ORCL))
)
# TNSNAMES.ORA Network Configuration File: D:\orant\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wylwh)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)ORC9 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wylwh)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orc9.lwh)
)
)ntoramy.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wylwh)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orc9.lwh)
)
)ntora.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =133.133.130.2)(PORT = 1521))
)
(CONNECT_DATA =
(sid = orcl)
)
)tbntora.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 133.133.130.3)(PORT = 1521))
)
(CONNECT_DATA =
(Sid = orcl)
)
)
ntora8.world =
(DESCRIPTION =
(ADDRESS= (PROTOCOL = BEQ)(PROGRAM = oracle80)(ARGV0 = oracle80ORCL)(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))'))
(CONNECT_DATA = (SID = ORCL))
)
ntora.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =133.133.130.2)(PORT = 1521))
)
(CONNECT_DATA =
(sid = orcl)
)
) tbntora.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 133.133.130.3)(PORT = 1521))
)
(CONNECT_DATA =
(Sid = orcl)
)
)
可他们两个的sid是一样的,那我的全局数据库名得设成什么呀