(转)测试备库应用主库日志时有无using current logfile选项的区别 [复制链接]

原文 http://www.itpub.net/thread-1810379-1-1.html

测试备库应用主库日志时,alter database recover managed standby database语句中,有无using current logfile选项的区别


一、配置信息
库版本:11.2.0.1
DG保护模式:最大性能
DG配置方式:物理备库 LGWR ASYNC

详细如下:
主库配置信息:
[oracle@db u01]$ sqlplus / as sysdba
–库版本11.2.0.1
SQL*Plus: Release 11.2.0.1.0 Production on Sat Aug 17 13:31:33 2013
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

–主库状态是open
SQL> select status from v$instance;
STATUS
————
OPEN

–主库配置了standby redo
SQL> select group#,thread#,sequence#,status from v$standby_log;
    GROUP#    THREAD#  SEQUENCE# STATUS
———- ———- ———- ———-
         4          0          0 UNASSIGNED
         5          0          0 UNASSIGNED
         6          0          0 UNASSIGNED
         7          0          0 UNASSIGNED

–主库的配置信息
SQL> set lines 200
SQL> col name for a20
SQL> col value for a100
SQL> select name,value from v$parameter where name in (‘log_archive_dest_1′,’log_archive_dest_2’);
NAME                 VALUE
——————– —————————————————————————————————-
log_archive_dest_1   location=/u01/arclog/ valid_for=(all_logfiles,all_roles) db_unique_name=orcl
log_archive_dest_2   service=db2 lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=db2

–主库的保护模式及open模式
SQL> select protection_mode,database_role,protection_level,open_mode from v$database;
PROTECTION_MODE      DATABASE_ROLE    PROTECTION_LEVEL     OPEN_MODE
——————– —————- ——————– ——————–
MAXIMUM PERFORMANCE  PRIMARY          MAXIMUM PERFORMANCE  READ WRITE


备库配置信息:
[oracle@db2 ~]$ sqlplus / as sysdba
–库版本11.2.0.1
SQL*Plus: Release 11.2.0.1.0 Production on Sat Aug 17 13:36:13 2013
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

–备库状态也是open,11g DG的备库是可以open的
SQL> select status from v$instance;
STATUS
————
OPEN

–备库配置了standby redo
SQL> select group#,thread#,sequence#,status from v$standby_log;
    GROUP#    THREAD#  SEQUENCE# STATUS
———- ———- ———- ———-
         4          1         47 ACTIVE
         5          0          0 UNASSIGNED
         6          0          0 UNASSIGNED
         7          0          0 UNASSIGNED

–备库的配置信息
SQL> set lines 200
SQL> col name for a20
SQL> col value for a100
SQL> select name,value from v$parameter where name in (‘log_archive_dest_1′,’log_archive_dest_2’);
NAME                 VALUE
——————– —————————————————————————————————-
log_archive_dest_1   location=/u01/arclog/  valid_for=(all_logfiles,all_roles)  db_unique_name=db2
log_archive_dest_2   service=orcl lgwr async valid_for=(online_logfiles,primary_role)  db_unique_name=orcl

–备库的保护模式及open模式
SQL> select protection_mode,database_role,protection_level,open_mode from v$database;
PROTECTION_MODE      DATABASE_ROLE    PROTECTION_LEVEL     OPEN_MODE
——————– —————- ——————– ——————–
MAXIMUM PERFORMANCE  PHYSICAL STANDBY MAXIMUM PERFORMANCE  READ ONLY




二、测试备库应用redo时有无using current logfile的区别
1.无using current logfile
备库执行:
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> col name for a50
SQL> col value for a50
SQL> select name,value,datum_time from v$dataguard_stats;
NAME                                               VALUE                                              DATUM_TIME
————————————————– ————————————————– ——————————
transport lag                                      +00 00:00:00                                       08/17/2013 13:57:07
apply lag                                          +00 00:40:55                                       08/17/2013 13:57:07
apply finish time                                  +00 00:00:05.000
estimated startup time                             22
–查出备库跟主库间有40分钟的应用延迟(我在主库执行alter database recover managed standby database cancel;后,去吃饭了)

主库切换一下redo
SQL> alter system archive log current;
System altered.
再查备库与主库的延迟:
SQL> select name,value,datum_time from v$dataguard_stats;
NAME                                               VALUE                                              DATUM_TIME
————————————————– ————————————————– ——————————
transport lag                                      +00 00:00:00                                       08/17/2013 14:01:14
apply lag                                          +00 00:00:21                                       08/17/2013 14:01:14
apply finish time                                  +00 00:00:00.001
estimated startup time                             22
–这次apply lag 是21秒了,我觉得主库切换redo后,备库才会应用日志。我们不切换主库redo,等一小会儿,再查备库与主库的应用延迟
SQL> select name,value,datum_time from v$dataguard_stats;
NAME                                               VALUE                                              DATUM_TIME
————————————————– ————————————————– ——————————
transport lag                                      +00 00:00:00                                       08/17/2013 14:03:45
apply lag                                          +00 00:02:52                                       08/17/2013 14:03:45
apply finish time                                  +00 00:00:01.000
estimated startup time                             22
–这次成了2份52秒了。
主库切换一下redo,备库马上查看跟主库的应用延迟:
SQL> alter system archive log current;
System altered.
以下备库连查了三次:
SQL> select name,value,datum_time from v$dataguard_stats;
NAME                                               VALUE                                              DATUM_TIME
————————————————– ————————————————– ——————————
transport lag                                      +00 00:00:00                                       08/17/2013 14:04:53
apply lag                                          +00 00:03:59                                       08/17/2013 14:04:53
apply finish time                                  +00 00:00:01.000
estimated startup time                             22
SQL> select name,value,datum_time from v$dataguard_stats;
NAME                                               VALUE                                              DATUM_TIME
————————————————– ————————————————– ——————————
transport lag                                      +00 00:00:00                                       08/17/2013 14:04:56
apply lag                                          +00 00:04:01                                       08/17/2013 14:04:56
apply finish time                                  +00 00:00:01.000
estimated startup time                             22
SQL> select name,value,datum_time from v$dataguard_stats;
NAME                                               VALUE                                              DATUM_TIME
————————————————– ————————————————– ——————————
transport lag                                      +00 00:00:00                                       08/17/2013 14:05:03
apply lag                                          +00 00:00:00                                       08/17/2013 14:05:03
apply finish time                                  +00 00:00:00.000
estimated startup time                             22
在主库切换redo后,备库跟主库的延迟没有立即归零,而是在继续增大,这充分证明了在主库切换归档后(此时备库也产生新归档),备库才会开始应用日志。
如果主库一直不切换redo,备库跟主库的差距会越来越大。

也许视图不能说明什么,我们进行DML操作,模拟下实际应用.
主库建张表:
SQL> create table t (id number);
Table created.
主库切日志:
SQL> alter system archive log current;         
System altered.

主库切日志后,备库能查到新建的表:
SQL> select * from t;
        ID
———-
         0
主库插入数据,并提交
SQL> insert into t values (1);
1 row created.
SQL> commit;
Commit complete.

备库能查数据:
SQL> select * from t;
        ID
———-
         0
SQL> select * from t;
        ID
———-
         0
主库提交后,备库查询若干次,都查不到数据!

再查备库与主库的应用延迟:
SQL> select name,value,datum_time from v$dataguard_stats;
NAME                                               VALUE                                              DATUM_TIME
————————————————– ————————————————– ——————————
transport lag                                      +00 00:00:00                                       08/17/2013 14:23:59
apply lag                                          +00 00:02:50                                       08/17/2013 14:23:59
apply finish time                                  +00 00:00:00.001
estimated startup time                             22
备库被主库拉开了2分50秒。

主库再切日志:
SQL> alter system archive log current;         
System altered.
备库能查到了:
SQL> select * from t;   
        ID
———-
         1
呵呵,无using current logfile感觉很像是ARCH ASYNC。


2.有using current logfile
备库先退出应用主库日志:
SQL> alter database recover managed standby database cancel;
Database altered.


备库使用using current logfile方式应用主库日志:
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.


检查备库与主库的应用延迟:
SQL> select name,value,datum_time from v$dataguard_stats;
NAME                                               VALUE                                              DATUM_TIME
————————————————– ————————————————– ——————————
transport lag                                      +00 00:00:00                                       08/17/2013 14:34:54
apply lag                                          +00 00:00:00                                       08/17/2013 14:34:54
apply finish time                                  +00 00:00:00.000
estimated startup time                             22
没用apply lag,而且一直是没有延迟。
SQL> select name,value,datum_time from v$dataguard_stats;
NAME                                               VALUE                                              DATUM_TIME
————————————————– ————————————————– ——————————
transport lag                                      +00 00:00:00                                       08/17/2013 14:35:00
apply lag                                          +00 00:00:00                                       08/17/2013 14:35:00
apply finish time                                  +00 00:00:00.000
estimated startup time                             22

主库插入数据测试:
SQL> insert into t values (2);
1 row created.
SQL> commit;
Commit complete.

无须等主库切换归档,备库很快就就能查到:
SQL> select * from t;
        ID
———-
         1
         2



三、参考官方文档
关于USING CURRENT LOGFILE官方文档有如下解释:
Specify USING BACKUP CONTROLFILE if you want to use a backup control file instead of the current control file.
–备库的控制文件确实是从主库备份来的。
USING CURRENT LOGFILE Clause Specify USING CURRENT LOGFILE to invoke real-time apply, which recovers redo from the standby redo log files as soon as they are written, without requiring them to be archived first at the physical standby database.
–这句写得很明白,大体意思是:指定USING CURRENT LOGFILE会调用实施应用,它从standby redo中还原信息并尽快写到数据文件中,不需要在备库上先归档。
另外在官方文档上还看到了这句话:
FINISH  Specify FINISH to complete applying all available redo data in preparation for a failover.
所以,在failover时,执行alter database recover managed standby database finish;是有必要的。




四、总结
无using current logfile感觉像下面这张图,主库切换日志后,备库才从归档文件挖掘出变化,然后应用到库文件中。


而using current logfile感觉像下面这张图,备库根据接收到的redo信息,实时应用到备库上,即便是最大性能。



测试应用日志usingcurrent

(转)oracle11g dataguard 备库数据同步的检查方法


本文链接:https://blog.csdn.net/ydwheel/article/details/70124908
概述:

一、环境
     主库:
      ip地址:192.168.122.203
      oracle根目录:/data/db/oracle
      SID:qyq
      数据文件路径/data/db/oracle/oradata/qyq
      归档文件路径:/data/db/oracle/archive’

     备库:
      ip地址:192.168.122.204
      oracle根目录:/data/app/oracle
      SID:qyq
      数据文件路径/data/app/oracle/oradata/qyq
      归档文件路径:/data/app/oracle/archive’

二、备库不同步的问题检查方法

