Re: Moving Oracle from one computer to another

From: Stan Brown <stanb_at_panix.com>
Date: Fri, 20 Oct 2006 01:00:11 +0000 (UTC)
Message-ID: <eh972r$asc$1@reader2.panix.com>

In <1161274477.414001_at_bubbleator.drizzle.com> DA Morgan <damorgan_at_psoug.org> writes:

>Stan Brown wrote:
>> In <1161265886.154141.76120_at_m73g2000cwd.googlegroups.com> "sybrandb" <sybrandb_at_gmail.com> writes:
>>
>>
>>
>>> 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.
>>
>>> For an answer you should provide an error number. Crystal balls have
>>> worn out here.
>>
>>
>> ORA-12154: TNS:could not resolve service name
>>
>> BTW, beither machine is naed debian, something I should have clarified in
>> my first post.

>Can you ping the machine?

I'm ssh'd onto the machine.

>Can you TNSPING the listener?

From the machine:

Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = TCP_COMMUNITY.world) (PROTOCOL = TCP) (Host = phsepi2.meadwestvaco.com) (Port = 1521))) (CONNECT_DATA = (SID = debian) (GLOBAL_NAME = phsepi2))) OK (0 msec)

That looks OK, right?

>What are the values of ORACLE_SID and ORACLE_HOME environment variables?

stan_at_phsepi2:~$ echo $ORACLE_HOME
/home/oracle/9.01/software/app/oracle/product/release

stan_at_phsepi2:~$ echo $ORACLE_SID
debian

>What is in your listener.ora, sqlnet.ora, and tnsnames.ora?

I posted tnsnames.ora originally.

listener.ora :

# LISTENER.ORA Network Configuration File: /home/oracle/9.01/software/app/oracle/product/release/network/admin/listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = phsepi2.wv.com)(PORT = 1521))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/oracle/9.01/software/app/oracle/product/release)
      (PROGRAM = extproc)

    )
    (SID_DESC =

      (GLOBAL_DBNAME = phsepi2.wv.com)
      (ORACLE_HOME = /home/oracle/9.01/software/app/oracle/product/release)
      (SID_NAME = phsepi2)

    )
  )

sqlnet.ora

# SQLNET.ORA Network Configuration File: /home/oracle/9.01/software/app/oracle/product/release/network/admin/sqlnet.ora # Generated by Oracle configuration tools.

# NAMES.DEFAULT_DOMAIN = wv.com

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
>What are you using as the Host name when you try to log on?

phsepi2

Thanks foor helping with this.

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin

Received on Thu Oct 19 2006 - 20:00:11 CDT