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/Te
ct 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
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 no
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:
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
).
-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
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
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
>
> 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:
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 r
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
m 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
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
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
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
.
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 tryi
RSLIST.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
cc
discussion
list(ARSList)"Subject
<[EMAIL PROTECTED] 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
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 t
**
Check your TNSNames file and ensure the SERVICE_NAME is correct.Also, can you SQLPLUS to the Dev oracle using the TNS names alias?On 9/1/06, John Kelley
<[EMAIL PROTECTED]> wrote:
Hi List: First time emailer. Long time reader.I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Havi
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
22 matches
Mail list logo