The seventh section of the Oracle Learning note shares dedicated server configurations and cases

SELECT * from v_$circuit; view logical loops, share server connections, use Easy connect to display

SELECT * from V_$dispatcher; General configuration of three

Operation in Sqlplus

Show Parameter Dispa

Alter system set dispatchers= ' (PROTOCOL=TCP) (dispatchers=3) '; This is the end plate.

alter system set shared_servers=3; This is for cooking.

Show parameter Max_dis max_shared These two also need to be configured under

LSNRCTL Services can recognize

Vim Tnsnames.ora

SORCL55 =

(DESCRIPTION =

(Address_list =

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

)

(Connect_data =

(SERVER = shared) #共享服务器连接, but this is slow

(service_name = orcl.example.com)

)

)

s physical View Connection session

Do not allow 1521 to connect to a shared server, 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 There is no shared server connection, only 1521 ports can be connected

Then connect the test, do a good job after TNS will prompt 12520 TNS error 4

The experiment 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; unlock hr user

Select salary from employees where employee_id=100;

Then do the database chain, first to 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 Equivalence

Conn system/oracle_4u non-equivalence

Create DATABASE link Dblink1 connect to HR identified by HR using ' ORCL244 ';

Select salary from [email protected] where employee_id=100;

Update [email protected] set salary=8888 where employee_id=100;

Commit

And see if the data was changed on the Windown.

This article is from the Oracle Personal Learning Notes blog, so be sure to keep this source http://wuchunqiang.blog.51cto.com/1022331/1852249

The seventh section of the Oracle Learning note shares dedicated server configurations and cases