Changing the Domain of Oracle Database Server

Posted on

I recently had the task of moving our Database server onto a new domain. The following steps outline what was involved in performing this task.

1. Change the Domain of the server

  • Take the server of the current domain
  • Reboot
  • Change the domain to the new one
  • Reboot

2. Update the Listener.ora and Tnsnames.ora

  • Change to the new domain name

3. Make sure the the instance is running

  • sqlplus / as sysdba

4. Drop the Enterprise Manager Console

  • emca -deconfig dbcontrol db -repos drop
  • Enter the SID name (ORA11gDB)
  • Listener port number = 1521
  • Password for SYS user
  • Password for SYSMAN user
  • Do you wish to continue = Y
  • Depending on the size of the DB it can take some minutes to complete the (10 minutes)

5. Reinstall the Enterprise Manager Console

  • emca -config dbcontrol db -repos create
  • Enter the SID name (ORA11gDB)
  • Listener port number = 1521
  • Password for SYS
  • Password for DBSNMP
  • Password for SYSMAN
  • Email address for notification
  • Outgoing mail (SMTP)
  • Do you wish to continue = Y
  • Again this can take some minutes to complete (20 minutes

6. Restart the database

7. Test connections

8. All should be OK

Advertisements

New Oracle Data Miner tool is now Available

Posted on

Today the new Oracle Data Miner tool has been made available as part of the SQL Developer 3.0 (Early Adoptor Release 4).

The new ODM tool has been significantly redeveloped, with a new workflow interface and new graphical outputs. These include graphical representations of the decision trees and clustering.

To download the tool and to read the release documentation go to
http://tinyurl.com/62u3m4y

If you download and use the new tool, let me know what you think of it.

Data Analytics Videos–CNBC–Big Brother–Big Business

Posted on

The following list of videos are available on Youtube from the CNBC program Big Brother – Big Business. Each video is between 8 minutes and 10 minutes long.

They give a good incite into how data analytics can be used and is currently being used by organisations to gain new information and knowledge of what is going on in their business.

Most of the techniques used in the examples given in the videos do not use any complex technique, but shows how a business can use their data to gain a incite into what is really going on in business

Video1, Video2, Video3, Video4, Video5, Video6, Video7, Video8, Video9, Video10

Let me know what you think of these videos.

If you come across any other interesting Data Analysis videos, let me know and I can add them to the list above

Brendan Tierney

New Oracle Data Mining tool video

Posted on

Charlie Berger has recently put together a video demonstrating the new Oracle Data Mining tool.
The link to this video is
http://tinyurl.com/6jhsth4

The video gives a demonstration of some of the main stets in building and applying a classification model. He also demonstrates applying classification to the same data.

The new ODM interface is due to me made available within the next month or two on a limited basis initially and will be part of an Early Adopter (EA) release of SQL Developer 3.

Brendan


Oracle SQL – Day number in Quarter

Posted on

trunc(vStartDate-trunc(vStartDate,’Q’))+1

Oracle SQL – Week Number in Quarter

Posted on

1 + TRUNC((vStartDate – TRUNC(vStartDate, ‘Q’))/7)

How to Prepar for Data Mining

Posted on

There is a new article by Eric King of The Modeling Agency on How to Prepare for Data Mining. It has some interesting points on various aspects that you would need to look out for.

I think some of the important things is that you need to plan such a project carefully, that you understand what you can get out of a data mining project, and have an appreciation of the type of techniques/technologies involved.

Brendan Tierney
var gaJsHost = ((“https:” == document.location.protocol) ? “https://ssl.” : “http://www.”); document.write(unescape(“%3Cscript src='” + gaJsHost + “google-analytics.com/ga.js’ type=’text/javascript’%3E%3C/script%3E”));
try { var pageTracker = _gat._getTracker(“UA-3030290-4”); pageTracker._trackPageview(); } catch(err) {}