Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

Thursday, 1 April 2010

Get a Redhat/CentOS/Oracle Enterprise Linux box to register on a Windows DNS

I live mainly in a Windows world, but occasionally I have to got down and dirty with a Linux box.

One of my particular hates is the way Linux will use a DHCP address supplied by a Windows server, but won't register itself in the DNS, so I have to go and put a static entry into my DNS.
After MUCH hunting around, I finally managed to get it working... and it's actually a very simple problem to fix...

On your DHCP server, right click on the Scope and change the DNS tab page to match below. It seems that Linux machines don't send out a "register me in the DNS" message (which Windows machines do), and you need to make the below changes to force the DHCP server to always send new registrations to the DNS.

 

Hopefully this page has been of help to you, if so, please click on one of the advert to show your appreciation.

Tuesday, 30 March 2010

Can't Export from Oracle

So, you've been using Oracle and want to export your data out to a spreadsheet... easy huh? Just click File - Export and a window pops up and closes straight away! What the...!!!
This took me ages to work out, so hopefully it'll save you some time.

First, add the site to your Trusted Sites List - if you trust it with your finances, you should be happy to do this :)
Then click on Custom Level and set 
Downloads > Automatic Prompting for file downloads to Enable 
Downloads > File downloads to Enable

A quick restart of IE, and you should be able to File > Export from Oracle with ease.

You may also want to associate TSV files Excel, just right click it and select Open, Select a program from a list of installed programs and choose Excel
Hopefully this hint helped you out, please feel free to click on the Ads on this page to show your appreciation.

Oracle "Yellow Bar" stops cut and paste

Sometimes installing the Oracle Jinitiator just doesn't go through properly. I recently had the experience of trying to install it several times, and it crashing out right at the end.
Assuming that it had probably done all the good bits earlier in the install, I ignored the error and fired up the URL, and up popped the Oracle window!
However, at the bottom of the windows were yellow warning bars, and I could not cut and paste into it.
After hunting around on the internet for a while, I worked out that it was something to do with the identitydb.obj file, so rather than get deep down into the hows and whys, I just copied the file from a working machine over onto the new PC and after a quick restart of IE, everything was fine once more!

You can fine the file in c:\program files\oracle\identitydb.obj

I hope this helps you and your Oracle woes... if so, please click on one of the ads on this site to show your appreciation.