首页 新闻 搜索 专区 学院

为什么我安装的Oracle数据库中的tnsnames.oRA文件截然不同?

0
悬赏园豆:50 [待解决问题]

为什么我安装的Oracle数据库中的tnsnames.oRA文件截然不同?我他妈真是服了,安了几天的Oracle数据库,网上教程没有一个真正解决我的问题的。希望大佬们直接提供一个Oracle数据安装、配置--->Plsql安装、配置---与Oracle连接。

This file contains the syntax information for

the entries to be put in any tnsnames.ora file

The entries in this file are need based.

There are no defaults for entries in this file

that Sqlnet/Net3 use that need to be overridden

Typically you could have two tnsnames.ora files

in the system, one that is set for the entire system

and is called the system tnsnames.ora file, and a

second file that is used by each user locally so that

he can override the definitions dictated by the system

tnsnames.ora file.

The entries in tnsnames.ora are an alternative to using

the names server with the onames adapter.

They are a collection of aliases for the addresses that

the listener(s) is(are) listening for a database or

several databases.

The following is the general syntax for any entry in

a tnsnames.ora file. There could be several such entries

tailored to the user's needs.

<alias>= [ (DESCRIPTION_LIST = # Optional depending on whether u have
# one or more descriptions
# If there is just one description, unnecessary ]
(DESCRIPTION=
[ (SDU=2048) ] # Optional, defaults to 2048
# Can take values between 512 and 32K
[ (ADDRESS_LIST= # Optional depending on whether u have
# one or more addresses
# If there is just one address, unnecessary ]
(ADDRESS=
[ (COMMUNITY=<community_name>) ]
(PROTOCOL=tcp)
(HOST=<hostname>)
(PORT=<portnumber (1521 is a standard port used)>)
)
[ (ADDRESS=
(PROTOCOL=ipc)
(KEY=<ipckey (PNPKEY is a standard key used)>)
)
]
[ (ADDRESS=
[ (COMMUNITY=<community_name>) ]
(PROTOCOL=decnet)
(NODE=<nodename>)
(OBJECT=<objectname>)
)
]
... # More addresses
[ ) ] # Optional depending on whether ADDRESS_LIST is used or not
[ (CONNECT_DATA=
(SID=<oracle_sid>)
[ (GLOBAL_NAME=<global_database_name>) ]
)
]
[ (SOURCE_ROUTE=yes) ]
)
(DESCRIPTION=
[ (SDU=2048) ] # Optional, defaults to 2048
# Can take values between 512 and 32K
[ (ADDRESS_LIST= ] # Optional depending on whether u have more
# than one address or not
# If there is just one address, unnecessary
(ADDRESS
[ (COMMUNITY=<community_name>) ]
(PROTOCOL=tcp)
(HOST=<hostname>)
(PORT=<portnumber (1521 is a standard port used)>)
)
[ (ADDRESS=
(PROTOCOL=ipc)
(KEY=<ipckey (PNPKEY is a standard key used)>)
)
]
... # More addresses
[ ) ] # Optional depending on whether ADDRESS_LIST
# is being used
[ (CONNECT_DATA=
(SID=<oracle_sid>)
[ (GLOBAL_NAME=<global_database_name>) ]
)
]
[ (SOURCE_ROUTE=yes) ]
)
[ (CONNECT_DATA=
(SID=<oracle_sid>)
[ (GLOBAL_NAME=<global_database_name>) ]
)
]
... # More descriptions
[ ) ] # Optional depending on whether DESCRIPTION_LIST is used or not

黑小子-余的主页 黑小子-余 | 初学一级 | 园豆:101
提问于:2020-04-29 23:24
< >
分享
所有回答(2)
0

通过自己的千万测试,已解决

黑小子-余 | 园豆:101 (初学一级) | 2020-09-18 16:55
0

你怎么解决的

苏州の酱醋茶 | 园豆:202 (菜鸟二级) | 2021-01-17 11:49

...找错地方了。。。我发现这个上一层目录才是真正的监听文件。。。

支持(0) 反对(0) 苏州の酱醋茶 | 园豆:202 (菜鸟二级) | 2021-01-18 11:23
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册