《网络部分介绍》
oracle数据库服务器是客户端
windows上
建两个数据库orcl用zhs16gpk和utforcl用al32utf8
服务oracleServiceORCL和oracleServiceutforcl开启
cmd
oradim 帮助
lsnrctl service
1、配置监听
2、配置别名
3、配置连接时故障转移
4、控制监听器
tnsping 测试网络
linux客户端或者服务器的网络配置文件都在这个目录
/u01/app/oracle/product/11.2.0/grid/network/admin
crs_stat -p | grep lsnr
NAME=ora.LISTENER.lsnr
crsctl stop res ora.LISTENER.lsnr
如果换端口改这个配置文件
/u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.55)(PORT = 15210))
)
)
然后复制到/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
crsctl start res ora.LISTENER.lsnr 重启监听
lsnrctl services 查看监听
SQL> show parameter local_lis
SQL> alter system set local_listener=”FOR15210″;
lsnrctl services 查看监听
需要把这个文件拷贝到grid目录下，这个目录是dbca创建的默认路径，单用户双HOME
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
进行修改后在拷贝！
FOR15210 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.55)(PORT = 15210))
)
lsnrctl services
