Oracle environment Configuration and Usage guide

One, Oracle installation

First of all, Oracle service, I am using Oracle 11g, direct download version of the official website, downloaded is: Win64_11gr2_database_1of2.zip, Win64_11gr2_database_ 2of2.zip Two unpacking package, note is to setup.exe the contents of the two bags and then the other.

Many times, we do not need to install the service, we just need a client, then we can use Instantclient, and then install PL/SQL to interface management. Because PL/SQL is only 32-bit, 64-bit instantclient cannot be successfully connected, so if you install Instantclient, you will install 32-bit.

It is worth noting that the service side and instantclient do not coexist (in fact, the installation of the service has a client), I initially configured the instantclient, and then to install the service, Because there is no instantclient configuration to delete the installation error has been installed.

Second, create storage space

After service startup we have to create the storage space using the database, we first log on PL/SQL with System (DBA authority), then open a command window and execute the following statement:

CREATE tablespace "St_data" LOGGING datafile ' + filepath/st_data.ora ' SIZE 1000M autoextend on NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; CREATE temporary tablespace "st_temp" Tempfile ' +filepath/st_temp.ora ' SIZE 1000M autoextend on NEXT 10M MAXSIZE 4096M EXT ENT MANAGEMENT LOCAL;

The above creates two storage spaces, one for storing data, and later for saving temp. We do not normally use DBA authority database roles to directly manage business data in a database, so we create users and give them permissions to manage:

create user st identified by st default tablespace st_data  temporary tablespace st_temp;grant connect to st;grant resource to st; Grant debug any procedure to st;grant debug connect session to  st;grant create database link to st;grant create procedure to  st;grant create table to st;grant create trigger to st;grant  create any index to st;grant create any sequence to st; grant create any view to st;grant create any synonym to st; Grant create any job to st;grant unlimited tablespace to st;grant  select on dba_data_files to st;grant select on dba_free_space to  st;

Above, we created the role, then we can use the St role, password St users to log PL/SQL to manage business data!

This article is from the "Snow July" blog, please be sure to keep this source http://xuepiaoqiyue.blog.51cto.com/4391594/1696245

Oracle environment Configuration and Usage guide