1 Reply Latest reply on Feb 25, 2016 2:41 AM by Greg Briggs

    How do you do an Oracle Instant Client connection with ArcFM Geodatabase Manager to a database listening on a non-default port?

    Greg Briggs

      Client:

      ArcFM Geodatabase Manager 10.2.1b

      ArcGIS 10.2.1

      Oracle 12.1.0.2 Instant Client

       

      Server:

      Oracle 12.1.0.2 database

      Solaris 11

       

       

      A customer is attempting to connect to an Oracle 12.1.0.2 geodatabase on Solaris 11 using the ArcFM Geodatabase Manager (10.2.1b) with ArcGIS 10.2.1  using an Oracle 12.1.0.2 Instant Client with EZCONNECT syntax. The Oracle database is listening on port 15011.

       

       

      The customer has found through trial and error that the syntax that will successfully connect to the Oracle database in the Instance field of the Database Connections tab is:

       

           sde:oracle$database_server:port_no/database_service

       

      (The User field is specified as "sde" and the Database field is blank. )

       

       

      The actual syntax the customer is using for the Instance field is:

       

            sde:oracle$db-xnetwdv3:15011/XNETWDV3

       

      where db-xnetwdv3 is the Oracle databaser server and XNETWDV3 is the Oracle service.

       

      image001.png

       

       

      The customer has tried the Oracle database connection EZCONNECT suggestion in the following link without success.

       

      http://resources.arcfmsolution.com/10.2.1b/DesktopConfig/DBConnectionsGDBM.html

       

            sde:oracle12c:db-xnetwdv3:15011/XNETWDV3    (Produces error: "The SDE workspace connection attempt failed with the specified parameters". )

       

            sde:oracle11g:db-xnetwdv3:15011/XNETWDV3    (Produces error: "The SDE workspace connection attempt failed with the specified parameters". )

       

       

      The customer would like to know if there is a better or more conventional way of specifying the Oracle connection syntax?

       

       

       

      In my own environment I can make a successful Oracle 12c instant client connection to an Oracle 12c database listening on the default port 1521 using the following syntax in the Instance field: 

       

          sde:oracle11g:database_server/database_service

       

      (Note that sde:oracle12c:database_server/database_service does not work even though an Oracle 12c client is being used.)

       

       

      If I explicitly specify the port_no (1521) however: 

       

           sde:oracle11g:database_server:1521/database_service

       

      the connection fails with the same error as the customer:

       

      "The SDE workspace connection attempt failed with the specified parameters". 

       

       

      I can also make a successful connection to the Oracle database with the following unconventional syntax: 

       

            sde:oracle11g$database_server:port_no/database_service

       

       

      Thanks in advance for your assistance.

       

      Greg B

        • Re: How do you do an Oracle Instant Client connection with ArcFM Geodatabase Manager to a database listening on a non-default port?
          Greg Briggs

          The syntax in the Instance field of the Database Connections tab to connect to an Oracle database listening on a non-1521 port using EZCONNECT syntax with ArcFM Geodatabase Manager is: 

           

          sde:oracle11g:/;LOCAL=oracle_server_name:port_no/oracle_service_name

           

           

          *********

           

          Matthew St John advised:

           

          I've gotten back some info on the connection string format. We have in our Appendix information on a longer connection string format which is normally not used, but which appears to be necessary for the fully-descriptive format needed to do a direct connection to a non-1521-hosted Oracle service:

           

          sde:oracle11g:/;LOCAL=minerva.miner.com:1522/orca10.minerva

           

           

          This connects to the server Minerva on port 1522, with the EZConnect name "orca10.minerva". Under normal circumstances the "/;LOCAL=" part isn't necessary, but for this port setting it is.