Re: Password file not getting updated

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Tue, 11 Oct 2011 14:01:24 +0530
Message-ID: <CAJsOtB6vLOKNktReAKPgziB__N+sHAToZShK=HgR7-PAEcK9Zg_at_mail.gmail.com>

hello Ram,
-rw------- 1 oracle oinstall 119158 Aug 10 17:19 nohup.out -rw------- 1 oracle oinstall 0 Aug 10 18:18 mtstatus.log

why the below file is owned root..are their many others..

-rw------- 1 root root 862 Oct 5 15:17 sqlnet.log

moslty becuase of sqlnet permission issue..

SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges

SQL> exit

a random guess do you have any other script running, owned by anyother user such as root and that starts stops database or other services..may be that is changing the ownership at runtime, if they are set proprely..

can you change rwx permission of oracle_base/OH to oracle:oinstall user

thanks...subodh

On 11 October 2011 00:52, Ram Raman <veeeraman_at_gmail.com> wrote:

> Thanks all who replied.
> Mark:
>
> [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
>
>
>

-- 
=============================================
TRUTH WINS AT LAST, DO NOT FORGET TO SMILE TODAY
=============================================


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

Received on Tue Oct 11 2011 - 03:31:24 CDT