ArcSDE Version 9.1 & Oracle Database Ver. 9.x

ThillainadarajanVaithilingam — Wed, 03 Aug 2011 05:30:39 GMT

One of our customer purchased ArcGIS 9.1 with
ArcSDE for Oracle Version 9.x.

The present user have no records about user name and Password to use this system and create new geodatabases, however they can access the existing database and create new feature dataset and feature classes within the existing Geodatabase.

How to create a new username and password in this present setup or ch.
ange the existing user name and password (which are not available)

Re: ArcSDE Version 9.1 & Oracle Database Ver. 9.x

VinceAngelo — Wed, 03 Aug 2011 10:21:50 GMT

While neither ArcSDE 9.1 or Oracle 9i are supported by their respective vendors, the mechanism
for changing a lost SDE password remains the same:

1) Stop the application server service (usually 'esri_sde')
2) Use the administrative login to connect to Oracle ("sqlplus / as sysdba")
3) Change the SDE user password ("alter user SDE identified by newPassw0rd")
4) Replace the existing service:
a - Use 'sdeservice -o list' to obtain the service properties
b - use 'sdeservice -o delete' to remove the existing service
c - Use 'sdeservice -o create' to recreate the service with the new administrative password
5) Start the new application server service
6) Write down the new password and place it in a locked filing cabinet

Changing the passwords for non-SDE users and creating new users are covered completely by
the database documentation and mentioned in the Esri documentation.

- V

topic Re: ArcSDE Version 9.1 & Oracle Database Ver. 9.x in Data Management Questions

ArcSDE Version 9.1 & Oracle Database Ver. 9.x

Re: ArcSDE Version 9.1 & Oracle Database Ver. 9.x