Category: 1Z0-048

Exam 1Z0-048: Oracle Database 10g, Real Application Clusters Administrator Certified Expert

Why was the instance not started by CRS?

View the Exhibit.

Users complain about the performance of an Oracle database-based application. You are requested to investigate. From Grid Control, you immediately infer that one of the cluster database instances and one of the cluster ASM instances are currently unavailable. You also see that the host where the instance belongs was recently rebooted due to an unknown reason.

Using Grid Control, you restart the instance and performance rapidly improves. You want to determine the cause of the instance startup failure after system boot, and you check the resource profiles on both the database and ASM instances involved.

Why was the instance not started by CRS?

Why was the instance not started by CRS?

View the Exhibit.

Users complain about the performance of an Oracle database-based application. You are requested to investigate. From Grid Control, you immediately infer that one of the cluster database instances is currently unavailable. You also notice that the host where the instance belongs was recently rebooted due to an unknown reason.

Using Grid Control, you restart the instance and performance rapidly improves. You want to determine the cause of the instance startup failure after the system reboot, and you check the resource profiles on both the database and ASM instances involved.

Why was the instance not started by CRS?

what is your conclusion, and what would you do to correct this?

After applying a patch to the network device drivers in your operating system, you verify using CRS_STAT -T that everything runs normally. View Exhibit1 for the CRS_STAT -T output.

After your coffee break, customers begin complaining about the performance of your Oracle Real Application Clusters database. Suddenly, the response time has increased and establishing new connections is slower than it used to be. You run CRS_STAT -T again to check if there is a problem.

Based on Exhibit2, what is your conclusion, and what would you do to correct this?

What could be the reason for this and how would you fix the problem?

View the Exhibit.

While you were away on vacation, your fellow DBA added an OCR mirror to your company’s three-node Linux cluster. Based on high-availability guidelines, you are asked to verify this change. You notice that one of the nodes does not report the OCR mirror when you run OCRCHECK on all cluster nodes.

What could be the reason for this and how would you fix the problem?

How many connections are established, and on which instances?

You define the ERP service using this statement:

srvctl add service -d RACDB -s ERP -r RAC01 -P PRECONNECT

srvctl start service -d RACDB -s ERP

You then use this connect string to connect to your RAC instances:

ERP =

(DESCRIPTION =(FAILOVER=ON)(LOAD_BALANCE=ON)

(ADDRESS=(PROTOCOL=TCP)(HOST=N1VIP)(PORT=1521))

(ADDRESS=(PROTOCOL=TCP)(HOST=N2VIP)(PORT=1521))

(CONNECT_DATA = (SERVICE_NAME = ERP)

(FAILOVER_MODE = (BACKUP=ERP_PRECONNECT)(TYPE=SESSION)(METHOD=PRECONNECT))))

You successfully establish a connection to your RAC database using the above connect string.

How many connections are established, and on which instances?

How many connections are established, and on which instances?

You define the ERP service using this statement:

srvctl add service -d RACDB -s ERP -r RAC01 -a RAC02 -P PRECONNECT

srvctl start service -d RACDB -s ERP

You then use this connect string to connect to your RAC instances:

ERP =

(DESCRIPTION =(FAILOVER=ON)(LOAD_BALANCE=ON)

(ADDRESS=(PROTOCOL=TCP)(HOST=N1VIP)(PORT=1521))

(ADDRESS=(PROTOCOL=TCP)(HOST=N2VIP)(PORT=1521))

(CONNECT_DATA = (SERVICE_NAME = ERP)

(FAILOVER_MODE = (BACKUP=ERP_PRECONNECT)(TYPE=SESSION)(METHOD=PRECONNECT))))

You successfully establish a connection to your RAC database using the above connect string.

How many connections are established, and on which instances?


Page 1 of 1612345...10...Last »