installation and download of 1.oracle1.1 Oracle Services:Oracle Monitoring Service (Oracleoradb11g_home1tnslistener): When a database needs to be accessed through a program, it must be opened.
Oracle Instance Service (Oracleservice): In an Oracle software platform you can create multiple databases, each of which creates a database service automatically.
1.2 The uninstallation of Oracle:1) The database is unloaded in the case of normal installation:
Stop all Oracle Database services
Start an uninstall program for Oracle
After the uninstallation is complete, it is possible that some residual system files and registry files will appear in the database and cannot be removed during normal operating system, so to restart the computer, press F8 to enter Safe mode.
Clean up all Oracle residue files and run "Regedit.exe" into the registry to manually search for all Oracle-related items and delete them.
2) Install half, over
At this time uninstall the program, has been unable to use, can only be directly to delete the file.
To restart your computer, press F8 to enter Safe mode.
Clean up all Oracle residue files and run "Regedit.exe" into the registry to manually search for all Oracle-related items and delete them.
1.3 Database Four primary user information:Super admin: Sys/change_on_install, you can't use this password in actual work
General administrator: System/manager, this password cannot be used in actual work
Normal User: Scott/tiger, need to unlock, this user is a very classic user
Big Data User: (sample Scenario Database): sh/sh, need to be unlocked.
2. SQLPLUS basic commands 2.1 Displaying formatting actionsThe most important component in a database is the data table (the structure of the table is the collection of rows and columns), then the data of the EMP table is queried below.
Sets the length of data displayed per row: Set Linesize 300;
Set the number of data rows to display per page: set PAGESIZE 30;
2.2 Calling the Notepad commandWhen you write a SQL program, you need to write multiple lines, the command line can not be processed, you need to call the local Notepad program. Enter the name of the "Ed file"
If there is no file, the user is asked to create the file, select Yes. then run the program code. "@ File name" (SQL suffix can not be written). This approach is suitable for operating systems that do not have a display interface.
If you have an interface operating system, you can write directly in a text editor, and then copy directly.
If you now have a file on disk that you want to execute, you must enter the full path, such as the "D:\my.txt" file.
A generic suffix named *.sql is called a database script file.
2.3 Switching usersOracle provides a total of four users, switching between the four users can be done using the following syntax:
CONN username/password [as SYSDBA]
If you are using a SYS account to log in, you must write "as SYSDBA", and after logging in, you can check the current user by "SHOW user".
Example: Logging in with SYS:
CONN Sys/change_on_install as SYSDBA;
Log in with Scott
CONN Scott/tiger;
2.4 Calling native commandsIn Sqlplus, you can call native DOS commands directly, such as the copy command:
Copy source file path destination file path
Example: Copy d:\my.txt d:hello.txt
If you want to invoke this machine: Add a host to the front
Example: calling a native copy command
Host Copy D:\my.txt D:hello.txt
Oracle Learning Summary (i)
