Install the Oracle database

Background:

Due to the epidemic, I can only take online classes at home. I need to install database when LEARNING Oracle, but!!

An error occurred during installation:

  • Unable to check whether the specified location is on CFS.

There’s basically no solution here, and I’ve been making this mistake all day. The initial installation was 19C. Result (failed to install).

Online thoughts and my test:

  1. Add the local IP address to the host file (X)
  2. Disconnection after installation to which step (X)

The later version of the teacher is 12C. I installed it again and tested it, but it still didn’t work.

This indicates that the environment of the machine is a problem, which may be environmental conflict or incomplete environment.

Solution:

  1. Reinstall the computer, come out of a pollution-free environment installation (but can not guarantee a successful installation after the reinstall environment)
  2. Vm Installation

Here the blogger chose the second option,

The reason is that there are too many environment inside my computer, Java, Python, PHP, C, JS, Vue, JB family bucket, code, various SAO operation plug-ins and so on….. (Let me try 😂)

Think about it.

Installation route:

  1. Windows10 virtual machine, open internal and external network
  2. Install oracle
  3. Changing the Oracle Password
  4. Navicat connects to the Oracle database on the VM

From trial and error to successful installation lasted afternoon + evening, this grinding goblin.

Without further ado, let’s begin!

Windows 10 virtual installation

In fact, this section has a very detailed tutorial on the Internet, where the blogger gives a link to the installation recommendations, and there is almost all of this content on the Internet, where the blogger does not show off.

Recommended VM installation link: Click to enter

There are two main points to note:

  1. Install the VMware tools

If you log in to the VM for the first time, follow the following instructions:

If not, follow the instructions:

Recommended VMware Tools installation link: Click to enter

  1. The snapshot backup

This backup is based on my current needs. If I want a pure system and need to reinstall the VIRTUAL machine, I can back up the virtual machine after the initial installation.

After oracle is installed successfully, the blogger can take a snapshot backup and make the database unusable. You can go back to the time when the database was created.

I don’t know. It’s convenient.

Backup process:

Open up internal and external networks:

Right-click windows10 on my computer and find the Settings:

Locate the network adapter and set the NAT mode of the network connection to bridge mode:

Remember to disable the firewall on the VM:

Testing:

Because the environment was set up when I wrote this blog (bridge mode was set), but when I started the VIRTUAL machine this time, I found no network, here is the solution:

Find your computer (laptop in this case) first:

Then select the corresponding network mode in bridge mode:

Install Oracle:

Ok, the main underlying environment is set up and we are ready to configure Oracle.

As always, you have to learn to learn by yourself.

Recommended link: Click to enter

I agree with the sentence in the author’s article: A Few Years…

True essence 😂;

In the test run section:

1, Click “Start menu”, find “oracle-oradb23home1” directory, find “SQL-developer” in that directory, double-click to run the program

That’s ok,

2, click the upper left corner of the “+” new database link, in the pop-up window to enter the database link information, click the “test” button, display “status: success” means that the database installation is successful

Link name: custom written

User name: SYS (system user)

Password: The password is a custom password, that is, the login password set in Step 5 of Section 2

Link type: Select the “basic” option by default

Role: Select “SYSDBA” database administrator

Host name: default localhost

Port: 1521

Service name: Check the “service name” option and enter “ORCL”,

If the above results are successful, then there is no need to look at the following questions, if not successful, welcome into the pit 😼;

Change the Oracle password:

I have the following situation:

Write user name as sysdba as prompted.

But I remember my password very well and tested it two or three times to make sure, so try to reset it:

Open CMD and use sysdba to change the passwords of other accounts.

sqlplus / as sysdba
Copy the code
alter user username identified by password;
Copy the code

The first time I changed sys, it didn’t work. The second time I changed sysdba, it didn’t work either. Then I checked the account name:

select distinct owner from all_objects;
Copy the code

Results:

This time, the selected account is system, and login can be successful after modification:

Why can I modify the system successfully? I don’t know, but I know that this user is a system user, so it is likely to be successful.

The installation is successful:

Navicat connects to the Oracle database on the VM

Recommended link: Click to enter

Note:

The Net Configuration Assistant tool is available after Oracle is successfully installed, as shown in the figure below.

Connection successful:

The end:

If you see this or happen to help you, please click 👍 or ⭐ thank you;

There are mistakes, welcome to point out in the comments, the author will see the modification.