You also need to make sure the following is included in the 'path' of the Environment Variables:Ĭ:\app\Oracle\product\12.2.0\client_1 C:\app\Oracle\product\12.2.0\client_1\bin (or wherever your path is loacted) Install all C:\app\Oracle\product\12.2.0\client_1 odac (the path is where you installed the above client to) To install the above you must open a Administator Command Prompt and change to the path that you extracted the files to. Note: in my case I change the default path of the install to C:\app\Oracle\product\12.2.0\client_1 but it doesn't matter where you put it.Īfter installing the client I had to install the following: (IT WILL NOT WORK WITHOUT THIS!) In my case I installed the following Oracle Client on my respective installs: It's the same install on each except you must use the matching bit version of the Oracle products that matches the PowerBI Desktop bit version. SunOS tafraud 5.For my experience, I installed on a 32-bit system and one on a 64-bit system. SQL> select dbms_utility.port_string from dual
Note that I got "Solaris" in a Sun Solaris:ġ select rtrim(substr(replace(banner,'TNS for ',''),1,instr(replace(banner,'TNS for ',''),':')-1)) os I think that the result of this query can be used joined with the result of PORT_STRING function to get a more detailed output. SQL> select os, count(*) from dbmon.hosts I use this query to fill a central table with information about all our databases. On the other hand, the PORT_STRING does tell you what operating system you are on. Using the port string, not only would you have to parse the string, but you cannot tell if you are in version 8.1.5 versus 8.1.6 versus 8.1.7. It is a very simple interface as declareĥ dbms_utility.db_version( l_version, l_compatibility ) ħ dbms_output.put_line( l_compatibility ) Īnd provides more version detail then the older function select dbms_utility.port_string from dual We could have used this in our CRYPT_PKG (see the DBMS_OBFUSCATION_TOOLKIT section) for example to tell users that attempted to use the DES3 routines in an Oracle 8.1.5 database that it would not work (instead of just trying to execute the DES3 routines and failing). The DB_VERSION routine was added in Oracle 8.0 in order to make it easier for applications to figure out what version of the database they were running in. Here is a small cut and paste from my book that describes how to do this:
0 kommentar(er)
