What is Domino?

Domino is the name of the applications and messaging server program for the Lotus Corporation‘s Lotus Notes product, a sophisticated groupware application that is installed in many corporations. Notes lets a corporation and its workers develop communications- anddatabase-oriented applications so that users at different geographic locations can share files with each other, comment on them publicly or privately (to groups with special access), keep track of development schedules, work projects, guidelines and procedures, plans, white papers, and many other documents, including multimedia files. Lotus uses the Domino name to refer to a set of Notes server applications. Notes itself refers to the overall product.

 Ask your Lotus Domino questions at ITKnowledgeExchange.com

The Notes and Domino servers interact with other Notes/Domino servers in a distributednetwork. As changes are made to a database at one server, updates are continually forwarded to replicated copies of these databases at the other servers so that users are always looking at the same information. In general, Notes follows the client/server model. The replication updates are made using Remote Procedure Call (RPC) requests. Notes can be coordinated with Web servers and applications on a company’s intranet.
Reference : http://searchdomino.techtarget.com/definition/Domino

AS/400 (IBM iSeries, AS/400e, eServer iSeries/400)

The AS/400 – formally renamed the “IBM iSeries,” but still commonly known as AS/400 – is a midrange server designed for small businesses and departments in large enterprises and now redesigned so that it will work well in distributed networks with Web applications. The AS/400 uses the PowerPC microprocessor with its reduced instruction set computertechnology. Its operating system is called the OS/400. With multi-terabytes of disk storage and a Java virtual memory closely tied into the operating system, IBM hopes to make the AS/400 a kind of versatile all-purpose server that can replace PC servers and Web servers in the world’s businesses, competing with both Wintel and UNIX servers, while giving its present enormous customer base an immediate leap into the Internet.

 Ask your AS/400 questions at ITKnowledgeExchange.com

The AS/400, one of IBM’s greatest success stories, is widely installed in large enterprises at the department level, in small corporations, in government agencies, and in almost every industry segment. It succeeded another highly popular product, the System/36 and was itself based on a later, more sophisticated product, the System/38. AS/400 customers can choose from thousands of applications that have already been written and many have been “Web-enabled.” IBM points to the AS/400’s “uptime” of 99.9%.

The AS/400 comes with a database built-in. One widely-installed option is Domino (Noteswith a Web browser).

According to IBM, these are some important new uses for the AS/400:

  • Data warehousing: With multi-gigabytes of RAM and multi-terabytes of hard disk space, the AS/400 can be a repository for large amounts of company data to which data mining could be applied.
  • Java application development: With its closely integrated Java virtual machine and new tools designed by IBM for building commercial applications with Java, the AS/400 can be used as a development system.
  • Web and e-commerce serving: Equipped with a Web server and applications designed to support e-commerce (taking orders, tracking orders, providing service to customers, working with partners and suppliers) and with firewall capabilities, the AS/400 can handle Internet serving for a moderate-size company.
  • Corporate groupware services: Assuming that Domino and Notes have been included with the system, it’s designed to quickly provide a corporation with sophisticated e-mail, project file sharing, whiteboards, and electronic collaboration.

Reference: http://search400.techtarget.com/definition/AS-400

How to Drop UNDO Tablespace?

It is not an easy task to drop the undo tablespace . Once I have to delete the undo tablespace due to some reason and i  find that it is not straight forward to delete the undo tablespace . I got the following error while dropping the error :

SQL> select tablespace_name,file_name from dba_data_files;

TABLESPACE_NAME                FILE_NAME
—————————— ———————————————————————
USERS                               D:\ORACLE\ORADATA\NOIDA\USERS01.DBF
UNDOTBS1                       D:\ORACLE\ORADATA\NOIDA\UNDOTBS01.DBF
SYSAUX                             D:\ORACLE\ORADATA\NOIDA\SYSAUX01.DBF
SYSTEM                            D:\ORACLE\ORADATA\NOIDA\SYSTEM01.DBF
EXAMPLE                          D:\ORACLE\ORADATA\NOIDA\EXAMPLE01.DBF

SQL> drop tablespace undotbs1;
drop tablespace undotbs1
*
ERROR at line 1:
ORA-30013: undo tablespace ‘UNDOTBS1’ is currently in use

As the error indicate that the undo tablespace is in use so i issue the following command.

SQL> alter tablespace undotbs1  offline;
alter tablespace undotbs1  offline
*
ERROR at line 1:
ORA-30042: Cannot offline the undo tablespace.

Therefore, to drop undo  tablespace, we have to perform following steps:

1.) Create new undo tablespace
2.) Make it defalut tablepsace and undo management manual by editting parameter file and restart it.
3.) Check the all segment of old undo tablespace to be offline.
4.) Drop the old tablespace.
 5.) Change undo management to auto by editting parameter file and restart the database

