We're having some problems with setting up ArcSde support under AIX-es. This
is the system:
System Model: IBM,8203-E4A
Processor Type: PowerPC_POWER6
Processor Implementation Mode: POWER 6
Processor Version: PV_6_Compat
Number Of Processors: 1
Processor Clock Speed: 4204 MHz
CPU Type: 64-bit
Kernel Type: 64-bit
LPAR Info: 2 california
Memory Size: 6144 MB
Good Memory Size: 6144 MB
Firmware Version: IBM,EL340_039
OS: some unix distribution
What happes is that ArcSde plugin can't connect to SdeEngine.
Sde version:
ArcSDE 9.2 for Oracle10g Build 1271
This is from SdeEngine log:
[Thu Mar 19 20:11:06 2009] [1936945006] [xxxxx] Cannot Add Proc Info
Record
[Thu Mar 19 20:11:06 2009] [1936945006] [xxxxx] Cannot Attach to Shared
Memory -51
[Thu Mar 19 20:11:06 2009] [0] [GIOMGR] Error (-51):Couldn't Start Server
Task.
This is what GeoServer spits out:
com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeConnection.v(Unknown Source)
at com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:146)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:138)
at org.geotools.arcsde.pool.Session$2.call(Session.java:202)
... 5 more
form connection params { pool.minConnections=2, pool.maxConnections=6,
password="xxxxx", user="xxxxx", instance="xxxxx", server="xxxxx",
pool.timeOut=500, dbtype="arcsde", port=5151}
19 ožu 20:11:05 ERROR [arcsde.pool] - Command execution failed for Session
0 in thread 100
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE
LEVEL ERROR OCCURRED.][Extended desc=
]
at org.geotools.arcsde.pool.Session$2.call(Session.java:205)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:284)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
at java.lang.Thread.run(Thread.java:810)
Caused by:
com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeConnection.v(Unknown Source)
at com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:146)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:138)
at org.geotools.arcsde.pool.Session$2.call(Session.java:202)
... 5 more
19 ožu 20:11:05 WARN [geoserver.action] - Unable to fetch a list of
FeatureType names from datastore.
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE
LEVEL ERROR OCCURRED.][Extended desc=
]
I think you have tried a reboot already and it does not help.
1)
Use ipcs to see your shared memory segments used by the oracle usr/group
2)
Check the access rights with respect to the user of your geoserver process.
3)
Stop oracle, stop geoserver, use ipcs to look for shared segments owned by oracle usr/group. If there are some, remove with ipcrm and reboot.
We had similiar problems with db2.
Another hint, ArcSDE is using an internal table for storing the active user connections. I think this is the way they want to check the max user license limit. Very often it happend to me that this table was full with records and I could not connect. but I was the only one user.
christian
GeoUser writes:
Hey all!
We're having some problems with setting up ArcSde support under AIX-es. This
is the system:
System Model: IBM,8203-E4A
Processor Type: PowerPC_POWER6
Processor Implementation Mode: POWER 6
Processor Version: PV_6_Compat
Number Of Processors: 1
Processor Clock Speed: 4204 MHz
CPU Type: 64-bit
Kernel Type: 64-bit
LPAR Info: 2 california
Memory Size: 6144 MB
Good Memory Size: 6144 MB
Firmware Version: IBM,EL340_039
OS: some unix distribution
What happes is that ArcSde plugin can't connect to SdeEngine.
Sde version:
ArcSDE 9.2 for Oracle10g Build 1271
This is from SdeEngine log:
[Thu Mar 19 20:11:06 2009] [1936945006] [xxxxx] Cannot Add Proc Info
Record
[Thu Mar 19 20:11:06 2009] [1936945006] [xxxxx] Cannot Attach to Shared
Memory -51
[Thu Mar 19 20:11:06 2009] [0] [GIOMGR] Error (-51):Couldn't Start Server
Task.
This is what GeoServer spits out:
com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeConnection.v(Unknown Source)
at com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:146)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:138)
at org.geotools.arcsde.pool.Session$2.call(Session.java:202)
... 5 more
form connection params { pool.minConnections=2, pool.maxConnections=6,
password="xxxxx", user="xxxxx", instance="xxxxx", server="xxxxx",
pool.timeOut=500, dbtype="arcsde", port=5151}
19 o.u 20:11:05 ERROR [arcsde.pool] - Command execution failed for Session
0 in thread 100
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE
LEVEL ERROR OCCURRED.][Extended desc=
]
at org.geotools.arcsde.pool.Session$2.call(Session.java:205)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:284)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
at java.lang.Thread.run(Thread.java:810)
Caused by:
com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeConnection.v(Unknown Source)
at com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:146)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:138)
at org.geotools.arcsde.pool.Session$2.call(Session.java:202)
... 5 more
19 o.u 20:11:05 WARN [geoserver.action] - Unable to fetch a list of
FeatureType names from datastore.
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE
LEVEL ERROR OCCURRED.][Extended desc=
]
Thanks Christian, I would have had no clue at all.
So you're or been using geoserver with ArcSDE + DB2?
That's be cool to hear cause I never had a success story about it (nor a failure one..)
Cheers,
Gabriel
Christian Müller wrote:
I think you have tried a reboot already and it does not help.
1)
Use ipcs to see your shared memory segments used by the oracle usr/group
2)
Check the access rights with respect to the user of your geoserver process.
3)
Stop oracle, stop geoserver, use ipcs to look for shared segments owned by oracle usr/group. If there are some, remove with ipcrm and reboot.
We had similiar problems with db2.
Another hint, ArcSDE is using an internal table for storing the active user connections. I think this is the way they want to check the max user license limit. Very often it happend to me that this table was full with records and I could not connect. but I was the only one user.
christian
GeoUser writes:
Hey all!
We're having some problems with setting up ArcSde support under AIX-es. This
is the system:
System Model: IBM,8203-E4A
Processor Type: PowerPC_POWER6
Processor Implementation Mode: POWER 6
Processor Version: PV_6_Compat
Number Of Processors: 1
Processor Clock Speed: 4204 MHz
CPU Type: 64-bit
Kernel Type: 64-bit
LPAR Info: 2 california
Memory Size: 6144 MB
Good Memory Size: 6144 MB
Firmware Version: IBM,EL340_039
OS: some unix distribution
What happes is that ArcSde plugin can't connect to SdeEngine.
Sde version:
ArcSDE 9.2 for Oracle10g Build 1271
This is from SdeEngine log:
[Thu Mar 19 20:11:06 2009] [1936945006] [xxxxx] Cannot Add Proc Info
Record
[Thu Mar 19 20:11:06 2009] [1936945006] [xxxxx] Cannot Attach to Shared
Memory -51
[Thu Mar 19 20:11:06 2009] [0] [GIOMGR] Error (-51):Couldn't Start Server
Task.
This is what GeoServer spits out:
com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeConnection.v(Unknown Source)
at com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:146)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:138)
at org.geotools.arcsde.pool.Session$2.call(Session.java:202)
... 5 more
form connection params { pool.minConnections=2, pool.maxConnections=6,
password="xxxxx", user="xxxxx", instance="xxxxx", server="xxxxx",
pool.timeOut=500, dbtype="arcsde", port=5151}
19 o.u 20:11:05 ERROR [arcsde.pool] - Command execution failed for Session
0 in thread 100
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE
LEVEL ERROR OCCURRED.][Extended desc=
]
at org.geotools.arcsde.pool.Session$2.call(Session.java:205)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:284)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
at java.lang.Thread.run(Thread.java:810)
Caused by:
com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeConnection.v(Unknown Source)
at com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:146)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:138)
at org.geotools.arcsde.pool.Session$2.call(Session.java:202)
... 5 more
19 o.u 20:11:05 WARN [geoserver.action] - Unable to fetch a list of
FeatureType names from datastore.
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE
LEVEL ERROR OCCURRED.][Extended desc=
]
Thanks a lot! We'll try this and then i'll report back.
mcr wrote:
I think you have tried a reboot already and it does not help.
1)
Use ipcs to see your shared memory segments used by the oracle usr/group
2)
Check the access rights with respect to the user of your geoserver
process.
3)
Stop oracle, stop geoserver, use ipcs to look for shared segments owned by
oracle usr/group. If there are some, remove with ipcrm and reboot.
We had similiar problems with db2.
Another hint, ArcSDE is using an internal table for storing the active
user
connections. I think this is the way they want to check the max user
license
limit. Very often it happend to me that this table was full with records
and
I could not connect. but I was the only one user.
christian
GeoUser writes:
Hey all!
We're having some problems with setting up ArcSde support under AIX-es.
This
is the system:
System Model: IBM,8203-E4A
Processor Type: PowerPC_POWER6
Processor Implementation Mode: POWER 6
Processor Version: PV_6_Compat
Number Of Processors: 1
Processor Clock Speed: 4204 MHz
CPU Type: 64-bit
Kernel Type: 64-bit
LPAR Info: 2 california
Memory Size: 6144 MB
Good Memory Size: 6144 MB
Firmware Version: IBM,EL340_039
OS: some unix distribution
What happes is that ArcSde plugin can't connect to SdeEngine.
Sde version:
ArcSDE 9.2 for Oracle10g Build 1271
This is from SdeEngine log:
[Thu Mar 19 20:11:06 2009] [1936945006] [xxxxx] Cannot Add Proc Info
Record
[Thu Mar 19 20:11:06 2009] [1936945006] [xxxxx] Cannot Attach to Shared
Memory -51
[Thu Mar 19 20:11:06 2009] [0] [GIOMGR] Error (-51):Couldn't Start
Server
Task.
This is what GeoServer spits out:
com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeConnection.v(Unknown Source)
at com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:146)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:138)
at org.geotools.arcsde.pool.Session$2.call(Session.java:202)
... 5 more
form connection params { pool.minConnections=2, pool.maxConnections=6,
password="xxxxx", user="xxxxx", instance="xxxxx", server="xxxxx",
pool.timeOut=500, dbtype="arcsde", port=5151}
19 o.u 20:11:05 ERROR [arcsde.pool] - Command execution failed for
Session
0 in thread 100
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE
LEVEL ERROR OCCURRED.][Extended desc=
]
at org.geotools.arcsde.pool.Session$2.call(Session.java:205)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:284)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
at java.lang.Thread.run(Thread.java:810)
Caused by:
com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeConnection.v(Unknown Source)
at com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:146)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:138)
at org.geotools.arcsde.pool.Session$2.call(Session.java:202)
... 5 more
19 o.u 20:11:05 WARN [geoserver.action] - Unable to fetch a list of
FeatureType names from datastore.
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE
LEVEL ERROR OCCURRED.][Extended desc=
]
Yes, we had ArcIMS , ARCSDE and AIX running on a p5 and p6.
To make it short, after one year of problems I kicked out all these ESRI products and deployed another infrastructure (using Geoserver, which is running on a Linux/ppc LPAR and using DB2/AIX ).
It depends on your requirements. If you are interested in details, ask.
Life is now much easier and I have no vendor lock in.
christian
Gabriel Roldan writes:
Thanks Christian, I would have had no clue at all.
So you're or been using geoserver with ArcSDE + DB2?
That's be cool to hear cause I never had a success story about it (nor a failure one..)
Cheers,
Gabriel
Christian Müller wrote:
I think you have tried a reboot already and it does not help.
1)
Use ipcs to see your shared memory segments used by the oracle usr/group
2)
Check the access rights with respect to the user of your geoserver process.
3)
Stop oracle, stop geoserver, use ipcs to look for shared segments owned by oracle usr/group. If there are some, remove with ipcrm and reboot.
We had similiar problems with db2.
Another hint, ArcSDE is using an internal table for storing the active user connections. I think this is the way they want to check the max user license limit. Very often it happend to me that this table was full with records and I could not connect. but I was the only one user.
christian
GeoUser writes:
Hey all!
We're having some problems with setting up ArcSde support under AIX-es. This
is the system:
System Model: IBM,8203-E4A
Processor Type: PowerPC_POWER6
Processor Implementation Mode: POWER 6
Processor Version: PV_6_Compat
Number Of Processors: 1
Processor Clock Speed: 4204 MHz
CPU Type: 64-bit
Kernel Type: 64-bit
LPAR Info: 2 california
Memory Size: 6144 MB
Good Memory Size: 6144 MB
Firmware Version: IBM,EL340_039
OS: some unix distribution
What happes is that ArcSde plugin can't connect to SdeEngine.
Sde version:
ArcSDE 9.2 for Oracle10g Build 1271
This is from SdeEngine log:
[Thu Mar 19 20:11:06 2009] [1936945006] [xxxxx] Cannot Add Proc Info
Record
[Thu Mar 19 20:11:06 2009] [1936945006] [xxxxx] Cannot Attach to Shared
Memory -51
[Thu Mar 19 20:11:06 2009] [0] [GIOMGR] Error (-51):Couldn't Start Server
Task.
This is what GeoServer spits out:
com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeConnection.v(Unknown Source)
at com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:146)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:138)
at org.geotools.arcsde.pool.Session$2.call(Session.java:202)
... 5 more
form connection params { pool.minConnections=2, pool.maxConnections=6,
password="xxxxx", user="xxxxx", instance="xxxxx", server="xxxxx",
pool.timeOut=500, dbtype="arcsde", port=5151}
19 o.u 20:11:05 ERROR [arcsde.pool] - Command execution failed for Session
0 in thread 100
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE
LEVEL ERROR OCCURRED.][Extended desc=
]
at org.geotools.arcsde.pool.Session$2.call(Session.java:205)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:284)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecut or.java:665)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.j ava:690)
at java.lang.Thread.run(Thread.java:810)
Caused by:
com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeConnection.v(Unknown Source)
at com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:146)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:138)
at org.geotools.arcsde.pool.Session$2.call(Session.java:202)
... 5 more
19 o.u 20:11:05 WARN [geoserver.action] - Unable to fetch a list of
FeatureType names from datastore.
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE
LEVEL ERROR OCCURRED.][Extended desc=
]
Ok, the problem has been solved, here's what was wrong:
Domain (computer) name was too long == 39 characters. And apparently SDE
engine stores this in a table with 32 character limit. After changing the
computer name all started working fine.
mcr wrote:
Yes, we had ArcIMS , ARCSDE and AIX running on a p5 and p6.
To make it short, after one year of problems I kicked out all these ESRI
products and deployed another infrastructure (using Geoserver, which is
running on a Linux/ppc LPAR and using DB2/AIX ).
It depends on your requirements. If you are interested in details, ask.
Life is now much easier and I have no vendor lock in.
christian
Gabriel Roldan writes:
Thanks Christian, I would have had no clue at all.
So you're or been using geoserver with ArcSDE + DB2?
That's be cool to hear cause I never had a success story about it (nor a
failure one..)
Cheers,
Gabriel
Christian Müller wrote:
I think you have tried a reboot already and it does not help.
1)
Use ipcs to see your shared memory segments used by the oracle usr/group
2)
Check the access rights with respect to the user of your geoserver
process.
3)
Stop oracle, stop geoserver, use ipcs to look for shared segments owned
by oracle usr/group. If there are some, remove with ipcrm and reboot.
We had similiar problems with db2.
Another hint, ArcSDE is using an internal table for storing the active
user connections. I think this is the way they want to check the max
user
license limit. Very often it happend to me that this table was full with
records and I could not connect. but I was the only one user.
christian
GeoUser writes:
Hey all!
We're having some problems with setting up ArcSde support under AIX-es.
This
is the system:
System Model: IBM,8203-E4A
Processor Type: PowerPC_POWER6
Processor Implementation Mode: POWER 6
Processor Version: PV_6_Compat
Number Of Processors: 1
Processor Clock Speed: 4204 MHz
CPU Type: 64-bit
Kernel Type: 64-bit
LPAR Info: 2 california
Memory Size: 6144 MB
Good Memory Size: 6144 MB
Firmware Version: IBM,EL340_039
OS: some unix distribution
What happes is that ArcSde plugin can't connect to SdeEngine.
Sde version:
ArcSDE 9.2 for Oracle10g Build 1271
This is from SdeEngine log:
[Thu Mar 19 20:11:06 2009] [1936945006] [xxxxx] Cannot Add Proc Info
Record
[Thu Mar 19 20:11:06 2009] [1936945006] [xxxxx] Cannot Attach to
Shared
Memory -51
[Thu Mar 19 20:11:06 2009] [0] [GIOMGR] Error (-51):Couldn't Start
Server
Task.
This is what GeoServer spits out:
com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeConnection.v(Unknown Source)
at com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:146)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:138)
at org.geotools.arcsde.pool.Session$2.call(Session.java:202)
... 5 more
form connection params { pool.minConnections=2,
pool.maxConnections=6,
password="xxxxx", user="xxxxx", instance="xxxxx", server="xxxxx",
pool.timeOut=500, dbtype="arcsde", port=5151}
19 o.u 20:11:05 ERROR [arcsde.pool] - Command execution failed for
Session
0 in thread 100
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error
desc=DATABASE
LEVEL ERROR OCCURRED.][Extended desc=
]
at org.geotools.arcsde.pool.Session$2.call(Session.java:205)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:284)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecut
or.java:665)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.j
ava:690)
at java.lang.Thread.run(Thread.java:810)
Caused by:
com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeConnection.v(Unknown Source)
at com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:146)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:138)
at org.geotools.arcsde.pool.Session$2.call(Session.java:202)
... 5 more
19 o.u 20:11:05 WARN [geoserver.action] - Unable to fetch a list of
FeatureType names from datastore.
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error
desc=DATABASE
LEVEL ERROR OCCURRED.][Extended desc=
]
Ok, the problem has been solved, here's what was wrong:
Domain (computer) name was too long == 39 characters. And apparently SDE
engine stores this in a table with 32 character limit. After changing the
computer name all started working fine.
mcr wrote:
Yes, we had ArcIMS , ARCSDE and AIX running on a p5 and p6.
To make it short, after one year of problems I kicked out all these ESRI products and deployed another infrastructure (using Geoserver, which is running on a Linux/ppc LPAR and using DB2/AIX ).
It depends on your requirements. If you are interested in details, ask.
Life is now much easier and I have no vendor lock in.
christian
Gabriel Roldan writes:
Thanks Christian, I would have had no clue at all.
So you're or been using geoserver with ArcSDE + DB2?
That's be cool to hear cause I never had a success story about it (nor a failure one..)
Cheers,
Gabriel
Christian Müller wrote:
I think you have tried a reboot already and it does not help.
1)
Use ipcs to see your shared memory segments used by the oracle usr/group
2)
Check the access rights with respect to the user of your geoserver process.
3)
Stop oracle, stop geoserver, use ipcs to look for shared segments owned by oracle usr/group. If there are some, remove with ipcrm and reboot.
We had similiar problems with db2.
Another hint, ArcSDE is using an internal table for storing the active user connections. I think this is the way they want to check the max
user license limit. Very often it happend to me that this table was full with records and I could not connect. but I was the only one user.
christian
GeoUser writes:
Hey all!
We're having some problems with setting up ArcSde support under AIX-es. This
is the system:
System Model: IBM,8203-E4A
Processor Type: PowerPC_POWER6
Processor Implementation Mode: POWER 6
Processor Version: PV_6_Compat
Number Of Processors: 1
Processor Clock Speed: 4204 MHz
CPU Type: 64-bit
Kernel Type: 64-bit
LPAR Info: 2 california
Memory Size: 6144 MB
Good Memory Size: 6144 MB
Firmware Version: IBM,EL340_039
OS: some unix distribution
What happes is that ArcSde plugin can't connect to SdeEngine.
Sde version:
ArcSDE 9.2 for Oracle10g Build 1271
This is from SdeEngine log:
[Thu Mar 19 20:11:06 2009] [1936945006] [xxxxx] Cannot Add Proc Info
Record
[Thu Mar 19 20:11:06 2009] [1936945006] [xxxxx] Cannot Attach to
Shared
Memory -51
[Thu Mar 19 20:11:06 2009] [0] [GIOMGR] Error (-51):Couldn't Start Server
Task.
This is what GeoServer spits out:
com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeConnection.v(Unknown Source)
at com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:146)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:138)
at org.geotools.arcsde.pool.Session$2.call(Session.java:202)
... 5 more
form connection params { pool.minConnections=2,
pool.maxConnections=6,
password="xxxxx", user="xxxxx", instance="xxxxx", server="xxxxx",
pool.timeOut=500, dbtype="arcsde", port=5151}
19 o.u 20:11:05 ERROR [arcsde.pool] - Command execution failed for Session
0 in thread 100
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE
LEVEL ERROR OCCURRED.][Extended desc=
]
at org.geotools.arcsde.pool.Session$2.call(Session.java:205)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:284)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecut or.java:665)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.j ava:690)
at java.lang.Thread.run(Thread.java:810)
Caused by:
com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeConnection.v(Unknown Source)
at com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:146)
at org.geotools.arcsde.pool.Session$1.execute(Session.java:138)
at org.geotools.arcsde.pool.Session$2.call(Session.java:202)
... 5 more
19 o.u 20:11:05 WARN [geoserver.action] - Unable to fetch a list of
FeatureType names from datastore.
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE
LEVEL ERROR OCCURRED.][Extended desc=
]