Latest Contributions by AsrujitSengupta

I was talking about SQLPLUS in cmd, but anyways, ArcGIS Desktop being a 32-bit application needs a 32-bit Oracle Client. You mentioned that you have both the 64-bit and 32-bit Oracle Client installed....so this should not be an issue. Just try these strings and check if it makes any diff: I.P_Address_of_your_lappy/MyLappy Server_name/MyLappy ... View more

Can you just login from SQLPlus and post a screenshot of that. Don't post your passwords! ... View more

The connection string is incorrect.....you spelt your database name as 'MAYLAPPY' instead of MYLAPPY ! ... View more

Are you able to connect using SQLPLUS? Do you have the Oracle Full or Instant Client installed? What is the bit-level of the Oracle Client installed? What is the Oracle_SID (Database name), which you are trying to connect? Do you have Oracle and ArcGIS installed on the same machine? If No, what is the database server name? ... View more

You did not provide all the details that were requested. What was the DBMS version for the 10.0 gdb? Has that been upgraded to a higher DBMS version? What is it now? ... View more

Please don't post Duplicate Posts....wait for someone to reply back on the original thread Cannot able to upgrade arcgis server 10.0 to 10.3? ... View more

Just remove that Orphaned entry from Process_information table using SQL Server Management Studio...should be quicker... Make sure you have a db backup before doing it. ... View more

Italics indicates your own Connection,....the one you used to connect and open the Geodatabase Administrator window. The other error is a known issue....as you cannot disconnect users from a 9.3.1 SDE geodatabase using the 'Geodatabase Administrator' window... You can try the below: 1. Use SDE Command line tools to disconnect that connection 2. remove that Orphaned Connection from the 'Process Information' table from the SQL Server Management Studio ... View more

Are you upgrading your SDE Oracle geodatabase? What was the Oracle Database version at 10.0 (Example: Oracle 10.2.0.1) and what is the version of the Oracle database you are using right now while upgrading to 10.3? ... View more

How to create an sde view in 10.2.2 The answer is quite the same. Only that SDE Command line tools have been deprecated at 10.3.x, however it can still be used for now with an SDE 10.3.x geodatabase. 44300 - Can ArcSDE command line tools be used against 10.3 and newer geodatabases? ... View more

Congrats to all the Winners! ... View more

Yes, restoring the gdb with the correct options would be the best way to proceed. However, make sure that there are no Orphaned Locks in the 4 Lock Tables or Connections in the Process Information table. For that Feature Dataset, you need to Unregister as Versioned and then re-Register as Versioned to edit the FCs in it. ... View more

What error do you observe while connecting to the database? Did you rename the database while restoring on your Instance? ... View more

To create the service, install ArcSDE 10.2.1 and use Command line to create the Service. ** The version of the sde gdb and the version of SDE should match, or else the Service won't start. You will need a Direct Connection, to do the upgrade. So, you need to upgrade the gdb first and then create the SDE Service using sde 10.2.1 command line tools. ... View more

Any additional information in the log files- sdedc log mainly..? ... View more