ASM Sandbox – Oracle 10gR2 on Windows7 32bit – Part IV

Part IV – Fixing the Mess

When the 10g installer completes you will have an Oracle 10g install, a Clusterware Service and no database.

With the logical 32GB partition now stamped for ASM, it is now possible to use DBCA to create a new empty database, and DBCA will allow you to specify ASM as the storage medium, whereupon DBCA will also create the ASM instance for you.

However by default on Windows 7 this process will fail, with errors in the Clusterware Service.

Oracle’s documentation suggests that you use the “localconfig add” tool in the Oracle Home bin directory to remove and reinstall the Clusterware service. Again on Windows 7 this does not work:

C:\oracle\product\10.2.0\db_1\BIN> localconfig add
 Step 1: creating new OCR repository
 Successfully accumulated necessary OCR keys.
 Creating OCR keys for user 'administrator', privgrp ''..
 Operation successful.
 Step 2: creating new CSS service
 Failed to create the new CSS service, err(1073)
 failed to create CSS services
Trying to delete and re-add the service fails with similar problems.

To solve this problem on Windows 7, we need to adjust the permissions and compatibility of a program called ocssd.exe in the Oracle Home bin directory. It is this program that creates the Clusterware service and it is not designed for Windows 7.

To address the problem, find the ocssd.exe program and right click on it. Then select the “Compatibility” tab and set it to Windows XP (Service Pack 2). We must also set it explicitly to “Run as Administrator”

 

 

Once this is done we can delete the Clusterware service using the localconfig tool, in this example we shut down the service first

 

C:\oracle\product\10.2.0\db_1\BIN>net stop OracleCSService
The following services are dependent on the OracleCSService service.
Stopping the OracleCSService service will also stop these services.
OracleServiceGCTDEV
OracleASMService+ASM
Do you want to continue this operation? (Y/N) [N]: y
The OracleServiceGCTDEV service is stopping.
The OracleServiceGCTDEV service was stopped successfully.
The OracleASMService+ASM service is stopping.
The OracleASMService+ASM service was stopped successfully.
The OracleCSService service was stopped successfully.

C:\oracle\product\10.2.0\db_1\BIN>localconfig delete
Step 1: stopping local CSS stack
Step 2: deleting OCR repository
failed to open the OCR subkey, err(1060)
failed to cleanup local OCR repository
successfully deleted local CSS setup

 

We can now re-install the service with the proper compatibility and privilege level:

 

C:\oracle\product\10.2.0\db_1\BIN>localconfig add
 Step 1: creating new OCR repository
 Successfully accumulated necessary OCR keys.
 Creating OCR keys for user 'phred', privgrp ''..
 Operation successful.
 Step 2: creating new CSS service
 successfully created local CSS service
 successfully added CSS to home

 

We can now use DBCA to create new databases and set them to use ASM as their storage!

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s