ORA-28575: unable to open RPC connection to external procedure agent

Hello Experts,

I am getting error while executing shell command from PLSQL.

Error:

declare
  retval number;
begin
  retval := msi_shell2('pwd');
 if (retval <>0) then
   dbms_output.put_line('failed');
else
  dbms_output.put_line('woohoo!');
end if;
end;

ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "******.MSI_SHELL2", line 1
ORA-06512: at line 4

Open in new window



Here is the below process done till now to set up this process:

1) created a folder under "/home/oracle/app/" as like below:
                 
/home/oracle/app/scripts/extproc/scripts/extproc

Open in new window


2) created a shell.c file with below code:

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
void sh(char *);
int sh2(char *);
void sh( char  *cmd )
{
        int num;
        num = system(cmd);
}
int sh2( char  *cmd )
{
        int num;
        num = system(cmd);
        return num;
}

Open in new window


3) compiled with below steps:

[oracle@**********]$ gcc -fPIC -c shell.c
[oracle@**********]$ gcc -shared -static-libgcc -o shell.so shell.o
[oracle@**********]$ chmod 775 shell.so

Open in new window


after this three files are created .

4) Now went to "/home/oracle/app/oracle/product/11.2.0/dbhome_1/hs/admin" path and opened "extproc.ora" file.

Added from :

#
# * ANY 
#   When EXTPROC_DLLS=ANY, DLL checking is disabled.
# 
#   Syntax: SET EXTPROC_DLLS=ANY
#
SET EXTPROC_DLLS=

Open in new window


To :

#
# * ANY 
#   When EXTPROC_DLLS=ANY, DLL checking is disabled.
# 
#   Syntax: SET EXTPROC_DLLS=ANY
#
SET EXTPROC_DLLS=ANY

Open in new window


5) Went to "/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin" path and changed the setting of "tnsnames.ora" and  "listener.ora" files.

tnsname.ora changes :

From :

# tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DB11204 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = db11204)
    )
  )

Open in new window


to

# tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

extproc_connection_data =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (CONNECT_DATA = (SID = EXTPROC1521)(SERVER=DEDICATED)
  )
    )

DB11204 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =myhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = db11204)
    )
  )

Open in new window


listner.ora file changes :

From :

# listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /home/oracle/app/oracle

Open in new window


TO :

# listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
    )
  )
SID_LIST_LISTENER_PROC =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = db11204)
      (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0)
    )
    (SID_DESC =
      (SID_NAME = EXTPROC1521)
      (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0)
      (PROGRAM = EXTPROC1521)
      (ENVS='EXTPROC_DLLS=ANY,PATH=/bin:/usr/bin:/usr/ccs/bin:/usr/ucb:/home/oracle/app/scripts/extproc')
    )
  )
ADR_BASE_LISTENER = /home/oracle/app/oracle
STARTUP_WAIT_TIME_LISTENER_PROC = 0
CONNECT_TIMEOUT_LISTENER_PROC = 10
TRACE_LEVEL_LISTENER_PROC = OFF  

Open in new window


6) Now created the library :

create or replace library MSI_CUST_LIB
  as '/home/oracle/app/scripts/extproc/shell.so';

Open in new window


7) created the function :

CREATE OR REPLACE FUNCTION msi_shell2 (cmd IN CHAR) RETURN number
AS EXTERNAL
   NAME "sh2"
   LIBRARY MSI_CUST_LIB
   LANGUAGE C
PARAMETERS (
    cmd STRING);

Open in new window


8) Finally calling the function to execute the shell command :

declare
  retval number;
begin
  retval := msi_shell2('pwd');
 if (retval <>0) then
   dbms_output.put_line('failed');
else
  dbms_output.put_line('woohoo!');
end if;
end;

Open in new window


Where I am getting the error.

Experts , please help me in identifying what mistake I am doing here.
LVL 17
Swadhin RaySenior Technical Engineer Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
Does the listener status show extproc is being listened for?
If so, check the listener.log file for additional error messages.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Swadhin RaySenior Technical Engineer Author Commented:
As this was not working so removed everything from tns and listner file. and only kept extproc.ora changes.
0
Swadhin RaySenior Technical Engineer Author Commented:
Status on listener :

[oracle@********** ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 21-AUG-2015 19:02:17

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                21-AUG-2015 19:02:07
Uptime                    0 days 0 hr. 0 min. 9 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /home/oracle/app/oracle/diag/tnslsnr/**********/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=**********.metricstream.com)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@********** ~]$

