OraFAQ Forum: Server Administration » ORA-01031: insufficient privileges

Home » RDBMS Server » Server Administration » ORA-01031: insufficient privileges (11g, 11.2.0.1, window7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01031: insufficient privileges [message #626975]

Thu, 06 November 2014 01:13

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Dear All,

While logging through sqlplus / as sysdba, getting below error -

C:\Users\3130738>set oracle_sid=ashtest

C:\Users\3130738>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 6 12:39:03 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges


Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SYS@ashtest>  select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS                            TRUE  TRUE  FALSE

SYS@ashtest> show parameter remote_login

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE
SYS@ashtest>

SQLNET.AUTHENTICATION_SERVICES=(NONE). Please assist me to resolve this problem.

Regards,
Ashish

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #626978 is a reply to message #626975]

Thu, 06 November 2014 01:30

John Watson
Messages: 8963
Registered: January 2010
Location: Global Village

Senior Member

This, SQLNET.AUTHENTICATION_SERVICES=(NONE) disables operating system authentication. So you can't login without a password. It isn't an error, this is by design.

[Updated on: Thu, 06 November 2014 01:31]

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #626980 is a reply to message #626978]

Thu, 06 November 2014 02:25

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

... So the solution is to set it to:
SQLNET.AUTHENTICATION_SERVICES=(NT)

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #626981 is a reply to message #626980]

Thu, 06 November 2014 02:54

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

I would use:

SQLNET.AUTHENTICATION_SERVICES=(NTS)

HTH
-g

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #626983 is a reply to message #626981]

Thu, 06 November 2014 03:01

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, thanks to correct my typo.

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #626993 is a reply to message #626983]

Thu, 06 November 2014 06:13

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Dear All,

I tried it with SQLNET.AUTHENTICATION_SERVICES = (NTS) but getting same error.

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #626995 is a reply to message #626993]

Thu, 06 November 2014 06:30

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It works for me.
As you don't show what you do and get we can't accurately help.
Most likely you modified a sqlnet.ora you don't use or you make a typo or the line is commented or...

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #626996 is a reply to message #626993]

Thu, 06 November 2014 06:32

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Post your sqlnet.ora file please.

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #627060 is a reply to message #626996]

Thu, 06 November 2014 23:12

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Dear All,

Please find the sqlnet.ora file.

Attachment: sqlnet.ora
(Size: 0.26KB, Downloaded 2160 times)

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #627061 is a reply to message #627060]

Thu, 06 November 2014 23:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

is COPY & PASTE broken for you?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #627062 is a reply to message #627061]

Thu, 06 November 2014 23:33

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Dear BlackSwan,

Attachment facility is also provided in orafaq. That's why i used it.

Thank you very much for highlighting such things instead of assisting me.
Please find the copy and paste answer --

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

 SQLNET.AUTHENTICATION_SERVICES = (NTS)

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #627063 is a reply to message #627062]

Fri, 07 November 2014 00:19

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Dear All,

My listener is throwing below error-

C:\Users\3130738>lsnrctl

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 07-NOV-2014 11:29:40

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.39.21)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 61: Unknown error
LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.39.21)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 61: Unknown error
LSNRCTL> start
Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is E:\app\product\11.2.0\dbhome_1\network\admin\listener.ora
Log messages written to e:\app\diag\tnslsnr\ER02DSK40615002\listener\alert\log.xml
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.39.21)(PORT=1521)))
TNS-12560: TNS:protocol adapter error
 TNS-00583: Valid node checking: unable to parse configuration parameters


Listener failed to start. See the error message(s) above...



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

e:\app\diag\tnslsnr\ER02DSK40615002\listener\alert>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 7 11:38:17 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges


Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SYS@ashtest> sho parameter local

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string
log_archive_local_first              boolean     TRUE
parallel_force_local                 boolean     FALSE
SYS@ashtest> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.39.21)(PORT = 1521))'
 scope=both;

System altered.

SYS@ashtest> alter system register;

System altered.

SYS@ashtest> conn system/oracle
Connected.
SYSTEM@ashtest> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

e:\app\diag\tnslsnr\ER02DSK40615002\listener\alert>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 7 11:39:39 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges


Enter user-name:

Below are the messages in listener log -

Toggle Spoiler


