Home -> Usenet -> comp.databases.oracle -> Re: Error in starting Oracle agent and ORA:01031 on SQLPLUS

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_at_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 - 10:26:19 CET












Original text of this message