span8
span4
span8
span4
Requirements:
Access to an Oracle Database (11g was tested).
Access to a DBA (create users,check OS Authenticate prefix,check SQLNet.ora file)
FME Desktop to test the results (FME 2013 tested).
Determine if your database is configured for OS Authentication.To do this check the SQLNET.ORA file found in the Network folder under the Oracle Home (on the database system not on the client).It must contain an entry such as the following:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
Next log into the Oracle database via SQLPlus and check the the OS_AUTHENTICATION_PREFIX.
By default this will have a value of OPS$.SQL> show parameter os_authent_prefix
NAME TYPE VALUE
-------------------------- -------- ----------------
os_authent_prefix string OPS$
Next you can create the new OS User using the prefix above.
SQL> create user "OPS$亚搏在线SAFE\MYDOMAINUSER" identified externally;
User created.
SQL> grant connect to "OPS$亚搏在线SAFE\MYDOMAINUSER";
Grant succeeded.
SQL> grant RESOURCE to "OPS$亚搏在线SAFE\MYDOMAINUSER";
Grant succeeded.
SQL> grant select on SUPPORT.CITIES to "OPS$亚搏在线SAFE\MYDOMAINUSER";
Grant succeeded.
Once this user is created you can connect to the Oracle database using OS Authentication.
In SQLPlus this would be done like the following:
SQL>conn /
or
SQL>conn /@
In FME we don't make use of the forward slash as SQLPlus does...So we would just enter the TNSNAME Service and leave the username and password fields blank: See next screen grab.
Performing spatial queries on database tables using the FeatureReader
Let the Database Do the Work: Reading
Working with Alternatives or Versions in Smallworld
Oracle Spatial Object Functionality
Writing to an Oracle table with Foreign Keys
Error truncating geodatabase table (Oracle errors ORA-29859 ORA-06512)
ORA-20092: Maximum number of grids per feature exceeded
© 2019 亚搏在线Safe Software Inc |法律