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;