1、检查主备两边的序号
select max(sequence#) from v$log;   —检查发现一致

2、备库执行,查看是否有数据未应用
select name,SEQUENCE#,APPLIED from v$archived_log order by sequence#;

select SEQUENCE#,FIRST_TIME,NEXT_TIME ,APPLIED from v$archived_log order by 1;

3、检查备库是否开启实时应用
select recovery_mode from v$archive_dest_status where dest_id=2;

4、检查备库状态
select switchover_status from v$database; –发现状态not allowed 

3、看看进程MRP是否存在
 ps aux|grep mrp      –发现进程不存在

4、如果不存在执行以下:
alter database recover managed standby database using current logfile disconnect;

alter database recover managed standby database disconnect from session;  –后台执行

alter database recover managed standby database –前台执行,执行这个可以看到报错的情况

如果有报错,查看alert日志和log.xml日志 

5、验证是否正常
select process,status from v$managed_standby;
select process,status,sequence# from v$managed_standby;

如果看到mrp0正常

6、以上步骤处理好后,如果数据还不正常,接着处理

关闭备库,接着处理:
把主库上 undotbs01.dbf 文件,物理的重拷到备库机上以前undotbs01.dbf 所在目录下;

$scp /data/oracle/oradata/voip/undotbs01.dbf   192.168.122.204:/data/oracle/oradata/voip

再在主库上重新生成一个standby control file ,拷到备库机上相应目录下,

alter database create standby controlfile as ‘/data/oracle/oradata/voip/qyqdg01.ctl’

$scp /data/oracle/oradata/voip/qyqdg01.ctl   192.168.122.204:/data/oracle/oradata/voip
$ mv qyqdg01.ctl  control01.ctl
$ cp control01.ctl /data/oracle/flash_recovery_area/qyq/
$cd /data/oracle/flash_recovery_area/qyq/
$ mv control01.ctl  control02.ctl

接着
STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;


session恢复完成后,重启打开备库;

alter database open read only;
————————————————
版权声明:本文为CSDN博主「dingding_2017」的原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/ydwheel/article/details/70124908

(转)物理standby database的日常维护

1.停止Standby

select process, status from v$managed_standby; –查看备库是否在应用日志进行恢复

alter database recover managed standby database cancel;
shutdown immediate; 

2.切换到只读模式

—-由shutdown模式切换到只读模式-

——startup nomount;
alter database mount standby database;
alter database open read only;-

—-由应用日志模式切换到只读模式——-alter database recover managed standby database cancel; —

取消日志应用
alter database open read only;

 3.切换回管理恢复模式

startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect from session; — 启动日志应用alter database recover managed standby database using current logfile disconnect from session; 

4.主库和备库之间角色切换

4.1 主库切换为备库
alter database commit to switchover to physical standby;alter database commit to switchover to physical standby with session shutdown;– 主库有会话连接的时候
shutdown immediate
startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect from session; 

4.2 从库切换为主库alter database commit to switchover to primary;
shutdown immediate;
startup
alter system switch logfile; 

5.备库自动使用主库传过来的日志进行恢复

alter database recover automatic standby database; 

6.更改保护模式

alter database set standby database to maximize protection;
alter database set standby database to maximize availability;
alter database set standby database to maximize performancen;

 7.取消自动恢复模式

alter database recover managed standby database cancel;
alter database recover managed standby database finish;
alter database recover managed standby database finish force;

JAVA 代码分析

package com.mingheinfo.common.utils;

import java.io.IOException;
import java.net.ConnectException;
import java.net.InetSocketAddress;
import java.net.SocketAddress;
import java.net.SocketTimeoutException;
import java.nio.ByteBuffer;
import java.nio.CharBuffer;
import java.nio.channels.SelectionKey;
import java.nio.channels.Selector;
import java.nio.channels.SocketChannel;
import java.nio.charset.Charset;
import java.nio.charset.CharsetDecoder;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Scanner;

import org.apache.commons.lang3.StringUtils;

import com.alibaba.fastjson.JSONObject;
import com.mingheinfo.common.json.ApiJson;

public class NIOClient {
private static final int SIZE = 1024;
private String ip = “127.0.0.1”;
private int port = 9501;
private SocketChannel channel=null;
private Selector selector = null;

String encoding = System.getProperty("file.encoding");
Charset charset = Charset.forName(encoding);

public NIOClient() {

}

public NIOClient(String ip,int port) {
    this.ip = ip;
    this.port = port;
}

public boolean connect() throws IOException{
    selector = Selector.open();

    try
    {
        channel = SocketChannel.open();
        InetSocketAddress remote = new InetSocketAddress(this.ip, this.port);

        channel.socket().connect(remote, 3000);
        //channel.connect(remote);


        while(!channel.finishConnect() ){
            System.out.print(".");
        }
    }
    catch(ConnectException e)
    {
        return false;
    }
    catch(SocketTimeoutException e)
    {
        return false;
    }

    System.out.println("connect success!");
    // 设置该sc以非阻塞的方式工作
    channel.configureBlocking(false);

    // 将SocketChannel对象注册到指定的Selector
    // SelectionKey.OP_READ | SelectionKey.OP_WRITE | SelectionKey.OP_CONNECT
    synchronized (selector) {
        channel.register(selector, SelectionKey.OP_READ);//这里注册的是read读,即从服务端读数据过来
    }
    return true;
}   


public boolean connect(String ip,int port) throws IOException{
    selector = Selector.open();

    try
    {
        this.ip  = ip;
        this.port = port;

        channel = SocketChannel.open();
        InetSocketAddress remote = new InetSocketAddress(ip, port);
        channel.connect(remote);
        while(!channel.finishConnect() ){
            System.out.print(".");
        }
    }
    catch(ConnectException e)
    {
        e.printStackTrace();
        return false;
    }

    System.out.println("connect success!");
    // 设置该sc以非阻塞的方式工作
    channel.configureBlocking(false);

    // 将SocketChannel对象注册到指定的Selector
    // SelectionKey.OP_READ | SelectionKey.OP_WRITE | SelectionKey.OP_CONNECT
    channel.register(selector, SelectionKey.OP_READ);//这里注册的是read读,即从服务端读数据过来

    return true;
}

public void reconnect()
{
    try {
        connect();
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
}

public void close() throws IOException
{
    selector.close();
    channel.close();
}

public boolean isConnected()
{
    if(channel==null)
        return false;

    return channel.isConnected();
}

public boolean isOpen()
{
    return channel.isOpen();
}

public static int length(String value) {
    int valueLength = 0;
    String chinese = "[\u0391-\uFFE5]";
    /* 获取字段值的长度,如果含中文字符,则每个中文字符长度为2,否则为1 */
    for (int i = 0; i < value.length(); i++) {
        /* 获取一个字符 */
        String temp = value.substring(i, i + 1);
        /* 判断是否为中文字符 */
        if (temp.matches(chinese)) {
            /* 中文字符长度为2 */
            valueLength += 2;
        } else {
            /* 其他字符长度为1 */
            valueLength += 1;
        }
    }
    return valueLength;
}

/**
 * 客户端发送数据
 * 
 * @param channel
 * @param bytes
 * @throws Exception
 */
protected void sendLen(byte[] bytes) throws IOException {
    ByteBuffer buffer = ByteBuffer.wrap(bytes);
    channel.write(buffer);
}   

protected void sendMsg(byte[] bytes) throws IOException {
    ByteBuffer newBuffer = ByteBuffer.wrap(bytes);

    /*
    CharBuffer cb = Charset.forName("UTF-8").decode(buffer);

    Charset cs = Charset.forName("GB2312");
    ByteBuffer newBuffer = cs.encode(cb);*/

    channel.write(newBuffer);

}

protected synchronized void send(String data) throws IOException {
    int len = length(data);

    System.out.println("Len="+len+" =="+data);
    byte[] size = ByteUtils.int2Bytes(len);
    this.sendLen(size);
    this.sendMsg(data.getBytes("gb2312"));
}

public synchronized String receive(int timeout)
{
    ByteBuffer buffer=ByteBuffer.allocate(200000);//分配缓冲区大小
    StringBuilder result = new StringBuilder();

    int dataLen = 0;
    int recLen = 0;

    try {
            while(selector.select(timeout)>0){//select()方法只能使用一次,用了之后就会自动删除,每个连接到服务器的选择器都是独立的

                //遍历每个有可用IO操作Channel对应的SelectionKey
                for(SelectionKey sk:selector.selectedKeys()){
                    //如果该SelectionKey对应的Channel中有可读的数据
                    if(sk.isReadable()){
                        //使用NIO读取Channel中的数据
                        SocketChannel sc=(SocketChannel)sk.channel();//获取通道信息

                        int ret = sc.read(buffer);//读取通道里面的数据

                        //服务端以断开
                        if(ret==-1)
                        {
                            this.connect();
                            System.out.println("服务器已断开");
                        }

                        buffer.flip();//调用此方法为一系列通道写入或获取操作做好准备 
                        // 将字节转化为为UTF-8的字符串  
                        //String receivedString=Charset.forName("UTF-8").newDecoder().decode(buffer).toString();
                        // 控制台打印出来  
                        //System.out.println("接收到来自服务器" + sc.socket().getRemoteSocketAddress() + "的信息:"  + receivedString);  
                        // 为下一次读取作准备  
                        System.out.println("有数据==============");
                        if(result.length()==0)
                        {
                            dataLen = buffer.getInt(0);

                            if(dataLen>1)
                            {
                                //System.out.println("");
                                System.out.println(dataLen+"===="+buffer.limit());
                                buffer.position(4);
                                recLen=buffer.limit();

                                if(recLen>dataLen)
                                {
                                    buffer.limit(4+dataLen);
                                }

                                result.append(getString(buffer));
                                System.out.println("有数据1=============="+result.toString());
                            }
                            else if(dataLen<1)
                            {

                                System.out.println("有数据x=============="+dataLen);
                                //无数据
                                sk.interestOps(SelectionKey.OP_READ);
                                selector.selectedKeys().remove(sk);
                                ApiJson json=new ApiJson();
                                json.setCode("99");
                                return JSONObject.toJSONString(json);                                   

                            }

                        }
                        else
                        {
                            recLen+=buffer.limit();
                            result.append(getString(buffer));
                            System.out.println("有数据2=============="+result.toString());
                        }

                        buffer.clear();
                        sk.interestOps(SelectionKey.OP_READ);
                    }
                     //删除正在处理的SelectionKey
                    selector.selectedKeys().remove(sk);
                }

                if(dataLen==-1)
                {
                    System.out.println("有数据4=============="+result.toString());
                    break;
                }

                if(recLen>dataLen)
                {
                    buffer.clear();
                    System.out.println("有数据3=============="+result.toString());
                    return result.toString();
                }                   
            }
        } catch (IOException e) {
            e.printStackTrace();
        }

    if(StringUtils.isEmpty(result.toString()))
    {
        ApiJson json=new ApiJson();
        json.setError("-1", "数据接收异常");

        return JSONObject.toJSONString(json);
    }
    return result.toString();       
}

public synchronized void clearBuffer()
{
    ByteBuffer buffer=ByteBuffer.allocate(20000);//分配缓冲区大小

    try {
            while(selector.select(2000)>0){

                //遍历每个有可用IO操作Channel对应的SelectionKey
                for(SelectionKey sk:selector.selectedKeys()){
                    //如果该SelectionKey对应的Channel中有可读的数据
                    if(sk.isReadable()){
                        //使用NIO读取Channel中的数据
                        SocketChannel sc=(SocketChannel)sk.channel();//获取通道信息

                        int ret = sc.read(buffer);//读取通道里面的数据

                        buffer.flip();//调用此方法为一系列通道写入或获取操作做好准备 

                        buffer.clear();
                        sk.interestOps(SelectionKey.OP_READ);

                        System.out.println("=========================有缓存数据=========================");
                    }
                     //删除正在处理的SelectionKey
                    selector.selectedKeys().remove(sk);
                }

            }
        } catch (IOException e) {
            e.printStackTrace();
        }

}

public String getIp() {
    return ip;
}

public void setIp(String ip) {
    this.ip = ip;
}

public int getPort() {
    return port;
}

public void setPort(int port) {
    this.port = port;
}

public static String getString(ByteBuffer buffer)  
{  
    Charset charset = null;  
    CharsetDecoder decoder = null;  
    CharBuffer charBuffer = null;  
    try  
    {  
        charset = Charset.forName("GB2312");  
        //decoder = charset.newDecoder();  
        //charBuffer = decoder.decode(buffer);//用这个的话,只能输出来一次结果,第二次显示为空  

        ByteBuffer dd = buffer.asReadOnlyBuffer();
        charBuffer = charset.decode(dd);  

        return charBuffer.toString();  
    }  
    catch (Exception ex)  
    {  
        ex.printStackTrace();  
        return "";  
    }  
}  

protected void finalize(){
    try {
        channel.close();
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
}

public static void main(String[] args) throws Exception
{
    NIOClient client = new NIOClient();
    try {
        client.connect("10.10.10.199",9501);

        String userName = "admin";
        String password = CryptoUtils.MD5(CryptoUtils.MD5("123456"));
        String msg = String.format("login User=\"%s\" Password=\"%s\"", userName,"6698d0c2522ccc0401d9fada0a57318f");

        System.out.println(msg);

        client.send(msg);
        //String data = client.receiveData();
        //System.out.println("login1="+data);


    } catch (IOException e) {
        e.printStackTrace();
    }


}

}

(转)七种网卡绑定模式详解

版权声明:本文为
PrudentWoo 原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/wuweilong/article/details/39720571
概览:

目前网卡绑定mode共有七种(0~6)bond0、bond1、bond2、bond3、bond4、bond5、bond6

常用的有三种:

mode=0:平衡负载模式,有自动备援,但需要”Switch”支援及设定。

mode=1:自动备援模式,其中一条线若断线,其他线路将会自动备援。

mode=6:平衡负载模式,有自动备援,不必”Switch”支援及设定。

说明:

    需要说明的是如果想做成mode 0的负载均衡,仅仅设置这里optionsbond0 miimon=100 mode=0是不够的,与网卡相连的交换机必须做特殊配置(这两个端口应该采取聚合方式),因为做bonding的这两块网卡是使用同一个MAC地址.从原理分析一下(bond运行在mode0下):

       mode 0下bond所绑定的网卡的IP都被修改成相同的mac地址,如果这些网卡都被接在同一个交换机,那么交换机的arp表里这个mac地址对应的端口就有多 个,那么交换机接受到发往这个mac地址的包应该往哪个端口转发呢?正常情况下mac地址是全球唯一的,一个mac地址对应多个端口肯定使交换机迷惑了。所以 mode0下的bond如果连接到交换机,交换机这几个端口应该采取聚合方式(cisco称为 ethernetchannel,foundry称为portgroup),因为交换机做了聚合后,聚合下的几个端口也被捆绑成一个mac地址.我们的解 决办法是,两个网卡接入不同的交换机即可。

       mode6模式下无需配置交换机,因为做bonding的这两块网卡是使用不同的MAC地址。

七种bond模式说明:

第一种模式:mod=0 ,即:(balance-rr)Round-robin policy(平衡抡循环策略)

特点:传输数据包顺序是依次传输(即:第1个包走eth0,下一个包就走eth1….一直循环下去,直到最后一个传输完毕),此模式提供负载平衡和容错能力;但是我们知道如果一个连接或者会话的数据包从不同的接口发出的话,中途再经过不同的链路,在客户端很有可能会出现数据包无序到达的问题,而无序到达的数据包需要重新要求被发送,这样网络的吞吐量就会下降

第二种模式:mod=1,即: (active-backup)Active-backup policy(主-备份策略)

特点:只有一个设备处于活动状态,当一个宕掉另一个马上由备份转换为主设备。mac地址是外部可见得,从外面看来,bond的MAC地址是唯一的,以避免switch(交换机)发生混乱。此模式只提供了容错能力;由此可见此算法的优点是可以提供高网络连接的可用性,但是它的资源利用率较低,只有一个接口处于工作状态,在有 N 个网络接口的情况下,资源利用率为1/N

第三种模式:mod=2,即:(balance-xor)XOR policy(平衡策略)

特点:基于指定的传输HASH策略传输数据包。缺省的策略是:(源MAC地址 XOR 目标MAC地址)% slave数量。其他的传输策略可以通过xmit_hash_policy选项指定,此模式提供负载平衡和容错能力

第四种模式:mod=3,即:broadcast(广播策略)

特点:在每个slave接口上传输每个数据包,此模式提供了容错能力

第五种模式:mod=4,即:(802.3ad)IEEE 802.3ad Dynamic link aggregation(IEEE802.3ad 动态链接聚合)

特点:创建一个聚合组,它们共享同样的速率和双工设定。根据802.3ad规范将多个slave工作在同一个激活的聚合体下。外出流量的slave选举是基于传输hash策略,该策略可以通过xmit_hash_policy选项从缺省的XOR策略改变到其他策略。需要注意的 是,并不是所有的传输策略都是802.3ad适应的,尤其考虑到在802.3ad标准43.2.4章节提及的包乱序问题。不同的实现可能会有不同的适应 性。

必要条件:

条件1:ethtool支持获取每个slave的速率和双工设定

条件2:switch(交换机)支持IEEE802.3ad Dynamic link aggregation

条件3:大多数switch(交换机)需要经过特定配置才能支持802.3ad模式

第六种模式:mod=5,即:(balance-tlb)Adaptive transmit load balancing(适配器传输负载均衡)

特点:不需要任何特别的switch(交换机)支持的通道bonding。在每个slave上根据当前的负载(根据速度计算)分配外出流量。如果正在接受数据的slave出故障了,另一个slave接管失败的slave的MAC地址。

该模式的必要条件:ethtool支持获取每个slave的速率

第七种模式:mod=6,即:(balance-alb)Adaptive load balancing(适配器适应性负载均衡)

特点:该模式包含了balance-tlb模式,同时加上针对IPV4流量的接收负载均衡(receiveload balance, rlb),而且不需要任何switch(交换机)的支持。接收负载均衡是通过ARP协商实现的。bonding驱动截获本机发送的ARP应答,并把源硬件地址改写为bond中某个slave的唯一硬件地址,从而使得不同的对端使用不同的硬件地址进行通信。

来自服务器端的接收流量也会被均衡。当本机发送ARP请求时,bonding驱动把对端的IP信息从ARP包中复制并保存下来。当ARP应答从对端到达时,bonding驱动把它的硬件地址提取出来,并发起一个ARP应答给bond中的某个slave。使用ARP协商进行负载均衡的一个问题是:每次广播 ARP请求时都会使用bond的硬件地址,因此对端学习到这个硬件地址后,接收流量将会全部流向当前的slave。这个问题可以通过给所有的对端发送更新(ARP应答)来解决,应答中包含他们独一无二的硬件地址,从而导致流量重新分布。当新的slave加入到bond中时,或者某个未激活的slave重新 激活时,接收流量也要重新分布。接收的负载被顺序地分布(roundrobin)在bond中最高速的slave上当某个链路被重新接上,或者一个新的slave加入到bond中,接收流量在所有当前激活的slave中全部重新分配,通过使用指定的MAC地址给每个 client发起ARP应答。下面介绍的updelay参数必须被设置为某个大于等于switch(交换机)转发延时的值,从而保证发往对端的ARP应答 不会被switch(交换机)阻截。

必要条件:

条件1:ethtool支持获取每个slave的速率;

条件2:底层驱动支持设置某个设备的硬件地址,从而使得总是有个slave(curr_active_slave)使用bond的硬件地址,同时保证每个 bond 中的slave都有一个唯一的硬件地址。如果curr_active_slave出故障,它的硬件地址将会被新选出来的 curr_active_slave接管其实mod=6与mod=0的区别:mod=6,先把eth0流量占满,再占eth1,….ethX;而mod=0的话,会发现2个口的流量都很稳定,基本一样的带宽。而mod=6,会发现第一个口流量很高,第2个口只占了小部分流量

Linux网口绑定:

通过网口绑定(bond)技术,可以很容易实现网口冗余,负载均衡,从而达到高可用高可靠的目的。前提约定:

2个物理网口分别是:eth0,eth1

绑定后的虚拟口是:bond0

服务器IP是:10.10.10.1

第一步,配置设定文件:

[root@woo ~]

# vi /etc/sysconfig/network-scripts/ifcfg-bond0
DEVICE=bond0
BOOTPROTO=none
ONBOOT=yes
IPADDR=10.10.10.1
NETMASK=255.255.255.0
NETWORK=192.168.0.0

[root@woo ~]

# vi /etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE=eth0
BOOTPROTO=none
MASTER=bond0
SLAVE=yes

[root@woo ~]

# vi /etc/sysconfig/network-scripts/ifcfg-eth1
DEVICE=eth1
BOOTPROTO=none
MASTER=bond0
SLAVE=yes
第二步,修改modprobe相关设定文件,并加载bonding模块:

1.在这里,我们直接创建一个加载bonding的专属设定文件/etc/modprobe.d/bonding.conf

[root@woo ~]

# vi /etc/modprobe.d/bonding.conf
alias bond0 bonding
options bonding mode=0 miimon=200

2.加载模块(重启系统后就不用手动再加载了)

[root@woo ~]

# modprobe bonding

3.确认模块是否加载成功:

[root@woo ~]

# lsmod | grep bonding
bonding 100065 0
第三步,重启一下网络,然后确认一下状况:

[root@db01 ~]

# service network restart
Shutting down interface bond0: [ OK ]
Shutting down loopback interface: [ OK ]
Bringing up loopback interface: [ OK ]
Bringing up interface bond0: [ OK ]

[root@db01 ~]

# cat /proc/net/bonding/bond0
Ethernet Channel Bonding Driver: v3.4.0-1 (October 7, 2008)

Bonding Mode: fault-tolerance (active-backup)
Primary Slave: None
Currently Active Slave: eth0
MII Status: up
MII Polling Interval (ms): 100
Up Delay (ms): 0
Down Delay (ms): 0

Slave Interface: eth0
MII Status: up
Speed: 1000 Mbps
Duplex: full
Link Failure Count: 0
Permanent HW addr: 40:f2:e9:db:c9:c2

Slave Interface: eth1
MII Status: up
Speed: 1000 Mbps
Duplex: full
Link Failure Count: 0
Permanent HW addr: 40:f2:e9:db:c9:c3

[root@db01 ~]

# ifconfig | grep HWaddr
bond0 Link encap:Ethernet HWaddr 40:F2:E9:DB:C9:C2
eth0 Link encap:Ethernet HWaddr 40:F2:E9:DB:C9:C2
eth1 Link encap:Ethernet HWaddr 40:F2:E9:DB:C9:C2
从上面的确认信息中,我们可以看到3个重要信息:

1.现在的bonding模式是active-backup

2.现在Active状态的网口是eth0

3.bond0,eth1的物理地址和处于active状态下的eth0的物理地址相同,这样是为了避免上位交换机发生混乱。

任意拔掉一根网线,然后再访问你的服务器,看网络是否还是通的。

第四步,系统启动自动绑定、增加默认网关:

[root@woo ~]

# vi /etc/rc.d/rc.local

追加

ifenslave bond0 eth0 eth1
route add default gw 10.10.10.1

如可上网就不用增加路由,0.1地址按环境修改.


留心:前面只是2个网口绑定成一个bond0的情况,如果我们要设置多个bond口,比如物理网口eth0和eth1组成bond0,eth2和eth3组成bond1,

多网口绑定:

那么网口设置文件的设置方法和上面第1步讲的方法相同,只是/etc/modprobe.d/bonding.conf的设定就不能像下面这样简单的叠加了:

alias bond0 bonding

options bonding mode=1 miimon=200

alias bond1 bonding

options bonding mode=1 miimon=200

正确的设置方法有2种:

第一种,你可以看到,这种方式的话,多个bond口的模式就只能设成相同的了:

alias bond0 bonding alias bond1 bonding options bonding max_bonds=2 miimon=200 mode=1
第二种,这种方式,不同的bond口的mode可以设成不一样:

alias bond0 bonding options bond0 miimon=100 mode=1 install bond1 /sbin/modprobe bonding -o bond1 miimon=200 mode=0
 

仔细看看上面这2种设置方法,现在如果是要设置3个,4个,甚至更多的bond口,你应该也会了吧!

后记:

简单的介绍一下上面在加载bonding模块的时候,options里的一些参数的含义:

miimon 监视网络链接的频度,单位是毫秒,我们设置的是200毫秒。

max_bonds 配置的bond口个数

mode bond模式,主要有以下几种,在一般的实际应用中,0和1用的比较多。
————————————————
版权声明:本文为CSDN博主「PrudentWoo」的原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/wuweilong/article/details/39720571

(转)Linux查看实时网卡流量的几种方式


来源  https://www.jianshu.com/p/b9e942f3682c

在工作中,我们经常需要查看服务器的实时网卡流量。通常,我们会通过这几种方式查看Linux服务器的实时网卡流量。

1. sar -n DEV 1 2

sar命令包含在sysstat工具包中,提供系统的众多统计数据。其在不同的系统上命令有些差异,某些系统提供的sar支持基于网络接口的数据统计,也可以查看设备上每秒收发包的个数和流量。

 sar –n DEV  1 2 

命令后面1 2 意思是:每一秒钟取1次值,取2次。

DEV显示网络接口信息

另外,-n参数很有用,他有6个不同的开关:DEV | EDEV | NFS | NFSD | SOCK | ALL ,其代表的含义如下:

  • DEV显示网络接口信息。
  • EDEV显示关于网络错误的统计数据。
  • NFS统计活动的NFS客户端的信息。
  • NFSD统计NFS服务器的信息
  • SOCK显示套接字信息
  • ALL显示所有5个开关
[sre@CDVM-213017031 ~]$ sar -n DEV 1 2
Linux 2.6.32-431.el6.x86_64 (CDVM-213017031)    05/04/2017  _x86_64_    (4 CPU)

08:05:30 PM     IFACE   rxpck/s   txpck/s    rxkB/s    txkB/s   rxcmp/s   txcmp/s  rxmcst/s
08:05:31 PM        lo      0.00      0.00      0.00      0.00      0.00      0.00      0.00
08:05:31 PM      eth0   1788.00   1923.00    930.47    335.60      0.00      0.00      0.00

08:05:31 PM     IFACE   rxpck/s   txpck/s    rxkB/s    txkB/s   rxcmp/s   txcmp/s  rxmcst/s
08:05:32 PM        lo      0.00      0.00      0.00      0.00      0.00      0.00      0.00
08:05:32 PM      eth0   1387.00   1469.00    652.12    256.98      0.00      0.00      0.00

Average:        IFACE   rxpck/s   txpck/s    rxkB/s    txkB/s   rxcmp/s   txcmp/s  rxmcst/s
Average:           lo      0.00      0.00      0.00      0.00      0.00      0.00      0.00
Average:         eth0   1587.50   1696.00    791.29    296.29      0.00      0.00      0.00

参数说明:

  • IFACE:LAN接口
  • rxpck/s:每秒钟接收的数据包
  • txpck/s:每秒钟发送的数据包
  • rxbyt/s:每秒钟接收的字节数
  • txbyt/s:每秒钟发送的字节数
  • rxcmp/s:每秒钟接收的压缩数据包
  • txcmp/s:每秒钟发送的压缩数据包
  • rxmcst/s:每秒钟接收的多播数据包
  • rxerr/s:每秒钟接收的坏数据包
  • txerr/s:每秒钟发送的坏数据包
  • coll/s:每秒冲突数
  • rxdrop/s:因为缓冲充满,每秒钟丢弃的已接收数据包数
  • txdrop/s:因为缓冲充满,每秒钟丢弃的已发送数据包数
  • txcarr/s:发送数据包时,每秒载波错误数
  • rxfram/s:每秒接收数据包的帧对齐错误数
  • rxfifo/s:接收的数据包每秒FIFO过速的错误数
  • txfifo/s:发送的数据包每秒FIFO过速的错误数

这种方式简单,直观,推荐使用。

2.实时监控脚本

#!/bin/bash

ethn=$1

while true
do
  RX_pre=$(cat /proc/net/dev | grep $ethn | sed 's/:/ /g' | awk '{print $2}')
  TX_pre=$(cat /proc/net/dev | grep $ethn | sed 's/:/ /g' | awk '{print $10}')
  sleep 1
  RX_next=$(cat /proc/net/dev | grep $ethn | sed 's/:/ /g' | awk '{print $2}')
  TX_next=$(cat /proc/net/dev | grep $ethn | sed 's/:/ /g' | awk '{print $10}')

  clear
  echo -e "\t RX `date +%k:%M:%S` TX"

  RX=$((${RX_next}-${RX_pre}))
  TX=$((${TX_next}-${TX_pre}))

  if [[ $RX -lt 1024 ]];then
    RX="${RX}B/s"
  elif [[ $RX -gt 1048576 ]];then
    RX=$(echo $RX | awk '{print $1/1048576 "MB/s"}')
  else
    RX=$(echo $RX | awk '{print $1/1024 "KB/s"}')
  fi

  if [[ $TX -lt 1024 ]];then
    TX="${TX}B/s"
  elif [[ $TX -gt 1048576 ]];then
    TX=$(echo $TX | awk '{print $1/1048576 "MB/s"}')
  else
    TX=$(echo $TX | awk '{print $1/1024 "KB/s"}')
  fi

  echo -e "$ethn \t $RX   $TX "

done

此脚本不需要额外再安装软件,并且可自定义欲查看接口,精确到小数,可根据流量大小灵活显示单位,默认采集间隔为1秒。

用法为:

1、将脚本保存为可执行脚本文件,比如叫netmon.sh。

2、chmod +x ./netmon.sh 将文件改成可执行脚本。

3、sudo ./netmon.sh eth0 即可开始监看接口eth0流量,按ctrl+c退出。

脚本是通过读取运行时文件系统/proc/net/dev中的网络实时数据,并通过简单计算得到的。关于目录/proc/net/dev,请参考下文。

3. cat /proc/net/dev

Linux 内核提供了一种通过 /proc 文件系统,在运行时访问内核内部数据结构、改变内核设置的机制。proc文件系统是一个伪文件系统,它只存在内存当中,而不占用外存空间。它以文件系统的方式为访问系统内核数据的操作提供接口。用户和应用程序可以通过proc得到系统的信息,并可以改变内核的某些参数。由于系统的信息,如进程,是动态改变的,所以用户或应用程序读取proc文件时,proc文件系统是动态从系统内核读出所需信息并提交的。/proc文件系统中包含了很多目录,其中/proc/net/dev 保存了网络适配器及统计信息。

[sre@CDVM-213017031 ~]$ cat /proc/net/dev
Inter-|   Receive                                                |  Transmit
 face |bytes    packets errs drop fifo frame compressed multicast|bytes    packets errs drop fifo colls carrier compressed
    lo:137052296  108029    0    0    0     0          0         0 137052296  108029    0    0    0     0       0          0
  eth0:13661574714188 31346790620    0    0    0     0          0         0 5097461049535 27671144304    0    0    0     0       0          0
  
  最左边的表示接口的名字,Receive表示收包,Transmit表示发送包;
  bytes表示收发的字节数;
  packets表示收发正确的包量;
  errs表示收发错误的包量;
  drop表示收发丢弃的包量;

其实,我们平时经常用的很多查看网卡实时流量的命令,都是通过读取该目录下的实时流量,并通过简单计算得到的。

4. 使用watch命令,配合ifconfig、more /proc/net/dev、cat /proc/net/dev来实时监控。比如执行 watch -n 1 “ifconfig eth0”

Every 1.0s: ifconfig eth0                                                                                                                                    Thu May  4 20:26:45 2017

eth0      Link encap:Ethernet  HWaddr FA:16:3E:7E:55:D1
          inet addr:10.213.17.31  Bcast:10.213.23.255  Mask:255.255.248.0
          inet6 addr: fe80::f816:3eff:fe7e:55d1/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:31350149703 errors:0 dropped:0 overruns:0 frame:0
          TX packets:27674701465 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:13663400883450 (12.4 TiB)  TX bytes:5098104759633 (4.6 TiB)

watch可以帮你监测一个命令的运行结果,省得你一遍遍的手动运行。在Linux下,watch是周期性的执行下个程序,并全屏显示执行结果。

最后,除了上面提供的几种,还有很多种方式可以来看当前系统的网卡流量,我就不再一一复述了,上述方式如果不能满足你的需求,请自行google一下吧。

根据其易用性以及可读性,强烈推荐方法1和方法2。

(转)上云容易出云难:AWS 发出 5000 万美元的巨额云迁移费用账单

业界有句口口相传的话:推动企业上云的第一动力是省成本。2019 年,是企业上云的关键一年,更多的企业掀起了“上云”的热潮,同时云计算的支出也开始备受关注。

有很多方式导致云计算的费用高昂,甚至高的出乎意料。其中有一项支出是将数据从 A 云提供商迁移到 B 云提供商或自己的数据中心所产生的成本,这个成本通常被叫作”数据传输费用“。

the information 给出了一张图,汇总了 Amazon Web Service 上“数据传输费用”最高的 10 家企业。

这张图显示了这 10 家企业在 2017 和 2018 年的“数据传输费用”。其中 Apple 在 2017 年的费用达到 5000 万美元,约占当年云服务总账单 7.75 亿美元的 6.5%。与前一年相比,10 家中有 7 家“数据传输费用”增长了 50% 以上。无法得知为什么这些公司会有这么高的数据传输费用。对于公有云的用户来说,这些高额费用是长期以来一直存在的问题。

AWS,Microsoft 和 Google 允许用户免费将数据上传到云中。但是移出数据产生的“出站费”足以阻止用户产生任何迁出的打算。还有一些其他原因会产生数据传输费用,包括将大量信息移至新服务器所产生的 Internet 服务费。云提供商需要某种方式来弥补用户数据迁移产生的成本,包括网络硬件设备、网络安全服务和网络监控软件等。

这些成本会随着时间流逝而越加明显。比如 Pinterest 的 AWS 数据传输费用为 2,640 万美元,比 2017 年的 1,470 万美元增加了 78%。Airbnb 在 2018 年的数据传输账单比 2017 年增长了 163%,Snap 的数据传输费用增长了 588%。

公司在备份数据时也会产生天价账单。企业会将数据存储在跨区域的多个数据中心里,以确保在服务中断时应用程序仍然可用。还有可能是用户将其部分云业务移出云服务。比如苹果为了确保某些区域的用户获得更好的性能,开始运营自己的云服务,所以它在 2017 年至 2018 年之间大幅缩减了对亚马逊云服务的使用。

大家怎么看

 the information 提供的信息中,有 AWS 专家建议使用 Direct Connect 之类的服务,该服务可以在云和用户的私有数据中心之间建立私有连接,从而减少互联网提供商的带宽费用。同时建议使用内容交付网络服务 CloudFront,可最大程度地减少数据传输的距离。

有犀利的网友指出:

带宽成本的确会让我破产,因此所有的工作我都会用到 Cloudflare。Cloudflare 不收取带宽费用,其首席执行官给出了为何不收费的理由:

建立这些带宽有固定的成本,但是一旦到位,成本就不会增加。这就是为什么我们与 Google,Microsoft,IBM,Digital Ocean 等签订了与 Backblaze 相似的协议的原因。使用 Cloudflare 时,他们不支付带宽费用,我们也不支付带宽费用。

另一位网友表示:

我对定价感到困惑。我们需要的是增加云服务定价的透明度。

现在有越来越多的企业将部分内容从云迁回内部进行混合部署,2010 年之后是“上云”潮流的开始,专家预测 2020 年之后则可能形成混合部署的高峰。那么用户也不得不考虑这些迁移带来的费用,这将对“回迁”带来一定的挑战。

Fatal NI connect error 12170.

Tue Oct 08 09:45:20 2019
Thread 1 advanced to log sequence 50657 (LGWR switch)
Current log# 2 seq# 50657 mem# 0: +DATA/orcl/onlinelog/group_2.300.924253815
Tue Oct 08 09:45:21 2019
LNS: Standby redo logfile selected for thread 1 sequence 50657 for destination LOG_ARCHIVE_DEST_2
Tue Oct 08 09:45:21 2019
Archived Log entry 188986 added for thread 1 sequence 50656 ID 0x5694063d dest 1:
Tue Oct 08 09:45:47 2019


Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 09:45:47
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.30.26.2)(PORT=2920))
Tue Oct 08 09:52:11 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 09:52:11
Tracing not turned on.
Tns error struct:
ns main err code: 12547

TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (8519802) as a result of ORA-609
Tue Oct 08 09:55:17 2019
Thread 1 advanced to log sequence 50658 (LGWR switch)
Current log# 3 seq# 50658 mem# 0: +DATA/orcl/onlinelog/group_3.301.924253815
Tue Oct 08 09:55:17 2019
LNS: Standby redo logfile selected for thread 1 sequence 50658 for destination LOG_ARCHIVE_DEST_2
Tue Oct 08 09:55:17 2019
Archived Log entry 188988 added for thread 1 sequence 50657 ID 0x5694063d dest 1:
Tue Oct 08 10:00:49 2019


Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:00:49
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505

TNS-00505: Operation timed out
nt secondary err code: 78
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.54.26)(PORT=49743))
Tue Oct 08 10:05:18 2019
Thread 1 advanced to log sequence 50659 (LGWR switch)
Current log# 1 seq# 50659 mem# 0: +DATA/orcl/onlinelog/group_1.299.924253815
Tue Oct 08 10:05:18 2019
LNS: Standby redo logfile selected for thread 1 sequence 50659 for destination LOG_ARCHIVE_DEST_2
Tue Oct 08 10:05:18 2019
Archived Log entry 188990 added for thread 1 sequence 50658 ID 0x5694063d dest 1:
Tue Oct 08 10:08:33 2019


Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:08:33
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505

