When you try create database DBCA show up PRPP-1001 and CRS-0215
1) There are separate homes for the ASM instance and the database instances.
2) The Oracle NET listener runs from a separate home than the home used for the database.
3) Even though the TNS_ADMIN for the session that launched DBCA was set and pointed to
the proper home and directory were the Oracle NET configuration files reside (e.g., tnsnames.ora, etc.),
this was not passed to the srvctl commands kicked off by DBCA
You can fix issue here
Update the TNS_ADMIN environment setting for each of these database and instance resources registered in the OCR, to point to the proper directory.
Example (do this only from one of the RAC nodes, any node),
1) If the node's Oracle NET listener runs from home '/home/oracle/oracle/product/11.1/asm_1', then
2) If DBCA is launched from home '/home/oracle/oracle/product/11.1/db_1' (which will be the home for the new database), then
3) From any node and as the Oracle software owner
srvctl setenv db -d <db_name> -t TNS_ADMIN=/home/oracle/oracle/product/11.1/asm_1/network/admin
srvctl setenv inst -d <db_name> -i <instance_name_1> -t TNS_ADMIN=/home/oracle/oracle/product/11.1/asm_1/network/admin
srvctl setenv inst -d <db_name> -i <instance_name_2> -t TNS_ADMIN=/home/oracle/oracle/product/11.1/asm_1/network/admin
4) Now, the RAC database and instance should not fail to startup via srvctl:
srvctl start db -d <db_name>
1) There are separate homes for the ASM instance and the database instances.
2) The Oracle NET listener runs from a separate home than the home used for the database.
3) Even though the TNS_ADMIN for the session that launched DBCA was set and pointed to
the proper home and directory were the Oracle NET configuration files reside (e.g., tnsnames.ora, etc.),
this was not passed to the srvctl commands kicked off by DBCA
You can fix issue here
Update the TNS_ADMIN environment setting for each of these database and instance resources registered in the OCR, to point to the proper directory.
Example (do this only from one of the RAC nodes, any node),
1) If the node's Oracle NET listener runs from home '/home/oracle/oracle/product/11.1/asm_1', then
2) If DBCA is launched from home '/home/oracle/oracle/product/11.1/db_1' (which will be the home for the new database), then
3) From any node and as the Oracle software owner
srvctl setenv db -d <db_name> -t TNS_ADMIN=/home/oracle/oracle/product/11.1/asm_1/network/admin
srvctl setenv inst -d <db_name> -i <instance_name_1> -t TNS_ADMIN=/home/oracle/oracle/product/11.1/asm_1/network/admin
srvctl setenv inst -d <db_name> -i <instance_name_2> -t TNS_ADMIN=/home/oracle/oracle/product/11.1/asm_1/network/admin
4) Now, the RAC database and instance should not fail to startup via srvctl:
srvctl start db -d <db_name>
No comments:
Post a Comment