Archive

Archive for the ‘Windows’ Category

MSVCP71.DLL and MSVCR71.DLL Missing on Windows 7

April 22, 2012 Leave a comment

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

October 19, 2011 Leave a comment

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:\oracle\product\10.1.0\db_2>oradim -new -sid %ORACLE_SID% -intpwd password -startmode A
Instance created.

Startup:

C:\oracle\product\10.1.0\db_2>oradim –startup –sid %ORACLE_SID%

Shutdown:

C:\oracle\product\10.1.0\db_2>oradim –shutdown –sid %ORACLE_SID%

Delete:

C:\oracle\product\10.1.0\db_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:\oracle\product\10.1.0\db_2\database\PWDDBName.ORA

Registry Settings:

Check registry editor by typing regedit into the console.

HKLM\Software\Oracle\Key_<Oracle Home Name>\ORA<SID>_AUTOSTART
Start the database when the service starts

HKLM\Software\Oracle\Key_<Oracle Home Name>\ORA<SID>_PFILE
Location of the Configuration File

HKLM\Software\Oracle\Key_<Oracle Home Name>\ORA<SID>_SHUTDOWN
Shutdown the database when the service stops

HKLM\Software\Oracle\Key_<Oracle Home Name>\ORA<SID>_SHUTDOWNTYPE
Type of shutdown to do when stopping the server

Start database along with Windows startup

September 30, 2011 Leave a comment

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_MACHINE\SOFTWARE\ORACLE\oracle_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

Categories: Windows