OraNA :: Oracle News Aggregator

I often use "ssvnc" to connect my servers to install or do something about X. Anyway, I must to start VNC before by using "vncserver".

[surachart@oralearning ~]$ vncserver

New 'oralearning:1 (surachart)' desktop is oralearning:1

Starting applications specified in /home/surachart/.vnc/xstartup
Log file is /home/surachart/.vnc/oralearning:1.log

[surachart@oralearning ~]$

I ended (more...)

I have used APEX 4.2.2. I was unable to logon my APEX with INTERNAL workspace as admin. It showed "The account is locked".
What was I able to do? ... run "apxchpwd.sql" script. I didn't think so. After checking in "apxchpwd.sql" script.
So, I checked (more...)

I have a chance to read a book - Hadoop Real-World Solutions Cookbook(Thank you ^______^). It pops up in my head, why I have never tested about Sqoop. As you know sqoop is a tool designed for efficiently transferring bulk data between Apache Hadoop and structured datastores such as (more...)

Today, I have a chance to review a good book about Oracle Database - Managing Multimedia and Unstructured Data in the Oracle Database by Marcelle Kratochvil.

Author, she is CTO and co-founder of Piction, an Oracle PL/SQL based app that allows for the delivery of Images on the internet. Marcelle (more...)

I was interested in how to do twitter streaming. I tried to find out on the internet and got many examples. I tested it with python code(tweepy). I got data in JSON format. I thought it's a good idea, if I was able insert this data into mongodb.
(more...)

Interactive Data Visualization for the Web An Introduction to Designing with D3 By Scott Murray.
This book was written about programming data visualization for non-programmer. You're able read this book and use it, even through you have no experience working with data or code.
This book will introduce you to (more...)

MongoDB is document-oriented database management system and supported by 10gen. Anyway, I was writing about a book, that's MongoDB Applied Design Patterns Practical Use Cases with the Leading NoSQL Database By Rick Copeland.

A book will guide you how to do the connection between MongoDB and the business problem it's (more...)

I had a chance to install CouchBase (Learned Couchbase - Just installed it). I definitely believe it's easy for installation and you can learn by yourself.
As you know, CouchBase Server is a NoSQL document database for interactive applications that has a flexible data model, is easily scalable, provides consistently high performance, and is “always on”, 24*7*365.
For developers, you can use Java, .NET, PHP, Ruby, C and Python. However, you should know how to connect CouchBase, how to store and retrieve the information
from the database and etc. So, I mention book - Developing with Couchbase Server (more...)

As you know, Couchbase is the open source NoSQL database for interactive web and mobile applications. I plan to read a book about Developing with Couchbase Server. First of all, I had to install it. I chose "Community Edition" for my test. If you will implement it you can choose Enterprise Edition and read more.
- Installed in on my host (centos):

[surachart@centos ~]$ wget --continue http://packages.couchbase.com/releases/2.0.0/couchbase-server-community_x86_64_2.0.0.rpm
--2013-02-10 14:46:14--  http://packages.couchbase.com/releases/2.0.0/couchbase-server-community_x86_64_2.0.0.rpm
Resolving packages.couchbase.com... 207.171.187.117
Connecting to packages.couchbase.com|207.171.187.117|:80... (more...)

I have a chance to review Oracle CRM On Demand Administration Essentials by Padmanabha Rao and Venkatesan Sundaram.
First of all, What is Oracle CRM On Demand?  It's Oracle Service, that you access over the Web. Oracle CRM on Demand help you to manage all your company’s sales, customer service, and marketing information. All pages in Oracle CRM On Demand share the same basic, interface framework. You can change the background color, hyperlink color, and so on by selecting a theme in your personal profile. OK! come back to a book that I want to review. This book will (more...)

As you know views are virtual tables. When you use view you might see the missing information problem and the view updating problem.There are interesting for learning.If you are someone who is interested in SQL and Relational Theory, Database Design and Relational Theory. I believe this book that is helpful for you to understand more about solving the view update problem.
View Updating and Relational Theory Solving the View Update Problem By C.J. Date.
This book is the third in a series. Its predecessors were as follows:
- SQL and Relational Theory: How to Write Accurate SQL (more...)

After I read a few document about Oracle Linux. I thought I should learn something new today. I didn't have much time. Maybe 30 minutes! So, I started to read a little about mongodb, then  download binary from web. I thought it's cool for installation it.

