Sort out ArcSDE Installation Problems and Solution Series

During ArcSDE installation, different configuration environments and support for relational databases may encounter some problems.
Now I share my problems and solutions here. I hope you can write your own experiences.

IArcsde9.1 for Oracle9i installation (ORA-12571)

Installation environment: Windows XP Professional
GIS software: arcsde9.1
Database software: Oracle 9.2.0.1.0

Steps:
1. Install Oracle 9.2.0.1.0 (Create a database instance)
2. Install ArcSDE for Windows \ arcsdeoracle9i
3. Run: ArcSDE for Oracle post installation
An error occurred while creating the esri_sde service.

Detection problems:
C: \ ArcGIS \ ArcSDE \ ora10gexe \ etc directory file
View the information of the sde_esri_sde file.

The error message is as follows:
Db_open_instance (): db_connect (ocib) error: 12571
Init_db db_instance_open_as DBA:-51
DBMS error code: 12571
Ora-12571: TNS package write failed

Solution:
Comment out the sqlnet. authentcation_services = (CNT) line in the % ORACLE_HOME % Network/admin/sqlnet. ora file.
Or you can change the content of the system to none.
Restart.

Note: This problem may occur when oracle9.2.0.1.0 is installed on Windows XP. It is usually related to the host subdomain name. For example, the host subdomain name is mycompute.domain.com.

Error message displayed when ArcSDE 9.1 SP1 for SQL Server 2005 encounters a problem:
Sqlstate: 42000 natvieerror: 15007 'sde' is not a legal user or you are not allowed to access

Error cause:
The reason is that SQL Server 2005 does not support the creation of Sde users using a simple password "SDE ".

Solution:
The six-digit password can solve the problem.

Image Attachment: TT. jpg (, 8.46 K)

 

Three ArcSDE 9.1 for release E 10g Installation Problems (Invalid Version error message)

The applications installed in arcsde9.1 for Oracle only include for Oracle 8i and 9i. How can I create the ArcSDE service in Oracle 10g (10.2.0.1?

The procedure is as follows: 1) Start the Oracle 10.2.0.1 service.
2) run the arcsdeoracle9i program of the installation disc.
3) download and install the ArcSDE 9.1 patch 1: ArcSDE-Oracle9i-91sp1.msp
: Http://support.esri.com/index.cf... = 19 & metaid = 1099
4) perform post install (the method here is the same as installing Oracle9i)

NOTE: If ArcSDE 9.1 patch 1 is not installed before the configuration, the Oracle version is incorrect during the configuration process.

4. Remote Installation of ArcSDE 9.1 for Oracle 10 GB (notes for Remote Installation)

Environment Description:
The database oracle10.2.0.1 is installed on the server of the ibm aix operating system.
Install ArcSDE on Windows 2000
Objective: To remotely install ArcSDE 9.1 for Oracle 10g

Installation steps:
1. Install the Oracle client on the Windows 2000 operating system
2. The steps for installing the ArcSDE program are the same as those for ArcSDE 9.1 for Oracle9i.
3. Install ArcSDE during configuration. 2: ArcSDE for oracle10g.exe
Http://support.esri.com/index.cf... = 19 & metaid = 1155
Others are the same as ArcSDE 9.1 for Oracle 9i
4. Open and modify the ECT \ dbinit. Sde folder in the $ sdehome directory.
Set oracle_sid = orlsde
Changed:
Set local = orlsde
5. When configuring to create a service in the last step. Select a command statement to create a service without selecting the wizard in the dialog box:
Start cmd
Sdeservice-o create-D Oracle10g, orlsde-I esri_sde-P Sde-n
Note that the command statement must end with-n.
6. Ensure that the ArcSDE service is created in c: \ windows \ system32 \ drivers \ etc \ Services.
7. Installation successful
8. sdemon-o start-I esri_sde-P SDE can start the service successfully.

ArcSDE for SQL Server 2000 (error message: DBMS error code: 18452)

When the service is started at the end of the configuration and installation phase, the following error message is returned.
"Unable to strat iomgr"
When you switch to \ ArcSDE \ sqlexe \ ect, open the Service Log File and you will find the following information:
------------------------------- ArcSDE 9.0 SQL Server ----------------------------- idbinitialize: initialization failed db_open_instance () pcc_connect error: 18452 init_db DB-instance_open_as_dba:-51 DBMS error code: 18452 Microsoft ole db provider for SQL Server: User SDE Login Failed. the reason is that it is not associated with a trusted SQL server connection.

Cause of error:
Set Microsoft SQL server to Windows only for verification on the security panel

Solution:

You only need to modify the security panel settings of SQL Server 2000.

1. Start the Enterprise Manager of Microsoft SQL Server

2. Right-click the SQL server instance and select Properties to open the properties Panel of the instance.

3. In the security panel, change windows only to SQL Server and windows.

Configuration of six arcsde9.2 personal versions
I wrote an article about the configuration of arcsde9.2 personal, which was originally pasted elsewhere. There are many images and it is not convenient to upload and paste them one by one.
Arcsde9.2 Personal Configuration
Http://www.cnblogs.com/flyingfish/archive/2007/04/03/698784.html

I have heard that arcgis9.2 desktop comes with a free personal SDE, called personal SDE. When learning the web-side editing function of server, you need to use SDE. Record the following issues during configuration. For more information about personal SDE, see ArcGIS 9.2 note (2): Personal ArcSDE, personal ArcSDE.

After sqlexpress is installed, a sqlexpress connection is created in the catalog. the following error occurs when the new geodatabase is installed:

---------------------------
New Geodatabase...
---------------------------
Error creating this Geodatabase
No ArcSDE server license found.
---------------------------
OK
---------------------------

I was confused. I thought it was a license problem. After I found several license tests, the problem still persists.

Think about it carefully. Since it is said that the free service should not require the SDE license of our experts, desktop can be used, and it should be available.

This item is found when you query the installation of desktop and DVD. For example, you can carefully check the fifth item: ArcSDE Personal Edition for sqlexpress.

It is suspected that no post install similar to the previous 9.0 installation is installed by default.

The configuration page is as follows.

The new Geodatabase problem has been solved again. Add a few feature classes to check them:

OK!

The databases shown in SQL Server Management are as follows:

Note:

1. sqlexpress itself is a free version of software without a GUI for controlling enterprise managers. For details, download: Microsoft SQL Server Management studio express 9.00.2047.00.
2. The Web editing function of ArcGIS Server depends on SDE. For more information, see http://bbs.esrichina-bj.cn/website xiaoyaohu's article: Server 9.2.