The tnsnames.ora file should be all you need to change as long as the
DBA keeps the owner of the database as ARAdmin (and keeps the password
the same).
The tnsnames file describes the location of the oracle database(s)
You should find something like this in your file:
ORDDPS1G.WEPCO =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL=TCP) (HOST=ServerName)
(PORT=1521)))
(CONNECT_DATA = (SID=OracleSIDName))
)
You probably have an environment variable of TNS_ADMIN that points to
the directory where your tnsnames.ora file resides. If not it is
probably in a directory of
/usr/oracle/product/10.2.0/client_1/network/admin (based on the info you
gave below).
Fred
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Marty.Thorin
Sent: Thursday, February 05, 2009 8:44 AM
To: [email protected]
Subject: Migrating databases
Good morning:
I need to move my database from one Oracle server to another. I
shall have the DBA copy the arsystem database from the old server to the
new. I know I need to change the file ar.conf. Do I need to do
anything else?
<from today's ar.conf>
Db-name: arsystem
Db-user: ARAdmin
Dbhome-directory: /usr/oracle/product/10.2.0/client_1
Oracle-Two-Task: ORDDPS1G.WEPCO
Db-Character-Set: UTF-8
<end ar.conf>
Statistics: ARS 7.1.0 Patch 5
Oracle 10g
This is our first Remedy system using Oracle. All previous systems used
Sybase.
Thank you for your help.
Thorin
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
