Re: Error in starting Oracle agent and ORA:01031 on SQLPLUS

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 02 Jan 2004 10:26:19 +0100
Message-ID: <bt3cu3$af8$1@news1.tilbu1.nb.home.nl>

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_at_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_at_localhost 9.2]$
>
> then i tried logging on to SQLPLUS. But i get the error below...
> SQL> conn system/system_at_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<DBNAME>.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

Received on Fri Jan 02 2004 - 03:26:19 CST