Re: Password file not getting updated

[oracle_at_server ~]$ . oraenv

ORACLE_SID = [oracle] ? ses
ORACLE_HOME = [/home/oracle] ? /u01/Oracle/ses1
[oracle_at_server ~]$
[oracle_at_server ~]$
[oracle_at_server ~]$ echo $TWO_TASK <-- no value set

[oracle_at_server ~]$ id

uid=500(oracle) gid=501(oinstall) groups=500(dba),501(oinstall)
[oracle_at_server ~]$ which sqlplus

/u01/Oracle/ses1/bin/sqlplus
[oracle_at_server ~]$
[oracle_at_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_at_server ~]$ echo $ORACLE_HOME

/u01/Oracle/ses1
[oracle_at_server ~]$
[oracle_at_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_at_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_at_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