Oracle installation tutorials and common commands

Although there are many installation tutorials on the Internet, write a record of the installation process and the solution to the problem.

• 1 installation package Download:

Go to Oracle's website: https://www.oracle.com/index.html Select Downloads->database->oracle database:

Choose to accept

Choose Windows 64 Download, select File1, and file2, note that two files are to be downloaded, download requires login, there is a direct login to the Oracle account, not registered a bar, the two files downloaded

Download down is two compressed files, will be selected two together decompression, separate decompression should also be able to extract in the same folder directory.

• 2. After the antidote produces a folder, database, double-click setup.exe.

Originally wanted to write an installation of the tutorial to record, but installed to find that this version of the installation seems to be very brain-free, what technical content is not, all points next to the line, and I bon Voyage installation success, there is no problem, really heart plug, do not solve the problem where the experience, but since the writing, first occupy a position, After the other machine installation encountered problems can continue to add.

I use the win10 installed, here Point next, will report what: "[INS-13001] environment does not meet the minimum requirements" warning, as if the product is win10 after the come out, can not recognize, regardless, ignore continue to install

• 3. Use Sqlplus to try to log in, open Win+r, enter Sqlplus, open Sqlplus,

Enter Conn/as sysdba to log in to the database as a SYSDBA

Use the show user command to query the currently logged on user

Querying all users with select * from All_users

Using Conn/as sysdba to log in to the database, if you want to modify the password of the system user, you can use: Alter user system identified by system; (after the new password);

Use the alter user Scott account unlock; Unlocking a locked user

Login with System User: Conn System/system

Shutdown database service: Shutdown immediate

Start database service: Startup

CMD Start Oracle database service: NET start Oracleserviceorcl,win10 to run with a command prompt (administrator) or you will be prompted for insufficient permissions

CMD Shutdown database service: net stop ORACLESERVICEORCL

Start the Oracle Monitoring service: LSNRCTL start

Turn off Oracle monitoring service: LSNRCTL stop

Oracle installation tutorials and common commands