alter system set shared_servers = 10;
cdh
cd network/admin
vim listener.ora
LISTENER_PROD2s =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=mmm111)(PORT=1421)))
lsnrctl start LISTENER_PROD2s
lsnrctl status LISTENER_PROD2s
vim tnsnames.ora
listener_PROD2s=
(DESCRIPTION =
(ADDRESS = (PROTOCOL=tcp)(HOST=mmm111)(PORT=1421)))
ALTER SYSTEM SET LOCAL_LISTENER=listener_PROD2s;
ALTER SYSTEM SET DISPATCHERS="(PROTOCOL=tcp)(LISTENER=listener_PROD2s)";
shutdown immediate;
startup
show parameter listen
show parameter dispa
show parameter shared
sqlplus system/oracle@mmm111:1421/PROD2.example.com
