Shulou(Shulou.com)06/01 Report--

Introduction to the Network part

The oracle database server is the client

On windows

Build two databases: zhs16gpk for orcl and al32utf8 for utforcl

Services oracleServiceORCL and oracleServiceutforcl are enabled

Cmd

Oradim help

Lsnrctl service

1. Configure monitoring

2. Configure aliases

3. Failover when configuring a connection

4. Control listener

Tnsping test network

The network configuration files of the linux client or server are in this directory

/ 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

If you change the port to change this configuration file

/ 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))

)

)

Then copy to / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Crsctl start res ora.LISTENER.lsnr restart snooping

Lsnrctl services View Monitoring

SQL > show parameter local_lis

SQL > alter system set local_listener= "FOR15210"

Lsnrctl services View Monitoring

You need to copy this file to the grid directory, which is the default path created by dbca. Single user and double HOME

/ u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

Copy after modification!

FOR15210 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.55) (PORT = 15210))

)

Lsnrctl services

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.