现在sde都推荐直连了,没想到还是遇到了非直连。
用10.1默认是直连,但还支持非直连。
安装半天始终无法启动。系统差点崩了。
原来是sde用户密码过期锁定了,好烦。
C:\Program Files\ArcGIS\ArcSDE\ora11gexe\etc\sde_esri_sde.log
报错如下:
-------------------------------------------------------
ArcSDE 10.1 for Oracle11g Build 679 Thu Apr 5 11:43:21 2012
-------------------------------------------------------
DB_open_instance()::db_connect (OCI8) error: 28000
init_DB DB_instance_open_as_dba: -51
DBMS error code: 28000
ORA-28000: the account is locked
SQL> select expiry_date,profile,created from dba_users where username=‘SDE‘;
SQL> select * from dba_profiles where resource_name=‘PASSWORD_LIFE_TIME‘;
SQL> alter profile default limit password_life_time unlimited;
SQL> alter user sde identified by sde;
SQL> alter user sde account unlock;又来了,SDE非直连
原文:http://www.cnblogs.com/yhlx125/p/4275985.html