CHAR_MENU_QUERY with actual references to my servername. I also discovered
that the server name is embedded in a field called ASSIGNSHORT in the table
ACTLINK_SET. The table ACTLINK_MACRO would also have the server name
embedded in the macro text field (SHORTTEXT and LONGTEXT) if any macros
reference a server name, which most do ("set-schema:..." statements, etc.),
but in my case I had previously done a transfer of active links and filters
from one server to another via the ardiff utility, so most of my server
references in macros had already been changed to a parameter substitution
setup.
-----Original Message-----
From: Michael Worts [mailto:Michael.Worts@NTL.COM]
Sent: Monday, March 20, 2000 10:43 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Database copy - Oracle
Mark,
Remedy stores the server name in only two tables. server_cache and
field_table (v4) only. They are the 2 tables I change if I am doing an
Oracle copy.
Mike.
Michael Worts
Remedy Consultant
ntl:
michael.worts@ntl.com
-----Original Message-----
From: Stilley, Mark [mailto:Mark_Stilley@ATK.COM]
Sent: 20 March 2000 16:06
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Database copy - Oracle
Isn't the server name embedded in various columns in various tables or are
there just a few, if any, references to it in the database tables? I thought
I recalled that this was the case (at least in ARS 3.x) and because of this
Remedy did not support copying database tables from one server to another
because it was so messy to change the server references in the database.
Correct me if I am wrong. Thanks.
-----Original Message-----
From: Neil [mailto:disturbed@FREEWEBACCESS.CO.UK]
Sent: Monday, March 20, 2000 6:59 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Database copy - Oracle
Make sure your file structures are the same then just copy the control, log
and databse files to the same places. make sure you close the database
before copying, and if using FTP, set it to binary.
Neil Anderson
Systems Developer
Halifax plc, UK
Working with the Remedy Action Request System - www.remedy.com
'This message is attributable to the sender and does not necessarily reflect
the view of Halifax Group plc or its subsidiaries'
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Christine Cambrils
Sent: 18 March 2000 20:27
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Database copy - Oracle
Does anyone have instructions for copying an Oracle AR System database from
one machine to another? Is it true that machine specific information is
stored in the database? I have some instructions for a MSSQL copy, however,
are there any catches with Oracle?
server independent and run arclean to cath any bits left. It is also worth
checking the file in wordpad, or notepad.
Delete the als, filters, escs menus and dsos and reimport them from the
modified file.
Schemas with tables fields need to be amended one by one. Bit of a pain.
Watch out for server names of different lengths as you will have to change
the number before the name eg 7/hfxsam1.
This could probaly be done with a standard SQL script that would work for
everyone. Anyone ever written one?
Neil Anderson
Systems Developer
Halifax plc, UK
Working with the Remedy Action Request System - www.remedy.com
'This message is attributable to the sender and does not necessarily reflect
the view of Halifax Group plc or its subsidiaries'
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Stilley, Mark
Sent: 20 March 2000 16:06
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Database copy - Oracle
Isn't the server name embedded in various columns in various tables or are
there just a few, if any, references to it in the database tables? I thought
I recalled that this was the case (at least in ARS 3.x) and because of this
Remedy did not support copying database tables from one server to another
because it was so messy to change the server references in the database.
Correct me if I am wrong. Thanks.
-----Original Message-----
From: Neil [mailto:disturbed@FREEWEBACCESS.CO.UK]
Sent: Monday, March 20, 2000 6:59 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Database copy - Oracle
Make sure your file structures are the same then just copy the control, log
and databse files to the same places. make sure you close the database
before copying, and if using FTP, set it to binary.
Neil Anderson
Systems Developer
Halifax plc, UK
Working with the Remedy Action Request System - www.remedy.com
'This message is attributable to the sender and does not necessarily reflect
the view of Halifax Group plc or its subsidiaries'
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Christine Cambrils
Sent: 18 March 2000 20:27
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Database copy - Oracle
Does anyone have instructions for copying an Oracle AR System database from
one machine to another? Is it true that machine specific information is
stored in the database? I have some instructions for a MSSQL copy, however,
are there any catches with Oracle?
server independent and run arclean to cath any bits left. It is also worth
checking the file in wordpad, or notepad.
Delete the als, filters, escs menus and dsos and reimport them from the
modified file.
Schemas with tables fields need to be amended one by one. Bit of a pain.
Watch out for server names of different lengths as you will have to change
the number before the name eg 7/hfxsam1.
This could probaly be done with a standard SQL script that would work for
everyone. Anyone ever written one?
Neil Anderson
Systems Developer
Halifax plc, UK
Working with the Remedy Action Request System - www.remedy.com
'This message is attributable to the sender and does not necessarily reflect
the view of Halifax Group plc or its subsidiaries'
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Stilley, Mark
Sent: 20 March 2000 16:06
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Database copy - Oracle
Isn't the server name embedded in various columns in various tables or are
there just a few, if any, references to it in the database tables? I thought
I recalled that this was the case (at least in ARS 3.x) and because of this
Remedy did not support copying database tables from one server to another
because it was so messy to change the server references in the database.
Correct me if I am wrong. Thanks.
-----Original Message-----
From: Neil [mailto:disturbed@FREEWEBACCESS.CO.UK]
Sent: Monday, March 20, 2000 6:59 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Database copy - Oracle
Make sure your file structures are the same then just copy the control, log
and databse files to the same places. make sure you close the database
before copying, and if using FTP, set it to binary.
Neil Anderson
Systems Developer
Halifax plc, UK
Working with the Remedy Action Request System - www.remedy.com
'This message is attributable to the sender and does not necessarily reflect
the view of Halifax Group plc or its subsidiaries'
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Christine Cambrils
Sent: 18 March 2000 20:27
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Database copy - Oracle
Does anyone have instructions for copying an Oracle AR System database from
one machine to another? Is it true that machine specific information is
stored in the database? I have some instructions for a MSSQL copy, however,
are there any catches with Oracle?
and databse files to the same places. make sure you close the database
before copying, and if using FTP, set it to binary.
Neil Anderson
Systems Developer
Halifax plc, UK
Working with the Remedy Action Request System - www.remedy.com
'This message is attributable to the sender and does not necessarily reflect
the view of Halifax Group plc or its subsidiaries'
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Christine Cambrils
Sent: 18 March 2000 20:27
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Database copy - Oracle
Does anyone have instructions for copying an Oracle AR System database from
one machine to another? Is it true that machine specific information is
stored in the database? I have some instructions for a MSSQL copy, however,
are there any catches with Oracle?
1. Instead of deleting the user_cache just change the server_cache to
reflect the new server name.
2. If you have any Table fields then you need to update a field called
tfserver in the "field_table" table.
I would also delete an reimport (server independent) all AL's, Filters,
Menus, Escalations as stated below.
That should do it.
Mike.
Michael Worts
Remedy Consultant
ntl:
michael.worts@ntl.com
-----Original Message-----
From: Domingo Del-Moral-Tornero (ESS)
[mailto:Domingo.Del-Moral-Tornero@ESS.ERICSSON.SE]
Sent: 20 March 2000 11:20
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Database copy - Oracle
Hello,
The way we are passing from production to development and vice versa can
help you. Following you have this:
PRODUCTION SERVER
=================
1. Export Oracle database ARS to a file (Example: "PRODUCTION.DMP").
2. Export from ARS all 'ACTIVE LINK', 'FILTER', 'SCALATION' and 'MENU' to a
file
(Example: "PRODUCTION.DEF"). Check Server-Independent option.
3. Copy both files to development server.
DEVELOPMENT SERVER
==================
1. Install ARS in development server.
2. Stop ARS.
3. Delete tablespace ARSYSTEM (The default ARS tablespace)
4. Create tablespace ARSYSTEM.
5. Import all from user ARADMIN from file PRODUCTION.DMP:
IMP SYS FILE=PRODUCTION.DMP LOG=IMPORT.LOG FROMUSER=ARADMIN
TOUSER=ARADMIN
6. Reboot server.
7. In ARS delete all 'ACTIVE LINK', 'FILTER', 'SCALATION' and 'MENU'
(because we have passed the PRODUCTION server name)
8. Import all 'ACTIVE LINK', 'FILTER', 'SCALATION' and 'MENU' from file
PRODUCTION.DEF
9. Could be necessary to delete the user cache in Oracle:
TRUNCATE TABLE ARADMIN.USER_CACHE;
Regards,
Domingo del Moral
Ericsson Business Consulting Spain
-----Original Message-----
From: Christine Cambrils [mailto:ccambrils@SILVERBACKTECH.COM]
Sent: Saturday, March 18, 2000 9:27 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Database copy - Oracle
Does anyone have instructions for copying an Oracle AR System database from
one machine to another? Is it true that machine specific information is
stored in the database? I have some instructions for a MSSQL copy, however,
are there any catches with Oracle?
CHAR_MENU_QUERY with actual references to my servername. I also discovered
that the server name is embedded in a field called ASSIGNSHORT in the table
ACTLINK_SET. The table ACTLINK_MACRO would also have the server name
embedded in the macro text field (SHORTTEXT and LONGTEXT) if any macros
reference a server name, which most do ("set-schema:..." statements, etc.),
but in my case I had previously done a transfer of active links and filters
from one server to another via the ardiff utility, so most of my server
references in macros had already been changed to a parameter substitution
setup.
-----Original Message-----
From: Michael Worts [mailto:Michael.Worts@NTL.COM]
Sent: Monday, March 20, 2000 10:43 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Database copy - Oracle
Mark,
Remedy stores the server name in only two tables. server_cache and
field_table (v4) only. They are the 2 tables I change if I am doing an
Oracle copy.
Mike.
Michael Worts
Remedy Consultant
ntl:
michael.worts@ntl.com
-----Original Message-----
From: Stilley, Mark [mailto:Mark_Stilley@ATK.COM]
Sent: 20 March 2000 16:06
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Database copy - Oracle
Isn't the server name embedded in various columns in various tables or are
there just a few, if any, references to it in the database tables? I thought
I recalled that this was the case (at least in ARS 3.x) and because of this
Remedy did not support copying database tables from one server to another
because it was so messy to change the server references in the database.
Correct me if I am wrong. Thanks.
-----Original Message-----
From: Neil [mailto:disturbed@FREEWEBACCESS.CO.UK]
Sent: Monday, March 20, 2000 6:59 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Database copy - Oracle
Make sure your file structures are the same then just copy the control, log
and databse files to the same places. make sure you close the database
before copying, and if using FTP, set it to binary.
Neil Anderson
Systems Developer
Halifax plc, UK
Working with the Remedy Action Request System - www.remedy.com
'This message is attributable to the sender and does not necessarily reflect
the view of Halifax Group plc or its subsidiaries'
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Christine Cambrils
Sent: 18 March 2000 20:27
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Database copy - Oracle
Does anyone have instructions for copying an Oracle AR System database from
one machine to another? Is it true that machine specific information is
stored in the database? I have some instructions for a MSSQL copy, however,
are there any catches with Oracle?
one machine to another? Is it true that machine specific information is
stored in the database? I have some instructions for a MSSQL copy, however,
are there any catches with Oracle?
there just a few, if any, references to it in the database tables? I thought
I recalled that this was the case (at least in ARS 3.x) and because of this
Remedy did not support copying database tables from one server to another
because it was so messy to change the server references in the database.
Correct me if I am wrong. Thanks.
-----Original Message-----
From: Neil [mailto:disturbed@FREEWEBACCESS.CO.UK]
Sent: Monday, March 20, 2000 6:59 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Database copy - Oracle
Make sure your file structures are the same then just copy the control, log
and databse files to the same places. make sure you close the database
before copying, and if using FTP, set it to binary.
Neil Anderson
Systems Developer
Halifax plc, UK
Working with the Remedy Action Request System - www.remedy.com
'This message is attributable to the sender and does not necessarily reflect
the view of Halifax Group plc or its subsidiaries'
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Christine Cambrils
Sent: 18 March 2000 20:27
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Database copy - Oracle
Does anyone have instructions for copying an Oracle AR System database from
one machine to another? Is it true that machine specific information is
stored in the database? I have some instructions for a MSSQL copy, however,
are there any catches with Oracle?
transfer ORACLE data between any 2 environments. See the ORACLE Utilities
manual for syntax.
> -----Original Message-----
> From: Christine Cambrils [SMTP:ccambrils@SILVERBACKTECH.COM]
> Sent: Saturday, March 18, 2000 3:27 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Database copy - Oracle
>
> Does anyone have instructions for copying an Oracle AR System database
> from
> one machine to another? Is it true that machine specific information is
> stored in the database? I have some instructions for a MSSQL copy,
> however,
> are there any catches with Oracle?
>
> Thank you,
> Christine
>
>
> Unsubscribe to: Text is: unsubscribe arslist
Here's a procedure written by our DBA to do exactly what you want to
do, but I haven't had time to use/test it as yet. We have used a similiar
procedure for our Remedy 3.2 system.
1. Set up oracle environment variables:
ORACLE_HOME=e:\orant
ORACLE_ADMIN=e:\oracle\admin
Description :
This document should be used as a guideline to copy an existing closed
database from one server to another server.
Procedure :
1) Log in to database that is to be copied.
Svrmgr30
SVRMGR> connect internal
Password:
1) Perform multiple log switches to the existing open database.
SVRMGR> alter system switch logfile;
1) Obtain list of all datafiles of the existing open database.
SVRMGR> spool SVRMGR> select File_Name from dba_tablespaces;
SVRMGR> spool off;
1) Obtain list of all logfiles of the existing open database.
SVRMGR> spool SVRMGR> select Member from v$logfile;
SVRMGR> spool off
1) Shut down database.
SVRMGR> select * from v$database; (verify connection to the proper database)
SVRMGR> shutdown immediate;
1) Map all drives on the remote system that will have files copied to
it.
With an Explorer window from the pull down Menu
Tools Ø Map Network Drive... Ø Ø OK
1) Copy all files associated with the database from the source server.
C:\> xcopy :\:\ /s /e
Sample Copy:
C:\> xcopy E:\oracle J:\oracle /s /e (Copies all files and subdirectories
from E:\Oracle)
C:\> xcopy F:\oracle K:\oracle /s /e (Copies all files and subdirectories
from F:\Oracle)
C:\> xcopy G:\oracle L:\oracle /s /e (Copies all files and subdirectories
from G:\Oracle)
1) Get copy of INIT.ora file from production to the new server.
The file is usually located in the E:\Orant\Database database directory.
2) Startup all Oracle NT services on the new database server.
Previous Topic
Index