TNS-00505: Operation timed out
nt secondary err code: 78
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.4.65)(PORT=65239))
Tue Oct 08 10:11:27 2019


Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:11:27
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505

TNS-00505: Operation timed out
nt secondary err code: 78
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.70.26)(PORT=53598))
Tue Oct 08 10:12:15 2019


Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:12:15
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505

TNS-00505: Operation timed out
nt secondary err code: 78
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.70.26)(PORT=53600))
Tue Oct 08 10:12:24 2019


Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:12:24
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505

TNS-00505: Operation timed out
nt secondary err code: 78
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.76.3)(PORT=64719))
Tue Oct 08 10:13:58 2019


Tue Oct 08 10:13:58 2019


Fatal NI connect error 12170.

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:13:58
Time: 08-OCT-2019 10:13:58
Tracing not turned on.
Tracing not turned on.
Tns error struct:
Tns error struct:
ns main err code: 12535
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12560
TNS-12535: TNS:operation timed out
nt main err code: 505
ns secondary err code: 12560

nt main err code: 505

TNS-00505: Operation timed out
nt secondary err code: 78
TNS-00505: Operation timed out
nt OS err code: 0
nt secondary err code: 78
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.74.215)(PORT=51233))
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.74.215)(PORT=51219))
Tue Oct 08 10:15:18 2019
Thread 1 advanced to log sequence 50660 (LGWR switch)
Current log# 2 seq# 50660 mem# 0: +DATA/orcl/onlinelog/group_2.300.924253815
Tue Oct 08 10:15:18 2019
LNS: Standby redo logfile selected for thread 1 sequence 50660 for destination LOG_ARCHIVE_DEST_2
Tue Oct 08 10:15:19 2019
Archived Log entry 188992 added for thread 1 sequence 50659 ID 0x5694063d dest 1:
Tue Oct 08 10:25:16 2019
Thread 1 advanced to log sequence 50661 (LGWR switch)
Current log# 3 seq# 50661 mem# 0: +DATA/orcl/onlinelog/group_3.301.924253815
Tue Oct 08 10:25:16 2019
LNS: Standby redo logfile selected for thread 1 sequence 50661 for destination LOG_ARCHIVE_DEST_2
Tue Oct 08 10:25:17 2019
Archived Log entry 188994 added for thread 1 sequence 50660 ID 0x5694063d dest 1:
Tue Oct 08 10:28:18 2019


Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:28:18
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505

TNS-00505: Operation timed out
nt secondary err code: 78
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.62.7)(PORT=56507))
Tue Oct 08 10:39:07 2019
Error 3135 trapped in 2PC on transaction 514.21.288. Cleaning up.
Tue Oct 08 10:39:09 2019
LNS: Standby redo logfile selected for thread 1 sequence 50662 for destination LOG_ARCHIVE_DEST_2
Tue Oct 08 10:39:09 2019
Archived Log entry 188996 added for thread 1 sequence 50661 ID 0x5694063d dest 1:
Tue Oct 08 10:39:09 2019
Thread 1 advanced to log sequence 50662 (LGWR switch)
Tue Oct 08 10:39:10 2019
Error 3135 trapped in 2PC on transaction 383.13.55216. Cleaning up.
Tue Oct 08 10:39:06 2019
Error 3135 trapped in 2PC on transaction 237.6.124258. Cleaning up.
Tue Oct 08 10:39:10 2019
Process J000 died, see its trace file
Current log# 1 seq# 50662 mem# 0: +DATA/orcl/onlinelog/group_1.299.924253815
kkjcre1p: unable to spawn jobq slave process
Error stack returned to user:
ORA-02050: 事务处理 383.13.55216 已回退, 某些远程数据库可能有问题
ORA-03135: 连接失去联系
Error stack returned to user:
Tue Oct 08 10:39:12 2019
Error 3135 trapped in 2PC on transaction 347.10.26884. Cleaning up.
Error stack returned to user:
Errors in file /oracle/app/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_4391642.trc:
Tue Oct 08 10:39:15 2019
DISTRIB TRAN ORCL.9c067325.237.6.124258
Error stack returned to user:
Tue Oct 08 10:39:17 2019


Tue Oct 08 10:39:17 2019
ORA-02050: 事务处理 237.6.124258 已回退, 某些远程数据库可能有问题
Tue Oct 08 10:39:22 2019


Tue Oct 08 10:39:17 2019
ORA-02050: 事务处理 514.21.288 已回退, 某些远程数据库可能有问题
Tue Oct 08 10:39:26 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:39:26
Tracing not turned on.
Tns error struct:
ns main err code: 12547

TNS-12547: TNS:lost contact

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:39:27
Tracing not turned on.
Tns error struct:
ns main err code: 12547

TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Tue Oct 08 10:39:26 2019


Tue Oct 08 10:39:23 2019
ORA-02050: 事务处理 347.10.26884 已回退, 某些远程数据库可能有问题
ORA-03135: 连接失去联系
ORA-03135: 连接失去联系
Tue Oct 08 10:39:27 2019


Tue Oct 08 10:39:27 2019


Tue Oct 08 10:39:27 2019
is local tran 237.6.124258 (hex=ed.06.1e562)
Tue Oct 08 10:39:29 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
ns secondary err code: 12560
Tue Oct 08 10:39:27 2019


Tue Oct 08 10:39:28 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:39:31
Tracing not turned on.
Tns error struct:
opiodr aborting process unknown ospid (18351024) as a result of ORA-609 ns main err code: 12547

Tue Oct 08 10:39:31 2019

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Time: 08-OCT-2019 10:39:32
TNS-12547: TNS:lost contact
Tracing not turned on.
ns secondary err code: 12560
Tns error struct:
nt main err code: 0
ns main err code: 12547
nt secondary err code: 0

nt OS err code: 0

TNS-12547: TNS:lost contact
ns secondary err code: 12560

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:28 2019
Tue Oct 08 10:39:26 2019



VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:34 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:34 2019


nt main err code: 0

Tue Oct 08 10:39:34 2019


insert pending collecting tran, scn=12629023016466 (hex=b7c.6c6e4612)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:30 2019


Tue Oct 08 10:39:35 2019


Tue Oct 08 10:39:35 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:36 2019


Tue Oct 08 10:39:30 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
DISTRIB TRAN ORCL.9c067325.383.13.55216

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:38 2019


ORA-03135: 连接失去联系
Tue Oct 08 10:39:39 2019


nt main err code: 0

Tue Oct 08 10:39:39 2019

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:31 2019


Tue Oct 08 10:39:39 2019


opiodr aborting process unknown ospid (47055730) as a result of ORA-609
is local tran 383.13.55216 (hex=17f.0d.d7b0)
Tue Oct 08 10:39:36 2019

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:39:41
Tracing not turned on.
Tns error struct:
ns main err code: 12547

Tue Oct 08 10:39:40 2019


Tue Oct 08 10:39:41 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:39:41

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tracing not turned on.
Time: 08-OCT-2019 10:39:41
Tns error struct:
Tracing not turned on.
ns main err code: 12547
Tns error struct:

ns main err code: 12547

TNS-12547: TNS:lost contact
ns secondary err code: 12560
TNS-12547: TNS:lost contact
nt main err code: 0
ns secondary err code: 12560
nt secondary err code: 0
nt main err code: 0
nt OS err code: 0
Tue Oct 08 10:39:36 2019
nt secondary err code: 0
Time: 08-OCT-2019 10:39:38


Tue Oct 08 10:39:35 2019
Tue Oct 08 10:39:36 2019

*Tue Oct 08 10:39:36 2019
Time: 08-OCT-2019 10:39:35

nt secondary err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:39:39

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:40 2019

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:43 2019


Tue Oct 08 10:39:43 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:41 2019
Tue Oct 08 10:39:40 2019


VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.
Tue Oct 08 10:39:40 2019
nt secondary err code: 0
Tue Oct 08 10:39:43 2019


VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt OS err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:41 2019
insert pending collecting tran, scn=12629023016461 (hex=b7c.6c6e460d)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:42 2019
Time: 08-OCT-2019 10:39:43
DISTRIB TRAN ORCL.9c067325.237.6.124258
Tue Oct 08 10:39:46 2019


Tue Oct 08 10:39:44 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:39:46
Tracing not turned on.
Tns error struct:
ns main err code: 12547

TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 0
Time: 08-OCT-2019 10:39:44
nt secondary err code: 0
Tue Oct 08 10:39:46 2019
Tracing not turned on.
nt OS err code: 0
Tns error struct:
Time: 08-OCT-2019 10:39:44

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:39:44
opiodr aborting process unknown ospid (5310270) as a result of ORA-609
Tue Oct 08 10:39:44 2019
Tns error struct:
Time: 08-OCT-2019 10:39:43
Tue Oct 08 10:39:45 2019
opiodr aborting process unknown ospid (1640358) as a result of ORA-609TNS-12547: TNS:lost contact
Tue Oct 08 10:39:44 2019
Tracing not turned on.


VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt OS err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

* ns main err code: 12547

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Tue Oct 08 10:39:45 2019

Tue Oct 08 10:39:46 2019
Time: 08-OCT-2019 10:39:43

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tracing not turned on.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:39:46
Tue Oct 08 10:39:46 2019


is local tran 237.6.124258 (hex=ed.06.1e562))
Tue Oct 08 10:39:47 2019


Tracing not turned on.
Tue Oct 08 10:39:46 2019


VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:47 2019
Time: 08-OCT-2019 10:39:46
Tue Oct 08 10:39:47 2019


Tns error struct:
Tue Oct 08 10:39:47 2019


Time: 08-OCT-2019 10:39:47
Tue Oct 08 10:39:47 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
ns main err code: 12547
Tracing not turned on.

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:39:47
Time: 08-OCT-2019 10:39:47
Time: 08-OCT-2019 10:39:47
ns main err code: 12547
ns main err code: 12547
TNS-12547: TNS:lost contact
Time: 08-OCT-2019 10:39:47
Tracing not turned on.
Tracing not turned on.
ns secondary err code: 12560

Tracing not turned on.
Tns error struct:
Tns error struct:
nt main err code: 0
TNS-12547: TNS:lost contact
ns main err code: 12547
Tns error struct:
TNS-12547: TNS:lost contact
ns main err code: 12547
nt secondary err code: 0
ns secondary err code: 12560

ns main err code: 12547
ns secondary err code: 12560

nt OS err code: 0
nt main err code: 0
    nt main err code: 0

TNS-12547: TNS:lost contact
nt secondary err code: 0
nt secondary err code: 0
TNS-12547: TNS:lost contact
Tue Oct 08 10:39:45 2019
TNS-12547: TNS:lost contact


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:46 2019

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:46 2019


Tue Oct 08 10:39:47 2019
Tracing not turned on.
Tue Oct 08 10:39:47 2019

*Tue Oct 08 10:39:47 2019


Tue Oct 08 10:39:47 2019


Tue Oct 08 10:39:47 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tns error struct:

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
ns main err code: 12547

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:39:47
Time: 08-OCT-2019 10:39:47

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Time: 08-OCT-2019 10:39:47
Tue Oct 08 10:39:47 2019

*Tue Oct 08 10:39:47 2019


Tracing not turned on.
Time: 08-OCT-2019 10:39:47
TNS-12547: TNS:lost contact
Tracing not turned on.

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tns error struct:

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.
ns secondary err code: 12560
ns main err code: 12547
Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt main err code: 0

ns main err code: 12547

Time: 08-OCT-2019 10:39:48
ns main err code: 12547
Time: 08-OCT-2019 10:39:48
nt secondary err code: 0
Tracing not turned on.

TNS-12547: TNS:lost contact

nt OS err code: 0

Tracing not turned on.
Tns error struct:
ns secondary err code: 12560
Tns error struct:
ns main err code: 12547
nt main err code: 0
Tracing not turned on.
TNS-12547: TNS:lost contact
TNS-12547: TNS:lost contact
ns main err code: 12547
Tue Oct 08 10:39:47 2019


Time: 08-OCT-2019 10:39:46

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:46 2019


Tue Oct 08 10:39:47 2019


Tue Oct 08 10:39:47 2019


Tue Oct 08 10:39:47 2019


Tracing not turned on.

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:48 2019


Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:48 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:39:48

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
ns main err code: 12547

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:39:48
Tracing not turned on.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:39:48
Tracing not turned on.
Tue Oct 08 10:39:46 2019


Time: 08-OCT-2019 10:39:48
Time: 08-OCT-2019 10:39:48
Tns error struct:
Tracing not turned on.
TNS-12547: TNS:lost contact
Tns error struct:
Tracing not turned on.

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.
ns main err code: 12547
Tns error struct:
ns secondary err code: 12560
ns main err code: 12547
Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Tracing not turned on.
Tns error struct:
nt main err code: 0
ns main err code: 12547

ns main err code: 12547

Time: 08-OCT-2019 10:39:48

Tns error struct:
ns main err code: 12547
nt secondary err code: 0
TNS-12547: TNS:lost contact

TNS-12547: TNS:lost contact
Tracing not turned on.
ns main err code: 12547
TNS-12547: TNS:lost contact
Tue Oct 08 10:39:48 2019
nt OS err code: 0


ns secondary err code: 12560

Tns error struct:
ns secondary err code: 12560
TNS-12547: TNS:lost contact

ns secondary err code: 12560
ns secondary err code: 12560
ns main err code: 12547
nt main err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
TNS-12547: TNS:lost contact
nt main err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt main err code: 0
TNS-12547: TNS:lost contact
Time: 08-OCT-2019 10:39:46
Time: 08-OCT-2019 10:39:46

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
ns main err code: 12547
ns secondary err code: 12560
Tue Oct 08 10:39:48 2019


Tracing not turned on.
Tracing not turned on.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Tue Oct 08 10:39:48 2019


nt secondary err code: 0
nt main err code: 0

Tns error struct:
Tns error struct:
Time: 08-OCT-2019 10:39:48

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt OS err code: 0
ns main err code: 12547
nt secondary err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
ns main err code: 12547
Tracing not turned on.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tns error struct:

Tracing not turned on.
nt OS err code: 0
delete pending collecting tran, scn=12629023016466 (hex=b7c.6c6e4612)
nt OS err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Tue Oct 08 10:39:48 2019
ns secondary err code: 12560


VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:49 2019


Tns error struct:

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt main err code: 0
Tue Oct 08 10:39:48 2019


VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:49 2019


Tue Oct 08 10:39:47 2019


Time: 08-OCT-2019 10:39:49
Tue Oct 08 10:39:49 2019


VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tracing not turned on.
TNS-12547: TNS:lost contact

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tns error struct:

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Time: 08-OCT-2019 10:39:49
ns secondary err code: 12560

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:39:49
Tracing not turned on.
nt main err code: 0
Tue Oct 08 10:39:47 2019


Tue Oct 08 10:39:49 2019


Tracing not turned on.
Tue Oct 08 10:39:45 2019
Time: 08-OCT-2019 10:39:44
Tue Oct 08 10:39:49 2019


ns secondary err code: 12560

Tue Oct 08 10:39:49 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.
opiodr aborting process unknown ospid (65142922) as a result of ORA-609
Tue Oct 08 10:39:49 2019


Tns error struct:
nt main err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
ns main err code: 12547
nt secondary err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
DISTRIB TRAN ORCL.9c067325.347.10.26884
opiodr aborting process unknown ospid (29819868) as a result of ORA-609
TNS-12547: TNS:lost contact
Tue Oct 08 10:39:49 2019


opiodr aborting process unknown ospid (30343724) as a result of ORA-609
Tue Oct 08 10:39:49 2019


Tue Oct 08 10:39:49 2019


Tue Oct 08 10:39:50 2019
Tue Oct 08 10:39:50 2019



opiodr aborting process unknown ospid (57869230) as a result of ORA-609
Tue Oct 08 10:39:49 2019
Tue Oct 08 10:39:49 2019


Tracing not turned on.

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:47 2019
Time: 08-OCT-2019 10:39:46
Tue Oct 08 10:39:49 2019


is local tran 347.10.26884 (hex=15b.0a.6904)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
ns main err code: 12547
Tue Oct 08 10:39:46 2019


ns secondary err code: 12560

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:39:49

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
TNS-12547: TNS:lost contact
Tue Oct 08 10:39:50 2019


VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:50 2019


Tue Oct 08 10:39:50 2019


Tue Oct 08 10:39:50 2019


Tue Oct 08 10:39:50 2019


nt secondary err code: 0

Tns error struct:
Tns error struct:
DISTRIB TRAN ORCL.9c067325.383.13.55216
Tue Oct 08 10:39:50 2019


Tns error struct:

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:47 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:50 2019


Tue Oct 08 10:39:50 2019


Time: 08-OCT-2019 10:39:46
nt secondary err code: 0
Tue Oct 08 10:39:50 2019

Tue Oct 08 10:39:51 2019
nt secondary err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tracing not turned on.
Time: 08-OCT-2019 10:39:49
Tns error struct:
TNS-12547: TNS:lost contact
Time: 08-OCT-2019 10:39:49

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Time: 08-OCT-2019 10:39:52

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.
Time: 08-OCT-2019 10:39:52
Tns error struct:
Tue Oct 08 10:39:52 2019
ns main err code: 12547

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tracing not turned on.
Tns error struct:
ns secondary err code: 12560

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tracing not turned on.
Tracing not turned on.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
ns main err code: 12547
ns main err code: 12547
nt main err code: 0
Tns error struct:

Tns error struct:

ns main err code: 12547

Time: 08-OCT-2019 10:39:52
nt secondary err code: 0
TNS-12547: TNS:lost contact
ns main err code: 12547
Tracing not turned on.

nt OS err code: 0

TNS-12547: TNS:lost contact
TNS-12547: TNS:lost contact
ns secondary err code: 12560

Tns error struct:
TNS-12547: TNS:lost contact
nt main err code: 0
ns secondary err code: 12560
TNS-12547: TNS:lost contact
ns secondary err code: 12560
Tns error struct:
Tue Oct 08 10:39:50 2019
Tue Oct 08 10:39:51 2019



Tue Oct 08 10:39:49 2019
nt OS err code: 0


Time: 08-OCT-2019 10:39:52

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Time: 08-OCT-2019 10:39:47
Time: 08-OCT-2019 10:39:48
Tue Oct 08 10:39:51 2019


Tue Oct 08 10:39:51 2019


Time: 08-OCT-2019 10:39:48
ns secondary err code: 12560

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.
Tue Oct 08 10:39:52 2019


is local tran 383.13.55216 (hex=17f.0d.d7b0))
Tracing not turned on.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt main err code: 0
Tracing not turned on.

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
delete pending collecting tran, scn=12629023016461 (hex=b7c.6c6e460d)
Time: 08-OCT-2019 10:39:52
Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.

ns main err code: 12547

opiodr aborting process unknown ospid (49742102) as a result of ORA-609

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tns error struct:
nt secondary err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Time: 08-OCT-2019 10:39:46
Tue Oct 08 10:39:50 2019
Tue Oct 08 10:39:52 2019
Tue Oct 08 10:39:50 2019




Tue Oct 08 10:39:50 2019
Tracing not turned on.


Tue Oct 08 10:39:50 2019


ns main err code: 12547

Tue Oct 08 10:39:50 2019


Tue Oct 08 10:39:51 2019


VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Tue Oct 08 10:39:51 2019


Tue Oct 08 10:39:51 2019
nt OS err code: 0

Tns error struct:

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:50 2019
ns secondary err code: 12560
Tue Oct 08 10:39:51 2019


Tns error struct:
Tue Oct 08 10:39:53 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt main err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
ns main err code: 12547

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt secondary err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Time: 08-OCT-2019 10:39:53

Time: 08-OCT-2019 10:39:53
Time: 08-OCT-2019 10:39:53
Tracing not turned on.
nt OS err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
ns main err code: 12547
TNS-12547: TNS:lost contact
Time: 08-OCT-2019 10:39:47
Time: 08-OCT-2019 10:39:52
Tue Oct 08 10:39:47 2019


Time: 08-OCT-2019 10:39:49
Time: 08-OCT-2019 10:39:49
nt OS err code: 0
opiodr aborting process unknown ospid (8389454) as a result of ORA-609 Tracing not turned on.
nt OS err code: 0
Tue Oct 08 10:39:51 2019

Tracing not turned on.

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt secondary err code: 0
Tue Oct 08 10:39:52 2019
Tue Oct 08 10:39:50 2019



TNS-12547: TNS:lost contact
ns main err code: 12547

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:53 2019


Tue Oct 08 10:39:53 2019
ns main err code: 12547
Tue Oct 08 10:39:50 2019


VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tns error struct:
Tue Oct 08 10:39:52 2019


Tue Oct 08 10:39:53 2019

* Tns error struct:

Tue Oct 08 10:39:53 2019


ns main err code: 12547

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
ns secondary err code: 12560

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt main err code: 0
ns main err code: 12547

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt secondary err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

TNS-12547: TNS:lost contact
Time: 08-OCT-2019 10:39:53
Time: 08-OCT-2019 10:39:53
Time: 08-OCT-2019 10:39:53
nt OS err code: 0
Time: 08-OCT-2019 10:39:53
ns secondary err code: 12560
TNS-12547: TNS:lost contact
Tracing not turned on.
ns secondary err code: 12560
Tracing not turned on.
Tracing not turned on.
nt main err code: 0
ns main err code: 12547
Tue Oct 08 10:39:50 2019


Tracing not turned on.
opiodr aborting process unknown ospid (34013610) as a result of ORA-609
nt secondary err code: 0
nt main err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:52 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt OS err code: 0
Tracing not turned on.
Tracing not turned on.
Time: 08-OCT-2019 10:39:52
TNS-12547: TNS:lost contact

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:51 2019

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

* Time: 08-OCT-2019 10:39:46
Tue Oct 08 10:39:51 2019
TNS-12547: TNS:lost contact

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

ns secondary err code: 12560

opiodr aborting process unknown ospid (63373738) as a result of ORA-609
Tue Oct 08 10:39:53 2019
Tracing not turned on.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:53 2019
nt main err code: 0
nt main err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tns error struct:
ns main err code: 12547


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
TNS-12547: TNS:lost contact

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
ns secondary err code: 12560
ns main err code: 12547

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TNS-12547: TNS:lost contact
nt OS err code: 0
ns secondary err code: 12560
Time: 08-OCT-2019 10:39:51
Tue Oct 08 10:39:53 2019


Tue Oct 08 10:39:53 2019


opiodr aborting process unknown ospid (62783752) as a result of ORA-609
Tue Oct 08 10:39:54 2019


Tns error struct:
Tue Oct 08 10:39:54 2019

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt main err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Time: 08-OCT-2019 10:39:53

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.
Time: 08-OCT-2019 10:39:54
nt secondary err code: 0
ns secondary err code: 12560

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

ns main err code: 12547

Time: 08-OCT-2019 10:39:54
nt main err code: 0
opiodr aborting process unknown ospid (5702580) as a result of ORA-609
Tracing not turned on.
Tns error struct:
Tracing not turned on.
Time: 08-OCT-2019 10:39:54

Tracing not turned on.
TNS-12547: TNS:lost contact
nt secondary err code: 0
ns main err code: 12547
Tns error struct:

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.
ns secondary err code: 12560
Time: 08-OCT-2019 10:39:53
Tns error struct:
nt OS err code: 0
Time: 08-OCT-2019 10:39:54
TNS-12547: TNS:lost contact

Tns error struct:
ns main err code: 12547
Tue Oct 08 10:39:54 2019
Tns error struct:

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
ns main err code: 12547
nt main err code: 0
ns secondary err code: 12560
nt secondary err code: 0
Time: 08-OCT-2019 10:39:52

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tns error struct:
opiodr aborting process unknown ospid (33817036) as a result of ORA-609
Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt secondary err code: 0

Tns error struct:
ns main err code: 12547
Time: 08-OCT-2019 10:39:53

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

nt main err code: 0

Time: 08-OCT-2019 10:39:53
insert pending collecting tran, scn=12629023018894 (hex=b7c.6c6e4f8e) Tracing not turned on.

* Tns error struct:
Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Tue Oct 08 10:39:53 2019

ns main err code: 12547

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)


Tns error struct:
Time: 08-OCT-2019 10:39:51

Tue Oct 08 10:39:53 2019
Tue Oct 08 10:39:53 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

* Time: 08-OCT-2019 10:39:53

Tue Oct 08 10:39:53 2019
TNS-12547: TNS:lost contact

*TNS-12547: TNS:lost contact

Time: 08-OCT-2019 10:39:53
nt main err code: 0
Tns error struct:
nt OS err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
ns main err code: 12547
Tracing not turned on.
ns main err code: 12547

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
ns secondary err code: 12560
Tns error struct:
Tracing not turned on.
Time: 08-OCT-2019 10:39:53

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
opiodr aborting process unknown ospid (7013178) as a result of ORA-609
ns secondary err code: 12560
Tue Oct 08 10:39:54 2019

* Time: 08-OCT-2019 10:39:53

nt secondary err code: 0
Tue Oct 08 10:39:54 2019
ns secondary err code: 12560

TNS-12547: TNS:lost contact

Time: 08-OCT-2019 10:39:54
Tracing not turned on.
nt main err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt secondary err code: 0
ns secondary err code: 12560

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:54 2019


nt OS err code: 0

Tue Oct 08 10:39:53 2019


ns main err code: 12547

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.
nt secondary err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:39:53
nt OS err code: 0
Tracing not turned on.
Tue Oct 08 10:39:56 2019


Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt main err code: 0
Tns error struct:
Time: 08-OCT-2019 10:39:56
ns main err code: 12547
nt main err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.
nt OS err code: 0
Tns error struct:
Tue Oct 08 10:39:56 2019

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
ns main err code: 12547
Time: 08-OCT-2019 10:39:55
Tue Oct 08 10:39:56 2019
nt OS err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Time: 08-OCT-2019 10:39:56
nt main err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.
ns main err code: 12547
Tracing not turned on.
ns secondary err code: 12560
Tue Oct 08 10:39:55 2019
Tns error struct:
TNS-12547: TNS:lost contact
Tue Oct 08 10:39:56 2019
Time: 08-OCT-2019 10:39:54

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
ns secondary err code: 12560
nt secondary err code: 0
ns main err code: 12547

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:55 2019
opiodr aborting process unknown ospid (22413328) as a result of ORA-609TNS-12547: TNS:lost contact
nt main err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt OS err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
ns main err code: 12547
Tns error struct:
Tue Oct 08 10:39:56 2019
Tns error struct:
Tue Oct 08 10:39:55 2019
nt secondary err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt secondary err code: 0
Tracing not turned on.
Time: 08-OCT-2019 10:39:54
TNS-12547: TNS:lost contact

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:56 2019
Tue Oct 08 10:39:55 2019
ns main err code: 12547
Tracing not turned on.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:56 2019
ns secondary err code: 12560
opiodr aborting process unknown ospid (44433892) as a result of ORA-609
VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
opiodr aborting process unknown ospid (41812246) as a result of ORA-609opiodr aborting process unknown ospid (64094530) as a result of ORA-609 Tracing not turned on.
Tracing not turned on.

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)



Tracing not turned on.


DISTRIB TRAN ORCL.9c067325.514.21.288



*DISTRIB TRAN ORCL.9c067325.347.10.26884

ns secondary err code: 12560
ns main err code: 12547

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.
Time: 08-OCT-2019 10:39:53
Tue Oct 08 10:39:56 2019


ns secondary err code: 12560

Tracing not turned on.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt secondary err code: 0
Tns error struct:
Tue Oct 08 10:39:56 2019
Tue Oct 08 10:39:56 2019
Tracing not turned on.
ns main err code: 12547
Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt OS err code: 0
Tracing not turned on.
Tns error struct:
nt main err code: 0
Tns error struct:
Time: 08-OCT-2019 10:39:56
Tns error struct:
Time: 08-OCT-2019 10:39:56
Time: 08-OCT-2019 10:39:56
nt secondary err code: 0
nt OS err code: 0
Time: 08-OCT-2019 10:39:56
Tns error struct:
ns main err code: 12547
ns main err code: 12547
ns main err code: 12547
TNS-12547: TNS:lost contact

