Re: Password file not getting updated

This is probably missing the point but these lines in the output look odd
to me

> [oracle@server ~]$ . oraenv
> ORACLE_SID = [oracle] ? ses
> ORACLE_HOME = [/home/oracle] ? /u01/Oracle/ses1

Surely if . oraenv had worked correctly there wouldn't have been prompt for
ORACLE_HOME. This probably just means that oratab hasn't been set up rather
than a pointer to the actual problem but I just thought I'd point it out.

Cheers,

Ian



|---------+----------------------------->
|         |           deshpande.subodh@g|
|         |           mail.com          |
|         |           Sent by:          |
|         |           oracle-l-bounce@fr|
|         |           eelists.org       |
|         |                             |
|         |                             |
|         |           11/10/2011 09:31  |
|         |           Please respond to |
|         |           deshpande.subodh  |
|         |                             |
|---------+----------------------------->
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                                                     |
  |       To:       veeeraman@xxxxxxxxx                                         
                                                                     |
  |       cc:       oracle-l@xxxxxxxxxxxxx                                      
                                                                     |
  |       Subject:  Re: Password file not getting updated                       
                                                                     |
  |                                                                             
                                                                     |
  |                                                                             
                                                                     |
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|




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@xxxxxxxxx> 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@xxxxxx>
> 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






For the latest data on the economy and society consult National Statistics at 
http://www.ons.gov.uk

*********************************************************************************


Please Note:  Incoming and outgoing email messages are routinely monitored for 
compliance with our policy on the use of electronic communications
*********************************************************************************


Legal Disclaimer  :  Any views expressed by the sender of this message are not 
necessarily those of the Office for National Statistics
*********************************************************************************


The original of this email was scanned for viruses by the Government Secure 
Intranet virus scanning service supplied by Cable&Wireless Worldwide in 
partnership with MessageLabs. (CCTM Certificate Number 2009/09/0052.) On 
leaving the GSi this email was certified virus free.
Communications via the GSi may be automatically logged, monitored and/or 
recorded for legal purposes.
--
http://www.freelists.org/webpage/oracle-l


Other related posts: