topic Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i in Data Management Questions

ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability issue

MattSimmons — Tue, 17 Apr 2012 20:24:35 GMT

I have a new oracle 11g instance where I installed ArcSDE 10. I want to install 10.1 and so I had my DBA blow away the 10 table space (it's a dev instance). I installed 10.1 and upon trying to start 10.1 using the sdemon -o start command I'm getting the following.
Could there still be something from ArcSDE 10 somewhere? Any ideas what I should check?

ArcSDE 10.1 for Oracle11g Build 611 Wed Dec 21 12:41:15 2011
-------------------------------------------------------

ST_Geometry Schema Owner: () Type Release: 0

Instance initialized for ((sde)) . . .

Connected to instance . . .

Previous SDE Server Release 0.0.0 is not compatible with the current Release 10.1.0.

Could not start ArcSDE -- Check Network, $SDEHOME disk, DBMS settings and dbinit.sde.

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

VinceAngelo — Wed, 18 Apr 2012 11:38:17 GMT

Is the listener pointing at the old ST_GEOMETRY libraries?

- V

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

MattSimmons — Wed, 18 Apr 2012 13:05:07 GMT

Very well could be... I'll report back...

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

ForrestJones — Wed, 18 Apr 2012 14:43:04 GMT

Hi Matt,

Did you run the "Create Enterprise Geodatabase" tool or the "Enable Enterprise Geodatabase" tool before trying to start the sde service?

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

VinceAngelo — Wed, 18 Apr 2012 14:54:21 GMT

I hope there weren't any outstanding ST_GEOMETRY columns at the time SDE was blown
away -- if so, you might experience some unrecoverable referential integrity issues within
the Oracle instance 😞

- V

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

MattSimmons — Wed, 18 Apr 2012 16:37:47 GMT

I have not run any Create or Enable Enterprise Geodatabase tools prior to starting the service. I was looking for sdesetup -o install to run first, which sets up a gdb for the sde user, but following the ArcSDE 10.1 installation instructions for Linux, right after running /install -load it says to start the service. I have been wondering if there was an in between step missing.

So what comes first at 10.1?
1.) setting up prereq's (environment variables, sde user, etc)
2.) install ArcSDE 10.1
3.) sdemon -o start

or

1.) setting up prereq's (environment variables, sde user, etc)
2.) install ArcSDE 10.1
3.) run create enterprise geodatabase tool
4.) sdemon -o start

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

KimPeter — Mon, 23 Apr 2012 19:07:40 GMT

Hi Matt,

The installation guide also says this:

"Before you install

You must install a database and create a geodatabase in it before you set up an ArcSDE service. Use the Create Enterprise Geodatabase geoprocessing tool, the Enable Enterprise Geodatabase geoprocessing tool, or a Python script to create a geodatabase before installing the application server and setting up a service."

The installation guide is for installing and creating a service only. Geodatabase creation has to happen prior to that. So your steps would be:

1.) Install an ArcGIS client.
2.) Run the Create Enterprise Geodatabase tool (or script).
3.) setting up prereq's (environment variables, OS sde user, etc)
4.) install ArcSDE 10.1
5.) Edit the sde and OS services files.
5.) sdemon -o start

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

MattSimmons — Tue, 24 Apr 2012 18:39:07 GMT

Thanks for your reply Kimberly- my steps and notes:

1.) Install an ArcGIS client.
      Done
2.) Run the Create Enterprise Geodatabase tool in 10.1 ArcCatalog.
      'Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly.'
       I also tried running the sdesetup -o install command via Putty. Strangely, in comparing the usage for sdesetup between my 10.0 ArcSDE and this attempt at 10.1, I see in the 10.1 usage that sdesetup -o install is missing. In other words, sdesetup options for 10.0 include:

-o install

-o upgrade

-o delete

-o list

-o update_key

-o install_st_raster

-o prerequisite_check

And here's the sdesetup options for this 10.1 istance that I'm seeing. Notice that -install (among others) is missing:

-o delete

-o list

-o update_key

-o install_st_raster

3.) setting up prereq's (environment variables, OS sde user, etc)
     Done
4.) install ArcSDE 10.1
     Done using the /install -load command
5.) Edit the sde and OS services files.
     Done
5.) sdemon -o start
     Will occur last

I'm super confused - What am I missing?? I set up my 10.0 SDE instance the same way, first installing ArcSDE then running sdesetup -o install.   Could it be a bad install?

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

KimPeter — Tue, 24 Apr 2012 18:50:39 GMT

You cannot use the sdesetup command to create a geodatabase at 10.1; that's why install is no longer a listed operation.

Sorry - I didn't elaborate on the ArcGIS client step. If the ArcGIS client is on a machine separate from the DBMS, you must install the DBMS client on the machine with the ArcGIS client to connect to the database. That's why you got the "database client software failed to load" message; there likely is not an Oracle client on the machine where you installed Desktop. See the Setting up a geodatabase in Oracle section of this topic, it has an overview of creating a geodatabase in Oracle at 10.1.

http://resourcesbeta.arcgis.com/en/help/main/10.1/index.html#/A_quick_tour_of_setting_up_a_geodatabase_in_Oracle/002n00000001000000/

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

MattSimmons — Thu, 26 Apr 2012 15:21:13 GMT

I think the issue may be in the syntax on the Spatial Database Connection window? My DBA has already set up the tablespace, sde user and permissions, and I've updated the variables; which means I'll be using the "Enable Enterprise Database" tool in Arc.

