Hello ,
In connection with this item on the possible automatic optimization of communication between different PDB using database links. Optimize Database Links between PDBs on the same CDB . closed in this fórum.
I tried to use the BEQ protocol to eliminate the overhead of SQL * Net and thus optimize the mass transfer of information between PDB using Database Links, as it is a normal requirement of the applications.
Using this network alias in Windows environment:
PDB_BE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = BEQ)
(PROGRAM = oracle)
(Argv0 = oracleCDB1)
(ARGS = '(DESCRIPTION = (LOCAL = YES) (ADDRESS = (PROTOCOL = BEQ)))')
)
)
(CONNECT_DATA = (SERVICE_NAME = CDB1))
)
D:\ARTURO\FORMACION\Oracle12c\multi-tenant\WORK>sqlplus system/oracle@pdb_be
SQL*Plus: Release 12.1.0.2.0 Production on Wed Dec 17 14:59:45 2014
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Wed Dec 17 2014 14:59:32 +01:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
Working properly, ie, a fast connection using the CDB1 service, it is obvious that CDB1 is the CBD.
But if we connect to the PDB using the associated service:
PDB_BE2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = BEQ)
(PROGRAM = oracle)
(Argv0 = oraclePDB1)
(ARGS = '(DESCRIPTION = (LOCAL = YES) (ADDRESS = (PROTOCOL = BEQ)))')
)
)
(CONNECT_DATA = (SERVICE_NAME = pdb1))
)
Where pdb1 is the service of a PDB, gives this error:
D: \ ARTURO \ TRAINING \ Oracle12c \ multi-tenant \ WORK> sqlplus system / oracle @ pdb_be2
SQL * Plus: Release 12.1.0.2.0 Production on Miu December 17 2014 14:55:52
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS: protocol adapter error
Enter your username:
Anyone know if I'm missing something in the configuration to use the BEQ protocol in this multi-tenant environment?
Thanks!
Arturo