Explain how to install and configure Oracle.

Tags: Oracle installation and configuration of original works, can be reproduced, when reprint, please be sure to mark the original source of the article, author information and this statement in the form of hyperlink. Otherwise, legal liability will be held. Http://enetq.blog.51cto.com/479739/316532

1. Oracle introduction. Oracleoracle is the first English word translated from oracle bone inscriptions (Yin Xu). It means "Oracle" in English. Oracle is the world's leading information management software developer and is well known for its complex relational database products. Oracle database products are used by the top 1000 companies in the Fortune ranking. Many large websites also use Oracle Systems. For more details, see: Baidu encyclopedia http://baike.baidu.com/view/15020.htm Ii. Oracle Installation.I demonstrated Oracle.10g. for. windows. prepare the installation package. open install \ setup.exe for installation. here, by the way, Oracle database products of ORACLE versions, starting from ORACLE2.0, without 1.0, until ORACLE7.3.4, are only simple version numbers, but different identifiers appear from ORACLE8. oracle 8 Oracle 8i here I represents the Internet, indicating that this product fully supports Internet applications. oracle 9i Oracle 10g Oracle 11g here g is the abbreviation of Grid, indicating that "Grid Computing" is supported so far, the latest version is ORACLE11g, and ORACLE also has a product called ORACLE11i, the full name is Oracle Applications 11i. Here I is the abbreviation of Intelligence, indicating that e-commerce intelligent software is not a database product, but a complete set of e-commerce suites, and a comprehensive set of business application software. 1. Installation interface. 2. Specify the file installation location. 3. Select the installation type. Here we select Enterprise Edition. 4. Select database configuration, and select create startup database. 5. Specify the Database Name and SID. We have another database example below. 6. Select the database management option. The default option is enough. 7. specify the location of the database file storage. Here we change the location, not in the installation directory. 8. Specify the backup and recovery options. Automatic Backup is enabled. Select the options as needed .. 9. Specify the password of the database account and select the same password. Set the password by yourself .. 10. Summary. 11. Start installation and wait patiently. 12. Please note that you should not click next directly. Open password management .. 13. All Database accounts (except SYS, SYSTEM, DBSNMP, and SYSMAN) are locked and need to be unlocked. If this option is selected, the database is locked.Change normal user: Scott password: tiger super administrator: SYS password: change_on_install normal administrator: SYSTEM password: manager.14. 15. Now the installation process is complete. Click to exit.16. After exiting the installation, the EM (Enterprise Manager) tool will be automatically opened. We seldom use it in learning, so we don't have to worry about it too much .. 17. After the installation, a series of Oracle services will be registered. Open and run (win + R) input services. msc to open the service. The following services will be displayed.Two of these services must enable OracleOraDb10g_home1TNSListener. The Listener service is called by name. the client must enable this service to connect to the database. oracleServiceWANG indicates the primary service of the database. must be enabled; otherwise, Oracle cannot be used. oracleService + database name. I am wang 3. log on to. SQLPLUSSQLPLUS is a command line execution tool provided by Oracle. SQLPLUS has two Commands: 1. sqlplus: Enter the database as a command line. the password input process is not displayed. 2. sqlplusw: log in as a window and start the command line tool. this method will be used in the future. enter the user name and password. The host string is our database name. let's talk about the differences between the two methods. enter select * from emp; note that it ends. run as follows: You can see that it is very messy. here we can set the set linesize 200 to set the length of each line and then execute the query. is it much clearer. but another one is awkward. that is, fields are repeatedly displayed. set pagesize 200 sets the length of records displayed on each page. this shows what looks clear. but sqlplus does not display this. now the installation is complete. happy learning! Good Luck!

This article from the ghost Conan technology blog, please be sure to keep this source http://enetq.blog.51cto.com/479739/316532