Full introduction to ArcSDE: fdnike Column

Many of my friends have failed to install ArcSDE in the following two cases:
1. An error occurred while installing ArcSDE.
2 ArcSDE has been installed, but the service has not been started.

For this reason, I installed ArcSDE multiple times and found a solution to possible problems during the period. Now I want to write down the installation steps. I hope that not only do I have a friend who installed ArcSDE for the first time, but also those who have not installed ArcSDE successfully. Of course, this is just a reference. please correct me if you have any mistakes.

In Windows, the solution is as follows:
1. Open the registry and delete the ArcSDE service.
Details:
(1) Open "Control Panel", "service", and find "ArcSDE Service (somename)". somename is the real name of your ArcSDE service, remember this name (for descriptive convenience, the following uses somename to indicate its real name ).
(2) Open "start", "run", type "Regedit", find HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ service \ somename, and delete the entire folder. (Somename here refers to somename in (1 .)
(3) restart the computer. (The purpose is to refresh the Registry. You can also use other methods to create a new registry. However, we strongly recommend that you restart the Registry here .)

2. delete user SDE and tablespace SDE from Oracle
Details:

(1) From "start" -->"Program"-->" Oracle-orahome92 "-->" Enterprise Manager Console ", which starts Oracle and logs in as any user name, password, or sysdba (login as sysdba does not require verification because: sysdba is authenticated by the operating system. There is an ora_dba group in the operating system. In this group, members can connect to the Oracle database as a DBA without a password, if you delete the username you used when logging on to the local machine from this group, you need to perform authentication when logging on to Oracle AS sysdba ).

(2) locate "SDE" under "security" --> "user" (if not, proceed to the next step), right-click "SDE", and select "move ", select "yes" to delete the user SDE.

(3) locate "SDE" under "Storage" --> "tablespace" (if not, proceed to the next step), right-click "SDE", and select "move ", select "yes" to delete the tablespace SDE.

(4) Disable oracle.

 

3. reinstall ArcSDE
Details:

(1) choose "start"> "program"> "ArcGIS"> "ArcSDE"> "ArcSDE for Oracle9i post installation" to go to the installation interface.

(2) Step 1: Select complete installation, that is, "complete", and click "Next ".

(3) Step 2: log on to the Oracle database as the Oracle user SYS. In sys user password, enter the Sys password (entered when oracle is installed). In net service name, enter the name of the Oracle service. You can view the name of the Oracle service as follows: "Control Panel" --> "Administrative Tools" --> "service", find the service marked with "oracleservicesomename2" (somename2 is just an alternative string), right-click "properties ", in the pop-up dialog box, you can see the string under "executable file path", which contains ". "EXE" is followed by the Oracle service name. Click "Next ".

(4) Step 3: Create the SDE tablespace and the user (if a dialog box is displayed, it indicates that the user SDE already exists because the user Sde Or the tablespace SDE has not been deleted from Oracle ). The dialog box contains three columns: SDE user, default, and file. The default column indicates the default SDE user name and tablespace name to be created, and the SDE user column indicates the password of the user SDE, the file column lists the newly created user and tablespace files.
We strongly recommend that you do not modify the "SDE" in the default column, because if you change it to another name, you will see the password for the user SDE in (8, we have not created the user "SDE ".
I personally think that the prompt in the SDE user column and the default column is not very good. In the rough view, two usernames are mistakenly required, one is the user name used for running, and the other is the default user name. However, the characters entered in the SDE user column are displayed as stars. By default, this column should be a password. In addition, when we first enter (6), we can open oracle. We can see that "user" does generate the name entered in the default column, this is not the name entered in the SDE user column, but also in the tablespace.
We can enter only one string in the SDE user column as the user's "SDE" password, and the rest will be used by default. Click Next.

(5) Two dialog boxes are displayed, prompting you that SDE and table space SDE are successfully created.

(6) Step 4: Go to "ArcSDE configuration files", configure the ArcSDE file, select default, and click Next.

(7) Step 5: Go to "ArcSDE configuration files continued", continue to configure the ArcSDE file, select default, and click Next.

(8) Step 6: create a solution SDE. At this time, the SDE user name is fixed, "SDE"; the program in (4) has obtained the user's "SDE" password, which is also given in the form of a star; the program has obtained the Oracle service name in (3), which is also shown here. If no errors are found in (3) and (4), click "Next" by default ".

(9) Step 7: Create the ArcSDE service by default. However, the last "oracle_sid" must be filled in correctly. Otherwise, the ArcSDE service cannot be started even if it is created. You can use the following method to view the SID of the Oracle that has been installed in the system: under the "\ admin \ SDE \ profile" folder in the Oracle installation path, there is a "init. ora.: \ oracle \ admin \ SDE \ pfile \ init. ora.6162005101919). Open it in a text file and search for the string "instance_name". You can see the value of "instance_name = somename3". This somename3 is oracle_sid. After filling in the information, click "Next ".

(10) If the ArcSDE service exists, a message indicating whether the service already exists and whether to overwrite the service or an error is displayed. Cause: "open registry and delete ArcSDE service" in step 1 only deletes the services in the control panel service list, the real service (in the HKEY_LOCAL_MACHINE \ SOFTWARE \ ESRI \ ArcInfo \ ArcSDE \ 8.0 \ ArcSDE for Oracle) is not deleted, so the system will prompt whether to overwrite the service. If Step 1 is not executed, that is, the ArcSDE service in the service list is not deleted, an error is prompted.

(11) In the preceding steps, the system prompts whether to overwrite the ArcSDE service in HKEY_LOCAL_MACHINE \ SOFTWARE \ ESRI \ ArcInfo \ ArcSDE \ 8.0 \ ArcSDE for Oracle because the actual service is not deleted. Click "yes". A dialog box will pop up later, prompting you to wait patiently, asking if you want to start the newly created ArcSDE service, and selecting "yes". Then, you will be prompted that the service is successfully started.

(12) the installation is complete. In this case, go to the service list ("Control Panel"> "Management Tools"> "services") and find "ArcSDE Service (somename4)" (somename4 is (9) the name of the ArcSDE service. The default value is esri_sde. If any of the above steps after installation, the service is not started, please contact me (Chen yuanlin), E-mail: ___ cyl@163.com

Makeup:
The above is mainly for the case where there is only one database in the Oracle database. If there are multiple databases, for example, there are two: SDE and testdb, then the above installation steps will be slightly changed, as shown below:

A selects a database when deleting SDE and table space SDE from Oracle. The database where you originally created the SDE user and table space (that is, the net service name entered in step 2 of ArcSDE installation, log on to the database first, and then delete the SDE tablespace and users under the database.

B. Steps 2 to 6 (I .e. (1)-(8) of installing ArcSDE. The net service name must be the same, in the "service" list, we can see "oracleservicesde" and "oracleservicetestdb". net service name should either be "SDE" or "testdb"

Step 7 (9) of installing ArcSDE in C )), the entered "oracle_sid" should also be the same as the SID of the Oracle database corresponding to the service corresponding to the net service name entered during the installation process. (The SID of the Oracle database can be seen after "Oracle Enterprise Manager Console" is opened: "network"-> "Database" under the root directory is all the SID of the Oracle database .) I have tested that, if not, the ArcSDE service cannot be started.

Important: The software environment is: ArcSDE 8.3 for Oracle 9i, Windows XP Professional Server Pack 2, and Oracle 9.02.