I am able to setup logical standby db on same server. My settings are
on primary database "infod" are
LOG_ARCHIVE_START = TRUE
LOG_ARCHIVE_DEST_1 = 'LOCATION=/apps/oradbf/infod/archive MANDATORY'

Is it possible to set up 10g RAC on a single physical machine?
I could be wrong on the Oracle terminology, but, in other words, can I
have say 2-node 10g RAC implemented on the same Linux box?
Thanks,

Please, could someone tell me, or maybe, indicate me some technical
article discussing the differences between the ORACLE Standby and
ORACLE Real Application Cluster, in terms of technical features.
I also search for some technical comparison on how to chose one or

I want to do a query based on two tables, t1 and t2;
t1 has the fields f1 and f2 which are codes, and of course they are for
different purposes no matter they have the same or different values in
one record;

How to optimize query's execution? By using hints? Here is execution plan
for statement returning 3390 records in about 10 sec:
Execution Plan
----------------------------------------------------------

OK,
I have a pl/sql API which seems to work fine when i test it in sqlPLUS,
but when I try to run it through the ASP front end, it returns no
results.

As a newcomer to Oracle server, I am experimenting with the
functionality (under Windows 2K) and so have deinstalled and
re-installed several times.
This works OK but I find that, although I try to make sure that all

How to kill a session that is running a stored procedure?
I am running a stored procedure (Oracle 9i) from a Client PC (WXP)using
TOAD. I would like to stop it using Kill Session -> Post Transaction of
Oracle Enterprise Manager.

I need to activate parameter SQLNET.EXPIR_TIME on my Database Server
in Oracle 10g x86_64 on SLES 9.0.
Until now I did not use sqlnet.ora. My question: Is it necessary to
shutdown the database for activating this parameter or what else do I

Now, I'm using dbms_transaction.local_transaction_id to
generate a unique ID among different tables' triggers (insert, update,
delete) since they
are under same transaction.

I want to build a new standby database for a production database.
And the production database already has a DR standby database.
I know , I can shutdown the DR standby database and copy the datafiles,
the controlfile, the init.ora to new box. But it's danguares when

I have a problem with calling stored procedure from PHP
using Oracle 8 functions.
The line which produces the error is
$s = OCIParse($db_link, "

I have a table (TableA) showing statitics of number of lines on my
salesorders. The table has 2 fields (Lines and qty)
In this example, i have 10 salesorders.
4 of them have 1 line.

I've procedure/function with IN OUT VARCHAR2 parameter.
Procedure changes IN variable to shorter but OUT parameter remebers end
of IN string.
why? is it bug?

     Oracle 8.1.7
     Solaris 6.
Discoverer 3.1.44
I have inherited yet another beauty.