dataguard--java.sql.SQLException: ORA-01033: ORACLE initialization or shutdown in progress
报错:2012-06-19 16:22:37,737 [SeverityLoad https://rac1:3938/emd/main] WARN jdbc.ConnectionCache _getConnection.353 - Got a fatal exeption when getting a connection; Error code = 1033; Cleaning up cache and retrying2012-06-19 16:22:37,769 [SeverityLoad https://rac1:3938/emd/main] ERROR eml.XMLLoader markFileAsError.890 - ORA-01033: ORACLE initialization or shutdown in progressjava.sql.SQLException: ORA-01033: ORACLE initialization or shutdown in progress at oracle.jdbc.driver.SQLStateMa
在redhat 6.2上安装oracle 11.2--RAC时报ADVM/ACFS is not supported
在redhat 6.2上安装oracle 11.2时ADVM/ACFS is not supported这个错误是由于redhat 6.2没有被oracle认证造成的[client(16891)]CRS-10001:18-Jun-12 09:57 ACFS-9459: ADVM/ACFS is not supported on this OS version: 'unknown'[client(16893)]CRS-10001:18-Jun-12 09:57 ACFS-9201: Not Supported[client(16975)]CRS-10001:18-Jun-12 09:57 ACFS-9459: ADVM/ACFS is not supported on this OS version: 'unknown'解决方法。在各个节点上运行下面的命令:[root@sfrac1 sfrac1]# more /tmp/.linux_release redhat-release-server-6Server-6
oracle 11g使用deferred_segment_creation 延迟段创建特性时遇到的问题总结
总结,下面是两个问题。问题1是用户可以在所有表空间创建表;问题2是exp不能导出空表问题1:版本:oracle 11.2.0.1.0创建用户aaa,给其connect和resource角色,但回收unlimited tablespace权限:SQL> create user aaa identified by aaa default tablespace users;User created.SQL> grant connect,resource to aaa;Grant succeeded.SQL> revoke unlimited tablespace from aaa;Revoke succeeded.SQL> select * from role_sys_privs where role='RESOURCE'; ROLE PRIVILEGE
Toad for Oracle 11.5 下载
Toad Development Suite for Oracle 11.5 Commercial Toad DBA Suite for Oracle 11.5 Commercial[@more@]