1.Windows Oracle Installation Diagram----ORACLE-WIN-64-11G detailed installation steps-SOUVC-Blog Park
Oracle 11g Download URL
oracle Download official address http://www.oracle.com/technetwork/database/enterprise-edition/downloads/ Index.html win 32-bit operating system: http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gr2_database_ 1of2.ziphttp://download.oracle.com/otn/nt/oracle11g/112010/win32_11gr2_database_2of2.zip win 64-bit operating system: http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gr2_database_1of2.ziphttp:// download.oracle.com/otn/nt/oracle11g/112010/win64_11gr2_database_2of2.zip 360 network disk Download: https://yunpan.cn/ Cydxkeqtrtvei Access Password f871 Note that Oracle is divided into two files, and after downloading, extract two files to the same directory. In the path name, it is best not to appear in Chinese, and do not appear spaces and other irregular characters. Oracle installation 1. Installation prerequisites, as well as preparation (1) Unzip the file, select the two compressed package together, right click on the-> unzip the file. (2) unzip the two into the same path. (3) to the corresponding decompression path above, find the executable installation file "setup.exe" double-click the installation. In the middle there will be a detection process: 2. Detailed installation steps start: (1) Install the first step: Configure security updates. This step can fill in your e-mail address (or you can not fill in, just received some useless mail only). Cancel the "I want to accept security update (W) through my Oracle support" below. Directly ignore fill in the subscription information: can click "Yes" to proceed to the next step. Direct fill in subscription information: I'm here to fail the connection. There is no impact on our installation. (2) security options. Directly select Create and configure a database by default (a DB instance is created automatically when you finish installing the database management software). (3) System class. Select the default desktop class directly. (If the computer is installed, this option is used by a personal notebook or personal computer). (4) Typical installation. Important steps. It is recommended that you only update the Oracle base directory, and that the directory path does not contain Chinese or other special characters. The global database name can be defaulted, and password passwords must be kept in mind. Password input, there is a warning, do not comply with ORACEL recommendations without tube. (because the password rules recommended by Oracel are cumbersome, they must be uppercase and lowercase plus numbers, and must be more than 8 digits.) Trouble, can enter the usual oneself habit of short password can) . default account is: ORCL, fill in the password yourself. tips can be ignored. If the password entered is short and simple, the installation will prompt the following. Just confirm Y to continue with the installation. (5) prerequisite checks. The installer checks to see if the hardware and software system meets the minimum requirements for installing this Oracle version. The immediate next step is OK. (6) Overview. Some of the relevant selection configuration information before installation. You can save the file or do not save the file directly to the point of completion. (7) Install the product. Automatic, no tube. Wait a moment when the database management software files and DBMS files are installed, a database that installs the ORCL name of the previous instance database is automatically created. Instance database creation is complete, the system by default is to lock all the accounts are not available (except SYS and SYSTEM account availability), the proposed point to the right of password management, the common Scott account unlocked and enter the password. Unlock The Scott account, remove the green tick from the front and enter the password. You can also enter a short password that you normally use, and you don't have to add numbers to the 8-bit size that Oracle recommends. can be ignored, and later used to set. Similarly, passwords that do not conform to the rules are prompted. Don't worry about it, continue Y. (8) Successful installation, complete。 Install Oracle interface tools. 1. The associated file. I am here to select all. 2. Create a new connection, fill in the link name, user name, and password. Default interface: Our default connection name is using the ORCL Username: System Password: The host name you just set: default is local (localhost) port number:1521sid:xe Note our need to modify XE for ORCL . You can click Test to test and connect. After the test is successful, you can fill in the Save password. Convenient for later login users. Save the information: execute a statement with the following effect: 2. file not found error when installing Oracle DATABASE 11g
| In the process of installing Oracle Database 11g under a 64-bit Windows 7 system, a prompt appears: "File not found E:\app\Administrator\product\11.2.0\dbhome_1\owb\external\ Oc4j_applications\applications\wfmlrsvcapp.ear ", my analysis is estimated that the file is not all copied to the installation directory for the reason, repeatedly groping a pass finally resolved. The workaround is as follows: Unzip the downloaded two zip files to separate folders. This will get two folders: Win64_11gr2_database_1of2 and WIN64_11GR2_DATABASE_2OF21) will win64_11gr2_database_2of2\database\stage\ Components files to win64_11gr2_database_1of2\stage\components2) run the Setup.exe in the Win64_11gr2_database_1of2 file |
3.Oracle Learning Lesson One (log in to Oracle and create users) "Learning is the spiral of the process, from easy to difficult, from less to more, from point to face, every step, every footprint, every knowledge, every mistake is the learning phase must, learning the biggest shortcut is not anxious, patience. "Here, I will learn from Oracle as a management system similar to OA. First of all, installing Oracle is the first step, there are many people who install Oracle in a learning state, in fact, there are few people who can install Oracle in a production environment, and some people have dealings with Oracle for a lifetime, not necessarily one Oracle database implementation, But also from another perspective, Oracle's installation is actually not simple, it is really a great thing to be able to install Oracle in different environments. Here, no longer verbose installation steps, other articles will be described. For a management system, the user name password is the first step, for example, you need to enter a 163 mailbox, do you want to enter a user name and password? The answer is yes. Oracle gives us the first 2 users: SYS and system This is the default of 2 users with very high administrative rights, where SYS is the highest administrator user, system second, the permissions are not as large as the Sys. Well, now that you know it, you don't have to go down to the specifics of system and sys. Summary: 1 Entering Oracle requires a user name and password
2 Oracle Default has 2 user sys and system
3 SYS and system have very high administrative rights, but SYS is greater than the system's permissions sys user is the highest administrator user, then we use this SYS user to log in to Oracle: In, we use this sentence to log in to the Oracle:sql code
- Sqlplus SYS/DWH as SYSDBA;
Sqlplus:oracle Login Command Sys/dwh:sys is the user name, DWH is the password as SYSDBA: Because SYS is the highest administrator, this sentence needs to be added. Although the Sqlplus interface is not good-looking, we use the SYS user to log in to the Oracle database. ^_^ So, we completed the first knowledge point: Log in to Oracle but don't be happy, it's not over yet. Production environment, we can not use SYS or system users to operate the database, one of the most important reasons: It is too dangerous! Using SYS or the system can easily destroy the Oracle database, or even never recover, so we generally do not need to log on to these 2 users. Then, you have to create a new user. In actual demand, we need to create a user bi, password for bi, (Buddy is engaged in Bi, so this is more familiar). How can I create this user? We just logged in with the SYS user and, well, without exiting, create a bi user directly in the SYS user's connection state. , use this statement to create a bi User: SQL code
- Create user bi identified by BI;
Create user:oracle user keyword BI: username identified by: Specify password keyword BI: password ok, bi users we have created, it seems we can use this user login. Use the BI user login below to try it: Unfortunately, we did not successfully log in with a bi user by following the error description, why? The error message is clear that the BI user does not have the Create session permission. What is the Create session permission? Why do I have create session permission? Who will give the BI user this permission? These problems are not to be discussed now, can do is to solve this error, that is, to give BI users to create session permissions. Re-login with the SYS user and give the BI user create session permission: Use this statement to give the BI user the Create Session permission, then you can log in with the BI user. SQL code
- Grant create session to BI;
Grant: Empowering keyword Create session: Permissions-Create connection to: paired with the GRANT keyword BI: User name bi user can log in to Oracle with CREATE session permission. Through the operation above we understand: 1 You can use the CREATE USER statement yourself created users 2 after creating the user must be given the CREATE session permission to log in Oracle3 under the SYS user can give themselves created user (such as BI) empowering create Session Knowledge Point review: 1 entering Oracle requires a user name and password
2 Oracle Default has 2 user sys and system
3 SYS and system have very high administrative privileges, but SYS is 4 larger than system permissions. You can use the Create USER statement to create users 5 you must give the Create session permission before you can log in Oracle6 Under the SYS user, you can assign the user you created (such as BI) the Create session 3. Enable apex-oracle database column in ORACLE 11g-Red and Black Alliance oracle Information Lifecycle management tool Ilma is used only if Apex.apex is installed by default in Oracle 11g Release 2. However, it is not enabled after installation. You can enable it using the following method. Sql> show Useruser is "SYS" sql> spool apex View installed Apex details. Sql> SELECT * from dba_registry where comp_id = ' APEX '; apexoracle application express3.2.1.00.10 & nbsp; VALID 02-apr-2010 14:20:27server sysapex_ 030200validate_apex flows_files sql>sql> @%oracle_home%\rdbms\admin\epgstat.sql+--------- -----------------------------+| XDB Protocol ports:  &Nbsp; | | XDB is listening for the protocol | | When the protocol port is Non-zero. |+--------------------------------------+ 0 0 1 row selected. +---------------------------+| DAD Virtual-path Mappings |+---------------------------+ /apex/* Apex 1 Row selected. +----------------+| DAD attributes |+----------------+ apex database-username anonymous default-page Apex document-table-name wwv_flow_file_objects$ request-validation-funct Wwv_flow_epg_include _modules.authorize ion document-procedure wwv_flow_file_mgr.process_download nls-language american_ america.al32utf8 document-path docs 7 rows selected. +------------------- --------------------------------+| DAD Authorization: || To use the static authentication of a user in a DAD, | | The DAD must is authorized for the user. |+--------------------- ------------------------------+ no rows selected +----------------------------+| DAD authentication schemes |+----------------------------+ apex anonymous Anonymous 1 Row selected. +--------------------------------------------------------+| ANONYMOUS User status: &nBSP; | | To use the static or anonymous authentication in any DAD, | | The ANONYMOUS account must is unlocked. |+--------------------------------------------------------+ anonymous EXPIRED & locked 1 Row selected. +------------------------------------------------ -------------------+| ANONYMOUS access to XDB repository: | | To allow public access to XDB repository without authentication, | | ANONYMOUS access to the repository must is allowed. |+-------------------------------------------------------------------+ false 1 row Selected. sql> view the port used by HTTP, where 0 means it is not turned on. SQl> Select Dbms_xdb.gethttpport from dual; 0 1 Row selected. sql> set port and view. Sql> begin 2 dbms_xdb.sethttpport (8080); 3 commit; 4 end; 5 / pl/sql procedure successfully completed. sql>sql> select Dbms_xdb.gethttpport From dual; 8080 1 row selected. Enable anonymous accounts. Sql> alter USER ANONYMOUS account UNLOCK; Change Password:sql> @%oracle_home%\apex\apxchpwd.sqlenter A value below for the PASSW Ord for the application Express admin User. enter a password for the admin user &n bsp; [] session altered. ...changing password for ADMIN PL /sql procedure successfully completed. commit Complete. user altered. sql>sql> Modify access rights: SQL > begin 2 dbms_xdb. SetlistenerloCalaccess (FALSE); 3 end; 4 / pl/sql procedure successfully completed. Access apex. via the link below https://localhost:8080/apex/apex_admin from Henrybai column
Install oracle11g and open Apex installation
