Re: Oracle + Solaris + SYS-UNCONFIG

Thanks
[Quoted] I already did that and besides TNSNAMES I also did it on TNSLISTNER.ORA and also
on Auto_home.... but no luck, my clients cannot connect to the server... any idea
thanks
Zeeshan

"Matthew D. Bennett" <mbennett_at_utah-inter.net> wrote in message news:3BF68D0E.C5718442_at_utah-inter.net... Zeeshan,

If you have changed the hostname and IP address, you will need to make the change in all TNSNAMES.ORA files for clients that want to access the database.

Matt.

Zeeshan Ahmed wrote:
>
> Hi All,
> I am using Oracle 8 on Solaris 2.6 & 8 and wanted to
> change the host name and other configuration on the
> server. Sys-unconfig does a woderful job, its like a
> mini jump start which changes the IP address everything
> but it doesnt go down at the application level.
> I used sys-unconfig command and changed the host name,
> I had to remount the drives by modifying the "auto_host" file
> also the "TNSNAMES.ORA" and "TNSLISTNER.ORA" because
> it was still pointing to the old host name. the server if running fine
> and the listener is runnning too but other oracle server cannot
> access/login to this server.
> Are there other places where I have to change the host name manually?
>
> Thanks
> Zeeshan
Received on Sun Nov 18 2001 - 23:32:31 CET