Hi All, A very strange issue i am experiencing with ArcSDE Post installation. My system configuration is defined below.
Server - Windows 2008 Server R2 Standard Processor - Intel(R) Xeon(R) CPU X5670 @ 2.93GHz 2.93 GHz Installed memory (RAM) - 12,0 GB System Type - 64 Bit OS
Problem :- I am able to perform Pre-Installation of ArcSDE successfully on this server, but when I or Setup try to run the Post-Installation it throws error. I have tried the installation & Post-installation from multiple copied of the setup to make sure that setup file are OK or not corrupt. Please find below the error details. I have also attached the screen shot for further reference. I tried to Google to sneak into this issue but unfortunately their are no threads providing any information on this issue.
--------------------------- ARCSDE~1.EXE - Application Error --------------------------- The application was unable to start correctly (0xc000007b). Click OK to close the application. --------------------------- OK ---------------------------
From the screen shot, I am guessing that you may use the wrong installation files for your ArcSDE/Oracle installation.
Please keep in mind, that you need the same bit-level software for your ArcSDE and your Oracle. For example:
If your ArcSDE, Oracle DB were in the same server, then you will need: Oracle DB 64-bit and ArcSDE 64-bit, or Oracle DB 32-bit and ArcSDE 32-bit, or Oracle DB 64-bit, Oracle Client 32-bit and ArcSDE 32-bit
If your ArcSDE, Oracle DB were in the different servers, then you will need: Oracle Client 64-bit and ArcSDE 64-bit, or Oracle Client 32-bit and ArcSDE 32-bit
I have similar problem. My system: - Win 7 Proffesional 64bit - Oracle 10G 32bit - ArcSDE 10 32bit
I can't do postinstallation... the error message is: "error connecting to oracle: O". I found a file called "Error connecting to Oracle" in C:\Program Files (x86)\ArcGIS\ArcSDE\ora10gexe\tools\ with nothing in it. And when i open sqlnet.log in C:\Program Files (x86)\ArcGIS\ArcSDE\ora10gexe\tools\ i found:
Fatal NI connect error 6413, connecting to: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oraclestarter)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=starter)(CID=(PROGRAM=C:\Program Files (x86)\ArcGIS\ArcSDE\ora10gexe\tools\ArcSdeSetupOracle10g.exe)(HOST=PCNAME)(USER=hani_umeko))))
VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 24-JUL-2012 11:12:45 Tracing not turned on.
I can connect to Oracle via Toad without problem. BTW, i set up a loop back adapter installation before oracle installation.
Please help me finding the cause of the problem...
Oracle 10.2.0.1 isn't supported with any Esri product. You need to patch it to at least 10.2.0.3, but I recommed using Oracle 11g (R1 or R2), which is under active support from Oracle (10gR2 is unsupported).
Finally ArcSDE 10 can work with Oracle 10.2.0.1. (yes right..., its 10.2.0.1 !)
My environment: - Win 7 Proff 64 bit - ArcSDE 10 32bit - Oracle 10.2.0.1 32bit
What do I do are two things (i dont know which one makes it works): 1. Grant SDE admin option "administer database trigger" ( I dont think this is neccessary) 2. I install arcsde in another folder (not the default C:\Program Files (x86)\...blabla). I name the folder with one word and without space(eg: c:\myfolder)
I never, *ever* install software with spaces or parenthesis in the path, but I know folks who do, and they've gotten ArcSDE 10 to work, so don't think this was the problem, either.
Oracle 10.2.0.1 is not supported because it doesn't work right. It fails strangely all the time. It can't pass all the certification tests (only 10.2.0.3+ can). 10.2.0.1 is unreliable and therefore should not be used.
Without active security patch support, Oracle 10gR2 is one CERT announcement away from being a vector for destroying the contents of your computer (and whatever network to which it may have access). Do you remember the ILoveYou macro virus? I do. It erased every piece of imagery at a client site (incuding the networked backup drive) forcing them to pay to have their area of interest reflown (using a significant portion of the next year's operating budget). The risk is low, but the potential cost is very high, making the vulnerabilty high. I do not recommend the use of unsupported software.