Re: Setup Dev Server (RESOLVED)
Hi James , Axton and everyone that responded. Thanks to all for the information. Here is what I ended up doing. During the setup of my DEV box. I selected the overwrite option Which would overwrite the DB. I Actually had a copy of the Original DB which later would replace the DB original install. Then reapply the license. FYI. The Dev DB is on B unix server with the same Table space name and same DB name as Production A server. As long as the TNSnames.ora file specifies the Instance correctly it will go to the proper spot. For eveyone, Please make sure tnsname is correct Thanks John Kelley * Axton: Definitely the way to copy a tablespace from one server to another. I had forgotten about copying the LOB space, too. I tend to use Export/Import from Remedy rather than do this at the DB level. However, this does not scale well if you are working with Direct SQL and reference tables by name. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [ mailto:[EMAIL PROTECTED] On Behalf Of Axton Grams Sent: Friday, September 01, 2006 12:53 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server I duplicate databases infrequently. The metadata (actlink_open, email mailbox, etc.) are fairly easy to clean with pl/sql. Copying between different tablespaces is a little tricky due to LOB storage, but not impossible. You have to manually create the tables with modified DDL (specifying lob storage) that have LOBs prior to running the imp of the dmp file to ensure the LOBS go to the right tablespace during import. http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:378418239571#16075038165527 The main reason we do it this way is because this method puts the margin for error/reliability and the time required to complete are in our favor. Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Fred: (Wacking self on head). Thanks. Now the next question is how did they duplicate the database? There are variables in the Remedy metadata that will error out if they did a physical vice ARExport/ARImport move of data. This may be causing the problem. I tried a physical move from one tablespace to another on the same server and Oracle would not let me. James Mckenzie L-3 GSI -- -- *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *Grooms, Frederick W *Sent:* Friday, September 01, 2006 12:12 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** He said they were on 2 different servers -- -- *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *McKenzie, James J C-E LCMC HQISEC/L3 *Sent:* Friday, September 01, 2006 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39
Re: Setup Dev Server (RESOLVED)
Title: RE: Setup Dev Server (RESOLVED) ** John: I totally agree with your last statement, but I want to add one thing. If you don't want people accessing your Development server, then put it on a private, non-connected network system. If you want folks accessing your Development/Test/QA system, then make sure that the server's naming service (be it tnsnames.ora for Oracle, or the settings for Sybase/MSSQL) point ONLY to the cooresponding database server. I seen where the developmnet ARS server was pointing to a live database instance and the results ended in disaster. It is great that you now have a working production and development system. Enjoy! James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley Sent: Thursday, September 14, 2006 12:58 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server (RESOLVED) Hi James , Axton and everyone that responded. Thanks to all for the information. Here is what I ended up doing. During the setup of my DEV box. I selected the overwrite option Which would overwrite the DB. I Actually had a copy of the Original DB which later would replace the DB original install. Then reapply the license. FYI. The Dev DB is on B unix server with the same Table space name and same DB name as Production A server. As long as the TNSnames.ora file specifies the Instance correctly it will go to the proper spot. For eveyone, Please make sure tnsname is correct Thanks John Kelley * Axton: Definitely the way to copy a tablespace from one server to another. I had forgotten about copying the LOB space, too. I tend to use Export/Import from Remedy rather than do this at the DB level. However, this does not scale well if you are working with Direct SQL and reference tables by name. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Grams Sent: Friday, September 01, 2006 12:53 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server I duplicate databases infrequently. The metadata (actlink_open, email mailbox, etc.) are fairly easy to clean with pl/sql. Copying between different tablespaces is a little tricky due to LOB storage, but not impossible. You have to manually create the tables with modified DDL (specifying lob storage) that have LOBs prior to running the imp of the dmp file to ensure the LOBS go to the right tablespace during import. http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:378418239571#16075038165527 The main reason we do it this way is because this method puts the margin for error/reliability and the time required to complete are in our favor. Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Fred: (Wacking self on head). Thanks. Now the next question is how did they duplicate the database? There are variables in the Remedy metadata that will error out if they did a physical vice ARExport/ARImport move of data. This may be causing the problem. I tried a physical move from one tablespace to another on the same server and Oracle would not let me. James Mckenzie L-3 GSI -- -- *From:* Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W *Sent:* Friday, September 01, 2006 12:12 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** He said they were on 2 different servers -- -- *From:* Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] *On Behalf Of *McKenzie, James J C-E LCMC HQISEC/L3 *Sent:* Friday, September 01, 2006 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John
Re: Setup Dev Server
Title: RE: Setup Dev Server ** Brian: If the two Oracle servers are on the same wire (network) then you cannot set the SID to the same name. You will get an error (I don't know what it is) when you go to start up the second instance. If they are in isolated spaces, then you will not get the error. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Luke, Brian Sent: Tuesday, September 05, 2006 3:11 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server James / John, I should clarify, the fear is not for cross communication between tablespaces - Oracle ARS handle that well. The concern is if the database SID names are the same, but refer to different oracle instances. If there was a tnsnames.ora copy / overwrite snafu, you could have both ARS instances talking to one Oracle instance and not even know it (If this is in fact what is meant by the DB is the same name). In thinking about what could be referencing the old ars server that the installer would care about, I could only think of SERVER_CACHE left over from ARS v5 or a copied .lic file. Table fields filter guides would not affect the upgrade installer I hope. I can't think of other embedded server references. I've never encountered the installer upgrade option complaining that the database intact and accessible - that seems very wrong - so I'm left to conclude that the database being present accessible is not the root problem. I _suspect_ that the installer detects that the ARS database it is about to upgrade is in use by another running ARS server elsewhere - which could easily happen if your SID's were the same in dev prod. The other problem here could be that all of the oracle binaries and config files were copied, including tnsnames which refernces the prod instance - and it is actually Oracle generating this error message. If this is the case, the DBA will need to either: A:) ensure that all references to the old db server hostname/ip in _any_ Oracle configurations are updated to the dev database hostname/ip Or B:) erase the instance and re-create it via standard tools/processes, then export the data from prod and import it in dev. Option B would be highly reccommended - who knows where Oracle stuffs away information about where it is supposed to reside. -brian luke From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3 Sent: Tuesday, September 05, 2006 2:28 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server ** Brian: Why the fear? If you name one tablespace ARSYSTEM for instance, and the second ARSYSTEM1, there should be NO cross-talk between the two tablespaces. The problem here might be that the database was physically copied from one server to another and there may be internal checking that is failing and thus the error. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Luke, Brian Sent: Tuesday, September 05, 2006 2:10 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server John, By the DB is the same name do you mean the ORACLE SID or the database server hostname? With Oracle, the Db-name: ar.cfg parameter is used for the tablespace name if it is not ARSYSTEM. One thing that worries me about this config is that if the SID's are the same, the only place they are differentiated is in tnsnames.ora - the danger of unintended cross communication seems great. What version of ARS have and are you upgrading from (this last time, and tracing back?) Check the contents of SERVER_CACHE and see if there are references to old servers there. Also, did you copy the file containing the ARS licenses to the dev ARS server? - try renaming it if you did. One Oracle instance can have one or many tablespaces. Each tablespace can contain the objects for one or more accounts/schemas and keep them separate (even with the same table names). -Brian Luke -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley Sent: Friday, September 01, 2006 8:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production
Re: Setup Dev Server
John, By the DB is the same name do you mean the ORACLE SID or the database server hostname? With Oracle, the Db-name: ar.cfg parameter is used for the tablespace name if it is not ARSYSTEM. One thing that worries me about this config is that if the SID's are the same, the only place they are differentiated is in tnsnames.ora - the danger of unintended cross communication seems great. What version of ARS have and are you upgrading from (this last time, and tracing back?) Check the contents of SERVER_CACHE and see if there are references to old servers there. Also, did you copy the file containing the ARS licenses to the dev ARS server? - try renaming it if you did. One Oracle instance can have one or many tablespaces. Each tablespace can contain the objects for one or more accounts/schemas and keep them separate (even with the same table names). -Brian Luke -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley Sent: Friday, September 01, 2006 8:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Setup Dev Server
Title: RE: Setup Dev Server ** Brian: Why the fear? If you name one tablespace ARSYSTEM for instance, and the second ARSYSTEM1, there should be NO cross-talk between the two tablespaces. The problem here might be that the database was physically copied from one server to another and there may be internal checking that is failing and thus the error. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Luke, Brian Sent: Tuesday, September 05, 2006 2:10 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server John, By the DB is the same name do you mean the ORACLE SID or the database server hostname? With Oracle, the Db-name: ar.cfg parameter is used for the tablespace name if it is not ARSYSTEM. One thing that worries me about this config is that if the SID's are the same, the only place they are differentiated is in tnsnames.ora - the danger of unintended cross communication seems great. What version of ARS have and are you upgrading from (this last time, and tracing back?) Check the contents of SERVER_CACHE and see if there are references to old servers there. Also, did you copy the file containing the ARS licenses to the dev ARS server? - try renaming it if you did. One Oracle instance can have one or many tablespaces. Each tablespace can contain the objects for one or more accounts/schemas and keep them separate (even with the same table names). -Brian Luke -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley Sent: Friday, September 01, 2006 8:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Setup Dev Server
James / John, I should clarify, the fear is not for cross communication between tablespaces - Oracle ARS handle that well. The concern is if the database SID names are the same, but refer to different oracle instances. If there was a tnsnames.ora copy / overwrite snafu, you could have both ARS instances talking to one Oracle instance and not even know it (If this is in fact what is meant by the DB is the same name). In thinking about what could be referencing the old ars server that the installer would care about, I could only think of SERVER_CACHE left over from ARS v5 or a copied .lic file. Table fields filter guides would not affect the upgrade installer I hope. I can't think of other embedded server references. I've never encountered the installer upgrade option complaining that the database intact and accessible - that seems very wrong - so I'm left to conclude that the database being present accessible is not the root problem. I _suspect_ that the installer detects that the ARS database it is about to upgrade is in use by another running ARS server elsewhere - which could easily happen if your SID's were the same in dev prod. The other problem here could be that all of the oracle binaries and config files were copied, including tnsnames which refernces the prod instance - and it is actually Oracle generating this error message. If this is the case, the DBA will need to either: A:) ensure that all references to the old db server hostname/ip in _any_ Oracle configurations are updated to the dev database hostname/ip Or B:) erase the instance and re-create it via standard tools/processes, then export the data from prod and import it in dev. Option B would be highly reccommended - who knows where Oracle stuffs away information about where it is supposed to reside. -brian luke From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3 Sent: Tuesday, September 05, 2006 2:28 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server ** Brian: Why the fear? If you name one tablespace ARSYSTEM for instance, and the second ARSYSTEM1, there should be NO cross-talk between the two tablespaces. The problem here might be that the database was physically copied from one server to another and there may be internal checking that is failing and thus the error. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Luke, Brian Sent: Tuesday, September 05, 2006 2:10 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server John, By the DB is the same name do you mean the ORACLE SID or the database server hostname? With Oracle, the Db-name: ar.cfg parameter is used for the tablespace name if it is not ARSYSTEM. One thing that worries me about this config is that if the SID's are the same, the only place they are differentiated is in tnsnames.ora - the danger of unintended cross communication seems great. What version of ARS have and are you upgrading from (this last time, and tracing back?) Check the contents of SERVER_CACHE and see if there are references to old servers there. Also, did you copy the file containing the ARS licenses to the dev ARS server? - try renaming it if you did. One Oracle instance can have one or many tablespaces. Each tablespace can contain the objects for one or more accounts/schemas and keep them separate (even with the same table names). -Brian Luke -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley Sent: Friday, September 01, 2006 8:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System
Setup Dev Server
Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Setup Dev Server
John, Did you also see: DLL function call crashed:UPORACL.UpgradeDatabaseOR ? I had exactly that problem when I upgraded from ARS 5.1.2 on a Windows 2000 box to ARS 6.3 on Windows 2003 box. The Oracle 9.2.0.4.0 64 bit was on an AIX box. Remedy Support was pretty sure that it had something to do with the Oracle client. Recently I noticed a note on the compatibility matrix that may provide a clue: Requires 32-bit Oracle 9iR2 database client for connecting to the Oracle database. I'm not sure what I have. I ended up upgrading the database from the old Win 2000 box, then connecting to the upgraded database from the 2003 box. I then tested everything and have now been in production with it since May with no problems. I do not know if I'll have a problem when it comes time to upgrade again, so I would love to hear if you find out what causes it. Julie At 09:30 AM 9/1/2006, you wrote: Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org --- Julie Rockwood Los Alamos National Laboratory IST-AUBAD Remedy Technical Lead (505) 667-9846 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Setup Dev Server
Title: RE: Setup Dev Server ** Julie: All UNIX versions of ARS require that the associated 32 bit client libaries be installed and placed in the library path file before any 64 bit libraries. This may also be true for the 64 bit Windows systems. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Julie Rockwood Sent: Friday, September 01, 2006 10:38 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server John, Did you also see: DLL function call crashed:UPORACL.UpgradeDatabaseOR ? I had exactly that problem when I upgraded from ARS 5.1.2 on a Windows 2000 box to ARS 6.3 on Windows 2003 box. The Oracle 9.2.0.4.0 64 bit was on an AIX box. Remedy Support was pretty sure that it had something to do with the Oracle client. Recently I noticed a note on the compatibility matrix that may provide a clue: Requires 32-bit Oracle 9iR2 database client for connecting to the Oracle database. I'm not sure what I have. I ended up upgrading the database from the old Win 2000 box, then connecting to the upgraded database from the 2003 box. I then tested everything and have now been in production with it since May with no problems. I do not know if I'll have a problem when it comes time to upgrade again, so I would love to hear if you find out what causes it. Julie At 09:30 AM 9/1/2006, you wrote: Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org --- Julie Rockwood Los Alamos National Laboratory IST-AUBAD Remedy Technical Lead (505) 667-9846 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Setup Dev Server
I can SQL plus on the Dev box to the DB. I log in as ARAdmin default password. Here is another catch. If I leave the tables space name the default (ARSYSTEM) it then goes to the Next Screen to Upgrade. I also tried to change the table space name to TABS and suprisingly it allows me to the next screen also. Shouldn't the DB only have one Tablespace name? Oh -- the Production server has the same version or Oracle. John Julie Rockwood [EMAIL PROTECTED] V To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)Subject [EMAIL PROTECTED] Re: Setup Dev Server ORG 09/01/2006 01:38 PM Please respond to [EMAIL PROTECTED] RG John, Did you also see: DLL function call crashed:UPORACL.UpgradeDatabaseOR ? I had exactly that problem when I upgraded from ARS 5.1.2 on a Windows 2000 box to ARS 6.3 on Windows 2003 box. The Oracle 9.2.0.4.0 64 bit was on an AIX box. Remedy Support was pretty sure that it had something to do with the Oracle client. Recently I noticed a note on the compatibility matrix that may provide a clue: Requires 32-bit Oracle 9iR2 database client for connecting to the Oracle database. I'm not sure what I have. I ended up upgrading the database from the old Win 2000 box, then connecting to the upgraded database from the 2003 box. I then tested everything and have now been in production with it since May with no problems. I do not know if I'll have a problem when it comes time to upgrade again, so I would love to hear if you find out what causes it. Julie At 09:30 AM 9/1/2006, you wrote: Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org --- Julie Rockwood Los Alamos National Laboratory IST-AUBAD Remedy Technical Lead (505) 667-9846 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Setup Dev Server
Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Setup Dev Server
Title: RE: Setup Dev Server ** John: You can create as many tablespaces in one Oracle DB as you need. I would not, if possible, install the production and development tablespaces into the same Oracle DB instance. I have two different versions of ARS installed on the same Oracle DB instance, however. James Mckenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:53 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server I can SQL plus on the Dev box to the DB. I log in as ARAdmin default password. Here is another catch. If I leave the tables space name the default (ARSYSTEM) it then goes to the Next Screen to Upgrade. I also tried to change the table space name to TABS and suprisingly it allows me to the next screen also. Shouldn't the DB only have one Tablespace name? Oh -- the Production server has the same version or Oracle. John Julie Rockwood [EMAIL PROTECTED] V To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList) Subject [EMAIL PROTECTED] Re: Setup Dev Server ORG 09/01/2006 01:38 PM Please respond to [EMAIL PROTECTED] RG John, Did you also see: DLL function call crashed:UPORACL.UpgradeDatabaseOR ? I had exactly that problem when I upgraded from ARS 5.1.2 on a Windows 2000 box to ARS 6.3 on Windows 2003 box. The Oracle 9.2.0.4.0 64 bit was on an AIX box. Remedy Support was pretty sure that it had something to do with the Oracle client. Recently I noticed a note on the compatibility matrix that may provide a clue: Requires 32-bit Oracle 9iR2 database client for connecting to the Oracle database. I'm not sure what I have. I ended up upgrading the database from the old Win 2000 box, then connecting to the upgraded database from the 2003 box. I then tested everything and have now been in production with it since May with no problems. I do not know if I'll have a problem when it comes time to upgrade again, so I would love to hear if you find out what causes it. Julie At 09:30 AM 9/1/2006, you wrote: Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org --- Julie Rockwood Los Alamos National Laboratory IST-AUBAD Remedy Technical Lead (505) 667-9846 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Setup Dev Server
Title: RE: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Setup Dev Server
Title: RE: Setup Dev Server ** He said they were on 2 different servers From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Friday, September 01, 2006 1:41 PMTo: arslist@ARSLIST.ORGSubject: Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Setup Dev Server
What problem is there with using the same instance with different schemas? We have one server with 4 arsystem schemas in a single instance, not to mention that are dozens of other schemas in the instance not being used for Remedy. Using the same tablespace will be a problem if you try and do a fresh install because the arserver installer is flawed in the sense that it drops whatever tablespace you install arserver to and recreates it. Creating another instance has a lot of overhead associated with it (two sets of processes, two sga's, etc.) If the db server has enough hardware to fulfill the software's requests you should not have a problem sharing an instance. Axton Grams Grooms, Frederick W wrote: ** He said they were on 2 different servers *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *McKenzie, James J C-E LCMC HQISEC/L3 *Sent:* Friday, September 01, 2006 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it_20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Setup Dev Server
Title: RE: Setup Dev Server ** Fred: (Wacking self on head). Thanks. Now the next question is how did they duplicate the database? There are variables in the Remedy metadata that will error out if they did a physical vice ARExport/ARImport move of data. This may be causing the problem. I tried a physical move from one tablespace to another on the same server and Oracle would not let me. James Mckenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick WSent: Friday, September 01, 2006 12:12 PMTo: arslist@ARSLIST.ORGSubject: Re: Setup Dev Server ** He said they were on 2 different servers From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Friday, September 01, 2006 1:41 PMTo: arslist@ARSLIST.ORGSubject: Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Setup Dev Server
Title: RE: Setup Dev Server ** Axton: What I seen was that the tablespace was the same name, which with two servers is not a problem. I've delt with one admin, here on the list, that had installed the production and development to the same server, same tablespace. Disaster was the result. As far as running two or more servers against the same instance. No problem. However, you will need to size the PGA and SGA to accomidate the additional load. I prefer what John has done. Two servers, two instances and never the two shall meet. And if you are covered by SarbOx, you may have to do things this way. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Grams Sent: Friday, September 01, 2006 12:19 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server What problem is there with using the same instance with different schemas? We have one server with 4 arsystem schemas in a single instance, not to mention that are dozens of other schemas in the instance not being used for Remedy. Using the same tablespace will be a problem if you try and do a fresh install because the arserver installer is flawed in the sense that it drops whatever tablespace you install arserver to and recreates it. Creating another instance has a lot of overhead associated with it (two sets of processes, two sga's, etc.) If the db server has enough hardware to fulfill the software's requests you should not have a problem sharing an instance. Axton Grams Grooms, Frederick W wrote: ** He said they were on 2 different servers -- -- *From:* Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] *On Behalf Of *McKenzie, James J C-E LCMC HQISEC/L3 *Sent:* Friday, September 01, 2006 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it_20060125___This posting was submitted with HTML in it___
Re: Setup Dev Server
I duplicate databases infrequently. The metadata (actlink_open, email mailbox, etc.) are fairly easy to clean with pl/sql. Copying between different tablespaces is a little tricky due to LOB storage, but not impossible. You have to manually create the tables with modified DDL (specifying lob storage) that have LOBs prior to running the imp of the dmp file to ensure the LOBS go to the right tablespace during import. http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:378418239571#16075038165527 The main reason we do it this way is because this method puts the margin for error/reliability and the time required to complete are in our favor. Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Fred: (Wacking self on head). Thanks. Now the next question is how did they duplicate the database? There are variables in the Remedy metadata that will error out if they did a physical vice ARExport/ARImport move of data. This may be causing the problem. I tried a physical move from one tablespace to another on the same server and Oracle would not let me. James Mckenzie L-3 GSI *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *Grooms, Frederick W *Sent:* Friday, September 01, 2006 12:12 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** He said they were on 2 different servers *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *McKenzie, James J C-E LCMC HQISEC/L3 *Sent:* Friday, September 01, 2006 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http
Re: Setup Dev Server
Title: RE: Setup Dev Server ** Axton: Definitely the way to copy a tablespace from one server to another. I had forgotten about copying the LOB space, too. I tend to use Export/Import from Remedy rather than do this at the DB level. However, this does not scale well if you are working with Direct SQL and reference tables by name. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Grams Sent: Friday, September 01, 2006 12:53 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server I duplicate databases infrequently. The metadata (actlink_open, email mailbox, etc.) are fairly easy to clean with pl/sql. Copying between different tablespaces is a little tricky due to LOB storage, but not impossible. You have to manually create the tables with modified DDL (specifying lob storage) that have LOBs prior to running the imp of the dmp file to ensure the LOBS go to the right tablespace during import. http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:378418239571#16075038165527 The main reason we do it this way is because this method puts the margin for error/reliability and the time required to complete are in our favor. Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Fred: (Wacking self on head). Thanks. Now the next question is how did they duplicate the database? There are variables in the Remedy metadata that will error out if they did a physical vice ARExport/ARImport move of data. This may be causing the problem. I tried a physical move from one tablespace to another on the same server and Oracle would not let me. James Mckenzie L-3 GSI -- -- *From:* Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W *Sent:* Friday, September 01, 2006 12:12 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** He said they were on 2 different servers -- -- *From:* Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] *On Behalf Of *McKenzie, James J C-E LCMC HQISEC/L3 *Sent:* Friday, September 01, 2006 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley
Re: Setup Dev Server
That's why it's better to look up the schema ids and field ids in your workflow based on the form/field names, then use var substitution in your direct sql (e.g. select C$fieldid1$ from T$schemaid1$ where C$fieldid2$ = 'some literal value or field'). Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Axton: Definitely the way to copy a tablespace from one server to another. I had forgotten about copying the LOB space, too. I tend to use Export/Import from Remedy rather than do this at the DB level. However, this does not scale well if you are working with Direct SQL and reference tables by name. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Grams Sent: Friday, September 01, 2006 12:53 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server I duplicate databases infrequently. The metadata (actlink_open, email mailbox, etc.) are fairly easy to clean with pl/sql. Copying between different tablespaces is a little tricky due to LOB storage, but not impossible. You have to manually create the tables with modified DDL (specifying lob storage) that have LOBs prior to running the imp of the dmp file to ensure the LOBS go to the right tablespace during import. http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:378418239571#16075038165527 The main reason we do it this way is because this method puts the margin for error/reliability and the time required to complete are in our favor. Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Fred: (Wacking self on head). Thanks. Now the next question is how did they duplicate the database? There are variables in the Remedy metadata that will error out if they did a physical vice ARExport/ARImport move of data. This may be causing the problem. I tried a physical move from one tablespace to another on the same server and Oracle would not let me. James Mckenzie L-3 GSI -- -- *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *Grooms, Frederick W *Sent:* Friday, September 01, 2006 12:12 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** He said they were on 2 different servers -- -- *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *McKenzie, James J C-E LCMC HQISEC/L3 *Sent:* Friday, September 01, 2006 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup
