I have installed Oracle 10g RDBMS on SuSE Linux 9.3 Professional with
start / stop scripts. But I dont understand something...
How do I start up the database itself?
After I have runed up the Enterprise Manager from Oracle 10g, and I

Can anyone please explain to me why i can't get a real number with a
long string.
select to_number('9999911444984599','99999999999999999999999') a from
dual;

been pounding my head on my desk trying to figure out why a test script was
not working -- it was just a simple loop like this one that called a stored
procedure with the value returned by the for loop
SQL> declare

I'm using Oracle 9i, using the latest thin JDBC Java driver.  I'm trying
to insert a NCLOB into the database.  The recommended way to do this is
to use CLOB.createTemporary() as you can see in the code below.  This
code works fine for CLOB fields, but fails with a 'ORA-12704: ...

I'm using an Oracle 9.2 Server on a Windows 2003 Server Machine
and want to connect from my Windows XP SP2 PC. Till yesterday, all worked finde.
But now every program hangs on the connect to the server. SQLPLus for example asks me for the
username and password and after that it ...

I've been asked to install Oracle LDAP on 8i.
Ok, I have no clue about where to start.  I grabbed a script of
Metalink and tried to compile it and received the following errors:
9/22     PLS-00201: identifier 'DBMS_LDAP.SESSION' must be declared

I have a situation where sql is executed from a java client to an Oracle
9.2.0.5 database.  We have open cursors set at 1000 and
session__cached_cursors set to 0.  The java code is executed many times
throughout the day.  However, we are having to re-cycle our app because

If I specify a recovery window of 7 days internal to rman, then perform
a backup using a recovery windows of 2 days(see below). Which one will
take recedence?
I'm looking for a way to have the rman catalog be aware of 7 days worth

my redo logs are 100m in size. how do i find the current size of redo
log.
in other words:

I'm using VB6, ADO, and Oracle 8.1.6, ComponentOne TrueDBGrid7 and I'm
having a problem updating from a grid source...
I can connect to the database, and run a SQL statement on a table i.e.:
select FIELD1 from TABLE1 where COND1 = 'T'

Ok, first, let me say that I didn't design this table, so don't blame
me for using CHAR when a VARCHAR2 would have worked just fine.  I'm
using Oracle 9.2.0.4 on Win2k3 Server.
My problem is this.  I have a table with CHAR(11) column

How can i find out, what the used memory is used for? I already found,
that i can find how many mb are used per session. But that is not enough
for me. I must know, which procedure, trigger, view, ... does use which
amount of memory. Is there any possibility?

I don't know what I am doing.  I've spent hours reading the docs and "Expert
One-On-One Oracle" but can't figure it out. Can someone tell me what I need
to do to free up those empty_blocks?
Connected to:

I am reading Chapter one (still beta) of Tom Kyte's new Expert 10g
book (http://oracle.apress.com/), and it is really a good read.
However, I have some questions about the read consistency example (page
20 - 22) - getting the total balance of accounts table (I would have

I am usnig ODP.Net and working on migrating my application to RAC
environment. I am not sure what  changes i need to make in my code to
use RAC failover featuers. I have checked ODP.NET documentation but
could not find a way to specify the failover (i.e. backup) server. If