I got step-by-step install rac 9.2.0.5 on RHEL3U3.
but I can't get all nodes when install oracle software after
I installed oracm and oracm running fine.
thanks.

I have inherited some 8.1.7.4 databases on Windows from a new company
acquired. We have had the servers crash recently during the hot backup
processing. This means doing the ALTER DATABASE  END BACKUP after
getting back to the command prompt before opening the database.

I have a two node RAC primary database and single node (non RAC)
physical
standby setup.  Now I need to test the failover.  I more or less know
how to

I have a package and stored procedure as follows:
create or replace package TEST.ReturnCur is
-- REF CURSOR type for returning result sets from procedures
TYPE REF_CUR IS REF CURSOR;

Does anyone have a before insert or update trigger already written
that inserts or updates only upper case charaters into a column of a
table.  I have been seardhing some of my books but can not find one.
If any one has one they have been using and wouldn't mind sharing that

Hi group,
I m new to oracle server. Just wanna know how to create database using
sqlplus command line utility?
Pointer will be helpful............

I am currently finishing my MSc course in computer science. I am also
looking for a job. I am very interested in becoming ORACLE DBA.
Can some ORACLE DBAs please talk to me about their job? Does it pay well?
What sort of skills does it require? Does it involve working for very long

I currently have a script running made up of
select username, count(*) from v$session group by username
that spools to a text file to give me number of connected users at any
one time. How can i see how many sessions are also active at that time?

  Is it at all possible in 8i to issue a SQLPLUS command in a trigger
? The SQLPLUS "COPY FROM" command works perfectly and would love to use
it.
Any ideas appreciated. Thanks, Steve.

hi every body,
We can define a variable as varchar2(20 CHAR) and as varchar2(20 BYTE).
can any body tell me the difference between the two in terms of storage
of data in such a variable. i.e. how the oracle  internally stores the

I have cleared SQL and PL/SQL exam of oracle9i. and i want to join for
DBA track but here i am confused whether to opt for DBA track of oracle
9i or wait for oracle 10G. As per my knowledge, oracle 9i shall be
outdated by the time i finished DBA track of oracle 9i. And till date

Hi NG,
first of all the version-informations:
Oracle 10G R2
Gentoo 2005.0 with kernel 2.6.12-gentoo-r4

When I did the database upgrade from 8i to 9i, I hit the error
ORA-07445: exception encountered: core dump [00000001015FD370]
[SIGSEGV] [Address not mapped to object] [100] [] []
The process is as the following :

Oracle database version - 8.1.7.3.0
The dbms_obfuscation_toolkit package has the procedure and function for
using 3DESC encryption/decryption. But only the DESEncrypt/Decrypt
procedure and function is documented -

Currently we are using 2 x Sun Fire 15K 8 CPU@1.2GHz 16GB of Memory under
VCS 3.5 with Solaris 8, we run both nodes active-active and failover between
both, each node has 4 Oracle instances, if all instances try to run on one
node the performance is impacted severely, and this ...