asked on

moving oracle home to new home for 1 database

hi,
I have a server on which I have oracle home
in that home, I have 3 databases in 10.2.0.3. Its ASM is on 10.2.0.4
ORACLE_HOME=/app/oracle/10203/db_1

I want to move one database to a new home and other 2 databases in the same home
ORACLE_HOME=/app/newdb/10203
it shd use the existing ASM

The process I want to adopt is
-- install oracle software 10.2.0.1
-- upgrade the software to 10.2.0.3

change the /etc/oratab entry
change the .profile for the database
copy the init, spfile, tnsnames, sqlnet, listener to the new home

is that complete? can anybody please let me know??

(my doubt is -- what happens to the original oraInventory if I change the oracle home, as I am doing nothing to that inventory)

ramavenkatesa

ASKER

can anybody please answer my question???

ramavenkatesa

ASKER

is it essential to move listener.ora, tnsnames files to the new home on the same host??

ASKER CERTIFIED SOLUTION

Mark Geerlings

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

ramavenkatesa

ASKER

i dont have my listener.ora file.
how can i create my listener.ora file using netca ?? can I use netca for creating listener.ora file??

Mark Geerlings

You don't have a listener.ora file, but you have three databases running? That doesn't sound right.

Anyway, yes, netca should be able to create a listener.ora file for you in the new Oracle_home.