重新安装oracle监听,求助：数据库重装后监听一顿问题

最新推荐文章于 2024-01-22 11:31:44 发布

天日可人

最新推荐文章于 2024-01-22 11:31:44 发布

阅读量1k

点赞数

文章标签：重新安装oracle监听

起因：笔记本上数据库原本运行的好好的，安装了avg杀毒软件后，监听不能正常工作，将avg停用后，监听恢复正常，卸载avg杀毒软件，没卸载干净，这下数据库的监听也彻底不能工作了。

原因一通找，实在解决不了，于是重装数据库。

重新安装碰到的问题，提示如下：

enterprise manager 配置失败

监听程序未启动或数据库服务未注册到该监听程序。

启动该监听程序并注册数据库服务，然后重新运行 EM configuration assistant。

有关详细资料，请参阅F:\app\xuzhou\cfgtoollogs\dbca\orcl\emConfig.log

您以后可以通过手动运行F:\app\xuzhou\product\11.2.0\dbhome_1\BIN\emca.bat，重新使用Enterprice manager配置此数据库。

通过database configuration assistant 配置数据库选件，提示如下：

could not find appropriate listener for this database configuring DB control requires database to be registered with atleast on lisnter

忽略后，数据库安装成功

但是监听还是无法工作，百度得到一个方法，修改了listener.ora，紫色为新增部分，

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = CLRExtProc)

(ORACLE_HOME = F:\app\xuzhou\product\11.2.0\dbhome_1)

(PROGRAM = extproc)

(ENVS = "EXTPROC_DLLS=ONLY:F:\app\xuzhou\product\11.2.0\dbhome_1\bin\oraclr11.dll")

)

(SID_DESC =

(GLOBAL_DBNAME = ORCL)

(ORACLE_HOME = F:\app\xuzhou\product\11.2.0\dbhome_1)

(SID_NAME = ORCL)

)

监听是工作了，但是登陆时间居然要20秒，tnsping如下：

C:\Users\xuzhou>tnsping orcl

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 28-4月 -

2017 21:41:36

已使用的参数文件:

F:\app\xuzhou\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora

已使用 TNSNAMES 适配器来解析别名

尝试连接 (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xuzhou-PC)(PORT = 152

1)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))

OK (21170 毫秒)

lisnter trace 结果分析如下：

Trace Assistant 实用程序: 版本 11.2.0.1.0 Production, 平台: 2017年4月28日 22:19:07

*************************************************************************

* Trace Assistant *

*************************************************************************

---> Send 58 bytes - Connect packet timestamp=28-4月 -2017 21:20:22:134

Current NS version number is: 314.

Lowest NS version number can accommodate is: 300.

Global options for the connection:

Don't care

Maximum SDU size: 8192

Maximum TDU size: 4096

NT protocol characteristics:

Asynchronous mode

Callback mode

Test for more data

Full duplex I/O

Line turnaround value: 0

Connect data length: 253

Connect data offset: 58

Connect data maximum size: 2048

Native Services wanted

Authentication is linked and specify

NAU doing O3LOGON - DH key foldedin

Native Services wanted

Authentication is linked and specify

NAU doing O3LOGON - DH key foldedin

Packet data is in the following data packet

---> Send 263 bytes - Data packet timestamp=28-4月 -2017 21:20:22:134

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleorcl)

(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DA

TA=(SID=orcl)(CID=(PROGRAM=F:\app\xuzhou\product\11.2.0\dbhome_1\bin\s

qlplus.exe)(HOST=XUZHOU-PC)(USER=xuzhou))))

Accepted NS version number is: 314.

Global options for the connection:

Don't care

Accepted maximum SDU size: 8192

Accepted maximum TDU size: 4096

Connect data length: 0

Native Services wanted

Authentication is linked and specify

NAU doing O3LOGON - DH key foldedin

Native Services wanted

Authentication is linked and specify

NAU doing O3LOGON - DH key foldedin

---> Send 168 bytes - Data packet timestamp=28-4月 -2017 21:20:22:165

Native Services negotiation packet version#: 0

Service data packet #0 for Supervisor has 3 subpackets

Subpacket #0: Version #186646784

Subpacket #1: 0000000000000000

Subpacket #2: DEADBEEF0003000000040004000100010002

Service data packet #1 for Authentication has 5 subpackets

Subpacket #0: Version #186646784

Subpacket #1: UB2: 57569

Subpacket #2: FCFF

Subpacket #3: UB1: 1

Subpacket #4: NTS

Service data packet #2 for Encryption has 2 subpackets

Subpacket #0: Version #186646784

Subpacket #1: 000000000000000000000000

Service data packet #3 for Data Integrity has 2 subpackets

Subpacket #0: Version #186646784

Subpacket #1: 000000

