Oracle 11GR2 Win64 Installation Configuration Tutorial additional basic operations _oracle

Recently arrived at the company to work, a general understanding of the company's process, found that the database is very badly needed to make up, the former school in some databases are SQL Server, as well as some increase, delete, change, check the basic operation,

These are all good and long ago, later, most of the time used to study the compilation, to go backwards, in order to develop their own development must be the foundation, of course, the database is necessary, Oracle for me really feel very strange before basically did not contact, after the recent days of tossing, Probably understand the Oracle database installation, simple configuration, after all, still small white, after the need to continue the evil, the following is the recent own some new and harvested.

1. The first is Oracle installation

For a software installation, in my impression, it seems that most of the software is very easy to install, the general installation software will configure their own operating environment, create and open their own needs of some services, and in the registry to create some need to use the items, and so on, But I didn't do that well when I installed Oracle, and I remember using the company's computer at the beginning of the installation (Win7 flagship 64, the configuration was OK, the machine assembled.) First, the version I installed was win64_11gr2_database (at that time, the 10 version was very small and useless) 11g This version of the following figure shows:

Believe that the installation of the interface is very familiar with, directly click Next:

The above interface we can choose according to their actual situation, if it is the initial installation, then choose the first one can be,

Click Next:

There are two options on this one, is a desktop class, a server class, in fact, I do not use your words can choose the desktop class, the use of the future has no impact (personal feeling), if the first Ze server class, configuration will be more detailed, this can be based on their own actual situation to choose, This time we will first select the Desktop class, click Next:

These are some of the locations of the databases that are about to be created, character type, what type of database, here I choose is the Enterprise version, here can be the default on it, you need to pay attention to the management of passwords, this password so that after the database login password, that is, the password, this must be remembered, Use this password to log in to the user name has system SYS and so on these user's password is this oneself sets the password, this password format may enter arbitrarily, although he may prompt does not conform to the rule, but may ignore, this to our oneself is not the special professional personnel to have no influence. Click Next:

The above interface appears, we just need to wait for a while, if normal will appear this interface:

Meet this interface, we wait on the quiet, this will take a long time, here is the most prone to errors, when I installed in here a lot of errors, first of all, a service is not responding or started, here need to explain, Oracle normal operation, The services you need to start are these:

Oracle ORCL VSS Writer service,oracledbconsoleorcl,oraclejobschedulerorcl,oraclemtsrecoveryservice,oracleoradb11g_ Home1clragent,oracleoradb11g_home1tnslistener,oracleserviceorcl. of which ORACLEDBCONSOLEORCL,

The ORACLEMTSRECOVERYSERVICE,ORACLEORADB11G_HOME1TNSLISTENER,ORACLESERVICEORCL is automatically started by default, ORACLEJOBSCHEDULERORCL is automatically disabled by default, and the rest defaults to

The meanings of these seven services are:

Oracle ORCL VSS Writer Service: Oracle Volume Mapping copy write service, VSS (Volume Shadow Copy service) enables the storage infrastructure (such as disks, arrays, etc.) to create a high-fidelity point-in-time image, the mapped copy (Shadow copy). It can create a mapped copy on multiple volumes or on a single volume without affecting the system's ability to do so. (must not be started)

ORACLEDBCONSOLEORCL: Oracle Database Console service, ORCL is an instance identity of Oracle, and the default instance is ORCL. You need to start this service when you are running Enterprise Manager (Enterprise Manager OEM). (must not be started)

ORACLEJOBSCHEDULERORCL: Oracle Job Scheduler (timer) service, ORCL is an Oracle instance identity. (must not be started)

oraclemtsrecoveryservice: server-side control. This service allows the database to act as a resource manager for a Microsoft Transaction Server MTS, com/com+ objects, and transactions under a distributed environment. (must not be started)

oracleoradb11g_home1clragent: Part of the Oracle database. NET Extension Service. (must not be started)

Oracleoradb11g_home1tnslistener: The Listener service, which is only needed when the database requires remote access. (Does not have to start, below will have detailed explanation).

ORACLESERVICEORCL: database Service (database instance), is the Oracle Core service, which is the foundation of database startup, and the Oracle database can start properly only if the service is started. (Must Start)

So what services do you need to start when you're developing?