Step 1 : Create Tablespace   :  Create undo tablespace undotbs2    

SQL> create undo tablespace UNDOTBS2 datafile  ‘D:\ORACLE\ORADATA\NOIDA\UNDOTBS02.DBF’  size 100M;
Tablespace created.

Step 2 : Edit the parameter file

SQL> alter system set undo_tablespace=UNDOTBS2 ;
System altered.

SQL> alter system set undo_management=MANUAL scope=spfile;
System altered.

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.
Total System Global Area  426852352 bytes
Fixed Size                  1333648 bytes
Variable Size             360711792 bytes
Database Buffers           58720256 bytes
Redo Buffers                6086656 bytes
Database mounted.
Database opened.
SQL> show parameter undo_tablespace
NAME                                 TYPE        VALUE
———————————— ———– ——————————
undo_tablespace                      string      UNDOTBS2

Step 3: Check the all segment of old undo tablespace to be offline

SQL> select owner, segment_name, tablespace_name, status from dba_rollback_segs order by 3;

OWNER  SEGMENT_NAME                   TABLESPACE_NAME                STATUS
—— —————————— —————————— —————-
SYS                 SYSTEM                                     SYSTEM                            ONLINE
PUBLIC       _SYSSMU10_1192467665$          UNDOTBS1                       OFFLINE
PUBLIC        _SYSSMU1_1192467665$           UNDOTBS1                       OFFLINE
PUBLIC        _SYSSMU2_1192467665$           UNDOTBS1                       OFFLINE
PUBLIC        _SYSSMU3_1192467665$           UNDOTBS1                       OFFLINE
PUBLIC        _SYSSMU4_1192467665$           UNDOTBS1                       OFFLINE
PUBLIC        _SYSSMU5_1192467665$           UNDOTBS1                       OFFLINE
PUBLIC        _SYSSMU6_1192467665$           UNDOTBS1                       OFFLINE
PUBLIC        _SYSSMU7_1192467665$           UNDOTBS1                       OFFLINE
PUBLIC        _SYSSMU8_1192467665$           UNDOTBS1                       OFFLINE
PUBLIC        _SYSSMU9_1192467665$           UNDOTBS1                       ONLINE
PUBLIC      _SYSSMU12_1304934663$          UNDOTBS2                        OFFLINE
PUBLIC      _SYSSMU13_1304934663$          UNDOTBS2                        OFFLINE
PUBLIC      _SYSSMU14_1304934663$          UNDOTBS2                        OFFLINE
PUBLIC      _SYSSMU15_1304934663$          UNDOTBS2                        OFFLINE
PUBLIC      _SYSSMU11_1304934663$          UNDOTBS2                        OFFLINE
PUBLIC      _SYSSMU17_1304934663$          UNDOTBS2                        OFFLINE
PUBLIC      _SYSSMU18_1304934663$          UNDOTBS2                        OFFLINE
PUBLIC      _SYSSMU19_1304934663$          UNDOTBS2                        OFFLINE
PUBLIC      _SYSSMU20_1304934663$          UNDOTBS2                        OFFLINE
PUBLIC      _SYSSMU16_1304934663$          UNDOTBS2                        OFFLINE

21 rows selected.

If any one the above segment is online then change it status to offline by using below command .

SQL>alter rollback segment “_SYSSMU9_1192467665$” offline;

Step 4 : Drop old undo tablespace

SQL> drop tablespace UNDOTBS1 including contents and datafiles;
Tablespace dropped.

Step  5 : Change undo management to auto and restart the database

SQL> alter system set undo_management=auto scope=spfile;
System altered.

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area  426852352 bytes
Fixed Size                  1333648 bytes
Variable Size             364906096 bytes
Database Buffers           54525952 bytes
Redo Buffers                6086656 bytes
Database mounted.
Database opened.

SQL> show parameter undo_tablespace
NAME                                       TYPE        VALUE
————————————   ———– ——————————
undo_tablespace                      string      UNDOTBS2

 

Reference:http://neeraj-dba.blogspot.com/2011/05/how-to-drop-undo-tablespace.html

Setting Up Oracle Data Miner 11g Release 2

In the following topics, you perform the steps required to set up Oracle Data Miner 11g Release 2 for use within SQL Developer 3.0.

Important: As stated above, you need the SYS user credentials in order to install the Oracle Data Miner Repository . In addiiton, you will use the SYS user to create a database user account for data mining purposes.

Create a Data Miner User Account

SQL Developer is a client to the Oracle Database software. Before you can perform actions such as creating a user, you must connect to the database from SQL Developer.

To connect to the database, you will define an administrative (SYS) connection in SQL Developer, and then use that connection to create the data miner user.

Perform the following steps.

1. To open SQL Developer, double-click sqldeveloper.exe in the directory where you unzipped SQL Developer.

