I have installed Arc SDE 10.1 on windows 2008 server and our Oracle 11g Release 2 is running on Linux. I have created Arc SDE service succesfully with create service command. But when i try to start the service from windows control panel, i get following error:
Windows unable to start ArcSDE service, Error 1053, unable to start the service in timely fashion.
side note form the main problem: hosting Arcsde on different server than database server profoundly impacts performance (personal experience).
There are a number of reasons to discourage use of a remote application server, but "profound" performance impact isn't one of them. There may be implementations where a remote server is the best available solution, so care should be taken when making such pronouncements, especially without knowledge of the networking and client configurations.
As to the main problem, there are many possible causes for service start failure, many of which become obvious when reviewing the logs. The installation instructions for remote service configuration with Oracle detail how the TWO_TASK (on Linux) or LOCAL (on Windows) environment variable must be set in the dbinit.sde for service connection to complete. You must also have a 64-bit Oracle client installed (as of 10.1, all application servers are only 64-bit). Without the content of the dbinit.sde file, the location of the client, and the error log contents, we can't be of much assistance.
After your suggestions, i have come out with following.
(1) The service entry is available in windows operating system services file (2) Environment variable ORACLE_SID is set in dbinit.sde (3) But esri_sde.log file is not available in SDEHOME\etc\, I dont know the reason.. (4) The Oracle client software installed on Windows 2008 server (where ArcSDE 10.1 is installed) is 32 bit but not 64 bit
2 and 4 are your problems. Oracle requires the use of LOCAL instead of ORACLE_SID on Windows for remote connection (TWO_TASK on Unix) and the 64-bit binary requires a 64-bit client install. I should note that use of Direct Connect is strongly recommended, and application server use is deprecated at 10.2.x. -V
Is there any other way to configure DBTUNE table other than ArcSDE command line ??
No. If you need to add a new keyword with multiple parameters to the DBTUNE table, it is easier to export, edit, then import the contents of the DBTUNE table. ( �??o export and �??o import command). This can be executed only through ArcSDE command line.