{共有サーバ}エイリアスを専用サーバ接続/共有サーバ接続として構成

https://docs.oracle.com/cd/F19136_01/netag/identifying-and-accessing-database.html#GUID-24890E90-6137-4B8B-98B4-976411BD4EDC

cdh
cd network/admin

vim tnsnames.ora

dedicatedorcl=
 (DESCRIPTION= 
  (ADDRESS=(PROTOCOL=tcp)(HOST=mmm111.example.com)(PORT=1521))
  (CONNECT_DATA= 
     (SERVICE_NAME=orcl.example.com)(server=dedicated)))

sqlplus system/oracle@dedicatedorcl

SELECT SID, SERIAL#, STATUS, SERVER
   FROM V$SESSION
   WHERE USERNAME = 'SYSTEM';

cdh
cd network/admin

vim tnsnames.ora

sharedorcl=
 (DESCRIPTION= 
  (ADDRESS=(PROTOCOL=tcp)(HOST=mmm111.example.com)(PORT=1521))
  (CONNECT_DATA= 
     (SERVICE_NAME=orcl.example.com)(server=shared)))

sqlplus system/oracle@sharedorcl

SELECT SID, SERIAL#, STATUS, SERVER
   FROM V$SESSION
   WHERE USERNAME = 'SYSTEM';