I want to change the host name and IP address of a machine with a (test)
Oracle 10g Database.
I figure I need to edit the "tnsnames.ora" and "listener.ora" files.
But, being an Oracle novice, I wonder if there are any other places that

We have today 4 nodes cluster running AIX, HACMP 5.2 and Oracle 9RAC. Now we
have about 30 instances on each of the servers (total of 30 databases).
I am thinking abot taking one of the databases out and move it into a 5.
server outside the cluster - as a standalone machine. Because ...

Can u pls tell me how can i tune this query ?
at any time records in UnitIDTbl and INFOTBL is not more then 50000.
INSERT INTO UnitIDTbl
SELECT DISTINCT ID,INUMBER,'E-NOTFOUND'

I have problems about CPU loading and Oracle performance.
The loading average is always higher than 1(which is abnormal).
I have looked up v$seesion_wait, jobq slave waits obviously hold
resources, that cause CPU loading is always high.

I am currently using the IMP command to import an Oracle 8i database:
imp userid=MyUsername/Mypassword@Myservicename buffer=50000
file=C:\temp\abc.dmp fromuser=ExportUsername touser=MyUsername
rows=y grants=n constraints=n ignore=y log=C:\temp\import.log

It was brought to my attention to a member of this group that my job
positing yesterday is not welcomed in this group.  To all of you who
found my posting inappropriate please accept my apologies.  I was
unaware that Oracle job postings are not allowed.

Vennela ERP Trainings and Managing IT Career in the 21st Century
Vennela Technologies Private Limited
Training Division
#2C, Nandanavanam Complex

OK, I have a table that contains a varray.  I have some data and I
would like to load into it using sqlldr.
However I keep getting the error:
"direct path loading of datatype for column COL_KEVIN not supported."

Can any body explain me on how to obtain connectivity between oracle
and progress database. The progress database already exists and i need
to use it in oracle. And hence need to obtain a connection between
Oracle and Progress database.

In our servers there are multiple entries with entries of the following
kind:
10-JAN-2006 09:07:03 *
(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) *

I have problems about CPU loading and Oracle performance.
The loading average is always higher than 1(which is abnormal).
I have looked up v$seesion_wait, jobq slave waits obviously hold
resources, that cause CPU loading is always high.

I have a problem concerning views.
Problem Definition:  In an application, each application user should
have access to specific departments.  All application users connect to
the database as scott; having a database user per actual application

I have a query such as the following
WITH A as
( select ... from FACT, DIM1, DIM2
where FACT.DKEY1=DIM1.DKEY1 and FACT.DKEY2=DIM2.DKEY2

in Oracle 9.2.0
after start database , I used "alter databsse cloes",
it shows "ORA-01094 ALTER DATABASE CLOSE in progress. Connections not
permitted"

Please fix what i am missing here.
The argument against frequent commits is that oracle needs the
transaction details, which is wiped out by COMMIT, to supports its
multiversioning facility.