Deploy multiple SDE services in the Oracle database

Problem: Purpose: if an oracle instance is installed on a machine, a database instance (SID: Orcl) is generated by default. An SDE (sde service name) is installed on this database instance.

Problem: Purpose: if an oracle instance is installed on a machine, a database instance (SID: Orcl) is generated by default. An SDE (sde service name) is installed on this database instance.

1. Deploy multiple SDE services in one Oracle Database (answers to questions)

Problem:

Purpose:

An oracle instance is installed on the machine. By default, a database instance (SID: Orcl) is generated. An SDE (esri_sde) is installed on the database instance ). Now another database instance (SID: SDEInst) is generated using this oracle tool. The goal is to deploy an SDE on this SDEInst database instance.

Procedure:

1. Use DBCA to generate a database instance with SDEInst SID, and then create a user (whose username is sde, only the role permission [Connect, DBA, RESOURCE] is granted, and other permissions are granted by default). The user's tablespace is also created by himself.

2. Install the methods provided by ESRI on the global network to create and modify files. The details are as follows:

I. Copy % SDEHOME % to a new location (% SDEHOME % My copied content is D: \ Program Files \ ArcSDE 9.2 \ ArcSDE \ ora9iexe ),, then rename it ora9iexe2.

II. Use the database instance SID (SDEInst here) to update the content of the dbinit. sde file (under ArcSDE \ ora9iexe2 \ etc) and change it to: # Oracle SID for service demo_sde.

Set ORACLE_SID = SDEInst

III. Update the ArcSDE \ ora9iexe2 \ etc \ services. sde file and set its service name and port number to demo_sde 5152/tcp # ArcSDE for Oracle

IV. Add the service name and port number demo_sde 5152/tcp to C: \ WINDOWS \ system32 \ drivers \ etc \ services.

V. Cleared the content of the log file brought by ora9iexe by ArcSDE \ ora9iexe2 \ etc --- sde_setup.log

VI. Update giomgr according to ESRI global network method. defs and dbtune. the content of the sde file has not been changed because you do not know how to set the parameters. should the sde parameter in Orcl be correct?

3. Create system tables and stored procedures for ArcSDE and Geodatabase. The command used here is:

Sdesetup-o install-d ORACLE9I-H "D: \ Program Files \ ArcSDE 9.2 \ ArcSDE \ ora9iexe2"-u sde-p sde

This command line also encountered many problems. Later, the sde user created by the user is attached with the DBA permission. However, ESRI's global online description of user-p is: Database administrator password. Why can't I use DBA users with other user names? This is the case. After all, it has been created successfully.

4. Create an sde Service (this is an error)

Run SDE command line: sdeservice-o create-d ORACLE9I, SDEInst-p sde-I demo_sde-H "D: \ Program Files \ ArcSDE 9.2 \ ArcSDE \ ora9iexe2"-n.

However, the following errors always occur during running (refer to the image): Wrong RDBMS Name "ORACLE9I, SDEInst ". My database is ORACLE9I and my SID is SDEInst as described above. No problem !!!?

Later, I tried to replace "-d ORACLE9I, SDEInst" with "-d ORACLE, SDEInst", but this SDE service named demo_sde still cannot be started, after comparing the successfully running SDE services, we found that the demo_sde SDE service is less dependent on the Database Service OracleServiceSDEINST, that is, the SDE service is not bound to the oracle instance.

Giomgr process answer:

I checked the application logs. The above is mainly about the sde license. It is actually a very simple problem.

(Previously, the service information was in the system log, but the application log was not viewed)