See whether Oracle is 32-bit or 64-bit
sql select * from V$version; BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.1.0.2.0-prod pl/sql release 10.1.0.2.0-production CORE 10.1.0.2.0 Production TNS for 32-bit Windows:versio
N 10.1.0.2.0-production nlsrtl version 10.1.0.2.0-production but only TNS information is not easy to convince users.
2. View x$ table SQL Show user user is "SYS" SQL desc x$ksmmemname Type----------------------------------------------ADDR RAW (4)
INDX number inst_id number Ksmmmval raw (4) Raw (4) indicates that 4 byte and 4*8=32bit RAW (8) represent 8 byte and 8*8=64bit Use this method is also very obscure.
3. View the environment of Oracle's system through V$database: SQL Select platform_name from V$database; Platform_name
Modify the Tnsnames.ora file, note that here is a help---about supporting information----inside the information panel of the TNS file path under the document, generally
TNS also has a TNS file under the name, but that modification does not work, and note that the following TNS in the instantclient_11_2 folder in Figure 2 below is to be modified,
And then reboot the Plsql and it's OK.