Native Services negotiation packet version#: 0

Service data packet #0 for Supervisor has 3 subpackets

Subpacket #0: Version #186646784

Subpacket #1: 0000

Subpacket #2: DEADBEEF00030000000200040001

Service data packet #1 for Authentication has 7 subpackets

Subpacket #0: Version #186646784

Subpacket #1: FAFF

Subpacket #2: UB1: 1

Subpacket #3: NTS

Subpacket #4: Version #33554432

Subpacket #5: UB4: 0

Subpacket #6: UB4: 0

Service data packet #2 for Encryption has 2 subpackets

Subpacket #0: Version #186646784

Subpacket #1: UB1: 0

Service data packet #3 for Data Integrity has 2 subpackets

Subpacket #0: Version #186646784

Subpacket #1: UB1: 0

---> Send 157 bytes - Data packet timestamp=28-4月 -2017 21:20:22:196

Native Services negotiation packet version#: 0

Service data packet #0 for Authentication has 7 subpackets

Subpacket #0: Version #33554432

Subpacket #1: UB4: 0

Subpacket #2: UB4: 0

Subpacket #3: 0200000004000000010000000000000000000000

Subpacket #4: 00000000

Subpacket #5: 3A000000

Subpacket #6: 4E544C4D535350000100000007B208A2090009003100000009000900280000000601B11D0000000F58555A484F552D5043574F524B47524F5550

Native Services negotiation packet version#: 0

Service data packet #0 for Authentication has 2 subpackets

Subpacket #0: B2000000

Subpacket #1: 4E544C4D5353500002000000120012003800000005C28AA2A7B384645AB7EAB0A014C00100000000680068004A0000000601B11D0000000F580055005A0048004F0055002D005000430002001200580055005A0048004F0055002D005000430001001200580055005A0048004F0055002D005000430004001200780075007A0068006F0075002D005000430003001200780075007A0068006F0075002D0050004300070008007D3B7B3022C0D20100000000

---> Send 131 bytes - Data packet timestamp=28-4月 -2017 21:20:22:212

Native Services negotiation packet version#: 0

Service data packet #0 for Authentication has 2 subpackets

Subpacket #0: 58000000

Subpacket #1: 4E544C4D535350000300000000000000580000000000000058000000000000005800000000000000580000000000000058000000000000005800000005C288A20601B11D0000000F0024995F2C363CA58F6A62D2E02417BB

---> Send 39 bytes - Data packet timestamp=28-4月 -2017 21:20:22:212

Set protocol (TTIPRO)

Operation 01 (con) Send protocol version=6

Originating platform: IBMPC/WIN_NT64-9.1.0

Set protocol (TTIPRO)

Operation 01 (con) Receive protocol version=6

Destination platform: IBMPC/WIN_NT64-9.1.0

---> Send 81 bytes - Data packet timestamp=28-4月 -2017 21:20:22:212

Set datatypes (TTIDTY)

---> Send 45 bytes - Data packet timestamp=28-4月 -2017 21:20:22:228

---> Send 1115 bytes - Data packet timestamp=28-4月 -2017 21:20:22:243

///

Error found. Error Stack follows:

id:0

Operation code:70

NS Error 1:12630

NS Error 2:0

NT Generic Error:0

Protocol Error:0

OS Error:0

NS & NT Errors Translation

12630, 00000 "不支持本机服务操作"

// *原因: 本机服务组件不支持用户

//所请求的操作。

// *操作: 如果组件支持该操作, 这就可能属于

//内部错误。

00000, 00000 "不是错误"

// *原因: 一切操作正常。

// *操作: 不必着急: 尽管放心。

00000, 00000 "不是错误"

// *原因: 一切操作正常。

// *操作: 不必着急: 尽管放心。

///

---> Send 60 bytes - Data packet timestamp=28-4月 -2017 21:20:22:274

---> Send 13 bytes - Data packet timestamp=28-4月 -2017 21:20:22:274

---> Send 13 bytes - Data packet timestamp=28-4月 -2017 21:20:30:297

---> Send 10 bytes - Data packet timestamp=28-4月 -2017 21:20:30:328

Data Packet flags:

End of file

///

Error found. Error Stack follows:

id:0

Operation code:65

NS Error 1:12535

NS Error 2:12560

NT Generic Error:505

Protocol Error:60

OS Error:0

NS & NT Errors Translation

12535, 00000 "TNS: 操作超时"

// *原因: 请求的连接无法在 listener.ora 中的 CONNECT_TIMEOUT

//参数所指定的超时值到来前完成。此

//错误源自 tnslsnr。

// *操作: 要么将 CONNECT_TIMEOUT 重新配置为 0, 这表示可以无限期等待;

//要么将 CONNECT_TIMEOUT 重新配置为某个更大的值。

