ORA-21561: OID generation failed
A very strange problem occurs: Linux5.8 + Oracle 11.2.0.3
When starting the database, an error is reported:
[Oracle @ tivoli02 ~] $ Sqlplus/as sysdba
SQL * Plus: Release 11.2.0.3.0 Production on Thu Oct 23 21:23:16 2014
Copyright (c) 1982,201 1, Oracle. All rights reserved.
Connected.
SQL> startup nomount pfile = '/tmp/a. ora ';
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS = (PROTOCOL = TCP) (HOST = tivoli02. *** .com.cn) (PORT = 1521 ))'
SQL> exit
Disconnected
[Oracle @ tivoli02 dbs] $ cat/tmp/a. ora
Processes = 150
Sga_target = 4432 M
Control_files = "/u01/app/oracle/oradata/orcl/control01.ctl"
Control_files = "/u01/app/oracle/oradata/orcl/control02.ctl"
DB _ block_size = 8192
Compatible = "11.2.0.0.0"
Undo_tablespace = "UNDOTBS1"
Remote_login_passwordfile = "EXCLUSIVE"
Db_domain = ""
Audit_file_dest = "/u01/app/oracle/admin/orcl/adump"
Audit_trail = "NONE"
Db_name = "orcl"
Open_cursors = 300
Pga_aggregate_target = 1477 M
Diagnostic_dest = "/u01/app/oracle"
LOCAL_LISTENER = ''<although it does not help
Then try DBCA to create a database with an error ORA-21561:
Check the startup and running time of the server.
[Oracle @ tivoli02 dbs] $ uptime
21:54:40 up, 5 users, load average: 2.18, 2.12, 1.91
It means that the operating system has restarted five hours ago, and then check/etc/hosts to find that the host entry has been modified, and the Host Name Domain name corresponding to the local IP address has been deleted.
Add an alias with a domain name
For example, tivoli02.robo.com
Later on MOS checked, ORA-21561 is actually ORACLE not public BUG:
Bug 12597261: "ORA-21561 if hostname environment variable is not fully qualified"
Therefore, you must be cautious when making any changes on the server, especially for long-running servers.
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian