NIM058641 for ArcSDE/Enterprise Geodatabase

Bug ID Number	NIM058641
Submitted	June 29, 2010
Last Modified	April 2, 2025
Applies to	ArcSDE/Enterprise Geodatabase
Version found	9.3.1
Operating System	Windows OS
Operating System Version	2008 64 Bit
Status	Will Not Be Addressed

Additional Information

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.

Workaround

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.