Open in new window

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

slightwv (䄆 Netminder) Commented:
It will be kind of hard to troubleshoot without everything set up.

Anyway, unless you deleted the listeners log file, the old attempts should still be there as long as the connection attempt made it to the listener.
0
Swadhin RaySenior Technical Engineer Author Commented:
I deleted the log and show the same status.
0
slightwv (䄆 Netminder) Commented:
Why did you delete the log?  It should have had the failed attempts at executing your procedure.

The log and the status aren't related.

Now, in order to troubleshoot what is causing the ORA-28575 you will need to redo everything.
0
Swadhin RaySenior Technical Engineer Author Commented:
redone everything.

Here is what I am able to see from my log :

<msg time='2015-08-21T19:20:09.469+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********' version='1'>
 <txt>System parameter file is /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
 </txt>
</msg>
<msg time='2015-08-21T19:20:09.469+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Log messages written to /home/oracle/app/oracle/diag/tnslsnr/**********/listener/alert/log.xml
 </txt>
</msg>
<msg time='2015-08-21T19:20:09.469+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Trace information written to /home/oracle/app/oracle/diag/tnslsnr/**********/listener/trace/ora_7182_140240935917312.trc
 </txt>
</msg>
<msg time='2015-08-21T19:20:09.469+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Trace level is currently 0
 </txt>
</msg>
<msg time='2015-08-21T19:20:09.469+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>
 </txt>
</msg>
<msg time='2015-08-21T19:20:09.470+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Started with pid=7182
 </txt>
</msg>
<msg time='2015-08-21T19:20:09.471+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
 </txt>
</msg>
<msg time='2015-08-21T19:20:09.474+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=1521)))
 </txt>
</msg>
<msg time='2015-08-21T19:20:09.478+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Listener completed notification to CRS on start
 </txt>
</msg>
<msg time='2015-08-21T19:20:09.478+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
 </txt>
</msg>
<msg time='2015-08-21T19:20:09.480+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>WARNING: Subscription for node down event still pending
 </txt>
</msg>
<msg time='2015-08-21T19:20:09.480+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:20:09 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=**********)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * status * 0
 </txt>
</msg>
<msg time='2015-08-21T19:20:14.863+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>WARNING: Subscription for node down event still pending
 </txt>
</msg>
<msg time='2015-08-21T19:20:14.863+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:20:14 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=**********)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * status * 0
 </txt>
</msg>
<msg time='2015-08-21T19:20:59.466+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:20:59 * service_register * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:21:14.470+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:21:14 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:21:44.478+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:21:44 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:22:14.488+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:22:14 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:22:44.501+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:22:44 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:23:14.509+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:23:14 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:23:44.519+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:23:44 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:23:59.524+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:23:59 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:24:05.526+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:24:05 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:27:08.697+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:27:08 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:27:44.733+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:27:44 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:27:52.421+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:27:52 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39080)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:27:53.742+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:27:53 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:28:14.763+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:28:14 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:28:44.793+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:28:44 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:29:14.823+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:29:14 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:29:19.712+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:29:19 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39083)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:29:20.484+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:29:20 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39085)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:29:20.830+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:29:20 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:29:21.274+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:29:21 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39086)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:29:23.833+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:29:23 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:29:24.373+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:29:24 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39088)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:29:26.836+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:29:26 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:29:44.853+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:29:44 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:33:45.094+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:33:45 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:34:03.112+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:34:03 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:34:06.115+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:34:06 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:34:15.124+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:34:15 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:34:45.154+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:34:45 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:35:15.184+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:35:15 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:35:45.215+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:35:45 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:35:54.563+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:35:54 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39129)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:35:57.227+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:35:57 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:36:15.245+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:36:15 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:36:25.495+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>WARNING: Subscription for node down event still pending
 </txt>
</msg>
<msg time='2015-08-21T19:36:25.496+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:36:25 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=**********)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * status * 0
 </txt>
</msg>
<msg time='2015-08-21T19:36:28.534+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
 </txt>
</msg>
<msg time='2015-08-21T19:36:28.534+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=1521)))
 </txt>
</msg>
<msg time='2015-08-21T19:36:29.540+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Listener completed notification to CRS on stop
 </txt>
