Tag Archives: windows

Windows update with oracle.

A client reported a slowdown on a database on Windows 2003 because of windows patches.

Posted in Oracle | Tagged , , , , , , | Comments Off

Enterprise Manager username/password incorrect.

Configuring Host Credentials for Windows Systems. You have to assign “Log on as a batch job” for the windows users to enable host authentication in windows. Here’s how to do it.

Posted in Enterprise Manager, Oracle | Tagged , , , | Comments Off

Windows and WScript.

We have production databases running on Windows, and I required to check that everything was up and running, and start them if not. Here’s how I’ve set it up.

Posted in Oracle | Tagged , , , , , , , | Comments Off

Emctl Returning status code 1

emctl agent would not start, returning the error : 2010-08-17 18:51:50,921 Thread-1696 ERROR main: nmectla_agentctl: Error connecting to http://hostname:3872/emd/main/. Returning status code 1 Even from the services panel, the same error was returned and the agent refused to start up. … Continue reading

Posted in Enterprise Manager, Oracle Agent, Oracle Configuration Manager | Tagged , , , , , , , | Comments Off

Dos equivalent oraenv

oraenv in unix sets your environment and allows you to connect directly to the database. However, there’s no equivalent in DOS for windows. Here’s the one that I use. I’ve used bits and pieces to get this working from various … Continue reading

Posted in Oracle | Tagged , , , , , , | Comments Off

Insufficient privileges purging scheduler logs.

Cannot purge the job history logs ? If you get insufficient privileges, you require the SCHEDULER_ADMIN role.

Posted in Oracle | Tagged , , , , , , | Comments Off

Windows Agent will not start.

Lost communication with agent from Grid on Windows 2003 server. I was unable to communicate with the agent on a server. Note that the symptoms are nothing to do with the cause. EM displayed the following : Error Communication between … Continue reading

Posted in Enterprise Manager | Tagged , , , , , , | Comments Off

Database Backup from Scheduler.

I wanted to backup a database using an OS script, but scheduled from the database rather than from the OS. Here’s the setup for it.

Posted in Recovery Manager | Tagged , , , | Comments Off

Autostart Database’s in Windows.

Window’s can be a funny beast. I found that on a windows 2003 server, the services would all start but the database would not. Here’s how to fix it.

Posted in Oracle | Tagged , , , , , | Comments Off

Installing 11gR2 reports missing files.

Files missing on installation. When installing Oracle 11g R2, I came across a number of missing files during the installation on windows 32bit, though this is also apparent on the 64 bit version.

Posted in Oracle | Tagged , , , , , | Comments Off