[surachart@centos ~]$ curl http://downloads.mongodb.org/linux/mongodb-linux-x86_64-2.2.2.tgz > mongo.tgz
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 53.3M  100 53.3M    0     0   163k      0  0:05:35  0:05:35 --:--:--  219k
[surachart@centos ~]$ tar zxf mongo.tgz
[surachart@centos (more...)

I found Oracle Linux 5.9 post. After I heard Red Hat Enterprise Linux 5.9 GA Announcement last week. However, I pointed to Oracle Linux. I had to upgrade my test system.
You can read Oracle Linux 5.9 Release Notes and you can upgrade by using yum command-line.

[root@linux ~]# rpm -qf /etc/oracle-release
oraclelinux-release-5-8.0.2

[root@linux ~]# uname -r
2.6.39-100.5.1.el5uek
[root@linux ~]#
[root@linux ~]# cd /etc/yum.repos.d

[root@linux yum.repos.d]# wget http://public-yum.oracle.com/public-yum-el5.repo
--2013-01-17 10:38:40--  http://public-yum.oracle.com/public-yum-el5.repo
Resolving public-yum.oracle.com... 141.146.44.34
Connecting (more...)

It's not something new with message "[Errno 4] IOError: <urlopen error> ". When you found with this error message. You might regenerate the metadata cache again. For my issue, 'Yes'! it's fixed after doing it.

[root@linux yum.repos.d]# yum update yum
Loaded plugins: rhnplugin, security
This system is not registered with ULN.
ULN support will be disabled.
http://public-yum.oracle.com/repo/OracleLinux/OL5/9/base/x86_64/repodata/primary.xml.gz: [Errno 4] IOError: <urlopen error>
Trying other mirror.
Error: failure: repodata/primary.xml.gz from ol5_u9_base: [Errno 256] No more mirrors to try.
[root@linux yum.repos.d]# yum clean all && yum clean metadata && yum clean (more...)

What is R programming language? R is an open source programming language and software environment for statistical computing and graphics. The R language is widely used among statisticians and data miners for developing statistical software and data analysis. R is an implementation of the S programming language combined with lexical scoping semantics inspired by Scheme. You can download R from R-Project.
What is R Graphics Cookbook book? The R graphics Cookbook (Practical Recipes for Visualizing Data) book by Winston Chang provides more than 150 recipes to help you generate high-quality graphs quickly, without having to comb through all the details (more...)

Strata offers the informations of building a data driven business, product or career. You will see conferences, webcasts, books and etc. If you work with data... there is helpful. I meant informations what you can catch.
Strata Conference New York + Hadoop World 2012 was interesting. Audiences could see many sessions: keynotes and tutorials. Unfortunately, you missed or couldn't this conference. You can buy the Complete Video Compilation - Strata Conference New York + Hadoop World 2012: Complete Video Compilation Tools and Techniques That Make Data Work By O'Reilly Media, Inc.
You will see videos over 106 hours 53 (more...)

 Nothing much for this post. I just needed to keep information in my blog. After I installed hadoop (rpm). I had started namenode & datanode, bit had an issue about jobtracker. When I started it. It showed error - FATAL mapred.JobTracker: ENOENT: No such file or directory.

-bash-4.1$ hadoop jobtracker &
[1] 14455
-bash-4.1$ 13/01/04 20:07:30 INFO mapred.JobTracker: STARTUP_MSG:
/************************************************************
STARTUP_MSG: Starting JobTracker
STARTUP_MSG:   host = centos/192.168.111.80
STARTUP_MSG:   args = []
STARTUP_MSG:   version = 1.1.1
STARTUP_MSG:   build = https://svn.apache.org/repos/asf/hadoop/common/branches/branch-1.1 -r 1411108; compiled by 'hortonfo' on Mon Nov 19 (more...)

A cqlsh is CQL Shell for Apache Cassandra. So, I was just curious what I see with "cassandra-cli" command, if I inserted data by using "cqlsh".
- Use "cqlsh" command.

[surachart@centos apache-cassandra-1.2.0]$ ./bin/cqlsh
Connected to Test Cluster at centos:9160.
[cqlsh 2.3.0 | Cassandra 1.2.0 | CQL spec 3.0.0 | Thrift protocol 19.35.0]
Use HELP for help.
cqlsh> CREATE SCHEMA demo WITH replication = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };
cqlsh> use demo;
cqlsh:demo> show tables;
Improper show command.
cqlsh:demo> CREATE TABLE users (
        ...                    user_id varchar PRIMARY (more...)

I began with Cassandra again today. However, i tried to practice from a book and found error - org.apache.cassandra.db.marshal.MarshalException: cannot parse '...' as hex bytes

[default@MyKeyspace]
[default@MyKeyspace] create column family users;
e931ab3d-4e46-3e13-9c7e-002ee5b8d1d4
[default@MyKeyspace] set users['opun']['fname']='Surachart';
org.apache.cassandra.db.marshal.MarshalException: cannot parse 'fname' as hex bytes
[default@MyKeyspace]
[default@MyKeyspace] describe;
Keyspace: MyKeyspace:
  Replication Strategy: org.apache.cassandra.locator.NetworkTopologyStrategy
  Durable Writes: true
    Options: [datacenter1:1]
  Column Families:
    ColumnFamily: users
      Key Validation Class: org.apache.cassandra.db.marshal.BytesType
      Default column value validator: org.apache.cassandra.db.marshal.BytesType
(more...)

Last post, I tested Cassandra Installation. However, It was only standalone. I thought how to use it as Multinode. With last configuration. I set them up as: (I was lazy to change hostname)

centos 192.168.111.80
centostest1 192.168.111.81

On "centos": (first node)
Note: Don't forgot to check iptables rule :)
- Checked hosts file.

[surachart@centos apache-cassandra-1.2.0]$ cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.111.80  centos  centos.surachartopun.com
192.168.111.81  centostest1 centostest1.surachartopun.com

(more...)