SERVICE_NAME

From: zeb <spam_at_nowhere.com>
Date: Tue, 15 Feb 2005 21:27:09 +0100
Message-ID: <42125ac1$0$15823$636a15ce@news.free.fr>

Hi,

I have to upgrade a database in 8.1.7
to 9.2.0.5 on W2000
the database is not too much big
but the downtime must be small ( 15 or 30 min max )

My plan to upgrade is :
- install 9i product

patch to 9.2.0.5
create a new database/instance with a new name
export 8i DB
import into 9i DB
create a 9.2.0.5 listener how can I have the same SERVICE in the new listener to not change the tnsnames.ora for all the clients ? ( they use SERVICE_NAME=XXX in their tnsnames.ora )
deinstall 8i

What do you thinks about this plan ?
My question was how to conserve the same SERVICE for a new database ?

Thanks in advance Received on Tue Feb 15 2005 - 14:27:09 CST