ns main err code: 12547

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Time: 08-OCT-2019 10:39:56
Tns error struct:

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TNS-12547: TNS:lost contact
ns main err code: 12547

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

is local tran 514.21.288 (hex=202.15.120)
Time: 08-OCT-2019 10:39:56

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
ns secondary err code: 12560
Tracing not turned on.
TNS-12547: TNS:lost contact

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
insert pending collecting tran, scn=12629023016380 (hex=b7c.6c6e45bc)
Time: 08-OCT-2019 10:39:56
nt main err code: 0
Time: 08-OCT-2019 10:39:56
TNS-12547: TNS:lost contact
Tns error struct:
ns secondary err code: 12560
Time: 08-OCT-2019 10:39:56
ns secondary err code: 12560
Tracing not turned on.
Time: 08-OCT-2019 10:39:56
nt secondary err code: 0
Tracing not turned on.
ns secondary err code: 12560
nt main err code: 0
ns main err code: 12547
nt main err code: 0
Tracing not turned on.
Tns error struct:
nt main err code: 0
Tracing not turned on.
nt OS err code: 0
nt main err code: 0
Tns error struct:

nt secondary err code: 0
nt secondary err code: 0
ns main err code: 12547

Tns error struct:
nt secondary err code: 0
nt secondary err code: 0
nt OS err code: 0
ns main err code: 12547
Tns error struct:

ns main err code: 12547

Time: 08-OCT-2019 10:39:55
TNS-12547: TNS:lost contact
nt OS err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (6423436) as a result of ORA-609

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tns error struct:
nt secondary err code: 0
Tue Oct 08 10:39:56 2019

* Tracing not turned on.

Time: 08-OCT-2019 10:39:56
nt OS err code: 0
ns main err code: 12547
TNS-12547: TNS:lost contact

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
ns main err code: 12547

Tns error struct:
Tracing not turned on.
ns secondary err code: 12560
Tue Oct 08 10:39:55 2019

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.
Tue Oct 08 10:39:56 2019


Tue Oct 08 10:39:53 2019


ns main err code: 12547
nt main err code: 0

Tue Oct 08 10:39:54 2019


Tue Oct 08 10:39:56 2019
Tracing not turned on.
Tns error struct:
opiodr aborting process unknown ospid (55575342) as a result of ORA-609
ns main err code: 12547

Time: 08-OCT-2019 10:39:56
nt OS err code: 0

nt main err code: 0

is local tran 347.10.26884 (hex=15b.0a.6904))
Tracing not turned on.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TNS-12547: TNS:lost contact
TNS-12547: TNS:lost contact

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
opiodr aborting process unknown ospid (4457978) as a result of ORA-609

TNS-12547: TNS:lost contact

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
ns secondary err code: 12560
Time: 08-OCT-2019 10:39:57
Time: 08-OCT-2019 10:39:57
ns secondary err code: 12560
Time: 08-OCT-2019 10:39:57
nt main err code: 0
ns secondary err code: 12560
nt main err code: 0
Tracing not turned on.
Tracing not turned on.
TNS-12547: TNS:lost contact

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt main err code: 0
Tns error struct:
nt secondary err code: 0
nt secondary err code: 0
Tns error struct:
Time: 08-OCT-2019 10:39:57
nt secondary err code: 0
ns main err code: 12547
nt OS err code: 0
nt secondary err code: 0
nt OS err code: 0
Tracing not turned on.
ns main err code: 12547
nt OS err code: 0

Time: 08-OCT-2019 10:39:56

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt OS err code: 0
opiodr aborting process unknown ospid (5439820) as a result of ORA-609TNS-12547: TNS:lost contact

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:57 2019
Tue Oct 08 10:39:54 2019

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tracing not turned on.
nt secondary err code: 0
Time: 08-OCT-2019 10:39:53
Tue Oct 08 10:39:57 2019

Tns error struct:
Time: 08-OCT-2019 10:39:56
Tracing not turned on.
ns main err code: 12547

TNS-12547: TNS:lost contact

nt main err code: 0

* Tracing not turned on.
nt secondary err code: 0

Tracing not turned on.
Tue Oct 08 10:39:57 2019
ns secondary err code: 12560
Tracing not turned on.
TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (10290332) as a result of ORA-609 opiodr aborting process unknown ospid (15599428) as a result of ORA-609

opiodr aborting process unknown ospid (9241752) as a result of ORA-609

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt main err code: 0

Tns error struct:
nt OS err code: 0
nt secondary err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:57 2019


ns secondary err code: 12560

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
ns secondary err code: 12560
Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

delete pending collecting tran, scn=12629023018894 (hex=b7c.6c6e4f8e)

Time: 08-OCT-2019 10:39:54
Tracing not turned on.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:57 2019
nt secondary err code: 0
ns main err code: 12547

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:57 2019
nt OS err code: 0
ns secondary err code: 12560

ns main err code: 12547

TNS-12547: TNS:lost contact

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt main err code: 0
TNS-12547: TNS:lost contact
Tns error struct:

nt main err code: 0

TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (51183652) as a result of ORA-609

TNS-12547: TNS:lost contact
nt OS err code: 0
ns secondary err code: 12560
Tns error struct:
ns main err code: 12547

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TNS-12547: TNS:lost contact

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
ns secondary err code: 12560
Time: 08-OCT-2019 10:39:58
ns main err code: 12547
Time: 08-OCT-2019 10:39:58
nt main err code: 0
ns secondary err code: 12560
ns main err code: 12547

ns main err code: 12547
ns secondary err code: 12560
nt main err code: 0

Tue Oct 08 10:39:58 2019
Time: 08-OCT-2019 10:39:56
Time: 08-OCT-2019 10:39:56
Tue Oct 08 10:39:58 2019
Tracing not turned on.
TNS-12547: TNS:lost contact
Tns error struct:
Tue Oct 08 10:39:58 2019
Time: 08-OCT-2019 10:39:56


Tns error struct:
DISTRIB TRAN ORCL.9c067325.514.21.288
TNS-12547: TNS:lost contact

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tns error struct:
Tue Oct 08 10:39:56 2019

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt OS err code: 0
TNS-12547: TNS:lost contact
Tracing not turned on.
ns secondary err code: 12560
nt secondary err code: 0
TNS-12547: TNS:lost contact
Tue Oct 08 10:39:58 2019
opiodr aborting process unknown ospid (64946748) as a result of ORA-609opiodr aborting process unknown ospid (4982170) as a result of ORA-609

TNS-12547: TNS:lost contact

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:58 2019
Tns error struct:


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt main err code: 0

Time: 08-OCT-2019 10:39:58
Tns error struct:

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:58 2019
opiodr aborting process unknown ospid (788148) as a result of ORA-609
Tracing not turned on.
ns main err code: 12547

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt main err code: 0
opiodr aborting process unknown ospid (63111670) as a result of ORA-609

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
ns main err code: 12547
ns secondary err code: 12560
ns main err code: 12547
Tns error struct:
Tue Oct 08 10:39:59 2019

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)


is local tran 514.21.288 (hex=202.15.120))
Time: 08-OCT-2019 10:39:59
nt secondary err code: 0
ns secondary err code: 12560
ns secondary err code: 12560

Tns error struct:
nt main err code: 0
Time: 08-OCT-2019 10:39:59
TNS-12547: TNS:lost contact

ns main err code: 12547

Tue Oct 08 10:39:58 2019


delete pending collecting tran, scn=12629023016380 (hex=b7c.6c6e45bc)
Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt OS err code: 0
Tracing not turned on.
nt main err code: 0
Time: 08-OCT-2019 10:39:58
ns main err code: 12547
ns secondary err code: 12560

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.
TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (5703676) as a result of ORA-609 nt secondary err code: 0

TNS-12547: TNS:lost contact
nt main err code: 0
Tns error struct:
Time: 08-OCT-2019 10:39:59
ns main err code: 12547
opiodr aborting process unknown ospid (27525640) as a result of ORA-609

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (8128162) as a result of ORA-609 nt secondary err code: 0

opiodr aborting process unknown ospid (65339710) as a result of ORA-609
nt main err code: 0
nt secondary err code: 0
Time: 08-OCT-2019 10:39:57
nt OS err code: 0
Tracing not turned on.
Tns error struct:
Tracing not turned on.
Tue Oct 08 10:39:58 2019
nt secondary err code: 0
ns main err code: 12547
Tns error struct:
ns secondary err code: 12560
Tue Oct 08 10:39:58 2019
Tracing not turned on.
TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (42074578) as a result of ORA-609 Tracing not turned on.
Time: 08-OCT-2019 10:39:57
nt main err code: 0
Tue Oct 08 10:39:58 2019
ns secondary err code: 12560

Tracing not turned on.
ns secondary err code: 12560
nt main err code: 0
Tue Oct 08 10:39:59 2019
nt secondary err code: 0
ns secondary err code: 12560
Time: 08-OCT-2019 10:39:58
Tue Oct 08 10:39:57 2019
Tns error struct:
Tns error struct:
Tue Oct 08 10:39:58 2019

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
opiodr aborting process unknown ospid (21103052) as a result of ORA-609Tue Oct 08 10:39:59 2019

ns main err code: 12547
nt main err code: 0

TNS-12547: TNS:lost contact
Tue Oct 08 10:39:58 2019
nt OS err code: 0
Time: 08-OCT-2019 10:39:56
Tue Oct 08 10:39:58 2019
TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (17433506) as a result of ORA-609TNS-12547: TNS:lost contact

nt OS err code: 0
ns main err code: 12547

Time: 08-OCT-2019 10:39:58
ns main err code: 12547
nt OS err code: 0
Tue Oct 08 10:39:59 2019
Tue Oct 08 10:39:59 2019
nt OS err code: 0
opiodr aborting process unknown ospid (9634960) as a result of ORA-609
Tracing not turned on.
ns secondary err code: 12560
TNS-12547: TNS:lost contact
nt secondary err code: 0
TNS-12547: TNS:lost contact
nt OS err code: 0
Tue Oct 08 10:39:59 2019
Tue Oct 08 10:39:58 2019

* Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt secondary err code: 0

Tracing not turned on.
ns main err code: 12547
Tue Oct 08 10:40:00 2019
ns main err code: 12547
opiodr aborting process unknown ospid (15991678) as a result of ORA-609 nt secondary err code: 0
Time: 08-OCT-2019 10:39:57
Tue Oct 08 10:39:58 2019
nt main err code: 0
ns secondary err code: 12560
nt OS err code: 0

  Tracing not turned on.


ns secondary err code: 12560

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt OS err code: 0
TNS-12547: TNS:lost contact
ns main err code: 12547
Tue Oct 08 10:39:59 2019
Tns error struct:
opiodr aborting process unknown ospid (40174158) as a result of ORA-609Tue Oct 08 10:40:00 2019

ns main err code: 12547
  Tracing not turned on.

opiodr aborting process unknown ospid (42860970) as a result of ORA-609 nt secondary err code: 0

ns main err code: 12547

Time: 08-OCT-2019 10:40:00
TNS-12547: TNS:lost contact
nt secondary err code: 0
ns secondary err code: 12560
ns secondary err code: 12560
Tns error struct:
Tns error struct:
nt secondary err code: 0
Tns error struct:
nt OS err code: 0
nt OS err code: 0
Tue Oct 08 10:40:00 2019
Tue Oct 08 10:40:00 2019
nt secondary err code: 0

* ns main err code: 12547

Tns error struct:
opiodr aborting process unknown ospid (42008748) as a result of ORA-609
TNS-12547: TNS:lost contact
nt OS err code: 0
ns main err code: 12547
nt main err code: 0
ns secondary err code: 12560
Time: 08-OCT-2019 10:39:58

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
ns main err code: 12547
Tue Oct 08 10:39:59 2019

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:39:59 2019
TNS-12547: TNS:lost contact


Tue Oct 08 10:40:00 2019
nt secondary err code: 0
Tracing not turned on.
nt OS err code: 0
Tue Oct 08 10:39:59 2019


VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

nt main err code: 0
ns secondary err code: 12560

Time: 08-OCT-2019 10:40:01

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
ns secondary err code: 12560
nt main err code: 0
nt OS err code: 0
Time: 08-OCT-2019 10:40:01
Tracing not turned on.
Tns error struct:
TNS-12547: TNS:lost contact

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt secondary err code: 0
nt main err code: 0
Tracing not turned on.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
ns main err code: 12547
Tracing not turned on.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt secondary err code: 0
Tracing not turned on.
ns main err code: 12547
nt main err code: 0
Tue Oct 08 10:40:01 2019
Tracing not turned on.
Tue Oct 08 10:39:58 2019
opiodr aborting process unknown ospid (32768124) as a result of ORA-609 nt OS err code: 0

* nt OS err code: 0

Tracing not turned on.
Tracing not turned on.
opiodr aborting process unknown ospid (54526150) as a result of ORA-609

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:39:59 2019


ns secondary err code: 12560

Time: 08-OCT-2019 10:40:00
nt main err code: 0
Tue Oct 08 10:39:59 2019
TNS-12547: TNS:lost contact
nt secondary err code: 0


Tracing not turned on.
ns secondary err code: 12560
Tue Oct 08 10:40:01 2019


ns main err code: 12547

nt main err code: 0

Tue Oct 08 10:40:01 2019
nt OS err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt OS err code: 0
Tns error struct:
ns main err code: 12547
TNS-12547: TNS:lost contact
Time: 08-OCT-2019 10:39:57
nt main err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

ns main err code: 12547
ns main err code: 12547
nt main err code: 0

Tue Oct 08 10:40:01 2019


nt OS err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:40:01 2019
nt secondary err code: 0

ns secondary err code: 12560

Tue Oct 08 10:39:59 2019
nt OS err code: 0
nt main err code: 0
Tue Oct 08 10:39:58 2019


Tue Oct 08 10:40:01 2019
opiodr aborting process unknown ospid (34734336) as a result of ORA-609

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tns error struct:

ns secondary err code: 12560
nt secondary err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Time: 08-OCT-2019 10:40:01

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tns error struct:
ns main err code: 12547
nt OS err code: 0
TNS-12547: TNS:lost contact
nt main err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TNS-12547: TNS:lost contact
Tracing not turned on.

nt secondary err code: 0
ns secondary err code: 12560


ns main err code: 12547
ns secondary err code: 12560

Tue Oct 08 10:39:59 2019
ns secondary err code: 12560
Tracing not turned on.
Tns error struct:
TNS-12547: TNS:lost contact
Time: 08-OCT-2019 10:40:01
Tracing not turned on.
TNS-12547: TNS:lost contact

ns secondary err code: 12560

Tue Oct 08 10:40:02 2019
nt main err code: 0
Tracing not turned on.
nt secondary err code: 0
Tns error struct:
Tracing not turned on.
TNS-12547: TNS:lost contact

ns main err code: 12547

Tracing not turned on.
ns secondary err code: 12560
opiodr aborting process unknown ospid (13174698) as a result of ORA-609TNS-12547: TNS:lost contact

Time: 08-OCT-2019 10:39:59
Time: 08-OCT-2019 10:40:02
opiodr aborting process unknown ospid (16449916) as a result of ORA-609
Tue Oct 08 10:40:02 2019
nt OS err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
opiodr aborting process unknown ospid (62194068) as a result of ORA-609
Time: 08-OCT-2019 10:40:01
Tns error struct:
opiodr aborting process unknown ospid (52364002) as a result of ORA-609
opiodr aborting process unknown ospid (14091150) as a result of ORA-609
TNS-12547: TNS:lost contact
nt main err code: 0
nt secondary err code: 0
Tue Oct 08 10:40:02 2019
ns secondary err code: 12560
Time: 08-OCT-2019 10:40:00
ns secondary err code: 12560
ns main err code: 12547
Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tracing not turned on.
TNS-12547: TNS:lost contact
Tracing not turned on.
nt secondary err code: 0
ns secondary err code: 12560
nt secondary err code: 0
nt OS err code: 0
Tracing not turned on.
Tns error struct:
nt main err code: 0
nt main err code: 0
nt OS err code: 0
Tns error struct:
nt main err code: 0

ns main err code: 12547

Tns error struct:
nt OS err code: 0
nt secondary err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

ns main err code: 12547
nt secondary err code: 0
nt OS err code: 0
ns secondary err code: 12560

Time: 08-OCT-2019 10:40:02
opiodr aborting process unknown ospid (60227966) as a result of ORA-609
nt main err code: 0
nt secondary err code: 0
nt main err code: 0
nt main err code: 0
Time: 08-OCT-2019 10:40:02
Tns error struct:
nt OS err code: 0
Tue Oct 08 10:40:02 2019
nt main err code: 0
nt main err code: 0
ns secondary err code: 12560
nt main err code: 0
Tns error struct:
opiodr aborting process unknown ospid (24641918) as a result of ORA-609TNS-12547: TNS:lost contact
Tue Oct 08 10:40:02 2019
Tue Oct 08 10:40:02 2019
ns secondary err code: 12560

    ns secondary err code: 12560


ns main err code: 12547
ns main err code: 12547
ns main err code: 12547

Tue Oct 08 10:40:02 2019
nt OS err code: 0

* Tracing not turned on.
Tue Oct 08 10:40:02 2019

ns secondary err code: 12560

Tracing not turned on.

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:40:03 2019


Tns error struct:
nt main err code: 0
nt main err code: 0
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

opiodr aborting process unknown ospid (9176170) as a result of ORA-609Tue Oct 08 10:40:03 2019
ns main err code: 12547

nt main err code: 0

Tns error struct:
nt secondary err code: 0
ns secondary err code: 12560

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tns error struct:
nt secondary err code: 0
opiodr aborting process unknown ospid (60293240) as a result of ORA-609
Time: 08-OCT-2019 10:40:01
ns main err code: 12547
Tue Oct 08 10:40:03 2019
TNS-12547: TNS:lost contact
nt OS err code: 0

Tue Oct 08 10:40:03 2019
nt secondary err code: 0
TNS-12547: TNS:lost contact
ns main err code: 12547
Tracing not turned on.
nt main err code: 0
Tue Oct 08 10:40:03 2019
nt secondary err code: 0
Tue Oct 08 10:40:01 2019
Tns error struct:
TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (60687188) as a result of ORA-609 nt secondary err code: 0

Tns error struct:
Tns error struct:
Tue Oct 08 10:40:03 2019

Tue Oct 08 10:40:03 2019
nt OS err code: 0

* ns secondary err code: 12560

TNS-12547: TNS:lost contact
nt secondary err code: 0
TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (64422282) as a result of ORA-609Tue Oct 08 10:40:02 2019

Tue Oct 08 10:40:03 2019


