MIME-Version: 1.0
In-Reply-To: <7C4BF3B32B80CC44AE37D31B172415937DCC9747D3@GVW1337EXC.americas.hpqcorp.net>
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>
Date: Mon, 10 Oct 2011 14:22:46 -0500
Message-ID: <CAHSa0M0TknkiEp0x5zao3cLn=2dW8pb5UV7ORzHJh-C42s1FJA@mail.gmail.com>
Subject: Re: Password file not getting updated
From: Ram Raman <veeeraman@gmail.com>
To: mark.powell2@hp.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: veeeraman@gmail.com

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