An alternative to Create Enterprise Geodatabase

[VinceAngelo]

Ran into a strange situation at a client site today.  I installed an Oracle Instant Client for Desktop to run Create Enterprise Geodatabase (Data Management), and discovered that Oracle 11gR2 wasn't accepting a connection as the SYS user (it gave a login failure similar to an invalid password error).  Actually, it seems that it did accept a connection, and then rejected it (we could actually watch the alert log post a client communication timeout error 120 seconds after the Toolbox tool failed, so it appears the error was generated by the listener without letting the server know it's services wouldn't be needed after all).  I eventually found a work-around -- I created the SDE tablespace and user (as I usually do, anyway) and granted the necessary package permissions as SYS using a local "sqlplus / as SYSDBA", then invoked Enable Enterpise Geodatabase (Data Management) instead (it doesn't require SYSDBA access).

- V

[Myoung-okYoo]

I have faced same problem. I cannot complete the tool- 'Create Enterprise Geodatabase' for creating Multiple geodatabases in Oracle. I cannot not login Oracle 11gR2 using sys account.

Do you have any idea to create use-schema geodatabase?

Thank you.

[VinceAngelo]

I avoid user-schema geodatabases, so I have no solution for you.  Maybe Tech Support can help.

[Myoung-okYoo]

Thank you.

I had resolved my problem.

In my case, the sys password includes '@'. So the connection was not established.

After changed password except '@', the tool works fine.

- Oracle 11.2.0.4

[VinceAngelo]

I've never been able to get an "at" sign in an Oracle password to pass through SQL*Net.  It may be a reasonable way to prevent SQL*Net login as SYS, but you need to know up front what will happen.