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??