Tue Oct 08 10:40:03 2019
Tns error struct:
Tns error struct:
nt OS err code: 0
Tns error struct:
Tue Oct 08 10:40:02 2019
opiodr aborting process unknown ospid (40764254) as a result of ORA-609
nt main err code: 0
ns main err code: 12547
TNS-12547: TNS:lost contact
nt secondary err code: 0
nt OS err code: 0
Tue Oct 08 10:40:03 2019
nt secondary err code: 0
ns main err code: 12547
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (56361566) as a result of ORA-609
Tracing not turned on.
Tue Oct 08 10:39:59 2019
opiodr aborting process unknown ospid (31260874) as a result of ORA-609

Tue Oct 08 10:40:03 2019
Tns error struct:
nt OS err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt secondary err code: 0
nt secondary err code: 0
nt main err code: 0
nt secondary err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

nt OS err code: 0

opiodr aborting process unknown ospid (26280356) as a result of ORA-609 Tracing not turned on.
opiodr aborting process unknown ospid (14811674) as a result of ORA-609Tue Oct 08 10:40:03 2019
TNS-12547: TNS:lost contact

TNS-12547: TNS:lost contact
nt OS err code: 0

ns main err code: 12547
nt secondary err code: 0
ns main err code: 12547

Tracing not turned on.
nt secondary err code: 0
Tue Oct 08 10:40:04 2019
nt OS err code: 0
opiodr aborting process unknown ospid (4063880) as a result of ORA-609

ns secondary err code: 12560

opiodr aborting process unknown ospid (54657078) as a result of ORA-609
TNS-12547: TNS:lost contact
Tns error struct:
nt main err code: 0
Tue Oct 08 10:40:04 2019

Tue Oct 08 10:40:04 2019
TNS-12547: TNS:lost contact
nt OS err code: 0
ns main err code: 12547
ns secondary err code: 12560
Tue Oct 08 10:40:03 2019
nt OS err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt OS err code: 0
ns secondary err code: 12560
nt secondary err code: 0
TNS-12547: TNS:lost contact
nt main err code: 0
Time: 08-OCT-2019 10:40:04
Time: 08-OCT-2019 10:40:03
nt main err code: 0
Tue Oct 08 10:40:02 2019
Time: 08-OCT-2019 10:40:04


ns secondary err code: 12560

opiodr aborting process unknown ospid (27787788) as a result of ORA-609TNS-12547: TNS:lost contact

TNS-12547: TNS:lost contact
TNS-12547: TNS:lost contact

ns secondary err code: 12560
nt OS err code: 0
nt main err code: 0
ns secondary err code: 12560
ns secondary err code: 12560

TNS-12547: TNS:lost contact
nt main err code: 0
nt secondary err code: 0
nt main err code: 0
TNS-12547: TNS:lost contact
nt secondary err code: 0
nt OS err code: 0
ns secondary err code: 12560

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt main err code: 0
TNS-12547: TNS:lost contact

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
TNS-12547: TNS:lost contact
Tue Oct 08 10:40:02 2019
ns main err code: 12547
nt secondary err code: 0
nt secondary err code: 0
nt main err code: 0
opiodr aborting process unknown ospid (60621056) as a result of ORA-609
ns secondary err code: 12560
ns secondary err code: 12560
TNS-12547: TNS:lost contact
nt OS err code: 0

nt OS err code: 0
nt secondary err code: 0
nt main err code: 0
nt main err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Time: 08-OCT-2019 10:40:02
nt OS err code: 0
ns secondary err code: 12560
TNS-12547: TNS:lost contact
nt main err code: 0
nt secondary err code: 0
Tue Oct 08 10:39:58 2019
nt OS err code: 0

nt main err code: 0

Tracing not turned on.
nt secondary err code: 0
nt secondary err code: 0
Tue Oct 08 10:40:02 2019
Tns error struct:
nt OS err code: 0
nt OS err code: 0
nt OS err code: 0
ns main err code: 12547
nt secondary err code: 0
opiodr aborting process unknown ospid (13764444) as a result of ORA-609

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TNS-12547: TNS:lost contact
Tracing not turned on.
TNS-12547: TNS:lost contact
Tue Oct 08 10:40:04 2019
opiodr aborting process unknown ospid (46728072) as a result of ORA-609


nt secondary err code: 0
ns main err code: 12547

Tue Oct 08 10:40:03 2019
nt OS err code: 0
opiodr aborting process unknown ospid (7405878) as a result of ORA-609opiodr aborting process unknown ospid (65929724) as a result of ORA-609Tue Oct 08 10:40:04 2019
ns main err code: 12547

    ns main err code: 12547

opiodr aborting process unknown ospid (48955778) as a result of ORA-609opiodr aborting process unknown ospid (62915020) as a result of ORA-609

opiodr aborting process unknown ospid (27132480) as a result of ORA-609
opiodr aborting process unknown ospid (14288788) as a result of ORA-609
opiodr aborting process unknown ospid (59638646) as a result of ORA-609 nt OS err code: 0

ns secondary err code: 12560
nt secondary err code: 0
nt OS err code: 0

Tue Oct 08 10:40:05 2019
TNS-12547: TNS:lost contact
nt OS err code: 0

opiodr aborting process unknown ospid (15205326) as a result of ORA-609

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt main err code: 0
Tns error struct:

ns secondary err code: 12560

Tns error struct:

ns secondary err code: 12560
ns main err code: 12547

Tue Oct 08 10:40:05 2019
nt OS err code: 0
opiodr aborting process unknown ospid (39387718) as a result of ORA-609
TNS-12547: TNS:lost contact
nt main err code: 0
nt main err code: 0
Tue Oct 08 10:40:05 2019
ns secondary err code: 12560
TNS-12547: TNS:lost contact
Tracing not turned on.
Tue Oct 08 10:40:05 2019
Tns error struct:
ns main err code: 12547
nt OS err code: 0
Tracing not turned on.
nt OS err code: 0
Time: 08-OCT-2019 10:40:04
Tracing not turned on.
opiodr aborting process unknown ospid (12124504) as a result of ORA-609
nt main err code: 0
opiodr aborting process unknown ospid (41222582) as a result of ORA-609
Tracing not turned on.
Tns error struct:

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt OS err code: 0
nt secondary err code: 0
Tracing not turned on.
opiodr aborting process unknown ospid (20054942) as a result of ORA-609
opiodr aborting process unknown ospid (45482914) as a result of ORA-609
opiodr aborting process unknown ospid (54526676) as a result of ORA-609 ns main err code: 12547

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tns error struct:
nt OS err code: 0
opiodr aborting process unknown ospid (27001076) as a result of ORA-609
opiodr aborting process unknown ospid (6161166) as a result of ORA-609
TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (5572592) as a result of ORA-609
ns main err code: 12547
TNS-12547: TNS:lost contact

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
ns main err code: 12547
ns secondary err code: 12560

nt main err code: 0
nt secondary err code: 0
nt secondary err code: 0
ns main err code: 12547
ns secondary err code: 12560

Time: 08-OCT-2019 10:40:03
Time: 08-OCT-2019 10:40:04
Tue Oct 08 10:40:05 2019
ns secondary err code: 12560
nt secondary err code: 0
Tue Oct 08 10:40:02 2019
TNS-12547: TNS:lost contact
Tue Oct 08 10:40:05 2019
ns main err code: 12547
TNS-12547: TNS:lost contact
Tue Oct 08 10:40:05 2019
opiodr aborting process unknown ospid (41091194) as a result of ORA-609
Tns error struct:
Tns error struct:

ns secondary err code: 12560
ns main err code: 12547
ns main err code: 12547

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt main err code: 0

TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (48693686) as a result of ORA-609

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:40:05
TNS-12547: TNS:lost contact
Tue Oct 08 10:40:02 2019
TNS-12547: TNS:lost contact

ns secondary err code: 12560

opiodr aborting process unknown ospid (16909304) as a result of ORA-609
Tracing not turned on.
nt OS err code: 0
nt main err code: 0
Tns error struct:
nt secondary err code: 0
TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (10028166) as a result of ORA-609
nt main err code: 0
Tue Oct 08 10:40:06 2019

* nt OS err code: 0

Tns error struct:
ns secondary err code: 12560
Tue Oct 08 10:40:05 2019
ns secondary err code: 12560
ns main err code: 12547
ns secondary err code: 12560
ns secondary err code: 12560
TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (9110264) as a result of ORA-609
opiodr aborting process unknown ospid (57999890) as a result of ORA-609
ns main err code: 12547
Tue Oct 08 10:40:05 2019
opiodr aborting process unknown ospid (8914026) as a result of ORA-609Tue Oct 08 10:40:06 2019

opiodr aborting process unknown ospid (41484478) as a result of ORA-609
opiodr aborting process unknown ospid (6358264) as a result of ORA-609
nt secondary err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tracing not turned on.
ns secondary err code: 12560
ns secondary err code: 12560

Time: 08-OCT-2019 10:40:05
nt main err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt main err code: 0

TNS-12547: TNS:lost contact
Tns error struct:
opiodr aborting process unknown ospid (56557812) as a result of ORA-609
Tracing not turned on.
Time: 08-OCT-2019 10:40:06
nt secondary err code: 0
ns secondary err code: 12560
nt secondary err code: 0
ns main err code: 12547
Tue Oct 08 10:40:06 2019
nt secondary err code: 0
TNS-12547: TNS:lost contact
Tns error struct:
nt OS err code: 0
nt OS err code: 0
Tracing not turned on.

nt main err code: 0
nt OS err code: 0
ns secondary err code: 12560
ns main err code: 12547

Tns error struct:
Time: 08-OCT-2019 10:40:05
opiodr aborting process unknown ospid (18612794) as a result of ORA-609 Tns error struct:
Time: 08-OCT-2019 10:40:05
ns secondary err code: 12560

nt main err code: 0
ns secondary err code: 12560

Time: 08-OCT-2019 10:40:06
TNS-12547: TNS:lost contact
nt secondary err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tns error struct:
Tue Oct 08 10:40:05 2019
ns main err code: 12547

nt main err code: 0

Tue Oct 08 10:40:06 2019
TNS-12547: TNS:lost contact
Tue Oct 08 10:40:07 2019
ns main err code: 12547
ns secondary err code: 12560
ns secondary err code: 12560
nt main err code: 0
Tue Oct 08 10:40:05 2019
nt secondary err code: 0

nt OS err code: 0
ns main err code: 12547
    nt OS err code: 0

Tue Oct 08 10:40:05 2019

nt main err code: 0

TNS-12547: TNS:lost contact

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt OS err code: 0
TNS-12547: TNS:lost contact
Tue Oct 08 10:40:05 2019

nt main err code: 0

Tue Oct 08 10:40:06 2019
ns secondary err code: 12560
Time: 08-OCT-2019 10:40:03
ns secondary err code: 12560
nt secondary err code: 0
nt OS err code: 0
TNS-12547: TNS:lost contact

ns main err code: 12547

TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (14877460) as a result of ORA-609 nt main err code: 0

nt OS err code: 0
nt OS err code: 0
nt secondary err code: 0

Tracing not turned on.
nt main err code: 0
opiodr aborting process unknown ospid (17892098) as a result of ORA-609
nt OS err code: 0
Tns error struct:
nt secondary err code: 0
Time: 08-OCT-2019 10:40:07
TNS-12547: TNS:lost contact
Tue Oct 08 10:40:07 2019
opiodr aborting process unknown ospid (5375628) as a result of ORA-609
nt OS err code: 0
nt main err code: 0
ns secondary err code: 12560
Tue Oct 08 10:40:07 2019
nt main err code: 0
TNS-12547: TNS:lost contact
TNS-12547: TNS:lost contact
Tue Oct 08 10:40:08 2019


nt main err code: 0
nt OS err code: 0

Tue Oct 08 10:40:07 2019
Tracing not turned on.

Tracing not turned on.
TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 0
Tue Oct 08 10:40:07 2019
ns main err code: 12547
nt secondary err code: 0
nt secondary err code: 0
TNS-12547: TNS:lost contact
nt main err code: 0
nt OS err code: 0
nt OS err code: 0
ns secondary err code: 12560
nt main err code: 0
ns secondary err code: 12560
Tue Oct 08 10:40:07 2019
nt main err code: 0
opiodr aborting process unknown ospid (11600558) as a result of ORA-609
Tue Oct 08 10:40:08 2019

nt main err code: 0
nt secondary err code: 0

TNS-12547: TNS:lost contact
Tue Oct 08 10:40:09 2019
nt secondary err code: 0
opiodr aborting process unknown ospid (14877262) as a result of ORA-609
nt OS err code: 0
ns secondary err code: 12560
ns secondary err code: 12560
opiodr aborting process unknown ospid (58458118) as a result of ORA-609
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt secondary err code: 0
nt main err code: 0
ns main err code: 12547
opiodr aborting process unknown ospid (49283130) as a result of ORA-609
ns main err code: 12547
nt main err code: 0
Tracing not turned on.
Tue Oct 08 10:40:07 2019
opiodr aborting process unknown ospid (10618010) as a result of ORA-609
nt main err code: 0
nt secondary err code: 0
Tue Oct 08 10:40:07 2019

TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (44237054) as a result of ORA-609
Tue Oct 08 10:40:09 2019
nt secondary err code: 0
nt secondary err code: 0
nt secondary err code: 0
ns secondary err code: 12560
opiodr aborting process unknown ospid (36962936) as a result of ORA-609 nt main err code: 0

Tracing not turned on.
ns secondary err code: 12560
Tue Oct 08 10:40:11 2019
Tue Oct 08 10:40:11 2019
ns main err code: 12547
nt OS err code: 0
ns secondary err code: 12560
Tue Oct 08 10:40:11 2019
nt secondary err code: 0
opiodr aborting process unknown ospid (20382680) as a result of ORA-609
nt secondary err code: 0
Tue Oct 08 10:40:12 2019
opiodr aborting process unknown ospid (58524220) as a result of ORA-609
nt main err code: 0

nt OS err code: 0
nt OS err code: 0
nt secondary err code: 0

TNS-12547: TNS:lost contact
ns secondary err code: 12560
ns secondary err code: 12560
Time: 08-OCT-2019 10:40:05
opiodr aborting process unknown ospid (14942998) as a result of ORA-609
nt main err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (58851418) as a result of ORA-609opiodr aborting process unknown ospid (44630650) as a result of ORA-609Tue Oct 08 10:40:12 2019

* nt secondary err code: 0
nt OS err code: 0

ns secondary err code: 12560

Tue Oct 08 10:40:11 2019
nt OS err code: 0
Tue Oct 08 10:40:11 2019


nt secondary err code: 0

Tns error struct:

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt secondary err code: 0
opiodr aborting process unknown ospid (10749214) as a result of ORA-609 nt OS err code: 0
ns main err code: 12547

nt OS err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt main err code: 0
nt main err code: 0
Tue Oct 08 10:40:12 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:40:12
Tracing not turned on.
Tns error struct:
ns main err code: 12547

TNS-12547: TNS:lost contact
ns secondary err code: 12560
opiodr aborting process unknown ospid (49807416) as a result of ORA-609
Tracing not turned on.
Tue Oct 08 10:40:10 2019
nt OS err code: 0
nt secondary err code: 0
nt main err code: 0
nt main err code: 0
TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (10225626) as a result of ORA-609
nt OS err code: 0
nt secondary err code: 0
nt OS err code: 0
Tns error struct:
ns secondary err code: 12560
nt secondary err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
Tue Oct 08 10:40:08 2019
Time: 08-OCT-2019 10:40:06
Tue Oct 08 10:40:11 2019
opiodr aborting process unknown ospid (10683546) as a result of ORA-609
Tracing not turned on.
Tns error struct:
ns main err code: 12547

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:40:13
TNS-12547: TNS:lost contact

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
ns secondary err code: 12560

ns main err code: 12547

Tue Oct 08 10:40:12 2019
nt secondary err code: 0
TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (9569428) as a result of ORA-609
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (42926854) as a result of ORA-609
TNS-12547: TNS:lost contact
nt main err code: 0

nt OS err code: 0

Tue Oct 08 10:40:13 2019
Tracing not turned on.
Tue Oct 08 10:40:13 2019

Tue Oct 08 10:40:13 2019
opiodr aborting process unknown ospid (8782966) as a result of ORA-609 nt OS err code: 0

opiodr aborting process unknown ospid (36504214) as a result of ORA-609
opiodr aborting process unknown ospid (59966132) as a result of ORA-609
nt secondary err code: 0
ns secondary err code: 12560
Tracing not turned on.
nt secondary err code: 0
ns secondary err code: 12560
Tns error struct:
Tue Oct 08 10:40:12 2019


nt secondary err code: 0

TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (58393330) as a result of ORA-609
Tue Oct 08 10:40:14 2019
ns main err code: 12547
nt OS err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
ns secondary err code: 12560

Tue Oct 08 10:40:14 2019
opiodr aborting process unknown ospid (7013094) as a result of ORA-609
TNS-12547: TNS:lost contact
nt main err code: 0
Tue Oct 08 10:40:14 2019
nt secondary err code: 0
ns secondary err code: 12560
Tue Oct 08 10:40:13 2019
nt secondary err code: 0
nt main err code: 0
Tue Oct 08 10:40:14 2019

opiodr aborting process unknown ospid (63767446) as a result of ORA-609
Tns error struct:
Tue Oct 08 10:40:14 2019
nt OS err code: 0
nt main err code: 0
Tue Oct 08 10:40:14 2019
nt secondary err code: 0
nt OS err code: 0
nt OS err code: 0
ns secondary err code: 12560
Tns error struct:
nt main err code: 0
Tue Oct 08 10:40:10 2019
TNS-12547: TNS:lost contact
nt main err code: 0
nt OS err code: 0
nt main err code: 0
nt OS err code: 0
Tue Oct 08 10:40:14 2019

nt OS err code: 0
nt OS err code: 0
nt main err code: 0

Time: 08-OCT-2019 10:40:13

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:40:14 2019
nt secondary err code: 0
nt secondary err code: 0
Tns error struct:
Tue Oct 08 10:40:16 2019
nt OS err code: 0
ns secondary err code: 12560
opiodr aborting process unknown ospid (63373992) as a result of ORA-609
nt main err code: 0
nt secondary err code: 0
opiodr aborting process unknown ospid (7341494) as a result of ORA-609
nt OS err code: 0
Tue Oct 08 10:40:14 2019
TNS-12547: TNS:lost contact
Tue Oct 08 10:40:14 2019
nt OS err code: 0
Tue Oct 08 10:40:16 2019


opiodr aborting process unknown ospid (45416652) as a result of ORA-609

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
opiodr aborting process unknown ospid (36765860) as a result of ORA-609

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:40:16
Tracing not turned on.
Tns error struct:
ns main err code: 12547
Tue Oct 08 10:40:16 2019
opiodr aborting process unknown ospid (43188860) as a result of ORA-609
Tue Oct 08 10:40:15 2019
opiodr aborting process unknown ospid (50660050) as a result of ORA-609
nt secondary err code: 0
nt secondary err code: 0
Tue Oct 08 10:40:16 2019
opiodr aborting process unknown ospid (28508406) as a result of ORA-609
ns main err code: 12547
Tracing not turned on.
ns secondary err code: 12560
Tue Oct 08 10:40:16 2019


