Error Analysis on two 10 Gb databases created in Oracle 11g RAC

In the clusterware and asm environments of Oracle 11g R2, we will run the Oracle 10g rdbms environment for the purpose of upgrading or migrating data. When using a 10 Gb rdbms to create a database, you must make some adjustments in advance. Otherwise, such problems may occur.

Error 1: When the ASM storage is selected, dbca cannot start the configured asm instance;

The error message is as follows:

"DBCA cocould not startup the ASM instance configured on this node. to proceed with the database creation using ASM, ASM instance needs to be up and running. do you want to recreate ASM instance on this node? "

This is because the asm instance status in the grid cannot be captured in the 10 Gb rdbms.

Solution:

Create a link manually so that 10G_DB_HOME/network/admin/listener. ora points to 11G_GRID_HOME/network/admin/endpoints_listener.ora.

Ln-s <11G_GRID_HOME>/network/admin/endpoints_listener.ora listener. ora

Export TNS_ADMIN = <10G_DB_HOME>/network/admin

Error 2: A ORA-29702 error occurred while creating the file;

This is because the 10 Gb css resource is statically configured, and it becomes a dynamic configuration at 11 GB. If you want to run a 10g rdbms in 11g asm and clusterware environments, You need to manually adjust it to static configuration. oracle is called pinning a node.

Solution:

Run <Grid_home>/bin/crsctl pin css-n nodes as the root user to change the css resource to static configuration. Ping css-n serv1 serv2.