PL/SQL FAQ in installation "make sure you have the 32 bits Oracle client installed" and "Database character set(AL32UTF8) and Client character set (GBK) are different"

时间:2022-08-10 17:21:23

requirement :

connecting to remote oracle server . now I know  the connectionURL :connectionUrl :jdbc:oracle:thin:LUXPRODUCTION/LUXPRODUCTION@//10.8.0.50:1521/PLM16D

I don't have to install oracle server in local environment.

I need to install plsql tools

after I install plsql tools

it couldn't work,  at the logon dialog, the database is invalid for inputing, as well as the "Connect as" properties disappeared. of course , the following dialog is normal because I finally  configure it successfully.

PL/SQL FAQ in installation "make sure you have the 32 bits Oracle client installed" and "Database character set(AL32UTF8) and Client character set (GBK) are different"

the reason for that, I didn't know now, but regarding material from internet, it told me I should install Oracle client  for plsql.

yes , I install it.

because my OS is based on 64 bits. so I chose the version of it with x64.

after installation, oracle client finally prompt me to configure tnsnames.ora setting file.

but when I confirm the prompt dialog. it tips me path is invalid.

why?

because I used the normal user previlige when I run the setup program. then I reinstall the setup with administive previlege. it was ok eventually.

tnsnames.ora was set up rightly.

PL/SQL FAQ in installation "make sure you have the 32 bits Oracle client installed" and "Database character set(AL32UTF8) and Client character set (GBK) are different"

PL/SQL FAQ in installation "make sure you have the 32 bits Oracle client installed" and "Database character set(AL32UTF8) and Client character set (GBK) are different"

then I need to set the windows environmental variable

TNS_ADMIN = {installation path}\network\admin

then I open the plsql which I have already installed

Tools -> preferences  ,then to set the Oracle Home  and OCI library path.

PL/SQL FAQ in installation "make sure you have the 32 bits Oracle client installed" and "Database character set(AL32UTF8) and Client character set (GBK) are different"

then restart the plsql.

then, the logon dialog would became as following.

PL/SQL FAQ in installation "make sure you have the 32 bits Oracle client installed" and "Database character set(AL32UTF8) and Client character set (GBK) are different"

we need to input valid username and password. and database.

PL/SQL FAQ in installation "make sure you have the 32 bits Oracle client installed" and "Database character set(AL32UTF8) and Client character set (GBK) are different"

after that . OK.

you might meet a problem, the plsql perhaps notice you "Initialization error could not initialize ....\oci,dll, make sure you have the 32 bits Oracle client installed"

PL/SQL FAQ in installation "make sure you have the 32 bits Oracle client installed" and "Database character set(AL32UTF8) and Client character set (GBK) are different"

I didn't know why it happened. but , I tried to download another oracle client with 32bit version, and installed it replacing the previous one.

the issue was settled.

but then I met another problem.

the PLSql prompt me character set was different.

PL/SQL FAQ in installation "make sure you have the 32 bits Oracle client installed" and "Database character set(AL32UTF8) and Client character set (GBK) are different"

then .I added an environmental variable in windows. the issue was resolved.

NLS_LANG = SIMPLIFIED CHINESE_CHINA.AL32UTF8

I didn't know if other parameter value are applicable for the issue. I didn't try.