Oracle 9.2.0.1.0 on Solaris 5.9

our database backups.  We've never used rman, but today I started
playing around with it, and got quite a shock.  Connected to a target

Are there any papers/docs available to compare the pros and cons
between Advanced Replication and Streams? (For data replication purpose
only).
Thanks a lot!

My workplace is having a debate on what to use for a file system/disk
management perspective for RAC.  I would like to know what others have
built their RAC clusters on, are more people using ASM or GPFS.  I'm
not a DBA, but do support Unix and lean towards using ASM.  I've read

Friday, the 31st we needed to restore the last backup of our Oracle 9.2
database.
We backup all the days only the oradata/SID directory.
So, I shutdown immediatly the DB.

Hi, im trying to use the instant client libs in an app that im
buildings in C++ in XCode on MacOSX 10.4.5 and im running into a bit of
trouble. I need to be able to connect to a remote Oracle server and do
some queries and close the connection. With OCCI, it's pretrty

hello group,
is there sb sucessfully using a SAN which is not labeld
by ibm, hp, dell ?
I would like to spend money on a SAN at which I

I have Oracle 8i DB server running on RH AS 2.1.
Here is my problem;
When I try to connect to the DB from an external system (using jdbc
thin driver) sometimes i get "network adapter could not establish the

A database to which our database is connected via db link has
collectted statistics. So executiion plan of some sqls may be changed.
How can I identify these bad sqls running over the db link?
Which wait events should I monitor?

when you install the 10g agent it automatically picks up the database
name - but where is does it get the name from. The reason I ask is that
some of our databases are being picked up as having duplicate names,
and I'd like to be able to distinguish them. Is there any way of

I've completed a cold backup using the following syntax:
gzip -c 'list of DB files to be zipped' > cb_dbname_date.gz
Now when I try to refresh from cold backup, I use this syntax:
gunzip cb_dbname_date.gz -- in the current directory

Migrate Oracle 8.1.7.4 database to 9.2.0.6 on HPUX 11.00 (PA-RISC)
We're told to export de '8' database with the user SYS. Till now
we've always exported our databases by the user system. The reason
for this should be that partitioned tables will not be exported

I had been campus recruited by IBM Global Services and after only one
month training I am working as a DB2 DBA on client side for past two
months.
I dont see many oppurtunities building for me in future since a DBA

I´d like to activate SNMP support for my database. Documentation
refers to a directory $ORACLE_HOME/network/snmp. This directory does
not exist on my server.
Does anybody know how to install the needed files ?

I would like to be able to go to a specific row in a ResultSet and get
the data from that row. Is that at all possible? If not, should i be
using something else do do this?
thanks

We are considering migrating our existing web applications development
to J2EE 1.4 from the current 1.3. and we use Oracle application sever.
Inevitably we'll also upgrade the app server from 9iAS(1.3 certified)
to 10gAS( 1.4 certified ).  My question is, does the Oracle 10g app