SERVER 1 (LAN)
- Windows 2003 Server
- Oracle 9.2.0.6
- CMAN 9.2.0.1 (on port 1610)

   I have two-node Oracle 10g RAC database (using OCFS) with Enterprise
Manager Database Control 10g configured on first node (node1). I can access
it on default address (http://node1.mydomain:1158/em/), but it doesn't work
on second node (node2). How to setup Enterprise Manager to ...

I'm trying to install Oracle 9i on Linux SUSE Enterprise Server 8i
SP3 OS.
In the last installation step it gives me the following error: Agent
Configuration Assistant failed.

I have a table for which i want to grant select privilige to a group of
users. Therefore I create a role and grant select on the table to this
role. Then i grant the role to the users.
I would have expected that my users can now select from this table.

is there anyone who have used jdbc and stored procedures that
returns more than one outparameter?
i have looked at some examples from oracle but they uses only
one outparameter.

Oracle9i
Say I have the following table:
ID       Value           Date
---      ------          -----

I am having trouble understanding the scope rules of
EXECUTE IMMEDIATE.  Consider this example, which causes
a PLS-201 error "identifier 'SAY_HELLO' must be declared":
   declare

the Oracle documentation recommends the use of associative arrays for
"relatively small lookup tables". Is there a rule of thumb to determine
the number of entries up to where it makes sense to use an associative
array ?

When you use an ASM disk as a destination for archive log files, how
can you keep track of the created log files, to delete old ones etc?

I am running oracle 8.1.7.4 on Solaris 5.9 (os is 64 bits)
and oracle is 32 bit.
I have this  script:
spool create_small_tbsp.log

Dear list,
I' a Oracle newbie and have a problem installing
Oracle 10gr2 on a Solaris 10 box.
I installed the database on my system and after

Hi, all.
Still working through RMAN permutations, and running into another wall.
Checked Metalink, which ran me square into ANOTHER wall.
Here's the situation:

If table A is the parent table and B and C are children with the PK of A
being a FK in each of B and C.
I have tried:
select A.pk,B.fk,C.fk

Oracle 10.1.0.4.0 on AIX 5.2.
I noticed that some system pl/sql packages become invalid after a certain
period of time, for example sys.dbms_sqltune. However, after manual
recompilation, everything becomes valid again (without errors). Is this a

I am trying to compare timestamp with CURRENT_TIMESTAMP and oracle is
throwing this error ORA-01866: the datetime class is invalid.
My query,
select * from message_log where log_timestamp >= CURRENT_TIMESTAMP