问题描述

linux oracle11g 做的rac双集，应用使用windows+weblogic，应用服务器重启后访问缓慢

第一次重启过了两天系统访问又变的很快了，第二次重启过后又变的访问缓慢，持续一个星期还没好，分析原因可能是rac双集原因，重启了linux 的两台数据服务器后，只起来了一台，另外一台监听Instance ""gzlcwdb1"" status BLOCKED ，看过listener配置，应该是没问题的，请大神帮忙分析下访问缓慢的原因，也通过单点分别访问过数据库，也还是访问缓慢，求解，在线等。。。

贴上配置：

copyright (c) 1997 by the Oracle Corporation

NAME

listener.ora

FUNCTION

Network Listener startup parameter file example

NOTES

This file contains all the parameters for listener.ora

and could be used to configure the listener by uncommenting

and changing values. Multiple listeners can be configured

in one listener.ora so listener.ora parameters take the form

of SID_LIST_ where is the name of the listener

this parameter refers to. All parameters and values are

case-insensitive.

This parameter specifies both the name of the listener and

it listening address(es). Other parameters for this listener

us this name in place of . When not specified

the name for defaults to ""LISTENER"" with the default

address value as shown below.

#

LISTENER =

(ADDRESS_LIST=

(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))

(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

SID_LIST_

List of services the listener knows about and can connect

clients to. There is no default. See the Net8 Administrator's

Guide for more information.

#

SID_LIST_LISTENER=

(SID_LIST=

(SID_DESC=

#BEQUEATH CONFIG

(GLOBAL_DBNAME=salesdb.mycompany)

(SID_NAME=sid1)

(ORACLE_HOME=/private/app/oracle/product/8.0.3)

#PRESPAWN CONFIG

(PRESPAWN_MAX=20)

(PRESPAWN_LIST=

(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))

)

)

)

PASSWORDS_

Specifies a password to authenticate stopping the listener.

Both encrypted and plain-text values can be set. Encrypted passwords

can be set and stored using lsnrctl.

LSNRCTL> change_password

Will prompt for old and new passwords and use encryption both

to match the old password and to set the new one.

LSNRCTL> set password

Will prompt for the new password for authentication with

the listener. The password must be set before running the next

command.

LSNRCTL> save_config

Will save the changed password to listener.ora. These last two

steps are not necessary if SAVE_CONFIG_ON_STOP_ is ON.

See below.

#

Default: NONE

#

PASSWORDS_LISTENER = 20A22647832FB454 # ""foobar""

SAVE_CONFIG_ON_STOP_

Tells the listener to save configuration changes to listener.ora when

it shuts down. Changed parameter values will be written to the file

while preserving formatting and comments.

Default: OFF

Values: ON/OFF

#

SAVE_CONFIG_ON_STOP_LISTENER = ON

USE_PLUG_AND_PLAY_

Tells the listener to contact an Onames server and register itself

and its services with Onames.

Values: ON/OFF

Default: OFF

#

USE_PLUG_AND_PLAY_LISTENER = ON

LOG_FILE_

Sets the name of the listener's log file. The .log extension

is added automatically.

Default=

#

LOG_FILE_LISTENER = lsnr

LOG_DIRECTORY_

Sets the directory for the listener's log file.

Default: /network/log

#

LOG_DIRECTORY_LISTENER = /private/app/oracle/product/8.0.3/network/log

TRACE_LEVEL_

Specifies desired tracing level.

Default: OFF

Values: OFF/USER/ADMIN/SUPPORT/0-16

#

TRACE_LEVEL_LISTENER = SUPPORT

TRACE_FILE_

Sets the name of the listener's trace file. The .trc extension

is added automatically.

Default:

#

TRACE_FILE_LISTENER = lsnr

TRACE_DIRECTORY_

Sets the directory for the listener's trace file.

Default: /network/trace

#

TRACE_DIRECTORY_LISTENER=/private/app/oracle/product/8.0.3/network/trace

CONNECT_TIMEOUT_

Sets the number of seconds that the listener waits to get a

valid database query after it has been started.

Default: 10

#

CONNECT_TIMEOUT_LISTENER=10