topic Re: ArcSDE10.1/Oracle 11gR2 guide in Data Management Questions

ArcSDE10.1/Oracle 11gR2 guide

AnisimDesya — Mon, 04 Feb 2013 18:28:01 GMT

Hi all,

I am Anisim and i need to know the steps for Oracle 11g R2 installation (needed for Enterprise Geodatabase).

Thank for all,
Anisim

Re: ArcSDE10.1/Oracle 11gR2 guide

VinceAngelo — Mon, 04 Feb 2013 19:34:02 GMT

Oracle installation and configuration is a *huge* topic unto itself. Esri documentation
only covers the ArcGIS-specific bits of Oracle configuration. It's not appropriate (or
neccessary) for Esri to dictate how Oracle (or any other enterprise RDBMS) should be
administered; the closest you'll find is the Educational Services classes, but even they
start with RDBMS installed on the machine. The RDBMS vendor is going to be the best
instructor for best practices in their enironment.

- V

Re: ArcSDE10.1/Oracle 11gR2 guide

AnisimDesya — Tue, 05 Feb 2013 05:15:23 GMT

Oracle installation and configuration is a *huge* topic unto itself. Esri documentation
only covers the ArcGIS-specific bits of Oracle configuration. It's not appropriate (or
neccessary) for Esri to dictate how Oracle (or any other enterprise RDBMS) should be
administered; the closest you'll find is the Educational Services classes, but even they
start with RDBMS installed on the machine. The RDBMS vendor is going to be the best
instructor for best practices in their enironment.

- V

Thank you very much!
Please, i need a short documentation with minimum Oracle requirements for ArcSDE. I do not need a complete documentation for Oracle administration.
Please help me!

Thank you very much!
Anisim

Re: ArcSDE10.1/Oracle 11gR2 guide

VinceAngelo — Tue, 05 Feb 2013 11:35:03 GMT

EVERY Oracle install contains the minimum requirements for ArcGIS (or can be
easily updated to contain the missing packages). You really need to understand
the underlying database to get your best value out of ArcSDE. Unfortunately,
there is no short-cut to learning Oracle -- you just need to do it (or choose a
different RDBMS with a less steep learning curve [they're all pretty steep]).

As a 24+ year Oracle DBA I am among the least likely on the planet to be
giving advice on simple install techniques (I tweak *everything*, and I tweak
differently at every site, and I doubt I could explain why I did what I did what
I did in under a week). There are nearly 5 million hits for a search on "oracle
install tutorial", but the first page looks like there's pretty good stuff to be
had right there.

- V

Re: ArcSDE10.1/Oracle 11gR2 guide

AnisimDesya — Wed, 06 Feb 2013 08:08:43 GMT

EVERY Oracle install contains the minimum requirements for ArcGIS (or can be
easily updated to contain the missing packages). You really need to understand
the underlying database to get your best value out of ArcSDE. Unfortunately,
there is no short-cut to learning Oracle -- you just need to do it (or choose a
different RDBMS with a less steep learning curve [they're all pretty steep]).

As a 24+ year Oracle DBA I am among the least likely on the planet to be
giving advice on simple install techniques (I tweak *everything*, and I tweak
differently at every site, and I doubt I could explain why I did what I did what
I did in under a week). There are nearly 5 million hits for a search on "oracle
install tutorial", but the first page looks like there's pretty good stuff to be
had right there.

- V

Thank you very much!

I used a custom installation, and I was able to escape the tables.

I think <Sample schema> option add all the tables into repository.

Thank you very much

Re: ArcSDE10.1/ST_GEOMETRY

AnisimDesya — Wed, 06 Feb 2013 09:56:38 GMT

Hi for All,

I have a following configuration:
1. Windows 2008 Server
2. ArcGIS Desktop Standard + Oracle client x32
3. ArcSDE + Oracle 11gR2
4. I copied st_shapelib.dll into "C:\app\curs\product\11.2.0\dbhome_2\BIN\"

Into tnsname.ora I put st_geometry library:
(ENVS = "EXTPROC_DLLS=C:\app\curs\product\11.2.0\dbhome_2\BIN\st_shapelib.dll")

When I try to create a enterprise geodatabase using <Create Enterprise Geodatabase> I get the following message:

The ST_Geometry shape library path may be invalid, or the EXTPROC is not configured correctly in the Oracle instance. [ (Unable to determine current version of ST_SHAPELIB. The latest ST_GEOMETRY and dependent libraries need to be copied to the correct software location. Refer to the ArcGIS help topics for more details.
)]

What is a wrong?

Thank a lot!
Anisim

Re: ArcSDE10.1/Oracle 11gR2 guide

VinceAngelo — Wed, 06 Feb 2013 11:31:24 GMT

You just need to follow the ST_GEOMETRY install instructions. The library is
installed with the path present in Desktop, so you must alter the library to point
to the location you specified to the listener.

In the future, please start a new thread for a new question.

- V

Re: ArcSDE10.1/Oracle 11gR2 guide

AnisimDesya — Wed, 06 Feb 2013 11:39:25 GMT

You just need to follow the ST_GEOMETRY install instructions. The library is
installed with the path present in Desktop, so you must alter the library to point
to the location you specified to the listener.

In the future, please start a new thread for a new question.

- V

Thank a lot!!!

I am sorry, but i started a new thread immediately after it!

I am sorry!

Re: ArcSDE10.1/Oracle 11gR2 guide

JamalNUMAN — Sat, 19 Oct 2013 11:28:54 GMT

Hi all,

I am Anisim and i need to know the steps for Oracle 11g R2 installation (needed for Enterprise Geodatabase).

Thank for all,
Anisim

Hi Anisim,

Access the link below if you still interested to know how to install Oracle database server\client

http://forums.arcgis.com/threads/73663-Connection-to-Oracle-database-failed?p=337964#post337964

Best

Jamal