POST
|
Hi Guys, we have ArcGIS Architecture on 4 servers, Test and Prod: 2 DB servers on Oracle, 2 ArcGIS Applications Servers connected to the DBs. They are located in one server room. We are going to change the servers location (move those servers to other server room). My question is if there can be any impact to those servers after changing servers location? (I don't know may be to change some IP address in config file, whatever?) If yes, please point to those items to be changed? Please reply!
... View more
10-16-2014
11:23 PM
|
0
|
0
|
3682
|
POST
|
hi once more, Guys, thanks for your replies. I am new to ArcGIS. I support Oracle. but we don't have person responsible for ArcGIS. so, we responsible for that. I think that these are full steps: 1.Stop the SDE service and disconnect database connections. 2.Follow steps in Oracle documentation to upgrade the RDBMS to 11.2.0.1. 3.Delete current sdehome folder. 4.Install ArcSDE 9.3.1 for Oracle 11g 5.Change environment variable (sde home/Oracle home) 6.Run sdesetup -o upgrade so that the geodatabase knows its Oracle version and gets any needed RDBMS changes, such as underlying stored procedures 7.Reconfigure the listener and tnsnames.ora for the new ST_GEOMETRY libraries 8.Debug the incorrect ST_GEOMETRY library references 9.Unblock the DBMS and start the SDE service 10.Update all your Direct Connect connection files (Syntax-11g) where it (apply SP2 for ArcGIS 9.3.1) must be added in this list? can you describe ArcGIS steps above in detail? With regards!
... View more
10-09-2013
04:55 AM
|
0
|
0
|
149
|
POST
|
hi Nidhinkn, thanks for the answer. But i am curious, step 4) 4.Install ArcSDE 9.3.1 for Oracle 11g question: wny it is needed to install again? it is already installed and configured. step 6) Run sdesetup -o upgrade so that the geodatabase knows its Oracle version and gets any needed RDBMS changes, such as underlying stored procedures question: where to run it? the command - 'sdesetup -o upgrade' step 😎 8.Debug the incorrect ST_GEOMETRY library references question: how to debug it (incorrect ST_GEOMETRY library references)? So, where can i read in detail all listed bullets written by you in ESRI documentation? did you do upgrade yourself? don't I lose ArcGIS data (configuration settings, data) after making those actions? With regards!
... View more
10-09-2013
04:11 AM
|
0
|
0
|
501
|
POST
|
Let me reformulate the question, what steps must be done in ArcGIS system side, in order Oracle upgrade was done smoothely? In result point, we need upgraded Oracle RDBMS with working ArcGIS 9.3.1 system. With regards!
... View more
10-09-2013
01:48 AM
|
0
|
0
|
501
|
POST
|
Hi everybody, I have question, What impact can be on ArcGIS after Oracle Upgrade? we have architecture: ArcGIS 9.3.1 system is installed on Microsoft Windows Server 2003 R2 (32 bit) with Database: Oracle 10.2.0.3.0. we are going to make upgrade of oracle on 11.2.0.1.0 version. So question is, if there will be any impact on ArcGIS system? if it will work uncorrectly? If yes, please advice, what steps must be done? where we can read necessary documentation? if that operation (upgrade of oracle) involve a lot of changes in ArcGIS? With regards!
... View more
10-08-2013
11:16 PM
|
0
|
13
|
804
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|