9. Oracle Network Configuration

Oracle Network configuration:

1, the relevant concept of monitoring

Path:

$ORACLE _home/network/admin/listener.ora

$ORACLE _home/network/admin/sqlnet.ora

$ORACLE _home/network/admin/samples/tnsnames.ora

tnsping ORCL Request Service Name

User process

Noun parsing (user process)----Request Connection request-----listener-service Process (server processes)

Configure and manage Oracle Network Tools

Enterprise Manager

Oracle Net Manager command line: netmgr

Oracle Net Configuration Assistant command line: NETCA

Command line: Lsnrctl

NETCA: Creating Network-related

DBCA: Creating a Database

ASMCA:ASM Create

Dbua: Database Upgrade

If a grid listener is installed and is supervised by the grid, perform the lsnrctl in a grid environment

If you do not have a grid installed, execute LSNRCTL directly in the database environment

Lsnrctl Status/start/stop;

Lsnrctl> Help

The following operations is available

An asterisk (*) denotes a modifier or extended command:

Start Stop status

Services version Reload

Save_config Trace Spawn

Change_password quit exit

set* show*

To view the monitoring details (install grid):

lsnrctl> status

Connecting to (Description= (address= (PROTOCOL=IPC) (key=extproc1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version Tnslsnr for Linux:version 11.2.0.1.0-production

Start Date 24-may-2017 18:51:25

Uptime 4 days 0 hr. Min. sec

Trace level off

Security on:local OS Authentication

SNMP OFF

Listener Parameter file/u01/app/oracle/product/11.2.0/grid/network/admin/listener.or

Alistener Log File/u01/app/oracle/diag/tnslsnr/oel/listener/alert/log.xml

Listening Endpoints Summary ...

(Description= (address= (PROTOCOL=IPC) (key=extproc1521)))

(Description= (address= (protocol=tcp) (Host=oel) (port=1521)))

Services Summary ...

Service "+asm" has 1 instance (s).

Instance "+asm", status ready, have 1 handler (s) for the This service ...

Service "ORCL" has 1 instance (s).

Instance "ORCL", status ready, have 1 handler (s) for the This service ...

Service "Orclxdb" has 1 instance (s).

Instance "ORCL", status ready, have 1 handler (s) for the This service ...

The command completed successfully

Lsnrctl>

Now there's LISTENER this monitor

Multiple listening, how to configure?

Configuration tool:

Netmgr or NETCA

I've just created 2 monitoring AEC and test, including listener, with 3 listeners.

View Monitoring

Lsnrctl status LISTENER; 1521

Lsnrctl status AEC; 1522

Lsnrctl status test; 1523

Start monitoring

Lsnrctl start AEC;

Lsnrctl start test;

Configuration information You can learn by configuring the Admin interface:

Vim/u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora

ADR_BASE_AEC =/u01/app/oracle

LISTENER =

(Description_list =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))

)

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = Oel) (PORT = 1521))

)

)

Adr_base_listener =/u01/app/oracle

AEC =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = Oel) (PORT = 1522))

)

Enable_global_dynamic_endpoint_listener = On

TEST =

(Description_list =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = Oel) (PORT = 1523))

)

)

Adr_base_test =/u01/app/oracle

Enable_global_dynamic_endpoint_test=on

2, management monitoring

Simple connection naming: TCP/IP connection string (general small and medium companies)

Local name: Local configuration file

Directory naming: LDAP centralized directory server

External naming: Using a supported non-Oracle naming service

Conn Hr/[email protected]

Test monitoring (Simple connection name resolution)

Tnsping HOSTNAME:1521/ORCL

Or

Tnsping 192.168.175.60:1521/listener

[Email protected] ~]$ tnsping Oel:1521/listener

TNS Ping Utility for linux:version 11.2.0.1.0-production on 28-may-2017 20:40:05

Copyright (c) 1997, Oracle. All rights reserved.

Used parameter files:

/u01/app/oracle/product/11.2.0/grid/network/admin/sqlnet.ora

Used Ezconnect Adapter to resolve the alias

Attempting to contact (description= (connect_data= (Service_name=listener)) (Address= (PROT

OCOL=TCP) (host=127.0.0.1) (port=1521))) OK (msec)

Support for local and directory naming:

Tnsping Listener

Client Configuration Tool:

Netmgr

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

ORCL =

(DESCRIPTION =

(Address_list =

(ADDRESS = (PROTOCOL = TCP) (HOST = Oel) (PORT = 1521))

)

(Connect_data =

(service_name = ORCL)

)

)

In Configuring a

OAEC =

(DESCRIPTION =

(Address_list =

(ADDRESS = (PROTOCOL = TCP) (HOST = Oel) (PORT = 1521))

)

(Connect_data =

(service_name = ORCL)

)

)

Test:

Sqlplus Scott/[email protected]

Sqlplus Scott/[email protected]

If Tnsnames.ora doesn't write anything,

Then the client to connect handwriting is more troublesome

Sqlplus Scott/[email PROTECTED]:1521/ORCL

3. Server Mode

Shared server: Storing user session data in the SGA

Consider taking the shared server memory into account when resizing the SGA.

When setting up a shared server, you must set the Large_pool size (UGA)

When do you set it up? (Too few restaurants service staff)

Can not set the situation of sharing server: (The following operation situation is very long!!!) )

