Problems and Solutions encountered during Oracle Installation

Today, I want to install the personal version of Oracle, But I have encountered many problems. Problem 1: The network configuration check fails because the company has not set a domain for the employee's computer. For example, James. The user name on his computer is zhangsan and the domain name is node. When the administrator logs on, the domain option is (zhangsan. Actually, no

Today, I want to install the personal version of Oracle, But I have encountered many problems. Problem 1: The network configuration check fails because the company has not set a domain for the employee's computer. For example, James. The user name on his computer is zhangsan and the domain name is node. When the administrator logs on, the domain option is (zhangsan. Actually, no

Today, I want to install the personal version of Oracle, But I have encountered many problems.

Problem 1: The network configuration fails to pass the domain check.

The company sets a domain for the employee's computer. For example, James. The user name on his computer is zhangsan and the domain name is node. When the administrator logs on, the domain option is (zhangsan. In fact, there are two options for node and zhangsan. The problem arises:

I log on to zhangsan. When installing Oracle, an oracle net error is returned when you create a database instance. Installation fails. In desperation, log on to the administrator to install Oracle. All the way. After the installation is complete, switch to zhangsan to log on to Oracle, which is very interesting:

1 When pl/SQL developer is connected, an Oracle net management error is returned when a table is queried.

2 sqlplus login. The first connection is okay. For example, sqlplus/as sysdba or sqlplus test1, but when switching users within sqlpllus, conn/as sysdba or conn test1 reports an error. Depressing

Solution:

This is obviously about the domain. But how can this problem be solved? We have steps to check the various prerequisites when installing Oracle. This step is always"Check network configuration -- not executed". The problem lies here. I installed Oracle again under the zhangsan user and tried to make this check pass to solve this problem. The principle is not clear yet, but the problem is finally solved. Let's share it with you first.

Before installation:

1. Open the control panel and enter add hardware.

2. Next Step

3. Select Yes. I have connected the hardware.

4. Select the last item: Add a new hardware device.

5. Select: Install the hardware (advanced) (M) That I manually select from the list. Next step:

6. Select the first option: Display All devices. Next Step

7. select on the left: Microsoft Loopback Adapter next

8. Next step of Installation

9 Completed

10. Check that there is an extra 'network connection 2' for your network connection '. Disable your current network connection, start network connection 2, and set the IP address to 192.168.1.1.

11. Install Oracle. No error is reported when you create a database. Disable network connection 2 and enable your original network connection. Set listening, etc. OK!

Note: first install the Oracle software, then stop local connection 2, open the local connection, and use DBCA to create a database.

Question 2: Change scott's password

Alter user scott identified by scott; // change scott's user password to scott, and scott's default password to tiger.

Problem 3: account locking

Enter cmd and enter the following command line in Start> Run.

Sqlplus/nolog press ENTER

SQL> conn/as sysdba press ENTER

SQL> alter user scott account unlock; press ENTER // unlock scott user

SQL> alter user scott account lock; press ENTER // to lock scott user