Oracle Learning Note 01

1.1 Understanding Oracle

MySQL is a very simple and easy to learn database, its own download the default version of the installation is forbidden to other users access, but as long as the settings can be accessed through IP, you can achieve multi-user operation of the same database. For example, you made a login page, and deployed to the Tomcat server, others just enter the correct HTTPS address to access the page (LAN), (WAN word tomcat and project is not deployed on the local computer, but deployed on a certain cloud server), The registration data generated by someone else through this page will flow to the database of the computer where the Tomcat server is deployed, and the data obtained when the other person logs on is also obtained by querying the database of the computer that deployed the Tomcat server. This is the core of the database, the most basic role, but also to answer why to engage in this database, the database is a lot of people play, not to someone to play.

MySQL database General enterprise is not used, the ability to deal with large amounts of data is still deficient, such as before I need to import all the provinces and cities in China County village about million bar data, the database is too much.

Oracle is just a bit more functional, and it's basically the role.

Oracle's architecture

1.2 Oracle's official use

Oracle will have the following account names and passwords installed, and if the unified password is selected in the installation, the password is the same.

　　

1.3 em use

　　EM is the basic Web management tool, the simplest way to open is as shown, because you do not know what Oracle's service name is installed, do not know the open address of the EM, if not, because the installation is not configured, go to the Reset command, go to cmd input This will happen after the command line is reset.

Open as shown in the following:

Select the SYS username and SYSTEMDBA permissions to log in. This is a javaweb website that can be viewed for some performance.

Oracle10 are all javaweb, before they are Java graphical interfaces.

1.4 Administration Assistant Use

Open administration Assistant under Configuration and Migration Tools , where you can set a default instance, registry variables, set up database administrators and operators, and manage instances.

Oracle Learning Note 01