For example, double-click C:\SQLDev\sqldeveloper.exe, as shown below:

Show Screenshot for Step

Notes:

  • If you are prompted to import settings from an earlier version, click Yes if you have been using an earlier version of SQL Developer and want to preserve those settings.
  • If you wish, create a shortcut to C:\SQLDev\sqldeveloper.exe and move it to your desktop.

 

2. In the the SQL Developer Connections tab, right-click Connections and select New Connection from the pop-up menu.

Show Screenshot for Step

Result: The New / Select Database Connection dialog box appears.

Notes:

  • Your SQL Developer interface may also display the Reports tab next to the Connections tab.
  • In this lesson, we have already closed the SQL Developer Reports tab.

 

3. In the New / Select Database Connection dialog box:

A. Enter the following parameters:

  • Connection Name: admin
  • Username: sys
  • Password: The Administrative password for your database
  • Connection Type: Basic
  • Role: SYSDBA
  • Hostname: The host name of your database server (localhost if the database is installed on your PC)
  • Port: Enter the apropriate port number (1521 is the default)
  • SID: The name of SID for your database (orcl the default)

Show Screenshot for Step

B. Click Test to test the connection.

Note: If the connection is successful, Status (just above the Help button) changes to “Success!”

C. Click Connect to save the connection and to also establish a connection to the database.

 

4 . Next, create an account for data mining.

A. In the SQL Developer Connections tab, drill on the admin connection.

B. Then, right-click the Other Users node and select Create User from the pop-up menu, like this:

Show Screenshot for Step

C. In the Create/Edit User window, select the User tab and specify a username, password, default tablespace, and temporary tablespace for the user account. In the example below, the parameters include:

  • User Namedmuser
  • Password: Create a password of your choice
  • Default TablespaceUSERS
  • Temporary Tablespace: TEMP

Note: Your available tablespaces may differ if you are using an existing database that does not have the standard default tablespaces.

Show Screenshot for Step

D. Still in the Create/Edit User window, select the Roles tab and click the check box in the Granted Column forCONNECT.

Show Screenshot for Step

E. Still in the Create/Edit User window, select the Quotas tab and click the check box to set Tablespace toUnlimited (for the default tablespace).

Show Screenshot for Step

F. Click Apply to create the account.

Note: The Results tab displays the following:

Show Screenshot for Step

E. Click Close to dismiss the Create/Edit User window.

 

Create a SQL Developer Connection for the Data Miner User

In this topic, you create a SQL Developer connection for the data miner user.

You can create this connection either by using the SQL Developer Connections tab or the Data Miner tab. In either case, the same New / Edit Database Connection dialog box appears. All saved SQL Developer connections appears in both tabs.

Follow these steps to create a connection for the data miner user:

1 . In the SQL Developer Connections tab, right-click the Connections node and select New Connection from the pop-menu.

Show Screenshot for Step

 

2 . In the New / Select Database Connection dialog box, specify the following parameters:

  • Connection Name: dmuser
  • Username: dmuser
  • Password: Enter the password that you created for the data miner user
  • Connection Type: Basic
  • Role: default
  • Host Name: Enter the appropriate host name for your database server
  • Port: Enter the apropriate port number (1521 is the default)
  • SID: Enter the approriate value (orcl the default)

Note: If you wish to avoid prompts for passwords, you can select the Save Password option.

Show Screenshot for Step

 

3 . Still in the New / Select Database Connection dialog box:

A. Click Test to test the Connection.

Result: The Status prompt should display “Success!”

B. Click Connect.

Result: The SQL Developer Connections tab now displays both connections, like this:

Show Screenshot for Step

Note: When you activate a connection from the SQL Developer Connections tab, a SQL Developer Worksheet window automatically opens for that user.

 

4 . Close both the dmuser and admin Worksheet windows, like this:

Show Screenshot for Step

Next, you will install the Data Miner Repository.

 

Install the Data Miner Repository

At this stage, you have created a database account for the data miner user (dmuser), and have created a SQL Developer connection for that user. Next, you install the Data Miner Repository in the database using an automated process.

To accomplish this, you simply display the Oracle Data Miner tab ( which looks similar to the SQL Developer Connections tab), and then connect to the data miner user from the Data Miner tab.

Notes:

  • The Data Miner Repository installation routine automatically starts the first time that you activate a SQL Developer connection from the Data Miner tab.
  • Once the Data Miner Repository has been installed in the database, other data miner users may be granted the required privileges to the repository by an automated process that is similar to the installation routine examined here.

Follow these steps:

1. From the SQL Developer menu, select View > Data Miner > Data Miner Navigator, as shown here:

Show Screenshot for Step

Result: The Data Miner tab appears below the SQL Developer Connections tab.

Show Screenshot for Step

 

2. Dismiss the SQL Developer Connections tab by clicking the Close (X) icon, like this:

