Character Set causes garbled characters and gi Installation Problems

Today is. At noon today, I received a question from a user in Tianjin about how to install gi, and a character set question asked by a user: sort it out here.

Question 1:

Gi installation problems:

Problem description:

When installing gi, the system prompts:"INS-20802] Automatic storage Management Configuration Assistant Failed"

I have encountered this problem before:

At that time the problem is not the same as this time, I encountered the problem: http://blog.csdn.net/rhys_oracle/article/details/19049413

Cause:

1. The direct cause is that the listener is not started.

2. There are multiple ip addresses in the hosts file, but the host names are all xxx. domainxxx.

Solution:

Modify the hosts configuration and modify the hosts address information in listener. ora. The problem is solved.

Question 2:

The listener is not added to crs.

Problem description:

Crsctl stat res-t does not display the local listener. You cannot add a listener using srvctl add listener.

Cause:

Hosts file configuration error. The Listener has been started

Solution:

1. Modify the hosts file and move the host name before the Domain Name

2. Disable the listener.

3. srvctl add listener

4. crsctl start resource xxxxlistener. lnsr start listening.

Problem solved

Question 3: character set:

I have summarized character sets. For details, see:

Http://blog.csdn.net/rhys_oracle/article/details/17128059

Http://blog.csdn.net/rhys_oracle/article/details/17130425

Http://blog.csdn.net/rhys_oracle/article/details/17130519

Not in the description:

Problem description:

Use select unistr ('\ 4F60 \ 597DHello') from dual; garbled characters are displayed, as shown in:

How can this problem be solved?

Someone may ask, what if "hello" and "hello" Get xxxxxxx?

Then oracle uses the asciistr function to convert any character set string to the character set string of oracle.

Eg:

 

If you are idle, record it immediately.