MIME-Version: 1.0
In-Reply-To: <CAHSa0M0TknkiEp0x5zao3cLn=2dW8pb5UV7ORzHJh-C42s1FJA@mail.gmail.com>
References: <CAHSa0M2ja4u9nhwyRwZAAc-idxQxBvGBkzQ=DaFFsQEpR6F7zg@mail.gmail.com>
 <CABe10sb_R58HumPf1b-DGSdhbFG-K07JqBvwZvyX1bAMgVUxDA@mail.gmail.com>
 <CAHSa0M2A5-xvU+=aycSwKEfPedsJXNEdaGMMfbX-BYv6s=YJ0Q@mail.gmail.com>
 <CAG8xnicrGJRS245=4VMd6ER9X1WYtT6+A4xDLG6RUjxKwovQcg@mail.gmail.com>
 <CAHSa0M2E2Xi_gYCgt5rUmQ4q_O2RjW68b3XpaqzExfiLr=eGjA@mail.gmail.com>
 <7C4BF3B32B80CC44AE37D31B172415937DCC9747D3@GVW1337EXC.americas.hpqcorp.net>
 <CAHSa0M0TknkiEp0x5zao3cLn=2dW8pb5UV7ORzHJh-C42s1FJA@mail.gmail.com>
Date: Tue, 11 Oct 2011 10:52:58 +1100
Message-ID: <CAFeFPA-3BBmu5WAu6=t1b0fCnL4njP9zcce4COMnToK8qaqBPQ@mail.gmail.com>
Subject: Re: Password file not getting updated
From: Jack van Zanen <jack@vanzanen.com>
To: veeeraman@gmail.com
Cc: ORACLE-L <oracle-l@freelists.org>
Content-type: text/plain
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: jack@vanzanen.com

Maybe a stupid question, but is the oracle database running under user
oracle?


Jack van Zanen

-------------------------
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment is prohibited. If you have received this e-mail in
error, please contact the sender and delete all copies.
Thank you for your cooperation


On Tue, Oct 11, 2011 at 6:22 AM, Ram Raman <veeeraman@gmail.com> wrote:

> Thanks all who replied.
> Mark:
>
> [oracle@server ~]$ . oraenv
> ORACLE_SID = [oracle] ? ses
> ORACLE_HOME = [/home/oracle] ? /u01/Oracle/ses1
> [oracle@server ~]$
> [oracle@server ~]$
> [oracle@server ~]$ echo $TWO_TASK    <-- no value set
>
> [oracle@server ~]$ id
> uid=500(oracle) gid=501(oinstall) groups=500(dba),501(oinstall)
> [oracle@server ~]$ which sqlplus
> /u01/Oracle/ses1/bin/sqlplus
> [oracle@server ~]$
> [oracle@server ~]$ sqlplus /nolog
> SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 10 14:09:55 2011
> Copyright (c) 1982, 2005, Oracle.  All rights reserved.
> SQL> connect / as sysdba
> ERROR:
> ORA-01031: insufficient privileges
>
> SQL> exit
> [oracle@server ~]$ echo $ORACLE_HOME
> /u01/Oracle/ses1
> [oracle@server ~]$
> [oracle@server ~]$ ls -ltr $ORACLE_HOME
> total 252
> -rw-r--r--   1 oracle oinstall    60 Oct  7  2010 oraInst.loc
> -rw-r-----   1 oracle oinstall    37 Oct  7  2010 install.platform
> drwxr-x---   7 oracle oinstall  4096 Oct  7  2010 jdk
> drwxr-x---   6 oracle oinstall  4096 Oct  7  2010 oui
> drwxr-x---   3 oracle oinstall  4096 Oct  7  2010 jdbc
> drwxr-x---   3 oracle oinstall  4096 Oct  7  2010 diagnostics
> ...
> drwxr-x---  14 oracle oinstall  4096 Oct  3 17:40 search
> drwxr-xr-x   2 oracle oinstall  4096 Oct  5 15:26 bin
> drwxr-x---   2 oracle oinstall  4096 Oct 10 14:00 dbs
>
> [oracle@server ~]$ ls -ltr $ORACLE_HOME/bin | more
> total 234160
> -rwxr-xr-x  1 oracle oinstall     1748 Feb 16  2003 pupbld
> -rwxr-xr-x  1 oracle oinstall     2134 Feb 16  2003 helpins
> -rwxr-x---  1 oracle oinstall       48 Oct  7  2003 oraxsl
> -rwxr-x---  1 oracle oinstall       48 Oct  7  2003 oraxml
> ....
> -rw-------  1 oracle oinstall   119158 Aug 10 17:19 nohup.out
> -rw-------  1 oracle oinstall        0 Aug 10 18:18 mtstatus.log
> -rw-------  1 root   root          862 Oct  5 15:17 sqlnet.log
>
> One thing that needs to be mentioned is that the database was installed by
> the application as part of the application install. It is oracle product
> SES, a product used in web center applications. DBAs did not install it. .
>
> On Mon, Oct 10, 2011 at 12:06 PM, Powell, Mark <mark.powell2@hp.com>
> wrote:
>
> >
> > Also make sure the TWO_TASK environment variable is unset.
> >
> > Can you log in as sysdba from the database server?
> >  set an export ORACLE_HOME and ORACLE_SID then
> >  sqlplus /nolog
> >  connect / as sysdba
> >
> >
> >
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


--
http://www.freelists.org/webpage/oracle-l