</msg>
<msg time='2015-08-21T19:36:29.542+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:36:28 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=**********)(USER=oracle))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * stop * 0
 </txt>
</msg>
<msg time='2015-08-21T19:36:35.355+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>System parameter file is /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
 </txt>
</msg>
<msg time='2015-08-21T19:36:35.355+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Log messages written to /home/oracle/app/oracle/diag/tnslsnr/**********/listener/alert/log.xml
 </txt>
</msg>
<msg time='2015-08-21T19:36:35.355+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Trace information written to /home/oracle/app/oracle/diag/tnslsnr/**********/listener/trace/ora_7321_139961083078400.trc
 </txt>
</msg>
<msg time='2015-08-21T19:36:35.356+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Trace level is currently 0
 </txt>
</msg>
<msg time='2015-08-21T19:36:35.356+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>
 </txt>
</msg>
<msg time='2015-08-21T19:36:35.357+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Started with pid=7321
 </txt>
</msg>
<msg time='2015-08-21T19:36:35.358+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
 </txt>
</msg>
<msg time='2015-08-21T19:36:35.360+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=1521)))
 </txt>
</msg>
<msg time='2015-08-21T19:36:35.364+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Listener completed notification to CRS on start
 </txt>
</msg>
<msg time='2015-08-21T19:36:35.365+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
 </txt>
</msg>
<msg time='2015-08-21T19:36:35.366+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>WARNING: Subscription for node down event still pending
 </txt>
</msg>
<msg time='2015-08-21T19:36:35.366+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:36:35 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=**********)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * status * 0
 </txt>
</msg>
<msg time='2015-08-21T19:36:52.895+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>WARNING: Subscription for node down event still pending
 </txt>
</msg>
<msg time='2015-08-21T19:36:52.896+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:36:52 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=**********)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * status * 0
 </txt>
</msg>
<msg time='2015-08-21T19:37:20.028+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:37:20 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39130)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:37:20.028+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:37:30.328+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:37:30 * service_register * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:37:45.335+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:37:45 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:38:15.365+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:38:15 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:38:33.383+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:38:33 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:38:45.394+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:38:45 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:39:15.425+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:39:15 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:39:28.739+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:39:28 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39166)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:39:30.440+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:39:30 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:39:45.455+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:39:45 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:40:15.485+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:40:15 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:40:45.516+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:40:45 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:41:15.545+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:41:15 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:41:45.576+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:41:45 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:42:15.605+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:42:15 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:42:45.635+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:42:45 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:43:13.245+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:43:13 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39172)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:43:14.020+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:43:14 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39174)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:43:14.061+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:43:14 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39175)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:43:45.695+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:43:45 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:44:06.716+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:44:06 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:44:45.755+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:44:45 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:45:05.752+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:45:05 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39190)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:45:06.525+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:45:06 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39192)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:45:07.330+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:45:07 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39193)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:45:41.325+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>WARNING: Subscription for node down event still pending
 </txt>
</msg>
<msg time='2015-08-21T19:45:41.325+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:45:41 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=**********)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * status * 0
 </txt>
</msg>
<msg time='2015-08-21T19:45:45.586+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
 </txt>
</msg>
<msg time='2015-08-21T19:45:45.586+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=1521)))
 </txt>
</msg>
<msg time='2015-08-21T19:45:50.405+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Listener completed notification to CRS on stop
 </txt>
</msg>
<msg time='2015-08-21T19:45:50.407+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:45:45 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=**********)(USER=oracle))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * stop * 0
 </txt>
</msg>
<msg time='2015-08-21T19:45:55.306+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>System parameter file is /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
 </txt>
</msg>
<msg time='2015-08-21T19:45:55.306+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Log messages written to /home/oracle/app/oracle/diag/tnslsnr/**********/listener/alert/log.xml
 </txt>
</msg>
<msg time='2015-08-21T19:45:55.307+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Trace information written to /home/oracle/app/oracle/diag/tnslsnr/**********/listener/trace/ora_7399_140394971916032.trc
 </txt>
</msg>
<msg time='2015-08-21T19:45:55.307+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Trace level is currently 0
 </txt>
</msg>
<msg time='2015-08-21T19:45:55.307+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>
 </txt>
</msg>
<msg time='2015-08-21T19:45:55.307+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Started with pid=7399
 </txt>
