Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

After installing oracle, there is no network directory under the installation directory, and the placement directory of tnsnames.ora

2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

(the following can be done at a glance. Anyway, copy is the most frequently used, and then the server ip address and port number are changed. Generally, the name is also ip address.)

ADDRESS_LIST: indicates that the client connects to one or more servers via multiple protocols. In the style file, it is indicated that the client will use the TCP/IP protocol to connect to the server.

PROTOCOL: indicates the protocol to be used for the connection

SERVICE_NAME: "SERVICE_NAME" is "GlobalDatabaseName". The ORACLE8i database uses "GlobalDatabaseName" to uniquely identify itself. The usual format is "name.domain", and the value here is "ora817.huawei.com".

HOST: is the server IP address used by the TCP/IP protocol

PORT: is the port address used by TCP/IP

SID: specifies the ORACLE_SID of the ORACLE database on the server to connect to

SERVER=DEDICATED: means to connect to an ORACLE database with a dedicated server.

Also: if the oracle installation fails for the first time, uninstall and reinstall first.

(this is the first article I published. In fact, these were encountered two years ago, but I just entered the society at that time and had no habit of sorting out materials and documents. Youdao cloud notes also had a lot of copy, so it was good to type and write down by himself, and it was also a suggestion to my new friends.)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report