//如果超时值超出可接受的时间范围, 请启用跟踪

//来获取详细信息。

12560, 00000 "TNS: 协议适配器错误"

// *原因: 出现一般协议适配器错误。

// *操作: 请检查所用的地址是否符合相应的协议说明。在

//报告此错误之前, 请查看错误堆栈, 检查是否有更低层的

//传输错误。启用跟踪后重新执行相关操作, 以获取更多详细

//资料。完成相关操作后, 禁用跟踪。

00505, 00000 "操作已超时"

// *原因: 请求的操作无法

//在超时到来前完成。

// *操作: 启用跟踪后重新执行相关操作, 以获取更多详细资料。

///

---> Send 58 bytes - Connect packet timestamp=28-4月 -2017 21:20:51:621

Current NS version number is: 314.

Lowest NS version number can accommodate is: 300.

Global options for the connection:

Don't care

Maximum SDU size: 8192

Maximum TDU size: 32767

NT protocol characteristics:

Asynchronous mode

Callback mode

Test for more data

Full duplex I/O

Urgent data support

Handoff connection to another

Grant connection to another

Line turnaround value: 0

Connect data length: 234

Connect data offset: 58

Connect data maximum size: 2048

Native Services wanted

Authentication is linked and specify

NAU doing O3LOGON - DH key foldedin

Native Services wanted

Authentication is linked and specify

NAU doing O3LOGON - DH key foldedin

Packet data is in the following data packet

---> Send 244 bytes - Data packet timestamp=28-4月 -2017 21:20:51:637

(DESCRIPTION=(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(

PROGRAM=F:\app\xuzhou\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=XU

ZHOU-PC)(USER=xuzhou)))(ADDRESS=(PROTOCOL=TCP)(HOST=fe80::1c8a:30b0:3f

57:fe97%25)(PORT=1521)))

---> Send 58 bytes - Connect packet timestamp=28-4月 -2017 21:20:51:699

Current NS version number is: 314.

Lowest NS version number can accommodate is: 300.

Global options for the connection:

Don't care

Maximum SDU size: 8192

Maximum TDU size: 32767

NT protocol characteristics:

Asynchronous mode

Callback mode

Test for more data

Full duplex I/O

Urgent data support

Handoff connection to another

Grant connection to another

Line turnaround value: 0

Connect data length: 234

Connect data offset: 58

Connect data maximum size: 2048

Native Services wanted

Authentication is linked and specify

NAU doing O3LOGON - DH key foldedin

Native Services wanted

Authentication is linked and specify

NAU doing O3LOGON - DH key foldedin

Packet data is in the following data packet

---> Send 244 bytes - Data packet timestamp=28-4月 -2017 21:20:51:699

(DESCRIPTION=(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(

PROGRAM=F:\app\xuzhou\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=XU

ZHOU-PC)(USER=xuzhou)))(ADDRESS=(PROTOCOL=TCP)(HOST=fe80::1c8a:30b0:3f

57:fe97%25)(PORT=1521)))

Accepted NS version number is: 314.

Global options for the connection:

Don't care

Accepted maximum SDU size: 8192

Accepted maximum TDU size: 32767

Connect data length: 0

Native Services wanted

Authentication is linked and specify

NAU doing O3LOGON - DH key foldedin

Native Services wanted

Authentication is linked and specify

NAU doing O3LOGON - DH key foldedin

---> Send 168 bytes - Data packet timestamp=28-4月 -2017 21:20:51:715

Native Services negotiation packet version#: 0

Service data packet #0 for Supervisor has 3 subpackets

Subpacket #0: Version #186646784

Subpacket #1: 0000000000000000

Subpacket #2: DEADBEEF0003000000040004000100010002

Service data packet #1 for Authentication has 5 subpackets

Subpacket #0: Version #186646784

Subpacket #1: UB2: 57569

Subpacket #2: FCFF

Subpacket #3: UB1: 1

Subpacket #4: NTS

Service data packet #2 for Encryption has 2 subpackets

Subpacket #0: Version #186646784

Subpacket #1: 000000000000000000000000

Service data packet #3 for Data Integrity has 2 subpackets

Subpacket #0: Version #186646784

Subpacket #1: 000000

Native Services negotiation packet version#: 0

Service data packet #0 for Supervisor has 3 subpackets

Subpacket #0: Version #186646784

Subpacket #1: 0000

Subpacket #2: DEADBEEF00030000000200040001

Service data packet #1 for Authentication has 7 subpackets

Subpacket #0: Version #186646784

Subpacket #1: FAFF

Subpacket #2: UB1: 1

Subpacket #3: NTS

Subpacket #4: Version #33554432

Subpacket #5: UB4: 0

Subpacket #6: UB4: 0

