By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,501 Members | 1,859 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,501 IT Pros & Developers. It's quick & easy.

Error in starting Oracle agent and ORA:01031 on SQLPLUS

P: n/a
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<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
Jul 19 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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.


CALM DOWN! Responses are provided by volunteers. Many of whom are
taking a vacation because of New Year celebrations.

Also, realize that that there are not that many who are running Oracle9i
on Red Hat 9. And even fewer do replication or standby. A reminder -
Red Hat 9 is not a certified or supported platform. Things can, and
will, go wrong.

From the description, you have a serious problem with your install - you
should not be getting segmentation faults. You may want to check
http://www.dizwell.com for a real detailed guide on installing Oracle9i
9.2 on Red Hat 9.

After install, you may also want to look at the Oracle By Example (OBE)
section of Oracle Tech Net (http://otn.oracle.com/obe/start/index.html)
That provides detailed instructions on installing and doing things in
the Windows environment. By carefully adjusting the OBE instructions,
using the information in Howard's document, you should be able to move
forward.
Jul 19 '05 #2

P: n/a
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<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

Jul 19 '05 #3

P: n/a
Hans Forbrich <fo******@yahoo.net> wrote in message news:<3F***************@yahoo.net>...
CALM DOWN! Responses are provided by volunteers. Many of whom are

taking a vacation because of New Year celebrations.

Also, realize that that there are not that many who are running Oracle9i
on Red Hat 9. And even fewer do replication or standby. A reminder -
Red Hat 9 is not a certified or supported platform. Things can, and
will, go wrong.

From the description, you have a serious problem with your install - you
should not be getting segmentation faults. You may want to check
http://www.dizwell.com for a real detailed guide on installing Oracle9i
9.2 on Red Hat 9.

After install, you may also want to look at the Oracle By Example (OBE)
section of Oracle Tech Net (http://otn.oracle.com/obe/start/index.html)
That provides detailed instructions on installing and doing things in
the Windows environment. By carefully adjusting the OBE instructions,
using the information in Howard's document, you should be able to move
forward.


SIR,
I REQUEST YOUR PARDON FOR THOSE MY LINES.IT WAS BECAUSE I WAS I NEED
OF IT BADLY.ORACLE DB IS WORKING PERFECTLY.AS I HAVE INSTALLED
FOLLOWING THE INSTRUCTION GIVEN IN THE OREILLY WEB SITE. ORACLE WAS
WORKING WELL AND GOOD WHEN I HAD TO CHANGE MY SYSTEM'S HARD DISK TO A
BIGGER 60GB HDD. SINCE I CAN INSTALL ORACLE BY JUST COPYING THE
ORACLE FOLDER IN LINUX. I DID THAT. I CREATED THE GROUP AND USER TO
RUN ORACLE. I SET THE KERNEL PARAMETERS.I STARTED WORKING ON IT. THEN
DUE TO YEAR END I DIDNT USE MY PC FOR A WEEK. NOW WHEN I START ORACLE
AGENT I GET ERROR. THE SECOND ERROR I HAD MENTIONED EARLIER WAS THAT I
COULDNT LOGIN AS SYS,SYSTEM OR ANY OTHER USER. I WAS GETTING ERROR
ORA-01031 INSUFFICIENT PRIVILEGES.
I CORRECTED IT BY DELETING THE EXISTING PASSWORD FILE AND RECREATED
IT. NOW I CAN LOGIN AS SYS WITH SYSDBA PRIVILEGE. I CAN USE DB I HAD
USED BEFORE...

MY TENSION NOW IS WHAT ALL PROCESSES WILL BE AFFECTED BY ORACLE
AGENT.?
CAN I CORRECT THE ERROR BY ANY MEANS....? OR SHOULD I NEED TO
UNINTSALL ORACLE AND INSTALL IT AGAIN?

EXPECTING REPLY,
CHERRISH VAIDIYAN
Jul 19 '05 #4

P: n/a
Cherrish Vaidiyan wrote:


SIR,
I REQUEST YOUR PARDON FOR THOSE MY LINES.IT WAS BECAUSE I WAS I NEED
OF IT BADLY.ORACLE DB IS WORKING PERFECTLY.AS I HAVE INSTALLED
FOLLOWING THE INSTRUCTION GIVEN IN THE OREILLY WEB SITE. ORACLE WAS
WORKING WELL AND GOOD WHEN I HAD TO CHANGE MY SYSTEM'S HARD DISK TO A
BIGGER 60GB HDD. SINCE I CAN INSTALL ORACLE BY JUST COPYING THE
ORACLE FOLDER IN LINUX. I DID THAT. I CREATED THE GROUP AND USER TO
RUN ORACLE. I SET THE KERNEL PARAMETERS.I STARTED WORKING ON IT. THEN
DUE TO YEAR END I DIDNT USE MY PC FOR A WEEK. NOW WHEN I START ORACLE
AGENT I GET ERROR. THE SECOND ERROR I HAD MENTIONED EARLIER WAS THAT I
COULDNT LOGIN AS SYS,SYSTEM OR ANY OTHER USER. I WAS GETTING ERROR
ORA-01031 INSUFFICIENT PRIVILEGES.
I CORRECTED IT BY DELETING THE EXISTING PASSWORD FILE AND RECREATED
IT. NOW I CAN LOGIN AS SYS WITH SYSDBA PRIVILEGE. I CAN USE DB I HAD
USED BEFORE...
You have an incorrect install. This may be due to an incomplete or
incorrect copy. Oracle does not ONLY place it's information in the
$ORACLE_HOME directory.

You do not seem to understand Oracle architecture. Doing so would ease
your tension significantly.


MY TENSION NOW IS WHAT ALL PROCESSES WILL BE AFFECTED BY ORACLE
AGENT.?
CAN I CORRECT THE ERROR BY ANY MEANS....? OR SHOULD I NEED TO
UNINTSALL ORACLE AND INSTALL IT AGAIN?
YES. YOU SHOULD INSTALL AGAIN. YOU HAVE A SERIOUS PROBLEM WITH YOUR
ENVIRONMENT. IT WOULD TAKE TOO LONG TO DEBUG YOUR ENVIRONMENT OVER THIS
MEDIA.

NOTE THAT THE AGENT IS ONLY USED FOR ENTERPRISE MANAGER INTERACTION AND
WILL ONLY CAUSE YOU PROBLEMS WHEN YOU ARE TRYING TO DO SOMETHING THROUGH
THE OEM.

EXPECTING REPLY,
CHERRISH VAIDIYAN


Please do not EXPECT anything from volunteers.

Please do not use UPPERCASE ONLY. That is generally interpreted as
shouting and is considered very rude. Continuing to do so will decrease
the chances that you will get the help you wish.
Jul 19 '05 #5

P: n/a
Hans Forbrich <fo******@yahoo.net> wrote in message news:<3F***************@yahoo.net>...

You have an incorrect install. This may be due to an incomplete or
incorrect copy. Oracle does not ONLY place it's information in the
$ORACLE_HOME directory.

You do not seem to understand Oracle architecture. Doing so would ease
your tension significantly.
Please do not EXPECT anything from volunteers.


Please do not use UPPERCASE ONLY. That is generally interpreted as
shouting and is considered very rude. Continuing to do so will decrease
the chances that you will get the help you wish.


sir,
I am very guily and request pardon all Google users for my words and
specially for typing the queries in uppercase. I didnt knew that
typing in uppercase had such a meaning.Its all because i was not used
to posting FAQs.I never meant as if i was shouting, i typed in
uppercase so that it creates some change to readers from previous
replies. I apologise for my behaviour towards all volunteers and
google users.

I will copy the entire Oracle Directory . I think I have followed
Oracle Flexible Architecture in installation. Thaking you for
correcting my errors.. and suggestions... please dont ignore me...

Respectfully
Cherrish Vaidiyan
Jul 19 '05 #6

P: n/a
Frank van Bortel <fv********@netscape.net> wrote in message news:<bt**********@news1.tilbu1.nb.home.nl>...

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.


Sir,
I request ur pardon for my words & query typed in uppercase. I have
copied the Entire Oracle Folder to the system.so i was getting the
error in Oracle Agent. But i am able to open and use Database. Will my
databse fail due to error in Oracle Agent ?
I am pounding for answers as i am a learner.. i have just 6 months
experience in Oracle.So i am in a testing environment.. i get stucked
in many situation where i cant get any views from books. Its true and
i am very grateful for ur effort and mind to help me by providing
guidance at various stages both personally and though groups.Please do
continue helping me.I accept ur words.
I am working on Database Availability. So I first wanted to implement
Advanced Replication.With ur guidance i did that. Later i got an
article on the net to setup fail over and standby database is best
suited. So after implementing Asynchronous Replication, i tried on
standby Database.
I know that all these stuffs are very tough and only Gurus in Oracle
can perform it.I thought of going into the subject by Trial N Errors
as i like the stream of Database.Hope u got my situation.Thereby i was
first querying about Listeners, then replicationand standby database.
Since a simple replication environment is set with sample tables of
Oracle. I am having some clarification and i am doing it as Test
Cases.So i am not trying to do everything at a stretch.
I accept that i have many disadvantage and lack many things in the
industry.. but i am sure with guidance from persons like you will make
me up.I take up jobs of my interest and ones that i think i can
perform well... leading to a inference...In a way that leads to some
learning.

Please do mail me in person and in the group and guide me...

Respectfully,
Cherrish Vaidiyan
Jul 19 '05 #7

P: n/a
Cherrish Vaidiyan wrote:

Hans Forbrich <fo******@yahoo.net> wrote in message news:<3F***************@yahoo.net>...

You have an incorrect install. This may be due to an incomplete or
incorrect copy. Oracle does not ONLY place it's information in the
$ORACLE_HOME directory.

You do not seem to understand Oracle architecture. Doing so would ease
your tension significantly.
Please do not EXPECT anything from volunteers.


Please do not use UPPERCASE ONLY. That is generally interpreted as
shouting and is considered very rude. Continuing to do so will decrease
the chances that you will get the help you wish.


sir,
I am very guily and request pardon all Google users for my words and
specially for typing the queries in uppercase. I didnt knew that
typing in uppercase had such a meaning.Its all because i was not used
to posting FAQs.I never meant as if i was shouting, i typed in
uppercase so that it creates some change to readers from previous
replies. I apologise for my behaviour towards all volunteers and
google users.

I will copy the entire Oracle Directory . I think I have followed
Oracle Flexible Architecture in installation. Thaking you for
correcting my errors.. and suggestions... please dont ignore me...

Respectfully
Cherrish Vaidiyan


I understand what you were trying to accomplish with the uppercase
typing. For myself, and I hope for the rest of our community, apology
accepted.

Please note: it is generally not well understood that the
comp.database.oracle and comp.databases.oracle newsgroups are obsolete
(and have been for several years). The correct location for the
questions is comp.databases.oracle.server and I encourage you to post
new questions there. This is because some ISPs do not carry obsolete
groups and you are not getting the full benefit of the volunteer
community. (For example, I believe you are missing Sybrand's helpful
hints.)
Now back to your problem:

I strongly encourage you to do a reinstall of your software based on the
discussion papers either from http://www.dizwell.com or
http://www.puschitz.com (both are excellent) . Reinstalling your
software does NOT mean destroying your database as these are separate.
(The software, when running, is your instance that manages the
database.)

The software is generally kept in the $ORACLE_HOME tree. There are
exceptions. It is these exceptions that I am concerned about. Things
like /usr/local/bin, /opt/oracle and possibly others. I am also
extremely concerned that your environment (such as variables) are not
set up correctly. And finally, I worry that you do not have the correct
version of gcc/glibc for recompile/relink. All these things are
discussed in the Dizwell and Puschitz papers.

Please note that there are MANY files in the $ORACLE_HOME directories,
such as (but not limited to) the $ORACLE_HOME/network/admin/*.ora and
some in the $ORACLE_HOME/sysman/config/*.properties, that contain
references to the installed and/or discovered systems. These will be
set up correctly with a reinstall, but will be incorrect for a pure
copy. It MAY be possible to fix your problem by adjusting the entries
in $ORACLE_HOME/network/agent/config files, but I suspect there are
other files as well. (Quite frankly, it's not worth the time or effort
to look for them, as the reinstall will probably be faster and will be
more complete!)

However, the database(s) are generally kept in the $ORACLE_BASE/oradata
tree. These can usually be safely copied between systems that use the
same operating system and same file system. The exceptions to the
location may include the pfile, the log files and possibly the control
files however they may also be copied to a corresponding location on the
clone system. Since various files names and directories are kept in
the pfile (or spfile) and in the control files, you will need to make
sure the database files are initially copied into an identically named
tree structure. Once there and the database is verified operational,
things can be moved (using the alter database command together with
Linux mv command).

I am hoping you are using pfile and not spfile, or at least you are not
editing the spfile directly. Editing the spfile has a high probability
of making your database unusable. If you are using spfile, read the
manual about converting to pfile so you can make appropriate changes
such as directory names. (All manuals are at http://docs.oracle.com and
the most important two are the Concepts Manual and Database
Administration Guide.)

HTH
/Hans
Jul 19 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.