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 $*
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

Hans Forbrich <forbrich (AT) yahoo (DOT) net> wrote

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

Frank van Bortel <fvanbortel (AT) netscape (DOT) net> wrote

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

Cherrish Vaidiyan wrote:
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