Service data packet #2 for Encryption has 2 subpackets

Subpacket #0: Version #186646784

Subpacket #1: UB1: 0

Service data packet #3 for Data Integrity has 2 subpackets

Subpacket #0: Version #186646784

Subpacket #1: UB1: 0

---> Send 157 bytes - Data packet timestamp=28-4月 -2017 21:20:51:762

Native Services negotiation packet version#: 0

Service data packet #0 for Authentication has 7 subpackets

Subpacket #0: Version #33554432

Subpacket #1: UB4: 0

Subpacket #2: UB4: 0

Subpacket #3: 0200000004000000010000000000000000000000

Subpacket #4: 00000000

Subpacket #5: 3A000000

Subpacket #6: 4E544C4D535350000100000007B208A2090009003100000009000900280000000601B11D0000000F58555A484F552D5043574F524B47524F5550

Native Services negotiation packet version#: 0

Service data packet #0 for Authentication has 2 subpackets

Subpacket #0: B2000000

Subpacket #1: 4E544C4D5353500002000000120012003800000005C28AA2F723026BD2951B8FA014C00100000000680068004A0000000601B11D0000000F580055005A0048004F0055002D005000430002001200580055005A0048004F0055002D005000430001001200580055005A0048004F0055002D005000430004001200780075007A0068006F0075002D005000430003001200780075007A0068006F0075002D005000430007000800FA8F1A4222C0D20100000000

---> Send 131 bytes - Data packet timestamp=28-4月 -2017 21:20:51:777

Native Services negotiation packet version#: 0

Service data packet #0 for Authentication has 2 subpackets

Subpacket #0: 58000000

Subpacket #1: 4E544C4D535350000300000000000000580000000000000058000000000000005800000000000000580000000000000058000000000000005800000005C288A20601B11D0000000F8467D273A41C7A5595B99D488E284FD7

---> Send 39 bytes - Data packet timestamp=28-4月 -2017 21:20:51:793

Set protocol (TTIPRO)

Operation 01 (con) Send protocol version=6

Originating platform: IBMPC/WIN_NT64-9.1.0

Set protocol (TTIPRO)

Operation 01 (con) Receive protocol version=6

Destination platform: IBMPC/WIN_NT64-9.1.0

---> Send 81 bytes - Data packet timestamp=28-4月 -2017 21:20:51:824

Set datatypes (TTIDTY)

---> Send 248 bytes - Data packet timestamp=28-4月 -2017 21:20:51:824

---> Send 1393 bytes - Data packet timestamp=28-4月 -2017 21:20:51:840

---> Send 60 bytes - Data packet timestamp=28-4月 -2017 21:20:51:871

---> Send 280 bytes - Data packet timestamp=28-4月 -2017 21:20:51:871

---> Send 21 bytes - Data packet timestamp=28-4月 -2017 21:20:51:887

---> Send 386 bytes - Data packet timestamp=28-4月 -2017 21:20:51:887

---> Send 362 bytes - Data packet timestamp=28-4月 -2017 21:20:51:887

---> Send 36 bytes - Data packet timestamp=28-4月 -2017 21:20:51:902

---> Send 13 bytes - Data packet timestamp=28-4月 -2017 21:20:51:902

---> Send 13 bytes - Data packet timestamp=28-4月 -2017 21:41:31:360

---> Send 10 bytes - Data packet timestamp=28-4月 -2017 21:41:31:376

Data Packet flags:

End of file

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

跟踪文件统计数据:

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

开始时间戳: 28-4月 -2017 21:20:22:134

结束时间戳: 28-4月 -2017 21:41:31:376

会话总数: 3

数据库:

操作计数: 打开次数 0, 语法分析次数 0, 执行次数 0, 提取次数 0

ORACLE NET SERVICES:

总调用数: 已发送 34 个, 已接收 27 个, 0 oci

总字节数: 已发送 6168 字节, 已接收 6138 字节

平均字节数: 每包发送 181 字节, 每包接收 227 字节

最大字节数: 已发送 1393 字节, 已接收 1156 字节

总计包数: 已发送 34 个, 已接收 27 个

*************************************************************************

* Trace Assistant 已经完成 *

*************************************************************************

天日可人

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
重新安装oracle监听,求助：数据库重装后监听一顿问题

起因：笔记本上数据库原本运行的好好的，安装了avg杀毒软件后，监听不能正常工作，将avg停用后，监听恢复正常，卸载avg杀毒软件，没卸载干净，这下数据库的监听也彻底不能工作了。原因一通找，实在解决不了，于是重装数据库。重新安装碰到的问题，提示如下：enterprise manager 配置失败监听程序未启动或数据库服务未注册到该监听程序。启动该监听程序并注册数据库服务，然后重新运行 EM conf...
复制链接

扫一扫