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

Introduction to manual database chain in section 7 of Oracle learning notes

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

Share

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

Select * from vault circle; check the logical circuit, share the server connection, and use easy connect to display

Select * from vastly qualified cherry; generally configured with three

Operation in sqlplus

Show parameter dispa

Alter system set dispatchers=' (PROTOCOL=TCP) (dispatchers=3)'; this one is responsible for carrying the dishes.

Alter system set shared_servers=3; is in charge of cooking.

These two show parameter max_dis max_shared also need to be configured.

Lsnrctl services can realize that

Vim tnsnames.ora

SORCL55 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.55) (PORT = 1522))

)

(CONNECT_DATA =

(SERVER = shared) # shared server connection, but this is slow

(SERVICE_NAME = orcl.example.com)

)

)

S physical view connection session

Do not allow 1521 not to make a shared server connection, others can

Vim tnsnames.ora

ONLY1521 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = station55.example.com) (PORT = 1521))

)

Alter system set dispatchers=' (PROTOCOL=TCP) (dispatchers=3) (listener=ONLY1521)'

Lsnrctl services L2 does not have a shared server connection, only port 1521 can connect.

Then carry on the connection test, after completing the tns, it will prompt 12520 TNS error and so on.

Experiments on win

Cmd

Set ORACLE_SID=orcl

Conn / as sysdba

Show parameter db_name

Show parameter service

Conn hr/hr

Alter user hr identified by hr account unlock; unlocks HR user

Select salary from employees where employee_id=100

Next, do the database chain, first do tns.

Vim tnsnames.ora

ORCL244 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.244) (PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl.example.com)

)

)

Sqlplus / nolog

Conn hr/oracle_4U peer

Conn system/oracle_4U is not equal.

Create database link dblink1 connect to hr identified by hr using 'ORCL244'; creates a database chain

Select salary from hr.employees@dblink1 where employee_id=100

Update hr.employees@dblink1 set salary=8888 where employee_id=100

Commit

Then go to windown to see if the data has been changed.

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

Wechat

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

12
Report