Moving Oracle from one computer to another

From: Stan Brown <stanb_at_panix.com>
Date: Thu, 19 Oct 2006 13:13:59 +0000 (UTC)
Message-ID: <eh7tmn$gmi$1@reader2.panix.com>

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/tnsnames.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

Received on Thu Oct 19 2006 - 08:13:59 CDT