Re: Moving Oracle from one computer to another

On Oct 19, 3:13 pm, Stan Brown <s..._at_panix.com> wrote:
> I'm in the process of upgrading a number of computers to newer/faster/more
> reliable hardware. One of these has an Oracle instance on it. I need this
> instance to talk to an Oracle 7 instance on another machine, so I need to
> keep the 9.01 Oracle instance on one of the machines being upgraded. This
> machine however will have a different hostname, than the one it replaces.
> This is running under Linux.
>
> I've succeeded in getting the Oracle tree copied over, getting the proper run
> time links set up etc, and the Oracle instance on the new machine starts on
> boot:
>
> stan_at_phsepi2:/etc$ ps -ef | grep ora
> 105 3883 3656 0 Oct18 ? 00:00:00
> /usr/lib/hal/hald-addon-storage
> oracle 4030 1 0 Oct18 ? 00:00:00 ora_pmon_debian
> oracle 4032 1 0 Oct18 ? 00:00:00 ora_dbw0_debian
> oracle 4034 1 0 Oct18 ? 00:00:00 ora_lgwr_debian
> oracle 4036 1 0 Oct18 ? 00:00:02 ora_ckpt_debian
> oracle 4038 1 0 Oct18 ? 00:00:00 ora_smon_debian
> oracle 4040 1 0 Oct18 ? 00:00:00 ora_reco_debian
> oracle 4042 1 0 Oct18 ? 00:00:00 ora_s000_debian
> oracle 4044 1 0 Oct18 ? 00:00:00 ora_d000_debian
> oracle 4046 1 0 Oct18 ? 00:00:00 ora_d001_debian
> oracle 4048 1 0 Oct18 ? 00:00:00 ora_d002_debian
> oracle 5396 1 0 Oct18 ? 00:00:00
> /home/oracle/9.01/software/app/oracle/product/release/bin/tnslsnr LISTENER
> -inherit
>
> My problem is in connecting to it with sqlplus. On the old machine if I set
> TWO_TASK to "debian", I can connect. On the new machine I can't. What I
> don't understand, is how it is working on the old machine :- here is
> /ec/oratab:
>
> debian:/home/oracle/9.01/software/app/oracle/product/release:Y
>
> And here is tnsnames.ora:
>
> # TNSNAMES.ORA Network Configuration File: /home/oracle/9.01/software/app/oracle/product/release/network/admin/tnsname­s.ora
> # Generated by Oracle configuration tools.
>
> INST1_HTTP.WV.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = phpshepi1.wv.com)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = SHARED)
> (SERVICE_NAME = MODOSE)
> (PRESENTATION =http://HRService)
> )
> )
>
> EXTPROC_CONNECTION_DATA.FAS.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> DEBIAN.WV.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = debian.wv.com)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = debian.wv.com)
> )
> )
>
> PHSEPI1.WV.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = phpshepi1.wv.com)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = phpshepi1.wv.com)
> )
> )
>
> DEBIAN.FAS.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = debian.fas.com)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = debian.fas.com)
> )
> )
>
> PHSE6.WV.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = phse6.wv.com)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = phse6.wv.com)
> (SID = pwhse)
> )
> )
>
> PHSE1.WV.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = phse6.wv.com)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = phse1.wv.com)
> (SID = pwhse)
> )
> )
>
> pwhse =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = TCP_COMMUNITY.world)
> (PROTOCOL = TCP)
> (Host = phse6.wv.com)
> (Port = 1521)
> )
> )
> (CONNECT_DATA =
> (SID = pwhse)
> (GLOBAL_NAME = phwse)
> )
> )
>
> Can anyone explain what is going on here to me?
>
> Thanks.
> --
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
> -- Benjamin Franklin

For an answer you should provide an error number. Crystal balls have worn out here.

-- 
Sybrand Bakker
Senior Oracle DBA