在10.2以上的版本，收集统计信息，如使用dbms_stats.gather_table_stats，还是在ebs中调用fnd_stats.GATHER_TABLE_STATS，有的时候虽然用了degree的参数，如degree=8，但是会发现仍然不使用并行。在10046的trace中，我们可以看到 […]
ORA-00000 normal, successful completion
当hosts文件配置错误时，用sqlplus登录后startup nomount，就会报错ORA-00000
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
[oracle11g@testdb2 dbs]$ sqlplus "/ as sysdba" SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 21 13:48:32 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected. SQL> startup nomount ORA-00000: normal, successful completion SQL> alter database mount; ERROR: ORA-01012: not logged on SQL> [root@testdb2 etc]# cat hosts # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.56.250 wrong_server #192.168.56.132 testdb2 |
修改host文件后：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
[root@testdb2 etc]# cat hosts # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 #192.168.56.250 wrong_server 192.168.56.132 testdb2 再次启动： SQL> startup nomount ORACLE instance started. Total System Global Area 1052274688 bytes Fixed Size 2259840 bytes Variable Size 1023411328 bytes Database Buffers 20971520 bytes Redo Buffers 5632000 bytes SQL> 正常。 |
另外，除了写错，如果丢失hosts文 […]