We're having some problems. The db seems to have started up
but an attempt to connect gives a listener error ORA-12541
We have ORA-00600 errors in the alert log. Attached is the entry
in the alert_emprod.log. what can we do ?

   I am starting a job soon developing asp.net pages against oracle
database.
   I know quite a lot about MS sql server (6 years experience) but I don't
know anything about Oracle.

Suppose that you are connected to an Oracle database with the user SYS or
SYSTEM.
I know that there is a way to impersonate another Oracle user account, but I
don't remember the command.

I have two SUNs at home an Ultra 10 and a Blade 1000.
I put 4Gb of RAM in the Blade installed oracle 9.2 on it
and oracle client 9.2 on the U10.
Now what I don't get is that I can sqlplus from the U10

I have ons.log files that are growing GB's in size with the message
"Local connection 0,127.0.0.1,6100 invalid form factor" repeated
continuously.
The opmn resides in an HTMLDB 1.6 home, installed from the 10.1.0.3

   I am starting a job soon developing asp.net pages against oracle
database.
   I know quite a lot about MS sql server (6 years experience) but I don't
know anything about Oracle.

At my office I work with Oracle Database version 9i
I'm only a client-server and web developer.
I want to install a Oracle Database Lite on my Home PC; just a database
where I can connect to retrieve and update data with VB 6 or VB.NET

I'm a MS SQL Server DBA and I know next ot nothing about how Oracle works.
Now I need to get involved in our Oracle server (some administration and
querying databases) so where do I start? Can any of you point me to some
good "Oracle Beginners guide" on how to do the basic stuff?

I'm trying to set up a 3 layer replication environment using Oracle 10g
(10.1.0) on Windows XP Professional. When I want to create a MV
replication group at the 2nd layer (MV on Master), I get the ORA-23313.
I've just used Oracle 10g Advanced Replication API Reference manual

Is there any oracle database simulators which simulates problems
normally faced by DBAs in real world? This is for practice purpose. If
so, could you give me the website address?

I have two long and very similar SQL queries. The only difference is in
this part:
Query 1: ... AND build_id IN (SELECT build_id from build where  .... )
....

I have the following questions in the Oracle 8 and 9 platforms:
1.     Does the roles need to set password?  If no password, any negative
impact?
2.     Can user data / objects be put in the system tablespace?  Can this

I am confused about whether to set PGA_AGGREGATE_TARGET or
SORT_AREA_SIZE. Whichever you recommend, what is the proper value for
the continuous running of the multiple applications for a database that
is sized between 6GB and 10GB? If you recommend using the

thanks, rm.

Given the query:
select * from carhitelszerzodesek where flotta_id=:1
The plan is table access full, though we have an index on flotta_id.
Flotta_id is numeric, the table is analyzed with all columns, all