NIM058641 for ArcSDE/Enterprise Geodatabase

Numéro d’ID de bogue	NIM058641
Envoi	June 29, 2010
Dernière modification	April 2, 2025
S’applique à	ArcSDE/Enterprise Geodatabase
Version trouvée	9.3.1
Système d’exploitation	Windows OS
Version du système d’exploitation	2008 64 Bit
Statut	Will Not Be Addressed

Informations supplémentaires

We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.

Solution de contournement

Workarounds:************a) Set LOCAL as second database instance in command line before running the sdesetup command for second geodatabase schema.e.g., set LOCAL=GISPRODIt creates multiple geodatabase schema. However, connection fails with error: "Failed to connect to the server. Bad login user". Because it is only reading the default dbinit.sde file even though it has been renamed as dbinit_service_name1 and SDEHOME has another dbinit with second service name appended to its name.b) Set ORACLE_SID to second database instance in the default dbinit.sde file.e.g., set ORACLE_SID=gisprod (in dbinit_esri_gisdev.sde/dbinit.sde)c) Use Direct connection string after password to run the command.e.g., sdesetup -o install -d ORACLE10G -u cprod -p cprod@gisprod -i esri_gisprod:cprod -H "<a href="file:C:/Program" target="_blank">C:\Program</a> Files\ArcGIS\ArcSDE\ora10gexe"d) Copy the SDEHOME and create a new service pointing to new SDEHOME for one database instance.e) Do not set LOCAL or ORACLE_HOME to any Oracle instance in default dbinit.sde.