楼主: amirons

oracle 11g 耗尽分配内存,连接中断问题

[复制链接]
论坛徽章:
18
秀才
日期:2017-06-14 16:27:23ITPUB18周年纪念章
日期:2018-09-17 10:12:57ITPUB18周年纪念章
日期:2018-09-17 10:09:49秀才
日期:2018-06-21 10:08:00秀才
日期:2018-04-08 14:48:31秀才
日期:2018-04-08 14:37:33秀才
日期:2017-12-12 09:50:56秀才
日期:2017-12-12 09:50:10秀才
日期:2017-12-12 09:49:20秀才
日期:2017-09-18 17:33:59
11#
发表于 2017-2-25 13:58 | 只看该作者
amirons 发表于 2017-2-25 13:24
谢谢。防火墙为关闭状态。与外网连接的网站也已经拔掉。重新启动数据库实例的时候,该进程直接跳到最大内 ...

你的系统是不会是win32的吧?是win2008R2,还是win2012 R2?系统都打补丁了吗?内存是单通道还是双通道,是单根还是双根?内核参数是多少?

使用道具 举报

回复
论坛徽章:
0
12#
 楼主| 发表于 2017-2-25 22:31 | 只看该作者
kasabulanka888 发表于 2017-2-25 13:58
你的系统是不会是win32的吧?是win2008R2,还是win2012 R2?系统都打补丁了吗?内存是单通道还是双通道,是 ...

操作系统是Windows server 2012 R2 standard 不清楚呢,现在觉得不是内存问题。因为重启后,内存和CPU没什么变化,且能连接上数据库。但是还是只能维持一天多时间。还是没有找到问题的根本。

使用道具 举报

回复
论坛徽章:
18
秀才
日期:2017-06-14 16:27:23ITPUB18周年纪念章
日期:2018-09-17 10:12:57ITPUB18周年纪念章
日期:2018-09-17 10:09:49秀才
日期:2018-06-21 10:08:00秀才
日期:2018-04-08 14:48:31秀才
日期:2018-04-08 14:37:33秀才
日期:2017-12-12 09:50:56秀才
日期:2017-12-12 09:50:10秀才
日期:2017-12-12 09:49:20秀才
日期:2017-09-18 17:33:59
13#
发表于 2017-2-25 23:15 | 只看该作者
本帖最后由 kasabulanka888 于 2017-2-25 23:17 编辑

兄弟,看32位或64位你至少百度一下吧,,汉!快查下
1.很奇怪你们不用linux系统,重点看一下 监听的service,
2.查看一下事件查看器中有什么异常,不懂的快发出来
3.另外在你电脑管理上,新建一下数据收器集,把监听相关信息单独收一下

你们IT经理人不错,要是我们公司,我们经理早拿 大刀来砍人了,哈哈,快点动手吧,别停下,即使现在没有查到原因,也要有这份责任心,让老板认为你是可以的,至少你是在努力!

使用道具 举报

回复
论坛徽章:
0
14#
 楼主| 发表于 2017-2-26 08:52 | 只看该作者
kasabulanka888 发表于 2017-2-25 23:15
兄弟,看32位或64位你至少百度一下吧,,汉!快查下
1.很奇怪你们不用linux系统,重点看一下 监听的service,
2 ...

系统64位,监听service一直开启。重启监听,重新配置监听都试过,不管用。liux系统太难用了。

使用道具 举报

回复
论坛徽章:
0
15#
 楼主| 发表于 2017-2-26 08:53 | 只看该作者
kasabulanka888 发表于 2017-2-25 23:15
兄弟,看32位或64位你至少百度一下吧,,汉!快查下
1.很奇怪你们不用linux系统,重点看一下 监听的service,
2 ...

事件查看器看系统的还是应用的?

使用道具 举报

回复
论坛徽章:
0
16#
 楼主| 发表于 2017-2-26 10:22 | 只看该作者
kasabulanka888 发表于 2017-2-25 23:15
兄弟,看32位或64位你至少百度一下吧,,汉!快查下
1.很奇怪你们不用linux系统,重点看一下 监听的service,
2 ...

这是一些事件查看器,其中在listener.ora中的报错TNS-12531,我试过在c:\windows\system32\drivers\etc\hosts文件中添加IP及hostname,但是也不见效。请多帮忙,谢谢

1.png (56.27 KB, 下载次数: 31)