For starters, if you only use Oracle's own sql*plus, just start ORACLESERVICEORCL, if you use a third-party tool such as Pl/sql Developer, Oracleoradb11g_ Home1tnslistener service should also be opened. ORACLEDBCONSOLEORCL is going into web-based em must be turned on and the rest of the service is rarely used.

Manual operation.

I'm having problems with 1

When I install this Oracleoradb11g_home1tnslistener service sometimes can not start, this service depends on the E:\app\admin\product\11.2.0\dbhome_2\BIN\TNSLSNR An executable file under this path

Sometimes this file is missing, causing the service to not function properly.

The problem I encountered 2:

ORACLESERVICEORCL This service does not start properly because the oracle.exe that the service relies on does not start properly.

We can click on this service, see the property bureau can see this service to some dependent files, then my computer environment error, resulting in this executable file can not run properly, and finally reinstall the system, resolved, and sometimes because the uninstall previously installed Oracle is not completely caused, These points need to be installed when the error of the time to consider, I was also because of these problems for several days.

If the above is all well installed, then your Oracle database Basic environment has been equipped, the following is the need to create new users, set the appropriate permissions, import the corresponding database backup (. dmp file), create table space and so on some operations. In order to adapt to their own needs I have some of the actual operation of my own some of the most recent operations:

If the installation is successful, then you can open the database command interface to enter the appropriate database commands (some people may ask where to enter the database command?) In fact, in order to facilitate the direct win+r input cmd, enter the black box is the Windows command line interface, input sqlplus will prompt you to belong to the user name before creating a new user can enter system this case-insensitive, and then enter the password is installed when the password is set , and then you go to the command line interface of the database,

）

You can enter the corresponding database command below.

Some of the following are some of the basic things I do when I use them:

first create a tablespace (that is, open space for storing things)

--Create the data table space of the collection process library

Copy Code code as follows:

CREATE tablespace hiip_def LOGGING datafile ' E:\app\admin\oradata\orcl\HIIP_DEF.dbf ' SIZE 64M autoextend on NEXT 64M maxsi ZE Unlimited EXTENT MANAGEMENT local autoallocate;

--Create a collection process library temp table space

Copy Code code as follows:

CREATE temporary tablespace hiip_temp tempfile ' E:\app\admin\oradata\orcl\HIIP_TEMP.dbf ' SIZE 64M autoextend on NEXT 64M MAXSIZE Unlimited EXTENT MANAGEMENT local;

--Create a collection process library user (create a new logged-on user, just like system, but also grant some permissions to the user who created it)

Create user Hiip identified by HIIP
 default tablespace hiip_def temporary tablespace hiip_temp profile
 DEFAULT
 Quota Unlimited on hiip_def;
---Grant/revoke object privileges grant the user the target permission grants
SELECT, INSERT, UPDATE, delete on SYS. Dba_jobs to HIIP;
--Grant/revoke role privileges grants connect to HIIP for user privileges
;
Grant DBA to HIIP;
Grant resource to HIIP;
--Grant/revoke System privileges Grant
CREATE DATABASE link to HIIP for users;
Grant force any transaction to HIIP;
Grant unlimited tablespace to HIIP;
Grant execute any procedure to HIIP;
Grant create any table to HIIP;
Grant Select any table to HIIP;
Grant insert any table to HIIP;
Grant Delete any table to HIIP;
Grant update any table to HIIP;

One thing to be aware of is Oracle's command to ";" End, otherwise there will be an error.

Here's how to import a backed-up database file (. dmp) into the database you want , where I'm going to import a database file into the HIIP user

At first I do not know how to import, and then also asked others, then how to do it, not in this command line, the new open a CMD window, enter IMP command

Enter the user name and password of the interface, enter the user name just created HIIP input password, you will be prompted to import the corresponding database files, I do you directly enter Yes on it, and then the need to import the file path of the database into the above, Ok,enter You can see that the database file is being imported into the library.

The following is how to export the database files that is the exp command, the same is executed under the CMD, export when you need to select the content, this can be selected according to their own circumstances, but also need to enter the exported file location and file name, this input will be created on their own, When the export succeeds, the Xx.dmp file appears. This is the exported database file.

Some of the other operations of the database continue to be familiar.

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.