Deleting IIS logs

IIS logs are residing under c:\windows\system32\logfiles  by default. (on windows 2003 server)
It should be named like  W3SVCxxx

I have an internal website, and its used by SharePoint, so I dont really need to store IIS logs older than 1 week. There is no way to automatically delete this logs. They can grow up to 50 gb in 1 year!

Its safe to delete them, just keep the recent.

Removing an Oracle Database from Windows

If you removed a database  but it's services are still showing up at services.mcsi then;
suppose the database name is demodb

oradim -delete -sid demodb

deletes the services, etc. related to this database.

oradim is an oracle utility for windows only!

Database Creation Assistant Fails during 2% complete with ora-12560

I was installing Oracle 10g to a Windows 2003 server yesterday and the installation went okay. But at the confuguration phase, dbca failed to create a general purpose database at %2 complete with  tns errors: ora-12560 and ora-12514.


So I cancelled the installation and head through metalink. After a few searches I first tried to remove / comment


SQLNET.AUTHENTICATION_SERVICES= (NTS)

row from sqlnet.ora file. (Note 164930.1)Then tried the dbca again; but no luck.

Then I found another note(Note 747243.1) stating that some policies could prevent the creation of oradba user and ora_dba group on windows. So the note suggested that I should manually create them and give it a try again. That was exciting  because I found out that there was a ORA_DBA group but no ORADBA user. So I immediately created a ORADBA user and add it to administrators group on the server. But unfortunately, this did not change anything, the error was still showing up at the exact same stage..

I hit google search and find that forum post, thankfully..

http://forums.oracle.com/forums/thread.jspa?threadID=317706 (merope is me at that page :))

Finally, changing the Regional settings of the server solved the problem.  To change it, navigate to control panel, regional settings and change the language to US English in the regional options tab.. 

unable to determine local host | Enterprise manager error 10g on windows

After a succesful 10g installation and a dbca assisted db creation, installer complains about "enterprise manager configuration failed ..." and you can retry manually by running emca.

and after you click ok the explorer opens up in a window  containing something like that in address bar:

http://tup03srv49.tuprasnet.local:%EM_UPLOAD_PORT%/em/

When I explore emconfig.log I saw:

Creating directories...
Setting console properties ...
Setting log and trace files locations for Console ...
Setting log and trace files locations for Agent ...
Service "OracleDBConsoleIZMTPRS" create SUCCESS
Service "OracleDBConsoleIZMTPRS" delete SUCCESS

Mar 29, 2010 8:56:15 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: '\regedit.exe' is not recognized as an internal or external command,
operable program or batch file.
Creating registry entries failed. Aborting...

 first I checked to see if the windows account which I was using is a local administrator. the account was in a group and the group was under the administrators group. I also added the account directly.

after that I executed:  emca -config dbcontrol db


 worked like a charm!

Username / Password Dialog while connecting to Sharepoint (Windows 2003 Server)

If the browser asks username/password to connect Sharepoint ; simply remove Internet Explorer Enhanced Security Configuration from Control panel -> add remove programs->  windows components.