Ran across an interesting problem today when trying to view an Oracle database in ArcCatalog. The error was something along the lines of ArcSDE not started on the server...Attempting to start the service revealed that the license was expired or not set for version 10. In order to update an ArcSDE license, you have to actually update an Oracle table (sde.server_config) and provide the new key. This is the example that Jen Baxter sent me.
update sde.server_config set char_prop_value =
'arcsdeserver,100,ecp895569880,30-jun-
2012,ZZYTYXLPECJPA4S8A214' where
PROP_NAME='AUTH_KEY';
Don't forget to commit the transaction in Oracle. You then need to (1) Restart Oracle and (2) Restart the ArcSDE service. That should allow you to then browse the database in ArcCatalog.
Can you provide an example of how you would restart an ArcSDE service?
ReplyDelete