Show Screenshot for Step

Result: The Data Miner tab now appears directly below the SQL Developer main menu.

Show Screenshot for Step

 

3 . To begin the installation process of the Data Miner Repository:

A. Double-click on dmuser (and not the admin user).

Result: A message tells you that the Data Miner Repository is not installed in the database, and asks you if you want to install the Repository.

Show Screenshot for Step

B. Click Yes to launch the installation process.

 

4 . In the Connection Information dialog box:

A. Enter the Administrative password for the database.

Show Screenshot for Step

Note: You must be logged in as SYS to install the repository.

B. Click OK to continue.

 

5 . In the Repository Installation Settings dialog box:

A. Select the Default Tablespace and the Temporary Tablespace for the repository account named ODMRSYS.

Show Screenshot for Step

Notes:

  • The initial space requirement for the Data Miner Repository is 200MB; however, the tablespace grows as metadata is added.
  • In our example, we select the default values, which are USERS for Default Tablespace and TEMP for Temporary Tablespace.

B. Click OK to display the Install Data Miner Repository dialog box.

 

6 . In the Install Data Miner Repository dialog box:

  • The Install Demo Data option is preselected (the demo data is used by subsequent Oracle Data Miner OBE tutorials).

Show Screenshot for Step

A. Click Start to begin the repository installation.

Notes:

  • The Installation takes approximately 10 minutes for remote database installations and 2 minutes for local database installations.
  • The scroll bar provides a visual indication of the installation process progress, as shown below.

Show Screenshot for Step

B. When the installation completes, click Close to dismiss the dialog box.

 

You are now ready to perform data mining with the dmuser account. You can begin with the tutorial Using Oracle Data Miner 11g Release 2.

Summary

In this lesson, you learned how to set up the Oracle Data Miner graphical user interface for use within SQL Developer, version 3.0.

 

Reference: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/bidw/datamining/ODM11gR2-SetUp.htm

Oracle Data Miner

The free Oracle Data Miner GUI is an extension to Oracle SQL Developer 3.1 that enables data analysts to work directly with data inside the database, explore the data graphically, build and evaluate multiple data mining models, apply Oracle Data Mining models to new data and deploy Oracle Data Mining’s predictions and insights throughout the enterprise. Oracle Data Miner work flows capture and document the user’s analytical methodology and can be saved and shared with others to automate advanced analytical methodologies. oaaodmrgui

Oracle Data Miner creates predictive models that application developers can integrate into applications to automate the discovery and distribution of new business intelligence-predictions, patterns and discoveries—throughout the enterprise.   (To see details about the prior release of Oracle Data Miner,  Oracle Data Miner Classic, click here.)

Getting Started

Oracle Data Miner is comprised of three components:

  • Oracle Database 12c or Oracle Database 11 Release 2
  • SQL Developer (client) which bundles the Oracle Data Miner work flow GUI
  • Data Miner Repository – installed in the Oracle Database

Installation

Follow these steps to install Oracle Data Miner:

  • Step 1: Install Oracle Database 12c or Oracle Database 11Release 2
    • Download the software from Oracle Database Software Downloads athttp://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html.
    • To use Oracle Data Miner, you must connect to an Oracle database that satisfies these requirements:
      • The Oracle Data Mining option is installed. Oracle Data Mining is installed automatically when you install Oracle Database Enterprise Edition.
      • Oracle Text is installed. Oracle Text is installed automatically when you install Oracle Database Enterprise Edition.
      • Oracle XML DB is installed. Oracle XML DB is installed automatically when you install Oracle Database Enterprise Edition.
      • Data used by the cue card sets and the Oracle By Example tutorials requires the SH schema. If you install a starter database when you install Oracle Database Enterprise Edition, SH is automatically installed.
    • Chapter 2 of Oracle Data Miner Administrator’s Guide athttp://download.oracle.com/docs/cd/E11882_01/datamine.112/e16807/toc.htm describes how to install Oracle Database Enterprise Edition on Microsoft Windows. For instructions for other platforms, see the Installing and Upgrading section of the Documentation Library.
  • Step 2: Download the SQL Developer client from the SQL Developer Download site,  following the instructions provided at this site: SQL Developer.
  • Step 3: Install the Data Miner Repository by following the Oracle By Example “Setting Up Oracle Data Miner”
    Install Data Miner Repository

Release Notes

Oracle Data Miner Tutorials

Oracle by Example (OBE) tutorials provide hands-on, step-by-step instructions on how to implement various technology solutions to business problems.There are four OBE Tutorials:  Setting Up Oracle Data Miner,  Using Oracle Data Miner,   Star Schema Mining, and Text  Mining.   You can find them listed as a group in the  Learning Library.

Downloads

Reference: http://www.oracle.com/technetwork/database/options/advanced-analytics/odm/dataminerworkflow-168677.html