</msg>
<msg time='2015-08-21T19:45:55.309+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
 </txt>
</msg>
<msg time='2015-08-21T19:45:55.313+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=1521)))
 </txt>
</msg>
<msg time='2015-08-21T19:45:55.317+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>Listener completed notification to CRS on start
 </txt>
</msg>
<msg time='2015-08-21T19:45:55.318+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
 </txt>
</msg>
<msg time='2015-08-21T19:45:55.322+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>WARNING: Subscription for node down event still pending
 </txt>
</msg>
<msg time='2015-08-21T19:45:55.322+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:45:55 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=**********)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * status * 0
 </txt>
</msg>
<msg time='2015-08-21T19:46:00.026+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:00 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39204)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:46:00.026+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:46:00.577+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>WARNING: Subscription for node down event still pending
 </txt>
</msg>
<msg time='2015-08-21T19:46:00.577+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:00 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=**********)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * status * 0
 </txt>
</msg>
<msg time='2015-08-21T19:46:19.945+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:19 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39208)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:46:19.945+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:46:20.697+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:20 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39209)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:46:20.697+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:46:21.449+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:21 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39210)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:46:21.449+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:46:24.005+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:24 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39211)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:46:24.005+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:46:25.590+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:25 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39212)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:46:25.590+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:46:26.342+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:26 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39213)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:46:26.342+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:46:28.913+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:28 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39214)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:46:28.913+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:46:29.666+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:29 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39215)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:46:29.666+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:46:30.422+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:30 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39216)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:46:30.423+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:46:33.681+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:33 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39217)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:46:33.681+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:46:34.433+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:34 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39218)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:46:34.433+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:46:35.612+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:35 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39219)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:46:35.612+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:46:38.428+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:38 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39220)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:46:38.428+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:46:39.180+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:39 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39221)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:46:39.180+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:46:40.213+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:40 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39222)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:46:40.213+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:46:44.474+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:44 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39223)) * establish * db11204 * 12505
 </txt>
</msg>
<msg time='2015-08-21T19:46:44.474+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 </txt>
</msg>
<msg time='2015-08-21T19:46:51.883+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:51 * service_register * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:46:52.100+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:52 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39224)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:46:54.884+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:54 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:46:55.807+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:55 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39226)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:46:56.921+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:56 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39235)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:46:56.942+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:56 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39236)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:46:57.715+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:46:57 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39237)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:47:03.076+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:47:03 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39238)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:47:03.853+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:47:03 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39239)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:47:21.822+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:47:21 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39250)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:47:22.595+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:47:22 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39251)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:47:22.639+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:47:22 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39252)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:47:24.914+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:47:24 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:47:34.370+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:47:34 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39254)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:47:35.439+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:47:35 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39263)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:47:36.211+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:47:36 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39264)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:47:36.254+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:47:36 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39265)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:47:39.929+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:47:39 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:47:43.069+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:47:43 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39266)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:47:45.935+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:47:45 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:47:54.944+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:47:54 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:08.749+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:08 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39270)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:09.800+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:09 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39278)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:09.959+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:09 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:10.574+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:10 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39279)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:11.350+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:11 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39280)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:12.962+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:12 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:15.965+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:15 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:21.518+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:21 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39281)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:21.972+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:21 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:22.313+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:22 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39282)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:24.975+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:24 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:29.629+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:29 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39286)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:30.401+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:30 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39288)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:31.193+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:31 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39289)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:43.739+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:43 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39309)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:44.510+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:44 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39310)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:45.285+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:45 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39311)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:45.996+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:45 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:48.752+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:48 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39312)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:48.999+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:48 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:57.616+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:57 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39313)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:57.632+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:57 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39314)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:48:58.008+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:48:58 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:49:03.514+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:49:03 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39316)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:49:04.291+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:49:04 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39318)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:49:07.019+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:49:07 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:49:16.027+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:49:16 * service_update * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:49:24.416+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:49:24 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39320)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:49:24.456+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:49:24 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39321)) * establish * db11204 * 0
 </txt>
</msg>
<msg time='2015-08-21T19:49:24.493+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='**********'
 host_addr='**********'>
 <txt>21-AUG-2015 19:49:24 * (CONNECT_DATA=(SID=db11204)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=**********)(PORT=39322)) * establish * db11204 * 0
 </txt>
</msg>

Open in new window