opiodr aborting process unknown ospid (56886088) as a result of ORA-609
opiodr aborting process unknown ospid (5506224) as a result of ORA-609

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
TNS-12547: TNS:lost contact

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
ns secondary err code: 12560
TNS-12547: TNS:lost contact
Tue Oct 08 10:40:14 2019
nt OS err code: 0
Tue Oct 08 10:40:15 2019


Tue Oct 08 10:40:16 2019
TNS-12547: TNS:lost contact
TNS-12547: TNS:lost contact
nt secondary err code: 0
nt OS err code: 0
nt OS err code: 0
nt main err code: 0
nt main err code: 0
Time: 08-OCT-2019 10:40:16
ns secondary err code: 12560
nt secondary err code: 0

Tracing not turned on.
opiodr aborting process unknown ospid (14615488) as a result of ORA-609
Tns error struct:
nt OS err code: 0
TNS-12547: TNS:lost contact
ns main err code: 12547
ns secondary err code: 12560
nt main err code: 0
Time: 08-OCT-2019 10:40:16
Tracing not turned on.

nt secondary err code: 0

Tns error struct:
nt OS err code: 0
TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (10946036) as a result of ORA-609
ns main err code: 12547
ns secondary err code: 12560
ns main err code: 12547
Tns error struct:
ns secondary err code: 12560
nt main err code: 0
opiodr aborting process unknown ospid (60162702) as a result of ORA-609
nt OS err code: 0
Time: 08-OCT-2019 10:40:16
nt secondary err code: 0
Tracing not turned on.
nt main err code: 0
nt OS err code: 0
nt secondary err code: 0
Tns error struct:
nt OS err code: 0
ns main err code: 12547

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

opiodr aborting process unknown ospid (50594532) as a result of ORA-609
Tue Oct 08 10:40:17 2019
nt OS err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Tue Oct 08 10:40:16 2019
opiodr aborting process unknown ospid (8454926) as a result of ORA-609
nt main err code: 0
Tue Oct 08 10:40:17 2019
opiodr aborting process unknown ospid (63308384) as a result of ORA-609
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (17564280) as a result of ORA-609
Tue Oct 08 10:40:18 2019


ns main err code: 12547
nt main err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
opiodr aborting process unknown ospid (8651940) as a result of ORA-609

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt secondary err code: 0
TNS-12547: TNS:lost contact
Time: 08-OCT-2019 10:40:18
nt OS err code: 0
ns secondary err code: 12560
Tracing not turned on.

opiodr aborting process unknown ospid (64422810) as a result of ORA-609
opiodr aborting process unknown ospid (32636968) as a result of ORA-609
TNS-12547: TNS:lost contact
Time: 08-OCT-2019 10:40:17
opiodr aborting process unknown ospid (329218) as a result of ORA-609
opiodr aborting process unknown ospid (34341616) as a result of ORA-609
TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 0
Tue Oct 08 10:40:19 2019
ns secondary err code: 12560
nt secondary err code: 0
nt main err code: 0
Tue Oct 08 10:40:18 2019
opiodr aborting process unknown ospid (53674714) as a result of ORA-609
nt OS err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (25952392) as a result of ORA-609
Tue Oct 08 10:40:19 2019
nt OS err code: 0
nt main err code: 0
nt main err code: 0
Tns error struct:
ns secondary err code: 12560
nt secondary err code: 0
nt secondary err code: 0
nt main err code: 0
ns main err code: 12547
nt OS err code: 0
nt OS err code: 0

nt secondary err code: 0
nt OS err code: 0

TNS-12547: TNS:lost contact
Tue Oct 08 10:40:16 2019
nt secondary err code: 0
opiodr aborting process unknown ospid (43516540) as a result of ORA-609
opiodr aborting process unknown ospid (11272742) as a result of ORA-609
opiodr aborting process unknown ospid (4589254) as a result of ORA-609
nt OS err code: 0
nt secondary err code: 0
nt secondary err code: 0
Tue Oct 08 10:40:19 2019

ns secondary err code: 12560

Tue Oct 08 10:40:19 2019
opiodr aborting process unknown ospid (10093702) as a result of ORA-609
Tracing not turned on.
opiodr aborting process unknown ospid (49677280) as a result of ORA-609
Tue Oct 08 10:40:19 2019
nt OS err code: 0
Tns error struct:
ns main err code: 12547
Tns error struct:

opiodr aborting process unknown ospid (37159620) as a result of ORA-609
ns main err code: 12547
Tue Oct 08 10:40:18 2019
ns main err code: 12547
TNS-12547: TNS:lost contact

ns secondary err code: 12560

Tue Oct 08 10:40:19 2019
opiodr aborting process unknown ospid (38339294) as a result of ORA-609
TNS-12547: TNS:lost contact
ns secondary err code: 12560
opiodr aborting process unknown ospid (45810226) as a result of ORA-609
TNS-12547: TNS:lost contact
Tue Oct 08 10:40:20 2019
nt OS err code: 0
opiodr aborting process unknown ospid (11404732) as a result of ORA-609
opiodr aborting process unknown ospid (35062508) as a result of ORA-609
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
nt main err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (66323402) as a result of ORA-609
opiodr aborting process unknown ospid (26149510) as a result of ORA-609
ns secondary err code: 12560
nt main err code: 0
opiodr aborting process unknown ospid (9241758) as a result of ORA-609
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
TNS-12547: TNS:lost contact
opiodr aborting process unknown ospid (56230526) as a result of ORA-609
ns secondary err code: 12560
nt main err code: 0
opiodr aborting process unknown ospid (17629814) as a result of ORA-609
nt secondary err code: 0
ns secondary err code: 12560
opiodr aborting process unknown ospid (9110640) as a result of ORA-609
Tue Oct 08 10:40:20 2019
opiodr aborting process unknown ospid (34013198) as a result of ORA-609


nt secondary err code: 0

Tue Oct 08 10:40:20 2019


Tue Oct 08 10:40:21 2019
opiodr aborting process unknown ospid (65601700) as a result of ORA-609

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
nt OS err code: 0

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
nt secondary err code: 0
nt OS err code: 0

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
opiodr aborting process unknown ospid (60293840) as a result of ORA-609
opiodr aborting process unknown ospid (40632994) as a result of ORA-609
VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

nt OS err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0

opiodr aborting process unknown ospid (56819856) as a result of ORA-609
opiodr aborting process unknown ospid (3867744) as a result of ORA-609
Tue Oct 08 10:40:22 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:40:22
Tracing not turned on.
Tns error struct:
ns main err code: 12547

TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (11273572) as a result of ORA-609
Time: 08-OCT-2019 10:40:21
Tracing not turned on.
Tns error struct:
ns main err code: 12547

TNS-12547: TNS:lost contact
ns secondary err code: 12560
opiodr aborting process unknown ospid (8454904) as a result of ORA-609 nt main err code: 0

opiodr aborting process unknown ospid (14221520) as a result of ORA-609
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (41157170) as a result of ORA-609
nt OS err code: 0
Time: 08-OCT-2019 10:40:21
Tracing not turned on.
Tue Oct 08 10:40:23 2019
opiodr aborting process unknown ospid (60620820) as a result of ORA-609
Tns error struct:
ns main err code: 12547

TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (17104932) as a result of ORA-609
Tue Oct 08 10:40:29 2019


Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:40:29
Tracing not turned on.
Tns error struct:
ns main err code: 12547

TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (56950924) as a result of ORA-609
Tue Oct 08 10:40:55 2019


Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:40:55
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505

TNS-00505: Operation timed out
nt secondary err code: 78
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.70.26)(PORT=53603))
Tue Oct 08 10:42:42 2019


Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:42:42
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505

TNS-00505: Operation timed out
nt secondary err code: 78
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.74.215)(PORT=51349))
Tue Oct 08 10:42:49 2019


Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production
Time: 08-OCT-2019 10:42:49
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505

TNS-00505: Operation timed out
nt secondary err code: 78
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.62.210)(PORT=60248))
Tue Oct 08 10:45:22 2019
Thread 1 advanced to log sequence 50663 (LGWR switch)
Current log# 2 seq# 50663 mem# 0: +DATA/orcl/onlinelog/group_2.300.924253815
Tue Oct 08 10:45:22 2019
LNS: Standby redo logfile selected for thread 1 sequence 50663 for destination LOG_ARCHIVE_DEST_2
Tue Oct 08 10:45:23 2019
Archived Log entry 188998 added for thread 1 sequence 50662 ID 0x5694063d dest 1:

(转)Linux┊详解udev

如果你使用Linux比较长时间了,那你就知道,在对待设备文件这块,Linux改变了几次策略。在Linux早期,设备文件仅仅是是一些带有适当的属性集的普通文件,它由mknod命令创建,文件存放在/dev目录下。后来,采用了devfs, 一个基于内核的动态设备文件系统,他首次出现在2.3.46内核中。Mandrake,Gentoo等Linux分发版本采用了这种方式。devfs创建 的设备文件是动态的。但是devfs有一些严重的限制,从2.6.13版本后移走了。目前取代他的便是文本要提到的udev--一个用户空间程序。

目前很多的Linux分发版本采纳了udev的方式,因为它在Linux设备访问,特别是那些对设备有极端需求的站点(比如需要控制上千个硬盘)和热插拔设备(比如USB摄像头和MP3播放器)上解决了几个问题。下面我我们来看看如何管理udev设备。
实际上,对于那些为磁盘,终端设备等准备的标准配置文件而言,你不需要修改什么。但是,你需要了解udev配置来使用新的或者外来设备,如果不修改配置, 这些设备可能无法访问,或者说Linux可能会采用不恰当的名字,属组或权限来创建这些设备文件。你可能也想知道如何修改RS-232串口,音频设备等文件的属组或者权限。这点在实际的Linux实施中是会遇到的。

为什么使用udev

在此之前的设备文件管理方法(静态文件和devfs)有几个缺点:

*不确定的设备映射。特别是那些动态设备,比如USB设备,设备文件到实际设备的映射并不可靠和确定。举一个例子:如果你有两个USB打印机。一个可能称 为/dev/usb/lp0,另外一个便是/dev/usb/lp1。但是到底哪个是哪个并不清楚,lp0,lp1和实际的设备没有一一对应的关系,因为 他可能因为发现设备的顺序,打印机本身关闭等原因而导致这种映射并不确定。理想的方式应该是:两个打印机应该采用基于他们的序列号或者其他标识信息的唯一 设备文件来映射。但是静态文件和devfs都无法做到这点。

*没有足够的主/辅设备号。我们知道,每一个设备文件是有两个8位的数字:一个是主设备号 ,另外一个是辅设备号来分配的。这两个8位的数字加上设备类型(块设备或者字符设备)来唯一标识一个设备。不幸的是,关联这些身边的的数字并不足够。

*/dev目录下文件太多。一个系统采用静态设备文件关联的方式,那么这个目录下的文件必然是足够多。而同时你又不知道在你的系统上到底有那些设备文件是激活的。

*命名不够灵活。尽管devfs解决了以前的一些问题,但是它自身又带来了一些问题。其中一个就是命名不够灵活;你别想非常简单的就能修改设备文件的名字。缺省的devfs命令机制本身也很奇怪,他需要修改大量的配置文件和程序。

*内核内存使用,devfs特有的另外一个问题是,作为内核驱动模块,devfs需要消耗大量的内存,特别当系统上有大量的设备时(比如上面我们提到的系统一个上有好几千磁盘时)

udev的目标是想解决上面提到的这些问题,他通采用用户空间(user-space)工具来管理/dev/目录树,他和文件系统分开。知道如何改变缺省配置能让你之大如何定制自己的系统,比如创建设备字符连接,改变设备文件属组,权限等。

udev配置文件

主要的udev配置文件是/etc/udev/udev.conf。这个文件通常很短,他可能只是包含几行#开头的注释,然后有几行选项:

udev_root=“/dev/”
udev_rules=“/etc/udev/rules.d/”
udev_log=“err“

上面的第二行非常重要,因为他表示udev规则存储的目录,这个目录存储的是以.rules结束的文件。每一个文件处理一系列规则来帮助udev分配名字给设备文件以保证能被内核识别。
你的/etc/udev/rules.d下面可能有好几个udev规则文件,这些文件一部分是udev包安装的,另外一部分则是可能是别的硬件或者软件包 生成的。比如在Fedora Core 5系统上,sane-backends包就会安装60-libsane.rules文件,另外initscripts包会安装60-net.rules文 件。这些规则文件的文件名通常是两个数字开头,它表示系统应用该规则的顺序。

规则文件里的规则有一系列的键/值对组成,键/值对之间用逗号(,)分割。每一个键或者是用户匹配键,或者是一个赋值键。匹配键确定规则是否被应用,而赋 值键表示分配某值给该键。这些值将影响udev创建的设备文件。赋值键可以处理一个多值列表。匹配键和赋值键操作符解释见下表:

udev 键/值对操作符

操作符        匹配或赋值                             解释
----------------------------------------
==             匹配                        相等比较
!=              匹配                        不等比较
=                赋值                       分配一个特定的值给该键,他可以覆盖之前的赋值。
+=              赋值                       追加特定的值给已经存在的键
:=               赋值                       分配一个特定的值给该键,后面的规则不可能覆盖它。

这有点类似我们常见的编程语言,比如C语言。只是这里的键一次可以处理多个值。有一些键在udev规则文件里经常出现,这些键的值可以使用通配符(*,?,甚至范围,比如[0-9]),这些常用键列举如下:

