From: fvanbortel@netscape.net   
      
   Cherrish Vaidiyan wrote:   
      
   > hello,   
   >   
   > I am been getting mad with so many doubts and errors..   
   >   
   > I have posted some doubts,test cases  regarding listener,replication   
   > and standby database.But i havent got any response..(I am sorry as   
   > some of the queries i have posted twice).Is it that my doubt are funny   
   > and simple for u gurus. I am just interested in Oracle on Linux . i   
   > request u all to guide me.   
   >   
   > my error : I cannot log on to database as any user. I cannot startup   
   > the database.My listener is up without any error. When i start the   
   > oracle agent, i get the following error..   
   >   
   > [oracle@localhost 9.2]$  bin/agentctl start   
   >   
   > DBSNMP for Linux: Version 9.2.0.1.0 - Production on 02-JAN-2004   
   > 10:47:31   
   >   
   > Copyright (c) 2002 Oracle Corporation.  All rights reserved.   
   >   
   > Starting Oracle Intelligent   
   > Agent.../usr01/ora9/product/9.2/bin/dbsnmpwd: line 153:  9810   
   > Segmentation fault      nohup $ORACLE_HOME/bin/dbsnmp $*   
   >   
   >>>$DBSNMP_WDLOGFILE 2>&1   
   >   
   > /usr01/ora9/product/9.2/bin/dbsnmpwd: line 153:  9823 Segmentation   
   > fault      nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1   
   > /usr01/ora9/product/9.2/bin/dbsnmpwd: line 153:  9835 Segmentation   
   > fault      nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1   
   > /usr01/ora9/product/9.2/bin/dbsnmpwd: line 153:  9847 Segmentation   
   > fault      nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1   
   > .[oracle@localhost 9.2]$   
   >   
   > then i tried logging on to SQLPLUS. But i get the error below...   
   > SQL> conn system/system@bics as sysoper   
   > ERROR:   
   > ORA-01031: insufficient privileges   
   >   
   > The Solution I tried :   
   >   
   > 1) i deleted the earlier password file and recreated it.   
   > 2) i gave $ unset TWO_TASK   
   > 3) i verified the group which owns pwd.ora it belongs to   
   > oinstall group   
   >   
   > Can you suggest any other options to solve it?? Is it that i have to   
   > delete the database.   
   >   
   > regards,   
   > Cherrish   
      
   So, when I get this correctly, you do not even have your basic   
   setup right, yet you are pounding all over for answers?   
   I have provided you with guidance, scripts, and links - yet you   
   do not seem to:   
   - know what you want (standby db or replication)   
   - want to take it one step at the time   
      
   It looks asif you accepted a task and need it getting done   
   before a deadline, but you haven't got a clue ho, what, or where.   
   All I can say is that lack of planning on your side does not   
   mean any panic on my side.   
   --   
   A prosperous 2004,   
   Regards,   
   Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)