Category: 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.

 

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

Start database along with Windows startup

Sometimes starting the Windows Oracle services starts the database automatically. You can check this in Windows registry as mentioned below.

Open the registry with regedit.

HKEY_LOCAL_MACHINESOFTWAREORACLEoracle_home_name.
There will be a key called:
ORA_SID_AUTOSTART. SID is your database SID.

This key should be set to TRUE. If you want to start the database automatically once the service is started.

If you want to manually start the database set ORA_SID_AUTOSTART to FALSE. The service will start but not the database.

There is also an ORA_SID_SHUTDOWN which you want to be TRUE so that if the server is shut down the service will shutdown the database automatically.

For Deleting a service

you can use
> oradim or sc delete