常用udev键
键                 含义
ACTION                     一个时间活动的名字,比如add,当设备增加的时候
KERNEL                     在内核里看到的设备名字,比如sd*表示任意SCSI磁盘设备
DEVPATH              内核设备录进,比如/devices/*
SUBSYSTEM              子系统名字,比如sound,net
BUS                     总线的名字,比如IDE,USB
DRIVER                     设备驱动的名字,比如ide-cdrom
ID                       独立于内核名字的设备名字
SYSFS{ value}              sysfs属性值,他可以表示任意
ENV{ key}              环境变量,可以表示任意
PROGRAM              可执行的外部程序,如果程序返回0值,该键则认为为真(true)
RESULT                     上一个PROGRAM调用返回的标准输出。
NAME                     根据这个规则创建的设备文件的文件名。注意:仅仅第一行的NAME描述是有效的,后面的均忽略。 如果你想使用使用两个以上的名字来访问一个设备的话,可以考虑SYMLINK键。
SYMLINK              根据规则创建的字符连接名
OWNER                     设备文件的属组
GROUP                     设备文件所在的组。
MODE                     设备文件的权限,采用8进制
RUN                     为设备而执行的程序列表
LABEL                     在配置文件里为内部控制而采用的名字标签(下下面的GOTO服务)
GOTO                     跳到匹配的规则(通过LABEL来标识),有点类似程序语言中的GOTO
IMPORT{ type}           导入一个文件或者一个程序执行后而生成的规则集到当前文件
WAIT_FOR_SYSFS         等待一个特定的设备文件的创建。主要是用作时序和依赖问题。
PTIONS                     特定的选项: last_rule 对这类设备终端规则执行; ignore_device 忽略当前规则; ignore_remove 忽略接下来的并移走请求。all_partitions 为所有的磁盘分区创建设备文件。

我们给出一个列子来解释如何使用这些键。下面的例子来自Fedora Core 5系统的标准配置文件。

KERNEL==”*”, OWNER=”root” GROUP=”root”, MODE=”0600″
KERNEL==”tty”, NAME=”%k”, GROUP=”tty”, MODE=”0666″, OPTIONS=”last_rule”
KERNEL==”scd[0-9]*”, SYMLINK+=”cdrom cdrom-%k”
KERNEL==”hd[a-z]”, BUS==”ide”, SYSFS{removable}==”1″,
               SYSFS{device/media}==”cdrom”, SYMLINK+=”cdrom cdrom-%k”
ACTION==”add”, SUBSYSTEM==”scsi_device”, RUN+=”/sbin/modprobe sg”上面的例子给出了5个规则,每一个都是KERNEL或者ACTION键开头:

*第一个规则是缺省的,他匹配任意被内核识别到的设备,然后设定这些设备的属组是root,组是root,访问权限模式是0600(-rw——-)。这也是一个安全的缺省设置保证所有的设备在默认情况下只有root可以读写

*第二个规则也是比较典型的规则了。它匹配终端设备(tty),然后设置新的权限为0600,所在的组是tty。它也设置了一个特别的设备文件名:%K。在这里例子里,%k代表设备的内核名字。那也就意味着内核识别出这些设备是什么名字,就创建什么样的设备文件名。

*第三行开始的KERNEL==”scd[0-9]*”,表示 SCSI CD-ROM 驱动. 它创建一对设备符号连接:cdrom和cdrom-%k。

*第四行,开始的 KERNEL==”hd[a-z]“, 表示ATA CDROM驱动器。这个规则创建和上面的规则相同的符号连接。ATA CDROM驱动器需要sysfs值以来区别别的ATA设备,因为SCSI CDROM可以被内核唯一识别。.

*第五行以 ACTION==”add”开始,它告诉udev增加 /sbin/modprobe sg 到命令列表,当任意SCSI设备增加到系统后,这些命令将执行。其效果就是计算机应该会增加sg内核模块来侦测新的SCSI设备。

当然,上面仅仅是一小部分例子,如果你的系统采用了udev方式,那你应该可以看到更多的规则。如果你想修改设备的权限或者创建信的符号连接,那么你需要熟读这些规则,特别是要仔细注意你修改的那些与之相关的设备。

修改你的udev配置

在修改udev配置之前,我们一定要仔细,通常的考虑是:你最好不要修改系统预置的那些规则,特别不要指定影响非常广泛的配置,比如上面例子中的第一行。不正确的配置可能会导致严重的系统问题或者系统根本就无法这个正确的访问设备。

而我们正确的做法应该是在/etc/udev/rules.d/下创建一个信的规则文件。确定你给出的文件的后缀是rules文件名给出的数字序列应该比 标准配置文件高。比如,你可以创建一个名为99-my-udev.rules的规则文件。在你的规则文件中,你可以指定任何你想修改的配置,比如,假设你 修改修改floppy设备的所在组,还准备创建一个信的符号连接/dev/floppy,那你可以这么写:

KERNEL==”fd[0-9]*“, GROUP=“users“,   SYMLINK+=“floppy“

有些发行版本,比如Fedora,采用了外部脚本来修改某些特定设备的属组,组关系和权限。因此上面的改动可能并不见得生效。如果你遇到了这个问题,你就需要跟踪和修改这个脚本来达到你的目的。或者你可以修改PROGRAM或RUN键的值来做到这点。

某些规则的修改可能需要更深的挖掘。比如,你可能想在一个设备上使用sysfs信息来唯一标识一个设备。这些信息最好通过udevinfo命令来获取。

$ udevinfo –a –p $(udevinfo –q path      –n /dev/hda)上面的命令两次使用udevinfo:一次是返回sysfs设备路径(他通常和我们看到的Linux设备文件名所在路径--/dev/hda--不同);第 二次才是查询这个设备路径,结果将是非常常的syfs信息汇总。你可以找到最够的信息来唯一标志你的设备,你可以采用适当的替换udev配置文件中的 SYSFS选项。下面的结果就是上面的命令输出

[root@localhost rules.d]# udevinfo -a -p $(udevinfo -q path        -n      /dev/hda1)
Udevinfo starts with the device specified by the devpath and then walks up the chain of
parent devices. It prints for every device found,all possible attributes in the udev rules
key format. A rule to match, can be composed by the attributes of the device and the
attributes from one single parent device.

looking at device ‘/block/hda/hda1’:    
KERNEL==”hda1″     SUBSYSTEM==”block”     DRIVER==””       
ATTR{stat}==”        1133         2268            2            4″         ATTR{size}==”208782″
ATTR{start}==”63″         ATTR{dev}==”3:1″        looking at parent device ‘/block/hda’:  

KERNELS==”hda”     SUBSYSTEMS==”block”     DRIVERS==””       
ATTRS{stat}==”28905 18814 1234781 302540 34087 133247 849708 981336 0 218340 1283968″
ATTRS{size}==”117210240″         ATTRS{removable}==”0″       
ATTRS{range}==”64″         ATTRS{dev}==”3:0″

looking at parent device ‘/devices/pci0000:00/0000:00:1f.1/ide0/0.0’:    

KERNELS==”0.0″     SUBSYSTEMS==”ide”     DRIVERS==”ide-disk”       
ATTRS{modalias}==”ide:m-disk”         ATTRS{drivename}==”hda”      
ATTRS{media}==”disk”      
looking at parent device ‘/devices/pci0000:00/0000:00:1f.1/ide0’:    

KERNELS==”ide0″     SUBSYSTEMS==””     DRIVERS==””      
looking at parent device ‘/devices/pci0000:00/0000:00:1f.1’:    
KERNELS==”0000:00:1f.1″     SUBSYSTEMS==”pci”     DRIVERS==”PIIX_IDE”       
ATTRS{broken_parity_status}==”0″         ATTRS{enable}==”1″       
ATTRS{modalias}==”pci:v00008086d000024CAsv0000144Dsd0000C009bc01sc01i8a”
ATTRS{local_cpus}==”1″         ATTRS{irq}==”11″         ATTRS{class}==”0x01018a”
ATTRS{subsystem_device}==”0xc009″         ATTRS{subsystem_vendor}==”0x144d”
ATTRS{device}==”0x24ca”         ATTRS{vendor}==”0x8086″      
looking at parent device ‘/devices/pci0000:00’:    

KERNELS==”pci0000:00″     SUBSYSTEMS==””     DRIVERS==””  
举一个例子:假设你想修改USB扫描仪的配置。通过一系列的尝试,你已经为这个扫描仪标识了Linux设备文件(每次打开扫描仪时,名字都会变)。你可以使 用上面的命令替换这个正确的Linux设备文件名,然后定位输出的采用SYSFS{idVendor}行和SYSFS{idProduct}行。最后你可 以使用这些信息来为这个扫描仪创建新的选项。

SYSFS{idVendor}==”0686″,   SYSFS{idProduct}==”400e”, 
SYMLINK+=”scanner”, MODE=”0664″,   group=”scanner”上面的例子表示将扫描仪的组设置为scanner,访问权限设置为0664,同时创建一个/dev/scanner的符号连接。

udev-FAQ

问:udev是什么? 它的目的何在?

答:udev是一种工具,它能够根据系统中的硬件设备的状态动态更新设备文件,包括设备文件的创建,删除等。设备文件通常放在/dev目录下。使用udev后,在/dev目录下就只包含系统中真正存在的设备。

问:udev支持什么内核?

答:udev只支持linux-2.6内核,因为udev严重依赖于sysfs文件系统提供的信息,而sysfs文件系统只在linux-2.6内核中才有。

问:udev是一个内核程序还是用户程序?

答:udev是一个用户程序(user-mode daemon)。

问:udev和devfs有什么差别?

答:udev能够实现所有devfs实现的功能。但udev运行在用户模式中,而devfs运行在内核模式中。据称:devfs具有一些不太容易解决的先天缺陷。

问:udev的配置文件放在哪里?

答:udev是一个用户模式程序。它的配置文件是/etc/udev/udev.conf。这个文件一般缺省有这样几项:

udev_root=”/dev” ; udev产生的设备文件的根目录是/dev
udev_db=”/dev/.udevdb” ; 通过udev产生的设备文件形成的数据库
udev_rules=”/etc/udev/rules.d” ;用于指导udev工作的规则所在目录。
udev_log=”err” ;当出现错误时,用syslog记录错误信息。

问:udev的工作过程是怎样的?

答:由于没有研究过udev的源程序,不敢贸然就说udev的工作过程。我只是通过一些网上的资料和udev的说明文档,大致猜测它的工作过程可能是这样的。

当内核检测到在系统中出现了新设备后,内核会在sysfs文件系统中为该新设备生成一项新的记录,一般sysfs文件系统会被mount到/sys目录中。新记录是以一个或多个文件或目录的方式来表示。每个文件都包含有特定的信息。(信息是如何表述的,还要另外研究?)

udev在系统中是以守护进程的方式udevd在运行,它通过某种途径(到底什么途径,目前还没搞懂。)检测到新设备的出现,通过查找设备对应的sysfs中的记录得到设备的一些信息。

udev会根据/etc/udev/udev.conf文件中的udev_rules指定的目录,逐个检查该目录下的文件,这个目录下的文件都是针对某类或某个设备应该施行什么措施的规则文件。udev读取文件是按照文件名的ASCII字母顺序来读取的,如果udev一旦找到了与新加入的设备匹配的规则,udev就会根据规则定义的措施对新设备进行配置。同时不再读后续的规则文件。

问:udev的规则文件的语法是怎样的?

答:udev的规则文件以行为单位,以”#”开头的行代表注释行。其余的每一行代表一个规则。每个规则分成一个或多个“匹配”和“赋值”部分。“匹配”部分用“匹配“专用的关键字来表示,相应的“赋值”部分用“赋值”专用的关键字来表示。“匹配”关键字包括:ACTION,KERNEL,BUS,SYSFS等等,“赋值”关键字包括:NAME,SYMLINK,OWNER等等。具体详细的描述可以阅读udev的man文档。

下面举个例子来说明一下,有这样一条规则:SUBSYSTEM==”net”, ACTION==”add”, SYSFS{address}==”00:0d:87:f6:59:f3″, IMPORT=”/sbin/rename_netiface %k eth0″
这个规则中的“匹配”部分有三项,分别是SUBSYSTEM,ACTION和SYSFS。而”赋值”部分有一项,是IMPORT。这个规则就是说,当系统中出现的新硬件属于net子系统范畴,系统对该硬件采取的动作是加入这个硬件,且这个硬件在SYSFS文件系统中的“address”信息等于“00:0d…”时,对这个硬件在udev层次施行的动作是调用外部程序/sbin/rename_netiface,传递的参数有两个,一个是“%k”,代表内核对该新设备定义的名称。另一个是”eth0“。    从上面这个例子中可以看出,udev的规则的写法比较灵活的,尤其在“匹配”部分中,可以通过诸如”*“, ”?“,[a-c],[1-9]等shell通配符来灵活匹配多个匹配项。具体的语法可以参考udev的man文档。

问:udev怎样做到不管设备连接的顺序而维持一个统一的设备名?

答:实际上,udev是通过对内核产生的设备名增加别名的方式来达到上述目的的。前面说过,udev是用户模式程序,不会更改内核的行为。因此,内核依然会我行我素地产生设备名如sda,sdb等。但是,udev可以根据设备的其他信息如总线(bus),生产商(vendor)等不同来区分不同的设备,并产生设备文件。udev只要为这个设备文件取一个固定的文件名就可以解决这个问题。在后续对设备的操作中,只要引用新的设备名就可以了。但为了保证最大限度的兼容,一般来说,新设备名总是作为一个对内核自动产生的设备名的符号链接(link)来使用的。

例如:内核产生了sda设备名,而根据信息,这个设备对应于是我的内置硬盘,那我就可以制定udev规则,让udev除了产生/dev/sda设备文件外,另外创建一个符号链接叫/dev/internalHD。这样,我在fstab文件中,就可以用/dev/internalHD来代替原来的/dev/sda了。下次,由于某些原因,这个硬盘在内核中变成了sdb设备名了,那也不用着急,udev还会自动产生/dev/internalHD这个链接,并指向正确的/dev/sdb设备。所有其他的文件像fstab等都不用修改。

问:怎样才能找到这些设备信息,并把他们放到udev的规则文件中来匹配呢?

答:这个问题比较难,网上资料不多,我只找到一篇文章来介绍如何写udev的规则。他的基本方法是通过udevinfo这个实用程序来找到那些可以作为规则文件里的匹配项的项目。有这样两种情况可以使用这个工具:

第一种情况是,当你把设备插入系统后,系统为设备产生了设备名(如/dev/sda)。那样的
话,你先用udevinfo -q path -n/dev/sda,命令会产生一个该设备名对应的在sysfs下的路径,如/block/sda。然后,你再用udevinfo -a -p/sys/block/sda,这个命令会显示一堆信息,信息分成很多块。这些信息实际来自于操作系统维护的sysfs链表,不同的块对应不同的路径。你就可以用这些信息来作为udev规则文件中的匹配项。但需要注意的是,同一个规则只能使用同一块中显示的信息,不能跨块书写规则。

第二种情况是,不知道系统产生的设备名,那就只有到/sys目录下去逐个目录查找了,反复用udevinfo -a -p/sys/path…这个命令看信息,如果对应的信息是这个设备的,那就恭喜你。否则就再换个目录。当然,在这种情况下,成功的可能性比较小。

问: udev和devfs是什么关系
答: udev完全在用户态(userspace)工作,利用设备加入或移除时内核所发送的hotplug事件(event)来工作。关于设备的详细信息是由内核输出(export)到位于/sys的sysfs文件系统的。所有的设备命名策略、权限控制和事件处理都是在用户态下完成的。与此相反,devfs是作为内核的一部分工作的。

问: 如果udev不能完成所有devfs的工作的话,为什么把devfs标记为OBSOLETE/removed?

答: 引用 Al Viro (Linux VFS 内核维护者):

-devfs所做的工作被确信可以在用户态来完成。
-devfs被加入内核之时,大家寄望它的质量可以迎头赶上。
-devfs被发现了一些可修复和无法修复的 bug。
-对于可修复的 bug,几个月前就已经被修复了,其维护者认为一切良好。
-对于后者,同样是相当常一段时间以来没有改观了。
-devfs的维护者和作者对它感到失望并且已经停止了对代码的维护工作。

问: 但是当一个并不存在的/dev节点被打开的时候,udev并不能如devfs一样自动加载驱动程序。
答: 的确如此,但Linux的设计是在设备被发现的时候加载模块,而不是当它被访问的时候。

问: 不过等等,我确实希望 udev 可以在不存在的节点被打开的时候自动加载驱动。这是我使用devfs的唯一原因了。给udev 增加这个功能吧。
答: 不,udev 是用来管理/dev 的,不是用来加载内核驱动的。

问: 嗨,求你们了。这不难做到的。
答: 这么个功能对于一个配置正确的计算机是多余的。系统中所有的设备都应该产生hotplug 事件、加载恰当的驱动,而 udev 将会注意到这点并且为它创建对应的设备节点。如果你不想让所有的设备驱动停留在内存之中,应该使用其它东西来管理你的模块(如脚本, modules.conf, 等等) 这不是udev 的工作。

问: 但是我真的喜欢那个功能,还是加上吧
答: devfs用的方法导致了大量无用的modprobe尝试,以此程序探测设备是否存在。每个试探性探测都新建一个运行 modprobe 的进程,而几乎所有这些都是无用的。

问: 我喜欢devfs的设备文件命名方式,udev 可以这样命名么?
答: 可以,udev 可以使用 /dev 的命名策略来创建节点。通过一个配置文件,可以把内核缺省的名字映射到 devfs 的名字。可以看看udev 中带的 udev.rules.devfs 文件。注意: devfs 的命名方式是不被建议并且不被官方支持的,因为它所用的简单枚举设备的方式在设备可能被随时加入或删除的情况下确实是一个比较笨的方法。这些编号代给你的将只有麻烦,而并不能用来确定设备。看看那个永久性磁盘 (persistentdisk) 的规则就知道如何在用户态下正确的做这件事,而不是傻傻地列出设备。

问: udev 可以为哪些设备创建节点?
答: 所有在 sysfs 中显示的设备都可以由 udev 来创建节点。如果内核中增加了其它设备的支持,udev 也就自动地可以为它们工作了。现在所有的块设备都在被支持之列,大部分的主字符设备也是被支持的。内核开发者们正致力于让所有的字符设备都被支持。可以到linux-kernel邮件列表上寻找补丁或是查看补丁的状态。

问: udev 是否会去掉匿名设备数量的限制?
答: udev 完全工作于用户态。如果内核支持了更多的匿名设备,udev就会支持。

问: udev 是否会支持符号链接?
答: udev 现在就支持符号链接,每个设备节点拥有多个符号链接也是被支持的。

问: udev如何处理/dev文件系统?
答: 建议使用一个每次启动系统的时候重新创建的 tmpfs 作为 /dev 的文件系统。不过实际上udev并不关心那种文件系统在被使用。

问: 在 init 运行之前,udev 如何处理设备?
答: udev 可以被放入 initramfs 之中,并在每个设备被发现的时候运行。也可以让udev 工作在一个真的根分区被加载之后根据 /sys 的内容创建的初始/dev目录之中。

问: 我是否可以利用 udev 在一个 USB 设备被加载的时候自动加载上这个设备?
答: 技术上讲是可以的,但是 udev 不是用于这个工作的。所有的主流发布版 (distro)都包含了 HAL (http://freedesktop.org/wiki/Software_2fhal) 用于这个工作,它也是专门用于监视设备变更的,并且集成进入了桌面软件。

换个角度说,这可以简单的通过 fstab 来实现:/dev/disk/by-label/PENDRIVE /media/PENDRIVE vfat user,noauto 0 0
这样,用户可以用如下命令来访问设备:
$mount /media/PENDRIVE
同样不需要管理员权限,但却拥有了设备的全部访问权限。使用永久性磁盘链接(label, uuid) 将可以指定同一设备,无论其实际上的内核名字是什么。

问: 有什么我需要注意的安全问题么?
答: 当使用动态设备编号的时候,一个给定的主/从设备号可能在不同时间对应不同的设备,如果一个用户拥有对这个节点的访问权限,并且可以创建一个到这个节点的硬链接,他就可以如此得到一个这个设备节点的拷贝。当设备被移除之后,udev 删除了设备节点,但硬链接依然存在。如果这个设备节点之后被重新使用不同的访问权限被创建的时候,其硬链接仍然可以使用先前的访问权限来访问。(同样的问题也存在在使用 PAM 改变访问权限的 login 上。)

简单的解决方案就是通过把 /dev 放在 tmpfs 这样的单独的文件系统之上来防止建立硬链接。

表 9-2 常规 IB 性能测试命令

表 9-1 常规 IB 监视命令
命令 说明
ibv_asyncwatch 监视 InfiniBand 异步事件
ibv_devices or ibv_devinfo 列举 InfiniBand 设备或设备信息
ibv_rc_pingpong、ibv_srq_pingpong 或 ibv_ud_pingpong 使用 RC 连接、SRQ 或 UD 连接测试节点之间的连通性
mckey 测试 RDMA CM 多播设置和简单数据传输
rping 测试 RDMA CM 连接并尝试 RDMA ping-pong
ucmatose 测试 RDMA CM 连接并尝试简单 ping-pong
udaddy 测试 RDMA CM 数据报设置并尝试简单 ping-pong

表 9-2 常规 IB 性能测试命令
命令 说明
rdma_bw or rdma_lat 测试 RDMA 写处理确定流带宽或等待时间
ib_read_bw 或 ib_read_lat 测试 RDMA 读处理确定带宽或等待时间
ib_send_bw 或 ib_send_lat 测试 RDMA 发送处理确定带宽或等待时间
ib_write_bw 或 ib_write_bw_postlist 测试 RDMA 写处理,确定一次显示一个 I/O 请求的带宽或显示一系列 I/O 请求的发布列表带宽
ib_write_lat 测试 RDMA 写处理确定等待时间
ib_clock_test 测试系统时钟准确性
qperf 测量插槽与 RDMA 性能

表 9-3 RDS 监视与测试工具
命令 说明
rds-info 显示 RDS 内核模块信息
rds-ping 确定基于 RDS 的远程节点是否可访问
rds-stress 在基于 RDS 插槽的进程间发送消息

表 9-4 光纤网络诊断工具
命令 说明
ibdiagnet 执行整个光纤网络诊断检查
ibaddr 查询 InfiniBand 的一个地址或多个地址
ibnetdiscover 搜索远程 InfiniBand 拓扑
ibping 验证 IB 节点之间的连通性
ibportstate 查询 IB 端口的物理端口状态和链接速度
ibroute 显示 InfiniBand 交换机转发表
ibstat 或 ibsysstat 查询 InfiniBand 设备状态或 IB 地址上的系统状态
ibtracert 跟踪 IB 路径
perfquery or saquery 查询 IB 端口计数器或 sIB 子网管理属性
sminfo 查询 IB SMInfo 属性
smpquery 或 smpdump 查询或转储 IB 子网管理属性
ibcheckerrors 或 ibcheckerrs 验证 IB 端口(或节点)或 IB 子网并报告错误
ibchecknet, ibchecknode, 或 ibcheckport 验证 IB 子网、节点或端口并报告错误
ibcheckportstate, ibcheckportwidth, ibcheckstate, or ibcheckwidth 验证已链接但不活动的 IB 端口、面向 1x (2.0 Gbps) 链路带宽的端口、IB 子网中已链接但不活动的端口或 IB 子网中的 lx 链路
ibclearcounters or ibclearerrors 对 IB 子网中的端口计数器或错误计数器进行清零
ibdatacounters or ibdatacounts 查询 IB 子网中的数据计数器或 IB 端口数据计数器
ibdiscover.pl 注释并比较 IB 拓扑
ibhosts 显示拓扑中的 IB 主机节点
iblinkinfo.pl 或 iblinkinfo 显示光纤网络中所有链路的链路信息
ibnodes 显示拓扑中的 IB 节点
ibprintca.pl 显示来自 ibnetdiscover 输出的特定 CA 或 CA 列表
ibprintrt.pl 显示来自 ibnetdiscover 输出的特定路由器或路由器列表
ibprintswitch.pl 显示来自 ibnetdiscover 输出的特定交换机或交换机列表
ibqueryerrors.pl 查询并报告非零 IB 端口计数器
ibrouters 显示拓扑中的 IB 路由器节点
ibstatus 查询 IB 设备的基本状态
ibswitches 显示拓扑中的 IB 交换机节点
ibswportwatch.pl 轮询特定交换机或端口上的计数器并报告更改信息速率
set_nodedesc.sh 设置或显示针对 IB 主机控制器适配器 (HCA) 的节点描述字符串
dump2psl.pl 转储基于 opensm 输出文件的 PSL 文件,该输出文件用于信用循环检查
dump2slvl.pl 转储基于 opensm 输出文件的 SLVL 文件,该输出文件用于信用循环检查
ibis 针对 IB 管理带内服务的扩展 TCL shell