I uninstalled ArcSDE using the esri.exe, and dropped user sde through running the sql statment "drop user sde cascade".
Now I want to reinstall ArcSDE. The installation runs successfully, but when I run post installation configuration to "create SDE repository", it failed.
Here is the error in sde_setup.log:
[Thu Jul 24 22:19:55 2014] SQL Stmt: <drop package SDE.st_geometry_shapelib_pkg>
[Thu Jul 24 22:19:55 2014] ERROR setting up st_geometry type.
[Thu Jul 24 22:19:55 2014] DBMS error code: 4043
ORA-04043: object ST_GEOMETRY_SHAPELIB_PKG does not exist
[Thu Jul 24 22:19:55 2014] ERROR setting up St_Geometry, Error = -1
How can I fix this error?