1. Database management

2. Backup and restore operations

3, batch processing and bulk loading

4. Data Warehouse operation

Long connection operation is not allowed.

How do I set up a shared server?

Shared server:

alter system set SHARED_SERVERS=5;

alter system set SHARED_SERVER_SESSIONS=20;

Show parameter Dispatchers

SELECT * from V$dispatcher;

Alter system set dispatchers= ' (Address= (PROTOCOL=TCP) (host=172.25.0.10) (port=14597) (dispatchers=5)) ';

Alter system set Local_listener= ' (Description= (address= (protocol=tcp) (host=172.25.0.10))) ';

Shared server server-side configuration methods and parameters explained:

1, configure all the people who eat to come in line up how many teams waiting to be served

Dispatchers

Alter system set dispatchers= ' (PROTOCOL=TCP) (dispatchers=3) ';

2. Configure how many service providers to provide services

Shared_servers

alter system set SHARED_SERVERS=5;

When the business is good can not be better, 5 attendants are not enough, I have to add a few, how many to increase the head?

Max_shared_servers

alter system set MAX_SHARED_SERVERS=20;

3, the first floor hall, Scatterplot Bento can do 100 people, the second floor, 3 floor seating can do 148 people,

Sessions 248

Set up shared server and private server coexistence

Shared_server_sessions 100 Sharing mode

Specialized Mode 248-100=148

##############################################################################

The specific configuration is as follows:

Alter system set sessions=248 Scope=spfile;

Sql> Show parameter sessions;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Java_max_sessionspace_size integer 0

Java_soft_sessionspace_limit integer 0

License_max_sessions integer 0

license_sessions_warning integer 0

Sessions integer 248

Shared_server_sessions Integer

Sql> alter system set dispatchers= ' (PROTOCOL=TCP) (dispatchers=3) ';

System altered.

Sql> show parameter dispatcher;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Dispatchers string (protocol=tcp) (dispatchers=3)

Max_dispatchers Integer

Sql> alter system set shared_servers=5;

System altered.

Sql> Show parameter shared_server;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Max_shared_servers Integer

Shared_server_sessions Integer

Shared_servers integer 5

Sql> alter system set MAX_SHARED_SERVERS=20;

System altered.

Sql> Show parameter max_shared_servers;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Max_shared_servers integer 20

Sql> Show parameter sessions;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Java_max_sessionspace_size integer 0

Java_soft_sessionspace_limit integer 0

License_max_sessions integer 0

license_sessions_warning integer 0

Sessions integer 248

Shared_server_sessions Integer

Sql> alter system set SHARED_SERVER_SESSIONS=100;

System altered.

Sql> Show parameter session;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Java_max_sessionspace_size integer 0

Java_soft_sessionspace_limit integer 0

License_max_sessions integer 0

license_sessions_warning integer 0

Session_cached_cursors integer 50

Session_max_open_files integer 10

Sessions integer 248

Shared_server_sessions integer 100

Sql>

####################################################################################

Client settings:

Tnsnames.ora

Sharing settings:

Orcl_sh =

(DESCRIPTION =

(Address_list =

(ADDRESS = (PROTOCOL = TCP) (HOST = Oel) (PORT = 1521))

)

(Connect_data =

(SERVER = SHARED)

(service_name = ORCL)

)

)

Proprietary settings

Orcl_sh =

(DESCRIPTION =

(Address_list =

(ADDRESS = (PROTOCOL = TCP) (HOST = Oel) (PORT = 1521))

)

(Connect_data =

(SERVER = dedicated)

(service_name = ORCL)

)

)

Test it.

Tnsping Orcl_sh

Tnsping Orcl_de

Sqlplus Scott/[email Protected]_sh

Sqlplus Scott/[email Protected]_de

See if there are currently queued current

Lsnrctl> Services

Connecting to (Description= (address= (PROTOCOL=IPC) (key=extproc1521)))

Services Summary ...

Service "+asm" has 1 instance (s).

Instance "+asm", status ready, have 1 handler (s) for the This service ...

Handler (s):

"Dedicated" Established:3 refused:0 State:ready

LOCAL SERVER

Service "ORCL" has 1 instance (s).

Instance "ORCL", status ready, have 4 handler (s) for the This service ...

Handler (s):

"D002" Established:2 refused:0 current:3 max:1022 state:ready

DISPATCHER <machine:oel, pid:2681>

(Address= (PROTOCOL=TCP) (Host=oel) (port=18845))

"D001" Established:3 refused:0 current:2 max:1022 state:ready

DISPATCHER <machine:oel, pid:2677>

(Address= (PROTOCOL=TCP) (Host=oel) (port=33604))

"D000" Established:4 refused:0 current:1 max:1022 state:ready

DISPATCHER <machine:oel, pid:5861>

(Address= (PROTOCOL=TCP) (Host=oel) (port=45766))

"Dedicated" Established:1 refused:0 State:ready

LOCAL SERVER

Service "Orclxdb" has 1 instance (s).

Instance "ORCL", status ready, have 0 handler (s) for the This service ...

The command completed successfully

4. Database connection

A database can query B database dblink

This article is from the "Liang blog" blog, make sure to keep this source http://7038006.blog.51cto.com/7028006/1930570

9. Oracle Network Configuration