tag:blogger.com,1999:blog-6335343228190511009.post491444756488418489..comments2023-10-17T03:07:46.787-07:00Comments on Oracle Apps Technology: connect / as sysdba ORA-01031 Insufficient privilegesVikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-6335343228190511009.post-41927300045612572562012-05-08T14:36:18.700-07:002012-05-08T14:36:18.700-07:00Sandra, the unset is for linux/unix environment. F...Sandra, the unset is for linux/unix environment. For window you can do following.<br /><br />1. Make sure pfile has *.remote_login_passwordfile='EXCLUSIVE'<br /><br />2. sqlnet.ora file has following.<br /><br />SQLNET.AUTHENTICATION_SERVICES= (NTS)<br /><br />#NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)<br /><br />make note that names.directory_path is commented out.<br /><br />Hope it helps.<br /><br />Thanks<br />-Vijay ParmarAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-52643406997114984622012-04-20T13:25:16.413-07:002012-04-20T13:25:16.413-07:00Hello Vukram,
I typed the unset TWO_TASK
at the pr...Hello Vukram,<br />I typed the unset TWO_TASK<br />at the prompt console in both of my units:<br />C:\> unset TWO_TASK<br />"unset" no se reconoce como un comando interno o externo,<br />programa o archivo por lotes ejecutable.<br />C:\>sqlplus/nolog<br /><br />SQL*Plus: Release 11.1.0.6.0 - Production on Vie Abr 20 15:56:56 2012<br /><br />Copyright (c) 1982, 2007, Oracle. All rights reserved.<br /><br />SQL> unset TWO_TASK<br />SP2-0734: inicio "unset TWO_..." de comando desconocido - resto de la lÝnea<br />rado.<br />SQL> unset TWO_TASK<br />SP2-0734: inicio "unset TWO_..." de comando desconocido - resto de la lÝnea<br />rado.<br />SQL> exit<br /><br />C:\>d:<br /><br />D:\>unset TWO_TASK<br />"unset" no se reconoce como un comando interno o externo,<br />programa o archivo por lotes ejecutable.<br /><br />D:\>sqlplus/nolog<br /><br />SQL*Plus: Release 11.1.0.6.0 - Production on Vie Abr 20 15:58:24 2012<br /><br />Copyright (c) 1982, 2007, Oracle. All rights reserved.<br /><br />SQL> conn/as sysdba<br />ERROR:<br />ORA-01031: insufficient privileges<br /><br />SQL><br />I still have the ora-0131 error. Any help is more than appreciated!sandrahttps://www.blogger.com/profile/08485313446645870024noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-6582738791800230082011-12-28T09:04:43.382-08:002011-12-28T09:04:43.382-08:00what is meant by integration & orderbase manag...what is meant by integration & orderbase management systemsandeephttps://www.blogger.com/profile/15808924277808247572noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-18671256622781934902011-12-28T09:03:36.695-08:002011-12-28T09:03:36.695-08:00How otm is installed what is the actuall processHow otm is installed what is the actuall processsandeephttps://www.blogger.com/profile/15808924277808247572noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-27105075428588807082011-09-07T20:37:26.424-07:002011-09-07T20:37:26.424-07:00Hi Vikram,
Simply superb! This resolved my issue ...Hi Vikram,<br /><br />Simply superb! This resolved my issue wherein Sharplex was not able to connect to DB as the sysdba. Both ORACLE_SID and TWO_TASK were set.<br /><br />Thanks,<br />MrinalAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-38604458893574061792010-12-16T08:31:54.153-08:002010-12-16T08:31:54.153-08:00Superb...
Such a simple solution.
But I do not u...Superb...<br /><br />Such a simple solution.<br /><br />But I do not understand why this TWO_TASK creates this problem.<br /><br />RidhiRidhi Sundarnoreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-84882613661611713212010-09-15T23:06:46.232-07:002010-09-15T23:06:46.232-07:00Hi Vikram,
How did you find the "environment...Hi Vikram,<br /><br />How did you find the "environment variable TWO_TASK" causes the<br /><br /><br />ORA-1031 Insufficient Privileges<br /><br />Thanks in advance.Anonymousnoreply@blogger.com