<msg time='2014-11-06T00:04:13.197+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 00:04:13 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T00:14:14.633+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 00:14:14 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T00:22:36.851+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 00:22:36 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T00:24:16.081+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 00:24:16 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T00:26:43.440+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 00:26:43 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T00:27:13.542+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 00:27:13 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T00:34:17.517+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 00:34:17 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T00:44:18.964+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 00:44:18 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T00:54:20.380+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 00:54:20 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T00:58:41.955+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 00:58:41 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T01:04:21.738+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 01:04:21 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T01:12:43.952+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 01:12:43 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T01:14:23.208+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 01:14:23 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T01:24:24.651+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 01:24:24 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T01:24:48.717+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 01:24:48 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T01:34:26.115+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 01:34:26 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T01:44:27.633+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 01:44:27 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T01:54:28.982+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 01:54:28 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T02:00:02.818+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 02:00:02 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T02:03:15.242+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 02:03:15 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T02:03:54.325+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 02:03:54 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T02:04:24.397+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 02:04:24 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T02:04:30.406+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 02:04:30 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T02:14:31.828+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 02:14:31 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T02:24:33.234+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 02:24:33 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T02:28:51.806+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 02:28:51 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T02:34:34.593+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 02:34:34 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T02:38:53.171+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 02:38:53 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T02:44:35.971+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 02:44:35 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T02:54:37.373+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 02:54:37 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T02:56:49.635+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 02:56:49 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T03:04:38.703+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 03:04:38 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T03:14:40.084+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 03:14:40 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T03:18:10.580+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 03:18:10 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T03:24:41.540+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 03:24:41 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T03:33:00.726+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 03:33:00 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T03:34:42.946+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 03:34:42 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T03:44:44.390+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 03:44:44 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T03:53:00.606+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 03:53:00 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T03:54:45.834+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 03:54:45 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T03:59:07.448+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 03:59:07 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T04:04:47.240+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 04:04:47 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T04:09:08.902+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 04:09:08 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T04:14:48.762+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 04:14:48 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T04:17:37.218+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 04:17:37 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T04:19:10.439+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 04:19:10 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T04:24:50.234+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 04:24:50 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T04:34:51.613+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 04:34:51 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T04:44:53.056+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 04:44:53 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T04:54:54.561+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 04:54:54 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T05:00:49.441+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 05:00:49 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T05:03:10.764+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 05:03:10 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T05:04:56.031+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 05:04:56 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T05:14:57.459+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 05:14:57 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T05:15:12.493+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 05:15:12 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T05:24:58.939+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 05:24:58 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T05:35:00.331+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 05:35:00 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T05:45:01.783+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 05:45:01 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T05:49:23.486+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 05:49:23 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T05:55:03.213+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 05:55:03 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T06:00:49.009+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 06:00:49 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T06:02:46.290+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 06:02:46 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T06:03:16.349+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 06:03:16 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T06:05:04.585+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 06:05:04 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T06:15:06.000+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 06:15:06 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T06:25:07.422+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 06:25:07 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T06:35:08.826+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 06:35:08 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T06:43:19.038+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 06:43:19 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T06:45:10.289+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 06:45:10 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T06:53:20.398+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 06:53:20 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T06:55:11.661+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 06:55:11 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T07:05:13.077+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 07:05:13 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T07:13:23.260+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 07:13:23 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T07:15:14.574+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 07:15:14 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T07:19:36.173+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 07:19:36 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T07:25:15.920+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 07:25:15 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T07:29:37.508+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 07:29:37 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T07:33:26.049+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 07:33:26 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T07:35:17.329+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 07:35:17 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T07:45:18.740+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 07:45:18 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T07:55:20.222+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 07:55:20 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T08:05:21.650+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 08:05:21 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T08:08:01.032+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 08:08:01 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T08:13:28.750+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 08:13:28 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T08:15:23.009+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 08:15:23 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T08:25:24.393+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 08:25:24 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T08:35:25.858+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 08:35:25 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T08:43:32.995+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 08:43:32 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T08:45:27.265+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 08:45:27 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T08:49:51.865+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 08:49:51 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T08:55:28.725+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 08:55:28 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:03:35.763+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:03:35 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:05:29.980+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:05:29 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:05:35.981+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:05:35 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:15:31.378+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:15:31 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:25:32.870+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:25:32 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:35:34.261+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:35:34 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:43:37.826+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:43:37 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:45:34.828+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:45:34 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:55:35.308+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:55:35 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:56:59.532+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:56:59 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:57:17.598+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:57:17 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:59:49.454+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:59:49 * (CONNECT_DATA=(SERVICE_NAME=ashtest)(CID=(PROGRAM=E:\app\product\11.2.0\dbhome_1\bin\rman.exe)(HOST=ER02DSK40615002)(USER=3130738))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.39.21)(PORT=61553)) * establish * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:59:49.656+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:59:49 * (CONNECT_DATA=(SERVICE_NAME=ashtest)(CID=(PROGRAM=E:\app\product\11.2.0\dbhome_1\bin\rman.exe)(HOST=ER02DSK40615002)(USER=3130738))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.39.21)(PORT=61554)) * establish * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:59:49.734+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:59:49 * (CONNECT_DATA=(SERVICE_NAME=ashtest)(CID=(PROGRAM=E:\app\product\11.2.0\dbhome_1\bin\rman.exe)(HOST=ER02DSK40615002)(USER=3130738))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.39.21)(PORT=61555)) * establish * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:59:50.093+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:59:50 * (CONNECT_DATA=(SERVICE_NAME=ashtest)(CID=(PROGRAM=E:\app\product\11.2.0\dbhome_1\bin\rman.exe)(HOST=ER02DSK40615002)(USER=3130738))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.39.21)(PORT=61556)) * establish * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:59:50.187+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:59:50 * (CONNECT_DATA=(SERVICE_NAME=ashtest)(CID=(PROGRAM=E:\app\product\11.2.0\dbhome_1\bin\rman.exe)(HOST=ER02DSK40615002)(USER=3130738))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.39.21)(PORT=61557)) * establish * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:59:50.234+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:59:50 * (CONNECT_DATA=(SERVICE_NAME=ashtest)(CID=(PROGRAM=E:\app\product\11.2.0\dbhome_1\bin\rman.exe)(HOST=ER02DSK40615002)(USER=3130738))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.39.21)(PORT=61558)) * establish * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T09:59:51.154+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 09:59:51 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T10:00:00.186+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 10:00:00 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T10:01:21.931+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 10:01:21 * (CONNECT_DATA=(SERVICE_NAME=ashtest)(CID=(PROGRAM=E:\app\product\11.2.0\dbhome_1\bin\rman.exe)(HOST=ER02DSK40615002)(USER=3130738))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.39.21)(PORT=61562)) * establish * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T10:05:37.509+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 10:05:37 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T10:06:33.981+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 10:06:32 * (CONNECT_DATA=(SERVICE_NAME=ashtest)(CID=(PROGRAM=E:\app\product\11.2.0\dbhome_1\bin\rman.exe)(HOST=ER02DSK40615002)(USER=3130738))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.39.21)(PORT=61579)) * establish * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T10:06:34.636+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 10:06:34 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T10:10:02.354+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 10:10:02 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T10:15:39.530+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 10:15:39 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T10:20:04.472+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 10:20:04 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T10:21:55.871+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 10:21:55 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T10:22:16.946+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 10:22:16 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T10:23:14.151+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 10:23:14 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T10:23:44.258+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 10:23:44 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T10:25:41.680+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 10:25:41 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T10:35:43.840+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 10:35:43 * service_update * ashtest * 0
 </txt>
