Shulou(Shulou.com)06/01 Report--

1. Solve the problem of flashback

Download the files instantclient-basic-windows.x64-12.2.0.1.0 and instantclient-sqlplus-windows.x64-12.2.0.1.0, extract them, and copy the contents of the two folders together.

Then relocate the file path.

2. Solve the problem of garbled code

Press F6 to start the SQLPLUS command line interface, the problem of garbled code may occur.

Query database character set

Select * from v$nls_parameters where parameter='NLS_CHARACTERSET'

Found that the character set is AL32UTF8

The corresponding character set variables need to be added to the operating system environment variables to make the character set the same as the server side.

NLS_LANG = AMERICAN_AMERICA.AL32UTF8

Press F6 to start the SQLPLUS command line, there is no garbled code in the login database.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.