Detailed installation and configuration of ArcSDE based on Oracle and sqlserver:

ArcSDE for sqlserver Installation Process
1. Windows 2000 SP3, SQL 8.3 SP3 sde8.2 with SP1, ArcInfo
The computer name is zongzhan-6afuly1, SQL2000 installation is installed by default. The installation directory of Sde is D: \ arcgissde \.
2. install the software first. Of course, the software is cracked. I modified the 8.3 license, changed the SDE license to 8.2, and then overwritten the original file with the cracked acore. dll.
3. Set slq and set authentication to Windows and SQL dual-verification. Do this before you try it.
4. Open the query analyzer and run the following code. The code is all in the generic folder. If it is 2000, you can open the 2000 remote line. If it is 97, It is the 97 file. Do not change the content in it. You just need to cut off the distance.
5. Open the Enterprise Manager and set the SDE user's logon password to SDE.
6. Perform DoS settings below, which is the most difficult part!
7. Open the DOS interface of Win2000 and enter the bin directory of Sde. Command is
CD arcgissde \ ArcSDE \ sqlexe \ bin
8. Run the following command sdesetupmssql-O install-u Sde-P Sde-s zongzhan-6auly1-h d: \ arcgissde \ ArcSDE \ sqlexe \
The above command is required to load the required table required by SDE into the SDE database.
9. Run the command (or in the bin directory) sdeservice-o create-P Sde-l @ zongzhan-6auly1-h d: \ arcgissde \ ArcSDE \ sqlexe \-I my_sde
10. Modify the file D: \ winnt \ systerm32 \ drives \ ect \ Services to open it with notepad and other tools. Add the following two lines:
Esri_sde 5151/tcp # ArcSDE
My_sde 5154/tcp # my_sde
Modify the service. Sde file under arcgsisde \ ArcSDE \ sqlexe \ etc, remove the # number before 5151/tcp, and add the following code to the next line.
Save the my_sde 5154/TCP.
11. Go to the Win2000 Service Manager and run the my_sde service.

ArcSDE for Oracle Installation Process

(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.

Appendix: causes and solutions for installation failure of ArcSDE

(Author: Chen yuanlin)

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) Start oracle from "start"> "program"> "oracle-orahome92"> "Enterprise Manager Console" and use any user name or password, sysdba identity login (the reason for logging in as sysdba does not need to be verified is that sysdba is authenticated by the operating system and 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, then you need to verify your identity 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.

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.