So the first thing I need to do to connect to the Oracle database. I've installed the Oracle 11g 64-bit full client on the client machine, since it's not the same as the Oracle machine. I can connect to the database using SQLPlus, no problem. But every time I try to establish a database connection through Arc, I get the same message: 'Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly.'

When comparing the connection properties window of a Version 10 connection, it looks like:
Server: samplegisdata
Service: port5151
Database

Username: xxxx
Password: xxxx

But at Version 10.1 the connection properties window has changed and looks like:
Database Platform: Oracle
Instance:

Username: xxxx
Password: xxxx

I'm going through the methodology in the 10.1 Help which says:
"The name of the Oracle server:Oracle port number/Oracle service name or ID
In this example, Oracle is installed on myserver, is listening on port 60000, and myoservice is the Oracle service name.
myserver:60000/myoservice"

In this case, the above statement translates to "samplegisdata:1521/mwtst" but that is not working... What the heck??

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

KimPeter — Thu, 26 Apr 2012 16:01:58 GMT

I think the problem is the Oracle client you installed:

"I've installed the Oracle 11g 64-bit full client on the client machine"

Desktop is a 32-bit client and requires a 32-bit DBMS client.

http://resourcesbeta.arcgis.com/en/help/main/10.1/index.html#/Setting_up_a_connection_to_Oracle/002n00000038000000/

"Some ArcGIS clients, such as ArcGIS for Desktop and ArcGIS Engine, are 32-bit applications. If you are making a database connection from one of these clients, you must use a 32-bit Oracle client to connect to the Oracle database. This is true even if you install the ArcGIS client application on a computer with a 64-bit operating system (OS) and the database and server OS are 64-bit."

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

MattSimmons — Thu, 26 Apr 2012 16:50:19 GMT

Just so I'm clear on the environment:

The Oracle server is 64-bit Linux,
ArcSDE 10.1 on Oracle is also the 64-bit version

On the client machine, the ArcGIS Desktop machine is 64-bit Windows 7, but I need to install the 32-bit Oracle client because Desktop is a 32-bit application? I'll give this a go~

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

KimPeter — Thu, 26 Apr 2012 16:56:32 GMT

Yes, that is correct.

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

MattSimmons — Thu, 26 Apr 2012 20:01:10 GMT

And voila - connection succeeds...:cool:
Next step will be enabling the gdb and starting the service...

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

FranciscoAcosta_Bazán — Fri, 27 Jul 2012 20:32:30 GMT

Hi, Kimberly

I'm in a similar problem
and in this post I can find the solution
in these lines mentioned :

"I've installed the Oracle 11g 64-bit full client on the client machine"

Desktop is a 32-bit client and requires a 32-bit DBMS client.

If Desktop and Server are on the same server even so I have to install client 32 for oracle???

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

KimPeter — Fri, 27 Jul 2012 20:37:10 GMT

If Desktop and Server are on the same server even so I have to install client 32 for oracle???

Yes; otherwise, you will not be able to connect from ArcGIS Desktop.

See this topic for information on having both the 32-bit and 64-bit Oracle client's installed:

http://resources.arcgis.com/en/help/main/10.1/index.html#/Setting_up_a_connection_to_Oracle/002n00000038000000/
If both ArcGIS for Server and ArcGIS for Desktop are installed on the same Windows computer, set the PATH variable to read the 64-bit client before the 32-bit client.

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

Chandan_KumarRath — Tue, 11 Jun 2013 17:42:48 GMT

Yes, that is correct.

I am also getting the same error. I am using SQLServer 2008 Express Edition.
OS: Windows 7 Ultimate x64
Database: SQLServer Express Edition x64

Please provide a solution.

Thanks,
Chandan

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

KimPeter — Tue, 11 Jun 2013 17:51:11 GMT

Chandan,

What version of the SQL Server Native Client do you have installed? You'll need at least the 2008 version to connect.

In the case of SQL Server, though, you run the Native Client installation that matches your OS - you cannot run the 32-bit SQL Server Native Client installation executable on a 64-bit machine.

http://resources.arcgis.com/en/help/main/10.1/#/Setting_up_a_connection_to_SQL_Server/002q00000038000000/

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

Chandan_KumarRath — Wed, 12 Jun 2013 15:51:55 GMT

Chandan,

What version of the SQL Server Native Client do you have installed? You'll need at least the 2008 version to connect.

In the case of SQL Server, though, you run the Native Client installation that matches your OS - you cannot run the 32-bit SQL Server Native Client installation executable on a 64-bit machine.

http://resources.arcgis.com/en/help/main/10.1/#/Setting_up_a_connection_to_SQL_Server/002q00000038000000/

Peter,

Installed native client is 10.0 comes with "Microsoft SQL Server 2008 R2 RTM - Express with Management Tools" (SQLEXPRWT_x64_ENU.exe), downloaded from microsoft.com.

Is there any way-out available to run 32-bit SQL Server Native Client.

Log file:
-------------------------------------------------------
ArcSDE 10.1 for SQL Server Build 679 Thu Apr 5 11:43:21 2012
-------------------------------------------------------

DB_instance_open() against SQL Server using OLEDB driver.
Connected to instance . . .
Previous SDE Server Release 0.0.0 is not compatible with the current Release 10.1.0.

Re: ArcSDE Prerelease 10.1 on a new Oracle instance won't start, says compatability i

KimPeter — Wed, 12 Jun 2013 19:22:05 GMT

I was thinking you had gotten an error about the DBMS client release. Now that I see the error in your last post, though, it looks like you did not create a geodatabase.