0
slightwv (䄆 Netminder) Commented:
Next time, check the log from the trace folder.  It is the old style not the XML version.  The XML stuff is mainly for OEM to be able to parse, not humans.

I don't see where the connection attempt made it to the listener.  There aren't any failed connections in the provided log that I can find.

I've only messed around with external procedures many years ago and it looks like some things have changed.

Some of the documentation mentions starting the agent with agtctl.  I don't see where you start it from what you posted above.  That might explain why the connection doesn't seem to have made it to the listener.
0
Swadhin RaySenior Technical Engineer Author Commented:
I think I am doing something wrong on setting the listener.ora file . Which is messing up the part.
0
slightwv (䄆 Netminder) Commented:
>>PROGRAM = EXTPROC1521

I've only ever seen the defaults of EXTPROC.  I'm not sure where EXTPROC is mandatory and where you can use your own names.

I would suggest using the defaults to get it working.  Once it is working, then start changing names to EXTPROC1521.
0
Swadhin RaySenior Technical Engineer Author Commented:
Did I did anything wrong on the setting .... what I mentioned on my questions ?
0
Swadhin RaySenior Technical Engineer Author Commented:
Even I tried with putting EXTPROC on the KEY and SID and program name but still same error.
0
slightwv (䄆 Netminder) Commented:
>>Did I did anything wrong on the setting

I don't know.  I only played with it many years ago.  It isn't something I can point to and say "look here".

I have to go by the documentation and look where you have something different.

Hopefully another Expert that has more recent hands-on experience with external procedures will arrive later.
0
Swadhin RaySenior Technical Engineer Author Commented:
The issue was with the listener file. Fixed it. Working fine now.
0
slightwv (䄆 Netminder) Commented:
In case someone else has this same issue, what was the fix?
0
Swadhin RaySenior Technical Engineer Author Commented:
@slightwv:

Here is the complete steps followed to achieve this solution:

1) created a shell.c file with below code:

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
void sh(char *);
int sh2(char *);
void sh( char  *cmd )
{
        int num;
        num = system(cmd);
}
int sh2( char  *cmd )
{
        int num;
        num = system(cmd);
        return num;
}


2) keep the file under "/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib"

3) compiled the shell.c program with below steps:
[oracle@**********]$ gcc -fPIC -c shell.c
[oracle@**********]$ gcc -shared -static-libgcc -o shell.so shell.o
[oracle@**********]$ chmod 775 shell.so

after this three files are created .

4) Now went to "/home/oracle/app/oracle/product/11.2.0/dbhome_1/hs/admin" path and opened "extproc.ora" file.

Added from :


#
# * ANY 
#   When EXTPROC_DLLS=ANY, DLL checking is disabled.
# 
#   Syntax: SET EXTPROC_DLLS=ANY
#
SET EXTPROC_DLLS=ANY


5) Went to "/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin" path and changed the setting of "tnsnames.ora" and  "listener.ora" files. 


listner.ora file changes :
From :
# listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /home/oracle/app/oracle

TO: 

# listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1 )
      (PROGRAM = extproc)
      (ENV = "EXTPROC_DLLS=ANY:/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/shell.so,LD_LIBRARY_PATH=/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
    )
  )


ADR_BASE_LISTENER = /home/oracle/app/oracle



tnsname.ora changes : 

From :

# tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DB11204 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = db11204)
    )
  )


TO: 
# tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DB11204 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = db11204)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = 
        (PROTOCOL = IPC)
        (KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )  


6) restart or reload listener :

lsnrctl reload

Check the service and status:

 lsnrctl service   
 lsnrctl status
 
 
7)  Now created the library :

create or replace library EXTPROCSHELL_LIB
     as '/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/extprocsh.so'; 
  
8) Create a oracle function to utilize the library:

 CREATE OR REPLACE FUNCTION msi_shell (cmd IN CHAR) RETURN number
AS EXTERNAL
   NAME "sh2"
   LIBRARY EXTPROCSHELL_LIB
   LANGUAGE C
PARAMETERS (
    cmd STRING);



9) Test the function :


declare
  retval number;
begin
  retval := msi_shell('/bin/ls /home/oracle/app/ > /home/oracle/app/scripts/extproc/out.txt');
 if (retval <>0) then
   dbms_output.put_line('Error');
else
  dbms_output.put_line('Passed!');
end if;
end;


	
  

Open in new window

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.