whenever I start up my Oracle instance (Orace 9.2.0.6 on Windows
Server 2003) I get the following error in oradim.log:
Wed Sep 05 16:36:36 2007
ORA-01034: ORACLE not available

I am a fresh graduate and would like to know the difference between
the skill sets required for an Oracle Applications Developer, an
Oracle Apps DBA and an Oracle DBA. Also can someone please shed some
light as to which of these three fields have a better opportunity and

Our company is about to purchase a product based on Oracle 10x. Strange
thing is, there are no Referential Keys declared at all, only Triggers.
Is this standard procedure in Oracle? Can Referential Keys be totaly
substituted by Triggers? Would that be wise?

since I'm still in the state of experiencing a database I would like to
know what mistakes I made some time ago. And as I learned that in Oracle
everything is a table or within one I'm wondering if there is kind of
history table for my SYS commands...

I am looking for the most efficient way to perform a daily search of
15,000 customers against 60M transactions in the system, using a
complicated close matching set of rules.  Any matches will then be
recorded for future use.

I'm learning and how to use oracle for my own.  I notice that I am
able to create the database but unable to create User and Password
other than Systems, sys, etc.
Can you give me the step by step how to create user and password so

Is it possible to install Oracle RAC within Solaris 10 Zones? Has anyone
tried this? This will only be used for testing purposes.
Thanks

I apologize if this is a dumn question ...
If i set the quota for a user to 0 for SYSTEM and SYSAUX will that user be
able to create stored procedures and packages?
I'm not sure where such a package/procedure would be stored.

Folks,
If anyone has a copy of a practice test or practive test answers for 1Z0-042
I'd be greatly appreciative hearing from you.
TIA

Can any of you give me some tips on running RMAN
via SYSOPER rather than SYSDBA?
Currently, when I run RMAN, I use an RMAN command line similar to
this:

I haven't worked in Oracle since 8i a few years ago and need a quick
refresher.
When importing a schema from a data export, the request Host
Credentials.  Is that the credentials for sysman from the server where

Vital info, 10.2.0.3 RAC PC6, 2 nodes, AIX 5.3 TL05 SP04.
Had what appears to be a network event last night, AIX did not log any
network link down events on either node, but found that an NFS mount
on the survining node failed.  Looking thru the ocssd.log file on the

I have been looking at this script for days - just cant see where the
error is.   In my script, I have the following logic (does the table
exist, if not, create it)....
bk number(30);

Bootstrap Technologies P Ltd is a leading Total Outsourcing services
provider. We have been retained by a large Implementation Project from
Middle East. We are hiring Oracle Apps Functional and Technical
resources for Onsite Implementation and Offshore support projects now.

10gR2
If you have :
2 columns on a hi-traffic transactional table
- one ("some_id")  high cardinality