ORA-01506: Missing or illegal Database Name

Start a database on a node:

SQL> startup;
ORA-01506: Missing or illegal Database Name

RAC ora-01506 missing or illegal Database Name

Because pfile is started earlier and spfile is generated again, an error may occur when the file is generated.

[Root @ rac2 DBS] # strings spfileracdb2.ora
*. Spfile = '+ Data/racdb/spfileracdb. ora'

Copy spfileracdb1.ora of the Rac1 node to spfileracdb2.ora.

Solve the problem.

Starting from 9i, the instance does not give priority to reading the pfile parameter file, but spfile <oracle_sid>. ora parameter file,

Therefore, db_name = 'orcl 'of pfile has nothing to do with this problem. Of course, you can delete spfile <oracle_sid>. ora, so the instance is successful.

However, we strongly recommend that you use the spfile <oracle_sid>. ora parameter to start the instance,

So, let's take a look at whether db_name is in spfile <oracle_sid>. ora.

The spfile <oracle_sid>. ora is a binary file. You can use the strings command to view the content of this file.

Strings spfileracdb2.ora

Link: http://blog.csdn.net/miyatang/article/details/7445821