In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.