Protocol adapter error and ORA-01017: invalid username/password; logon denied, Oracle server and client installation problem resolved

<! --
/* Font Definitions */
@ Font-face
{Font-family:;
Panose-1: 2 1 6 0 3 1 1 1 1 1;
MSO-font-alt: simsun;
MSO-font-charset: 134;
MSO-generic-font-family: auto;
MSO-font-pitch: variable;
MSO-font-Signature: 3 135135232 16 0 262145 0 ;}
@ Font-face
{Font-family: "/@ ";
Panose-1: 2 1 6 0 3 1 1 1 1 1;
MSO-font-charset: 134;
MSO-generic-font-family: auto;
MSO-font-pitch: variable;
MSO-font-Signature: 3 135135232 16 0 262145 0 ;}
/* Style definitions */
P. msonormal, Li. msonormal, Div. msonormal
{MSO-style-parent :"";
Margin: 0 cm;
Margin-bottom:. 0001pt;
Text-align: justify;
Text-justify: Inter-ideograph;
MSO-pagination: none;
Font-size: 10.5pt;
MSO-bidi-font-size: 12.0pt;
Font-family: "Times New Roman ";
MSO-Fareast-font-family:;
MSO-font-kerning: 1.0pt ;}
/* Page Definitions */
@ Page
{MSO-page-border-Surround-header: No;
MSO-page-border-Surround-footer: No ;}
@ Page Section1
{Size: 612.0pt 792.0pt;
Margin: 72.0pt 90.0pt 72.0pt 90.0pt;
MSO-header-margin: 361_pt;
MSO-footer-margin: 36366pt;
MSO-paper-Source: 0 ;}
Div. Section1
{Page: Section1 ;}
-->

Today I suddenly want to pretend
Oracle
The result is not as simple as you think, but the client side, but the server side, no problem. A combination of the two causes a lot of problems. For the whiteboard, you have to solve it step by step.

 

Oracle
Dual-Installation Problems on servers and clients

 

First install the client, then install the server, maybe there will be no problem, but I installed the server first, then installed the client,

 

Use
CMD-sqlplus
When logging on, the first one appears
--- Oracle10
Protocol adapter Error
---

 

The Registry, the configuration file, and the environment variables are all viewed. They are totally useless. Later, when we found the environment variables
Oracle
Path
Bin
It's actually a front-and-back relationship, and the path is changed. It's actually solved. It's speechless .....

 

 

Then
--

ORA-01017: invalid username/password; Logon
Denied-
Solve the problem. What is the solution!

I think again, this
Oracle
It's not that difficult to get started. The prompt is "user name and password". Try again. It turns out that your password is wrong. Alas, it's just a waste of blame.

 

In fact, the main problems are some variables,

When installing the server (if you do not need to create a database with it), you must first create a listener, create a database, and then check whether it is started by the Service, install the client, but note some conflicts between them,

In fact, just think about it. It's nothing more than who is in the front and who is behind. Therefore, the environment variable configuration allows the server to be in the front, the client to be in the back, or the registry information, to view the path of its software, as well as the service
Sid
And so on. That's all.

 

D:/Oracle/product/10.2.0/db_2/bin; D:/Oracle/product/10.2.0/db_1/bin;

Change

D:/Oracle/product/10.2.0/db_1/bin; D:/Oracle/product/10.2.0/db_2/bin; That's OK. It's just my situation.