Oracle11g Window管理教程

1.连接数据库 并创建新的用户和表空间

sqlplus /@shannxi2016 as sysdba
create tablespace shannxi2016 DATAFILE 'D:\app\Administrator\oradata\shannxi2016\TPIN.DBF' SIZE 1500m AUTOEXTEND on next 100m maxsize unlimited;
create user shannxi2016 identified by shannxi2016 default tablespace shannxi2016;
grant dba to shannxi2016 ;

2. 修改数据库的占用内存

sqlplus /nolog
connect sys/shannxi2016@shannxi2016 as sysdba;
alter system set sga_max_size=2048m scope=spfile;
alter system set sga_target=256m scope=spfile;
alter system set memory_target=2048m scope=spfile;

shutdown immediate;
startup;
show parameter sga;

3.修改数据库的远程访问

3.1在datebase configuration assitant工具中：

• 配置数据库选项
• 连接模式设置为共享服务器模式
• 保存配置并重启服务

3.2 在windows防火墙中添加1521端口的出入站规则

控制面板 -> 所有控制面板项 -> windows防火墙 ->高级设置

4.TEMP表空间不足的解决方案

sqlplus /@shannxi as sysdba
create temporary tablespace TEMP02  TEMPFILE 'D:\ORACLE\ORADATA\SHANNXI\TEMP02.DBF' SIZE 512M  REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED;   
alter database default temporary tablespace temp02;  
drop tablespace temp including contents and datafiles; 
select file_name,bytes/1024/1024 "MB",autoextensible,tablespace_name from dba_temp_files ;
alter database tempfile '/u01/app/oracle/product/10.2.0/db_1/dbs/temp01.dbf' RESIZE 1000m;