ARCGIS and Oracle Direct connection.
A very small problem I faced and thought of sharing how I fixed it maybe it will help someone he faces it, Last week my boss send me to one of our client, They were having problems in Database connectivity, first I look at the structure they were using, our Client have 4TB High Resolution Raster Images on Oracle10g installed on Windows Server 2003 with ARCSDE, the database was crashed so I asked the DBA for the last backup in case we do the clean installation, I installed the windows then oracle and then SDE but when I restore the data SDE was not working I try everything but it was not working at any cost, after few hours of hard work the DBA admit that the ARCSDE was crashed long time ago and he took the last back up with ARCSDE not running on the server. Now I have to find a way to recover ARCSDE and get the database on track again, I already tried installing ARCSDE but it didn’t work out and if I drop the SDE tablespace and user all the Schema will be lost I have to find a way to give the clients access to the server without losing any data, so I thought why not give them direct connection to the database instead of using ARCSDE infect users uses ARCCATALOG for loading the raster files so all I did (instead of playing around with the voluble data) is just installed oracle Client in all the nudes with easy naming and conform that the connectivity is absolutely working I just made changes in the ARCCATALOG Add spatial database connection so here is what I done.
SERVER = write the name of the Server (or IP address)
Service = ARCSDE:ORACLE10g
DATABASE = Database Name
USER = User Name
PASSWORD = Password
Note:
If you have more than one database sometime you cannot get connect with the one you want so it is better to shutdown the one of them get connected with the other then do the same for the first one.
Thanks for Reading….
