查看tnsname
vi $ORACLE_HOME/network/admin/tnsnames.ora
创建tnsname
1.创建tnsnames.ora在$ORACLE_HOME/network/admin路径下
2.netca
修改tnsname
修改tnsnames.ora文件
删除tnsname
删除tnsnames.ora文件内相应tns
在数据库中设置不同的server_name。
1.查看数据库service_name
show parameter service_name
2.添加新的service_name
alter system set service_names='oldservice_name','newservice_name';
修改数据库参数,使其可以提供共享功能
alter system set shared_servers=10;
alter system set max_shared_servers=30;
alter system set dispatchers='(PROT=tcp)(DISP=3)';
alter system set max_dispatchers=10;
alter system set shared_server_sessions=200; 共享连接会话最多200个
alter system set session=300 scope=spfile;
在tns里注册不同server_name,使用不同端口,一个专用,一个共享
NEWSERVERNAME1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vast.vastdata)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <servicename1>)
)
)
NEWSERVERNAME2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vast.vastdata)(PORT = 1522))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = <servicename2>)
)
)