</msg>
<msg time='2014-11-06T10:36:19.017+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>06-NOV-2014 10:36:17 * service_died * ashtest * 12547
 </txt>
</msg>
<msg time='2014-11-06T10:36:19.033+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>TNS-12547: TNS:lost contact
 </txt>
</msg>
<msg time='2014-11-06T10:39:23.848+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>System parameter file is E:\app\product\11.2.0\dbhome_1\network\admin\listener.ora
 </txt>
</msg>
<msg time='2014-11-06T10:39:24.004+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Log messages written to e:\app\diag\tnslsnr\ER02DSK40615002\listener\alert\log.xml
 </txt>
</msg>
<msg time='2014-11-06T10:39:24.004+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Trace information written to e:\app\diag\tnslsnr\ER02DSK40615002\listener\trace\ora_2024_1100.trc
 </txt>
</msg>
<msg time='2014-11-06T10:39:24.004+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Trace level is currently 0
 </txt>
</msg>
<msg time='2014-11-06T10:39:24.004+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>
 </txt>
</msg>
<msg time='2014-11-06T10:39:24.160+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Started with pid=2024
 </txt>
</msg>
<msg time='2014-11-06T10:39:24.332+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ER02DSK40615002.cmcindia.com)(PORT=1521)))
 </txt>