1.png

2.png (157.8 KB, 下载次数: 39)

2.png

3.png (149.48 KB, 下载次数: 38)

3.png

4.png (161.08 KB, 下载次数: 30)

4.png

5.png (150.28 KB, 下载次数: 33)

5.png

6.png (177.01 KB, 下载次数: 31)

6.png

7.png (150.03 KB, 下载次数: 22)

7.png

8.png (154.9 KB, 下载次数: 31)

8.png

使用道具 举报

回复
论坛徽章:
18
秀才
日期:2017-06-14 16:27:23ITPUB18周年纪念章
日期:2018-09-17 10:12:57ITPUB18周年纪念章
日期:2018-09-17 10:09:49秀才
日期:2018-06-21 10:08:00秀才
日期:2018-04-08 14:48:31秀才
日期:2018-04-08 14:37:33秀才
日期:2017-12-12 09:50:56秀才
日期:2017-12-12 09:50:10秀才
日期:2017-12-12 09:49:20秀才
日期:2017-09-18 17:33:59
17#
发表于 2017-2-26 13:00 | 只看该作者
本帖最后由 kasabulanka888 于 2017-2-26 13:02 编辑
amirons 发表于 2017-2-26 10:22
这是一些事件查看器,其中在listener.ora中的报错TNS-12531,我试过在c:\windows\system32\drivers\etc\h ...

TNS-12531问题已经明显了,两种原因可能性大
1.PGA太小
2.host未配置主机IP和Hostname
3.内核 有一定机率。未知原因
这个在windows下面把hosts用记事本打下,添加你的主机名称和IP地址
C:\Windows\System32\drivers\etc/
hosts文件修改
格式 192.168.1.XX HOSTNAME


修改后要重启生效,如果OK了,记得回复下!

使用道具 举报

回复
论坛徽章:
0
18#
 楼主| 发表于 2017-2-26 17:12 | 只看该作者
kasabulanka888 发表于 2017-2-26 13:00
TNS-12531问题已经明显了,两种原因可能性大
1.PGA太小
2.host未配置主机IP和Hostname

谢谢你的回复。PGA我查过,是够大的,因为是新安装的,没有什么数据。HOST文件的修改一早就试过了,只是没有重启电脑,只是重启了listener服务,但是没有达到连接的目的。如果不在hosts文件添加 IP地址 HOSTNAME的话,直接重启电脑可以连接数据库,这是什么原因呢?至于内核问题对我来说太深了,不理解。现在已经修改了hosts文件,并重启了电脑。静等问题再次出现。

使用道具 举报

回复
论坛徽章:
18
秀才
日期:2017-06-14 16:27:23ITPUB18周年纪念章
日期:2018-09-17 10:12:57ITPUB18周年纪念章
日期:2018-09-17 10:09:49秀才
日期:2018-06-21 10:08:00秀才
日期:2018-04-08 14:48:31秀才
日期:2018-04-08 14:37:33秀才
日期:2017-12-12 09:50:56秀才
日期:2017-12-12 09:50:10秀才
日期:2017-12-12 09:49:20秀才
日期:2017-09-18 17:33:59
19#
发表于 2017-2-27 08:15 | 只看该作者
amirons 发表于 2017-2-26 17:12
谢谢你的回复。PGA我查过,是够大的,因为是新安装的,没有什么数据。HOST文件的修改一早就试过了,只是 ...

还想再出现问题啊!哈哈,应该不不会出现了!自已去学习一下监听与Hostname的重要关系吧!谢谢!

使用道具 举报

回复
论坛徽章:
0
20#
 楼主| 发表于 2017-2-27 19:42 | 只看该作者
kasabulanka888 发表于 2017-2-25 09:07
1.最好有第三方专业的监控performance 工具,如果没有,楼主把windows自带的资源监视器打开和pefromance mo ...

问题果然再度出现了,查看了下listener.log发现port有变动的痕迹,这是端口的正常现象吗?我在客户端电脑安装oracle client配置local net service name configuration并增加监听后再度报错TNS-12531。求解啊。期待你的回复,谢谢。
Sun Feb 26 16:39:33 2017
26-FEB-2017 16:39:33 * (CONNECT_DATA=(SID=wattra)(CID=(PROGRAM=watson.exe)(HOST=LC-MS-03)(USER=wangwenju))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.166)(PORT=49324)) * establish * wattra * 0
Sun Feb 26 16:39:58 2017
26-FEB-2017 16:39:58 * (CONNECT_DATA=(SID=wattra)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.166)(PORT=49336)) * establish * wattra * 0
26-FEB-2017 16:39:58 * (CONNECT_DATA=(SID=wattra)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.166)(PORT=49337)) * establish * wattra * 0
Sun Feb 26 16:41:04 2017
26-FEB-2017 16:41:04 * (CONNECT_DATA=(SID=watval)(CID=(PROGRAM=watson.exe)(HOST=LC-MS-03)(USER=wangwenju))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.166)(PORT=49339)) * establish * watval * 0
26-FEB-2017 16:41:10 * (CONNECT_DATA=(SID=watpro)(CID=(PROGRAM=watson.exe)(HOST=LC-MS-03)(USER=wangwenju))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.166)(PORT=49340)) * establish * watpro * 0
Sun Feb 26 17:03:44 2017
26-FEB-2017 17:03:44 * (CONNECT_DATA=(SID=wattra)(CID=(PROGRAM=watson.exe)(HOST=LC-MS-04-PC)(USER=liudongbo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.115)(PORT=50546)) * establish * wattra * 0
Sun Feb 26 17:30:18 2017
26-FEB-2017 17:30:18 * (CONNECT_DATA=(SID=wattra)(CID=(PROGRAM=watson.exe)(HOST=LC-MS-05)(USER=WangWenju))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.104)(PORT=49453)) * establish * wattra * 0
Sun Feb 26 17:30:50 2017
26-FEB-2017 17:30:50 * (CONNECT_DATA=(SID=wattra)(CID=(PROGRAM=watson.exe)(HOST=LC-MS-04-PC)(USER=liudongbo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.115)(PORT=50550)) * establish * wattra * 0
Sun Feb 26 17:33:35 2017
26-FEB-2017 17:33:35 * (CONNECT_DATA=(SERVICE_NAME=wattra)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=50652)) * establish * wattra * 0
Mon Feb 27 09:21:58 2017
27-FEB-2017 09:21:58 * ping * 0
Mon Feb 27 09:22:28 2017
27-FEB-2017 09:22:28 * (CONNECT_DATA=(SERVICE_NAME=wattra)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=54530)) * establish * wattra * 0
Mon Feb 27 09:23:06 2017
27-FEB-2017 09:23:06 * (CONNECT_DATA=(SID=wattra)(CID=(PROGRAM=watson.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=54533)) * establish * wattra * 0
Mon Feb 27 09:25:14 2017
27-FEB-2017 09:25:14 * (CONNECT_DATA=(SID=watpro)(CID=(PROGRAM=watson.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=54553)) * establish * watpro * 0
Mon Feb 27 09:45:24 2017
27-FEB-2017 09:45:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=watpro)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=54628)) * establish * watpro * 0
Mon Feb 27 09:46:15 2017
27-FEB-2017 09:46:15 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=watpro)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=54632)) * establish * watpro * 0
Mon Feb 27 09:51:25 2017
27-FEB-2017 09:51:25 * (CONNECT_DATA=(SERVICE_NAME=wattra)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=54648)) * establish * wattra * 0
Mon Feb 27 09:55:08 2017
27-FEB-2017 09:55:08 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Mon Feb 27 09:58:58 2017
27-FEB-2017 09:58:58 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=watval)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=54677)) * establish * watval * 0
Mon Feb 27 09:59:27 2017
27-FEB-2017 09:59:27 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=watval)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=54680)) * establish * watval * 0
27-FEB-2017 09:59:29 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=watval)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=54682)) * establish * watval * 0
27-FEB-2017 09:59:34 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=watval)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=54685)) * establish * watval * 0
Mon Feb 27 10:00:19 2017
27-FEB-2017 10:00:19 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Mon Feb 27 10:06:03 2017
27-FEB-2017 10:06:03 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=watval)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=54718)) * establish * watval * 0
Mon Feb 27 10:49:02 2017
27-FEB-2017 10:49:02 * (CONNECT_DATA=(SID=wattra)(CID=(PROGRAM=watson.exe)(HOST=LC-MS-05)(USER=WangWenju))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.104)(PORT=49497)) * establish * wattra * 0
Mon Feb 27 10:49:43 2017
27-FEB-2017 10:49:43 * (CONNECT_DATA=(SID=wattra)(CID=(PROGRAM=watson.exe)(HOST=LC-MS-05)(USER=WangWenju))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.104)(PORT=49511)) * establish * wattra * 0
Mon Feb 27 10:54:02 2017
27-FEB-2017 10:54:02 * (CONNECT_DATA=(SID=watval)(CID=(PROGRAM=watson.exe)(HOST=LC-MS-06)(USER=liudongbo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.119)(PORT=49415)) * establish * watval * 0
Mon Feb 27 10:55:56 2017
27-FEB-2017 10:55:56 * (CONNECT_DATA=(SID=wattra)(CID=(PROGRAM=watson.exe)(HOST=LC-MS-06)(USER=liudongbo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.119)(PORT=49416)) * establish * wattra * 0
Mon Feb 27 10:58:31 2017
27-FEB-2017 10:58:31 * (CONNECT_DATA=(SID=wattra)(CID=(PROGRAM=watson.exe)(HOST=LC-MS-05)(USER=WangWenju))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.104)(PORT=49531)) * establish * wattra * 0
Mon Feb 27 10:59:35 2017
27-FEB-2017 10:59:35 * (CONNECT_DATA=(SID=wattra)(CID=(PROGRAM=watson.exe)(HOST=LC-MS-05)(USER=WangWenju))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.104)(PORT=49533)) * establish * wattra * 0
Mon Feb 27 11:00:15 2017
27-FEB-2017 11:00:15 * (CONNECT_DATA=(SID=watpro)(CID=(PROGRAM=watson.exe)(HOST=LC-MS-06)(USER=liudongbo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.119)(PORT=49417)) * establish * watpro * 0
Mon Feb 27 11:01:11 2017
27-FEB-2017 11:01:11 * (CONNECT_DATA=(SID=watval)(CID=(PROGRAM=watson.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=54898)) * establish * watval * 0
Mon Feb 27 11:01:26 2017
27-FEB-2017 11:01:26 * (CONNECT_DATA=(SID=watpro)(CID=(PROGRAM=watson.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=54911)) * establish * watpro * 0
Mon Feb 27 11:55:39 2017
27-FEB-2017 11:55:39 * (CONNECT_DATA=(SID=wattra)(CID=(PROGRAM=watson.exe)(HOST=LC-MS-05)(USER=WangWenju))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.104)(PORT=49546)) * establish * wattra * 0
27-FEB-2017 11:55:42 * (CONNECT_DATA=(SID=watval)(CID=(PROGRAM=watson.exe)(HOST=LC-MS-05)(USER=WangWenju))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.104)(PORT=49547)) * establish * watval * 0
Mon Feb 27 12:12:56 2017
27-FEB-2017 12:12:56 * (CONNECT_DATA=(SID=wattra)(CID=(PROGRAM=watson.exe)(HOST=LC-MS-05)(USER=WangWenju))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.104)(PORT=49571)) * establish * wattra * 0
Mon Feb 27 12:14:28 2017
27-FEB-2017 12:14:28 * (CONNECT_DATA=(SID=wattra)(CID=(PROGRAM=watson.exe)(HOST=LC-MS-06)(USER=wangwenju))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.119)(PORT=49422)) * establish * wattra * 0
Mon Feb 27 13:17:36 2017
27-FEB-2017 13:17:36 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=watpro)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=55342)) * establish * watpro * 0
Mon Feb 27 13:17:48 2017
27-FEB-2017 13:17:48 * (CONNECT_DATA=(SERVICE_NAME=wattra)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=55344)) * establish * wattra * 0
Mon Feb 27 13:22:35 2017
27-FEB-2017 13:22:35 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=watval)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=55359)) * establish * watval * 0
Mon Feb 27 13:22:55 2017
27-FEB-2017 13:22:55 * (CONNECT_DATA=(SERVICE_NAME=wattra)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=55361)) * establish * wattra * 0
Mon Feb 27 13:24:27 2017
27-FEB-2017 13:24:27 * (CONNECT_DATA=(SERVICE_NAME=wattra)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=55367)) * establish * wattra * 0
Mon Feb 27 13:24:51 2017
27-FEB-2017 13:24:51 * (CONNECT_DATA=(SERVICE_NAME=wattra)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=55369)) * establish * wattra * 0
27-FEB-2017 13:24:53 * (CONNECT_DATA=(SERVICE_NAME=wattra)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=55371)) * establish * wattra * 0
27-FEB-2017 13:24:58 * (CONNECT_DATA=(SERVICE_NAME=wattra)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=SERVER_WATSON)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.123)(PORT=55374)) * establish * wattra * 0
Mon Feb 27 13:42:06 2017
27-FEB-2017 13:42:06 * (CONNECT_DATA=(SID=wattra)(CID=(PROGRAM=odbcad32.exe)(HOST=CT-703-01)(USER=WinNonlin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.113)(PORT=58397)) * establish * wattra * 0
Mon Feb 27 13:47:42 2017
27-FEB-2017 13:47:42 * (CONNECT_DATA=(SID=wattra)(CID=(PROGRAM=watson.exe)(HOST=CT-703-01)(USER=WinNonlin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.113)(PORT=58436)) * establish * wattra * 0
Mon Feb 27 13:49:46 2017
27-FEB-2017 13:49:46 * (CONNECT_DATA=(SID=wattra)(CID=(PROGRAM=watson.exe)(HOST=CT-703-01)(USER=WinNonlin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.113)(PORT=58452)) * establish * wattra * 0
Mon Feb 27 13:59:58 2017
27-FEB-2017 13:59:58 * (CONNECT_DATA=(SID=wattra)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.113)(PORT=58546)) * establish * wattra * 0
Mon Feb 27 14:00:10 2017
27-FEB-2017 14:00:10 * (CONNECT_DATA=(SID=wattra)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.113)(PORT=58548)) * establish * wattra * 0
Mon Feb 27 14:05:57 2017
27-FEB-2017 14:05:57 * (CONNECT_DATA=(SID=wattra)(CID=(PROGRAM=watson.exe)(HOST=CT-703-01)(USER=WinNonlin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.113)(PORT=58579)) * establish * wattra * 0
Mon Feb 27 15:01:15 2017
27-FEB-2017 15:01:15 * (CONNECT_DATA=(SERVICE_NAME=wattra)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\client_1\jdk\jre\bin\java.exe)(HOST=CT-703-01)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.113)(PORT=58718)) * establish * wattra * 0
Mon Feb 27 15:04:10 2017
27-FEB-2017 15:04:10 * (CONNECT_DATA=(SERVICE_NAME=wattra)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\client_1\jdk\jre\bin\java.exe)(HOST=CT-703-01)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.113)(PORT=58731)) * establish * wattra * 0
Mon Feb 27 15:04:27 2017
27-FEB-2017 15:04:27 * (CONNECT_DATA=(SERVICE_NAME=watpro)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\client_1\jdk\jre\bin\java.exe)(HOST=CT-703-01)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.113)(PORT=58734)) * establish * watpro * 0
Mon Feb 27 15:04:43 2017
27-FEB-2017 15:04:43 * (CONNECT_DATA=(SERVICE_NAME=wattra)(CID=(PROGRAM=E:\app\Administrator\product\11.2.0\client_1\jdk\jre\bin\java.exe)(HOST=CT-703-01)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.113)(PORT=58736)) * establish * wattra * 0
Mon Feb 27 15:14:55 2017
27-FEB-2017 15:14:55 * 12531
TNS-12531: TNS:cannot allocate memory
Mon Feb 27 15:16:37 2017
27-FEB-2017 15:16:37 * 12531
TNS-12531: TNS:cannot allocate memory
Mon Feb 27 15:23:08 2017
27-FEB-2017 15:23:08 * 12531
TNS-12531: TNS:cannot allocate memory
Mon Feb 27 16:54:27 2017
27-FEB-2017 16:54:27 * 12531
TNS-12531: TNS:cannot allocate memory
Mon Feb 27 16:55:56 2017
27-FEB-2017 16:55:56 * 12531
TNS-12531: TNS:cannot allocate memory
Mon Feb 27 16:57:45 2017
27-FEB-2017 16:57:45 * 12531
TNS-12531: TNS:cannot allocate memory
Mon Feb 27 16:59:31 2017
27-FEB-2017 16:59:31 * 12531
TNS-12531: TNS:cannot allocate memory
Mon Feb 27 17:02:34 2017
27-FEB-2017 17:02:34 * 12531
TNS-12531: TNS:cannot allocate memory

使用道具 举报

回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 未成年人举报专区 
京ICP备16024965号-8  北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表