In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-02-24 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
1)Preparation before installation
Before installing ArcSDE, verify that the Oracle server is installed and that the sde library has been created, user, and authorized. Install Oracle10g PL/SQL client locally first. The following information will also be collected:
server computer name
Oracle Network Service Name
User name and password:
2)installation process
Step 1: Double click setup64.exe to execute the installer
Step 2: Welcome screen appears, click Next button
Step 3: Select Accept License Statement and click Next button
The fixed path is set to C:\ArcGis\
Step 4: Specify the installation path and click the Next button.
Step 5: Confirm the installation and click the Next button.
Step 6: Click Finish to complete the installation.
After Finish is complete, the following problems may appear. After they appear, uninstall the previously installed programs, go back to the first step of installation, right-click setup64.exe, compatibility troubleshooting
Click Ok for Post Installation and follow the usual steps to install ArcSDE until you exit the installation interface.
Create system user variables:
Variable Name: TNS_ADMIN
Variable value: D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
Go to DOS and execute the following command:
Create Services:
sdeservice -o create -d "oracle10g,SDH" -p "sde ASBsde-11" -i "esri_sde" -n
Modify Windows configuration files:
First find the services file under windows/system32/drivers/etc directory, open it with Notepad, and add the line esri_sde 5151/tcp #ArcSDE Oracle10g at the end.
This is important: Open the ArcSDE installation directory, the default path for the program
"C:\ArcGIS\ArcSDE\ora10gexe," open the etc folder and use Notepad to open the dbinit.sde file. (changes every time you create an SDE service)
Change Set Oracle_sid=XXXX to Set Local=XXXX,(XXXX: is the local ORACLE TNSNAME) and save, close the file.
Startup Services:
sdemon -o start -i esri_sde -p "ASBsde-11"
Start the sde service. If it fails, restart the computer. In this case, in ArcSDE services, a Dependency item is one that has no related Oracle service.
View service status:
sdemon -o status
ArcGIS Related Issues Summary
1. After Oracle is upgraded to 10.2.0.4, ArcGIS sde must be upgraded to 9.2.6 to support it, otherwise the post will not succeed.
2. When the database and ArcSDE are installed on different machines, errors will occur in general. The solution is as follows:
1)Oracle Client needs to be installed on the ArcSDE installation machine, or ODAC needs to be installed, as long as Oracle Net software can be installed, assuming that the configured oracle connection service name is Oracle_ServiceName.
2)Installing ArcSDE programs follows the same steps as ArcSDE 9.2 for Oracle10g
3)Install ArcSDE 9.2 patch
4)In the ect\dbinit.sde folder under $SDEHOME, open it if there are:
set Oracle_SID = Oracle_ServiceName
Amend to read
set LOCAL = Oracle_ServiceName (Oracle_ServiceName is the local Oracle connection service name configured with Oracle Net)
If not, add: set LOCAL = Oracle_ServiceName
5)When configuring to the last step of creating services. Do not select dialog box wizard create, but select command statement action create service:
a) Start cmd and type: sdeservice -o create -d Oracle10g,Oracle_ServiceName -i esri_sde -p sde -n
b)(Note that command statements end with-n)
6)Make sure the SDE service port is open in the C:\WINDOWS\system32\drivers\etc\services file: ESRI_SDE 5151/TCP #ArcSDE for Oracle. (Generally, after installing sde, it will automatically add the opening of this port)
7)installation is successful
8)sdemon -o start -i esri_sde -p sde can successfully start the service
9)If step 8 fails and prompts error 1053, restart the machine and sde can be started normally.
10)If it still doesn't work, add the variable LOCAL to the system environment variable and make it equal to the oracle connection service name configured earlier: Oracle_ServiceName.
11)The 10th point is the solution to the problem I encountered. It may be to the 9th step. Generally, it can be started, but if it still doesn't work, it prompts in the windows event log that the database cannot be connected, then add this environment variable, and then restart the machine. The problem can be solved.
3. ArcGIS is best installed together with the applied GIS project, which will be much faster.
4. Windows login password modification affects ArcGIS
ArcGIS default installation authentication is done by account, this method is characterized by not changing the password, enter the system service interface, change ArcGIS to local account system, this way and operating system login password has nothing to do.
5, arcgis login password forgotten or the service can not enter, has been padding
1) Go to\AppServer\directory and delete AimsAdmPw(password file) and ArcGISSite.sez (service definition file);
2) Go to Control Panel-Administrative Tools-Services and restart all arcGIS services. Go to Administrator again.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
Oracle Database SQL Tuning Guide---8 Optimizer Access PathsDirect Path ReadsIn a direct path read, t
© 2024 shulou.com SLNews company. All rights reserved.