POST
|
Also, on a Windows machine, what location should I have moved the st_shapelib.dll to in order for the Create Enterprise Geodatabase tool to find it and work correctly?
... View more
02-19-2014
09:00 AM
|
0
|
0
|
651
|
POST
|
That's not an ArcGIS connection for mapping, it's an admin login associated with a management script. I always manage my database from database tools. - V I don't completely understand. I realize that creating the user and setting privileges can be done using SQL Plus for example through SQL statements, but isn't the point of the Add User tool to do the same? With SQL Server I just login as SA and add the users. And with PostGres I just login as postgres and add the users. I guess Oracle's default security doesn't allow this to work correctly.
... View more
02-19-2014
08:56 AM
|
0
|
0
|
651
|
POST
|
You do NOT need to connect through ArcGIS as SYS. SYS is only used by the Python tool to create geodatabases. If you did not copy the DLL, you need to do so, then follow the instructions for installing the ST_GEOMETRY DLL (search on "CREATE or REPLACE LIBRARY"). - V Then why in ArcCatalog when I right click on my Oracle database connection and go to Administration --> Add user, it tells me I must be logged in as SYS? [ATTACH=CONFIG]31579[/ATTACH]
... View more
02-19-2014
06:18 AM
|
0
|
0
|
651
|
POST
|
I found a way that works, but is this really what I'm suppose to do? Quoted from another forum: If you want to bypass the SYSDBA or SYSOPER checking step then there is a way . 1. Log in to sqlplus as sys i.e use the following command in sql prompt conn / as sysdba 2. Check for parameter named O7_DICTIONARY_ACCESSIBILITY i.e use the following command in sql prompt show parameter O7_DICTIONARY_ACCESSIBILITY It will give you result as shown below NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ O7_DICTIONARY_ACCESSIBILITY boolean FALSE 3. Change this parameter using alter system set O7_dictionary_accessibility=TRUE scope=spfile; 4. It is a static parameter so need to bounce the database . Restart your database . 5. Now connect as SYS without SYSDBA privilege. conn sys/<your SYS password> it will be successful . Note: Setting O7_DICTIONARY_ACCESSIBILITY to TRUE is dangerous This behavior is because sys objects can be accessed only by user who is logged in as sysdba. EVEN SYS cannot access its own objects unless during logon he authenticate himself as sysdba. After we set O7_DICTIONARY_ACCESSIBILITY=True, this check is no more there and even guys with 'select any table' priv can select tables like user$, obj$, seq$ etc.
... View more
02-19-2014
06:03 AM
|
0
|
0
|
651
|
POST
|
Why do you need to create ST_GEOMETRY a second time? (Enterprise geodatabases include ST_GEOMETRY support.) When ArcGIS tells you it needs SYS, it needs SYS, not any SYSDBA user. Certain privileges can only be granted by SYS. - V Well when I created the geodatabase it came back with a warning about the ST_GEOMETRY not being used. I never moved the DLL before I ran the tool. I was suppose to, right? How can I check it the ST_GEOMETRY was created? Also, then why when I try to login as SYS it says that I can't? [ATTACH=CONFIG]31576[/ATTACH]
... View more
02-19-2014
05:37 AM
|
0
|
0
|
651
|
POST
|
I installed Oracle11g and ran the Create Enterprise Geodatabase tool. It succeeded, but I now need to run the Create Spatial Type tool. It says I need to be logged in as sys, but when I try to login as sys it tells me I should be logged in as SYSDBA or SYSOPER. So I created a user and assigned it SYSDBA privileges, but when I got in as this user the tool tells me that I need to be logged in as sys! I can't add users in ArcCatalog either, it gives the same errors. What am I missing here?
... View more
02-19-2014
05:00 AM
|
0
|
8
|
2726
|
POST
|
I guess you have looked here? http://resources.arcgis.com/en/help/main/10.1/index.html#//003n000000t2000000 http://resources.arcgis.com/en/help/main/10.1/index.html#//003n000000wn000000 What version of ArcGIS are you using? Yeah, I've looked at pretty much all the documentation. I'm using 10.2.1 and I've used the compare replica successfully before with updated domains, but not with Subtypes. I guess I'm wondering whether Subtypes are included or not in the compare replica tool. And if not, what's the correct way to add them to both replicas? Just manually through ArcCatalog? The documentation is not very clear.
... View more
01-28-2014
05:21 AM
|
0
|
0
|
199
|
POST
|
I have a two-way replica and added a couple subtypes on a feature class in one of the geodatabases. When I run the compare replica tool, it doesn't notice the subtype change. Is this normal? What's the proper way of keeping the schemas the same? Do I have to add the subtypes manually on each replica?
... View more
01-28-2014
05:08 AM
|
0
|
2
|
760
|
POST
|
I don't know but you can install another web adaptor with new name (you can have multiple web adaptor) and then if it's all ok you can uninstall old web adaptor. Probably the safest way, thanks.
... View more
01-20-2014
05:43 AM
|
0
|
0
|
446
|
POST
|
If I want to rename my web adaptor, is it as easy as going to my wwwroot folder on my server and changing the name of the root web adaptor folder from "xxxx" to "yyyy"? Or is this not a good way to do it? Thanks.
... View more
01-20-2014
03:50 AM
|
0
|
2
|
2899
|
POST
|
I'm about to upgrade from Server 10.1 to 10.2.1 and have a question. I currently have (2) active two-way replicas. I believe the servers hosting the other data are either 10.1 or 10.2. When I upgrade to 10.2.1 will this cause any problems with the two-way replicas? Thanks!
... View more
01-10-2014
11:43 AM
|
0
|
2
|
784
|
POST
|
This could mean there is an issue with the service and the server is not accepting the features. Russ What's the easiest way to share my Collector map with you?
... View more
01-07-2014
11:44 AM
|
0
|
0
|
272
|
POST
|
Are you able to perform the same edits in the web map and see that data sync with your database? Also try refreshing you web page after you make the edit change to see if it is still there in the web map. I am checking out my network test now and will update the thread when I am done. Update: I did a quick test with a sample network and my edits submitted without any issue. Russ When I go to the AGOL web map and try to create one of the features that participate in the geometric network, it just doesn't create the feature when I click. The mouse has the little "Click to add a point" text, but it just doesn't do anything.
... View more
01-07-2014
09:36 AM
|
0
|
0
|
272
|
POST
|
Depending on the version of desktop you are using you should see it when you are publishing the feature service and you are enabling the capabilities for the service. And the Collector does not fully support geometric networks currently. Russ I'm running Desktop 10.2 and Server 10.1 and I didn't see it there. So what happens when you try to edit/create features that participate in a geometric network? Would you get there error I got above? I'm trying to figure out if it's the geometric network or something else.
... View more
01-07-2014
07:43 AM
|
0
|
0
|
272
|
Title | Kudos | Posted |
---|---|---|
1 | 11-12-2012 11:35 AM | |
1 | 11-07-2012 03:32 AM | |
1 | 11-18-2012 05:07 PM | |
1 | 11-07-2012 09:37 AM | |
1 | 11-08-2012 03:25 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|