--新建测试表 create tablespace test datafile 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\test01.DBF' size 500m autoextend on next 100m maxsize unlimited extent management local autoallocate segment...
Oracle故障处理
1：故障发现
Oracle 启动后发现其他帐户都无法登陆，报告错误如下：
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or dir...
修改了字符集，修改错了，然后不能启动
alter system set nls_language='AMERICA';
shutdown immediate;
startup
报错
[oracle@oracle4 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Fri ...
Xlib: connection to ":0.0" refused by server Xlib: No protocol specified解决方案
Problem: The security parameters in the kernel do not meet the minimum requirements (see above).Recommendation: Perform...