</msg>
<msg time='2014-11-06T10:39:24.332+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>TNS-12560: TNS:protocol adapter error
 TNS-00583: Valid node checking: unable to parse configuration parameters

 </txt>
</msg>
<msg time='2014-11-06T18:32:32.941+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>System parameter file is E:\app\product\11.2.0\dbhome_1\network\admin\listener.ora
 </txt>
</msg>
<msg time='2014-11-06T18:32:33.066+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Log messages written to e:\app\diag\tnslsnr\ER02DSK40615002\listener\alert\log.xml
 </txt>
</msg>
<msg time='2014-11-06T18:32:33.066+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Trace information written to e:\app\diag\tnslsnr\ER02DSK40615002\listener\trace\ora_1936_1968.trc
 </txt>
</msg>
<msg time='2014-11-06T18:32:33.066+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Trace level is currently 0
 </txt>
</msg>
<msg time='2014-11-06T18:32:33.066+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>
 </txt>
</msg>
<msg time='2014-11-06T18:32:33.331+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Started with pid=1936
 </txt>
</msg>
<msg time='2014-11-06T18:32:33.409+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ER02DSK40615002.cmcindia.com)(PORT=1521)))
 </txt>
</msg>
<msg time='2014-11-06T18:32:33.424+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>TNS-12560: TNS:protocol adapter error
 TNS-00583: Valid node checking: unable to parse configuration parameters

 </txt>
</msg>
<msg time='2014-11-07T09:30:05.950+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>System parameter file is E:\app\product\11.2.0\dbhome_1\network\admin\listener.ora
 </txt>
</msg>
<msg time='2014-11-07T09:30:06.074+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Log messages written to e:\app\diag\tnslsnr\ER02DSK40615002\listener\alert\log.xml
 </txt>
</msg>
<msg time='2014-11-07T09:30:06.074+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Trace information written to e:\app\diag\tnslsnr\ER02DSK40615002\listener\trace\ora_1948_1980.trc
 </txt>
</msg>
<msg time='2014-11-07T09:30:06.074+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Trace level is currently 0
 </txt>
</msg>
<msg time='2014-11-07T09:30:06.074+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>
 </txt>
</msg>
<msg time='2014-11-07T09:30:06.199+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Started with pid=1948
 </txt>
</msg>
<msg time='2014-11-07T09:30:06.386+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ER02DSK40615002.cmcindia.com)(PORT=1521)))
 </txt>
</msg>
<msg time='2014-11-07T09:30:06.386+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>TNS-12560: TNS:protocol adapter error
 TNS-00583: Valid node checking: unable to parse configuration parameters

 </txt>
</msg>
<msg time='2014-11-07T11:29:51.044+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>System parameter file is E:\app\product\11.2.0\dbhome_1\network\admin\listener.ora
 </txt>
</msg>
<msg time='2014-11-07T11:29:51.106+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Log messages written to e:\app\diag\tnslsnr\ER02DSK40615002\listener\alert\log.xml
 </txt>
</msg>
<msg time='2014-11-07T11:29:51.106+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Trace information written to e:\app\diag\tnslsnr\ER02DSK40615002\listener\trace\ora_2516_1340.trc
 </txt>
</msg>
<msg time='2014-11-07T11:29:51.122+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Trace level is currently 0
 </txt>
</msg>
<msg time='2014-11-07T11:29:51.122+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>
 </txt>
</msg>
<msg time='2014-11-07T11:29:54.975+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Started with pid=2516
 </txt>
</msg>
<msg time='2014-11-07T11:29:55.006+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.39.21)(PORT=1521)))
 </txt>
</msg>
<msg time='2014-11-07T11:29:55.022+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ER02DSK40615002'
 host_addr='fe80::a951:ce7e:d880:8ee6%15'>
 <txt>TNS-12560: TNS:protocol adapter error
 TNS-00583: Valid node checking: unable to parse configuration parameters

 </txt>
</msg>

Please assist me to find out the root cause of it.

Regards,
Ashish

[Updated on: Fri, 07 November 2014 00:51] by Moderator

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #627066 is a reply to message #627063]

Fri, 07 November 2014 00:51

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ You don't need any listener to connect a local database
2/ Your user is not in the ORA_DBA OS group

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #627067 is a reply to message #627066]

Fri, 07 November 2014 01:12

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Dear Michel,

