ORA-21561: OID generation failed 错误解决

通过修改hosts文件，错误解决

点击(此处)折叠或打开

1. [root@dg bin]# ./srvctl remove listener
   
2. [root@dg bin]# su - grid
   
3. [grid@dg ~]$ cd /u01/app/grid/product/11.2.0/grid/bin/
   
4. [grid@dg bin]$ ./srvctl add listener
   
5. [grid@dg bin]$ ./srvctl start asm
   
6. PRCR-1079 : Failed to start resource ora.asm
   
7. CRS-2674: Start of 'ora.LISTENER.lsnr' on 'dg' failed
   
8. ORA-21561: OID generation failed
   
9. CRS-5017: The resource action "ora.asm start" encountered the following error:
   
10. ORA-21561: OID generation failed
    
11. . For details refer to "(:CLSN00107:)" in "/u01/app/grid/product/11.2.0/grid/log/dg/agent/ohasd/oraagent_grid/oraagent_grid.log".
    
12. 
    
13. CRS-2674: Start of 'ora.asm' on 'dg' failed
    
14. ORA-21561: OID generation failed
    
15. [grid@dg bin]$ ./srvctl start asm
    
16. [grid@dg bin]$

具体见官方说明
ORA-21561: OID generation failed (Doc ID 1335327.1)

APPLIES TO:
Oracle Net Services - Version 9.2.0.8 to 11.2.0.3 [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 14-Jan-2013***
 
SYMPTOMS
When attempting to connect to the database using SQL*Plus or DBCA,
the following error occurs intermittently:
 
ERROR
-----------------------
ORA-21561: OID generation failed
 
CAUSE
This could be caused by not having the host name for the
target database fully qualified in the hosts file.
To verify if you are hitting this issue, the following symptoms should be met:
 
- ORA-21561: OID generation failed.
- Hosts file has un-fully qualified entry for the target database host:
 
127.0.0.1 loopback localhost # loopback (lo0) name/address
10.210.9.111 dbhost
In this sample, dbhost is the target db host.
 
This is reported in an unpublished Bug 12597261:
"ORA-21561 IF HOSTNAME ENVIRONMENT VARIABLE IS NOT FULLY QUALIFIED",
 which should be resolved as of 12G.
 
SOLUTION
Modify the hosts file to have the fully qualified host names,
by adding the fully qualified domain name to the entry.
 
127.0.0.1 loopback localhost # loopback (lo0) name/address
10.210.9.111 dbhost.sample.com
 
Verify that other environment and service handles are properly defined as well.
 
If this is a Windows environment, please check :
Windows: Connections Fail with ORA-12640 or ORA-21561 (Doc ID 744125.1)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30258496/viewspace-2059918/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30258496/viewspace-2059918/