Tag: Windows

MSVCP71.DLL and MSVCR71.DLL Missing on Windows 7

Both MSVCP71.DLL and MSVCR71.DLL are Microsoft C Runtime Library files. Some programs like SQL Developer require you to have any of this files for it to work successfully.

  • Download the DLL files from here.
  • Copy the files to System32 on 32 bit OS and SysWOW64 on 64 bit OS.

 

Determine OS Block Size

1. Windows Machine
If you use ntfs file system you can use fsutil fsinfo ntfsinfo drivename:  to get information of block size.

c:>fsutil fsinfo ntfsinfo f:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:Documents and SettingsAdministrator>fsutil fsinfo ntfsinfo D:
NTFS Volume Serial Number : 0xc054aec854aec090
Version : 3.1
Number Sectors : 0x000000000c34f28c
Total Clusters : 0x0000000001869e51
Free Clusters : 0x00000000015f0419
Total Reserved : 0x0000000000000000
Bytes Per Sector : 512
Bytes Per Cluster : 4096
Bytes Per FileRecord Segment : 1024
Clusters Per FileRecord Segment : 0
Mft Valid Data Length : 0x0000000003528000
Mft Start Lcn : 0x00000000000c0000
Mft2 Start Lcn : 0x0000000000c34f28
Mft Zone Start : 0x00000000000c3520
Mft Zone End : 0x00000000003cd3e0
C:Documents and SettingsAdministrator>

Start Oracle service on Windows using ORADIM utility

To start a new service on Windows, Oracle provides a command-line utility, ORADIM. It can also be used to remove, edit and stop a service.

Create:

C:oracleproduct10.1.0db_2>oradim -new -sid %ORACLE_SID% -intpwd password -startmode A
Instance created.

Startup:

C:oracleproduct10.1.0db_2>oradim –startup –sid %ORACLE_SID%

Shutdown:

C:oracleproduct10.1.0db_2>oradim –shutdown –sid %ORACLE_SID%

Delete:

C:oracleproduct10.1.0db_2>oradim –delete –sid %ORACLE_SID%

  • startup – Indicates that the specified instance should be started.
  • shutdown – Indicates that the specified instance should be shutdown.
  • sid – The SID of the database to start.
  • intpwd – The password for the database user.
  • startmode – It could be A(utomatic) or M(anual), this refers to whether or not starting the service automatically opens the database.

To verify whether the service is created or not, check Windows services by typing services.msc into the console. A service named OracleServiceDBName (DBName = %ORACLE_SID%) will be found.

Oracle also created a password file under %ORACLE_HOME%database.

C:oracleproduct10.1.0db_2databasePWDDBName.ORA

Registry Settings:

Check registry editor by typing regedit into the console.

HKLMSoftwareOracleKey_<Oracle Home Name>ORA<SID>_AUTOSTART
Start the database when the service starts

HKLMSoftwareOracleKey_<Oracle Home Name>ORA<SID>_PFILE
Location of the Configuration File

HKLMSoftwareOracleKey_<Oracle Home Name>ORA<SID>_SHUTDOWN
Shutdown the database when the service stops

HKLMSoftwareOracleKey_<Oracle Home Name>ORA<SID>_SHUTDOWNTYPE
Type of shutdown to do when stopping the server