1) You are correct. Listener doesn't require as I am connecting database directly.
2) my user 3130738 is in ora_dba group (computer management>> local Users and Groups >>Groups >> ora_dba).

Please let me know where to check more?

Regards,
Ashish

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #627069 is a reply to message #627067]

Fri, 07 November 2014 01:23

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post in a DOS box:

set
net user %USERNAME%
sqlplus / as sysdba

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #627077 is a reply to message #627069]

Fri, 07 November 2014 02:50

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Dear Michel,

Please find the details -

e:\app\diag\tnslsnr\ER02DSK40615002\listener\alert>set
ALLUSERSPROFILE=C:\ProgramData
APPDATA=C:\Users\3130738\AppData\Roaming
CommonProgramFiles=C:\Program Files\Common Files
CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
CommonProgramW6432=C:\Program Files\Common Files
COMPUTERNAME=ER02DSK40615002
ComSpec=C:\Windows\system32\cmd.exe
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Users\3130738
LOCALAPPDATA=C:\Users\3130738\AppData\Local
LOGONSERVER=\\ER01SRVADCAMAC
NUMBER_OF_PROCESSORS=4
oracle_sid=ashtest
OS=Windows_NT
Path=E:\app\product\11.2.0\dbhome_1\bin;C:\Program Files (x86)\Common Files\NetSarang;C:\Program Files\Common
Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;D:\oracl
e\product\10.2.0\client_2\bin;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:
\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program F
iles\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Compone
nts\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\In
tel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\OpenCL SDK\3.0\bin\x86;C:\Program Files (
x86)\Intel\OpenCL SDK\3.0\bin\x64;C:\Program Files (x86)\Windows Live\Shared
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE=AMD64
PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 58 Stepping 9, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=3a09
ProgramData=C:\ProgramData
ProgramFiles=C:\Program Files
ProgramFiles(x86)=C:\Program Files (x86)
ProgramW6432=C:\Program Files
PROMPT=$P$G
PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
PUBLIC=C:\Users\Public
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\Windows
TEMP=C:\Users\3130738\AppData\Local\Temp
TMP=C:\Users\3130738\AppData\Local\Temp
USERDNSDOMAIN=CMCINDIA.COM
USERDOMAIN=CMCINDIA
USERNAME=3130738
USERPROFILE=C:\Users\3130738
windir=C:\Windows
windows_tracing_flags=3
windows_tracing_logfile=C:\BVTBin\Tests\installpackage\csilogfile.log

e:\app\diag\tnslsnr\ER02DSK40615002\listener\alert>net user %USERNAME%
The user name could not be found.

More help is available by typing NET HELPMSG 2221.


e:\app\diag\tnslsnr\ER02DSK40615002\listener\alert>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 7 14:17:16 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges


Enter user-name:

Regards,
Ashish

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #627078 is a reply to message #627077]

Fri, 07 November 2014 02:57

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

e:\app\diag\tnslsnr\ER02DSK40615002\listener\alert>net user %USERNAME%
The user name could not be found.

This is suspicious, is your user a local or a domain user?

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #627083 is a reply to message #627078]

Fri, 07 November 2014 03:05

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Dear Michel,

It's domain user only. No local user. Do I need to add user(3130738) on the ora_dba group?

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #627086 is a reply to message #627083]

Fri, 07 November 2014 03:09

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't know if it will work; I think you already know how to add it Wink

Quote:

computer management>> local Users and Groups >>Groups >> ora_dba

Then click on "Add"

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #627087 is a reply to message #627083]

Fri, 07 November 2014 03:11

John Watson
Messages: 8963
Registered: January 2010
Location: Global Village

Senior Member

I do not think it is possible to use OS authentication if you are a domain user and the instance is running under a local user: a technology limitation. You can try, of course.

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #627100 is a reply to message #627087]

Fri, 07 November 2014 03:47

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Dear John,

You are correct. It's not allowed.

Even when i tried to delete the database though dbca,it gives the same error - ORA-01031: insufficient privileges. When pressed on OK button, another message pop-up

connection to the database failed, verify the user name and password and try again.

Waiting for your valuable inputs -

regards,
Ashish

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #627126 is a reply to message #627100]

Fri, 07 November 2014 09:55

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As we said, you have to create a local account.

Report message to a moderator

Previous Topic:	license of oracle 11g
Next Topic:	Release storage back to Unix OS from Oracle 11g Tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 17 22:46:48 CST 2025