Oracle XE Client Connect to Other Server

After I install Oracle XE Client, i try to connect to another server, but I cannot. I look for tnsnames.ora, but i cannot find any on XEClient folder. I look for network/admin folder,but i not find too.

So I try to create a new one on $ORACLE_HOME/network/admin/
then create/copy SQLNET.ORA and TNSNAMES.ORA

After that i try using sqlplus and succesful, now, i can connect to other server using Oracle XE Client.

Here my SQLNET.ORA,
##########################
SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, ONAMES, HOSTNAME)

DEFAULT_SDU_SIZE = 8761
##########################

my TNSNAMES.ORA,
##########################
TESTSVR=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=192.168.0.1)
(PORT=1521)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=apps)
)
)
##########################

or if you are using sqlplus, in oracle 10g, you can use direct command
SQL> conn USERNAME/PASSWORD@HOSTNAME:PORT/SID

In that case you don’t need a tnsnames.ora. Only your sqlnet.ora need the following entry:
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT, HOSTNAME)

 

^_^

How to Faster Windows Vista Copy File Without Long Calculating Time

I experience poor slow copy file performance over the network in Windows Vista. After i googling, i found that “Remote Differential Compression” may cause of that.

Remote Differential Compression is a Windows feature introduced in Windows Server 2003 and is available on all later versions of Windows. This Windows feature is enabled by default in Windows Vista.

Remote Differential Compression (RDC) allows data to be synchronized with a remote source using compression techniques to minimize the amount of data sent across the network. RDC is different from patching-oriented differencing mechanisms, such as Binary Delta Compression (BDC), that are designed to operate only on known versions of a single file. BDC requires the server to have copies of all versions of the file, and differences between each pair of versions are precomputed so that they can be distributed efficiently from a server to multiple clients.

So to fasten, try follow this steps,

First, turn off “Remote Differential Compression”, go to Control Panel | Turn Windows features on or off, then find and uncheck “Remote Differential Compression”.

Next step, open a command prompt and type,

netsh interface tcp set global rss=disabled
netsh interface tcp set global autotuninglevel=disabled

Final step, restart computer

One vote can make a difference, One million votes could change the world

Usually we know Facebook as only social networking sites. As a place to show photos, reported status, exchange information, make friends and meet old friends, or place ads.

Now, Facebook function are growing one more, namely as a tool to garner support and can also be a means to make pressure on the parties in opposition to the will of the people.

This has been evidenced by the emergence of groups to support the two leaders of the Indonesia’s Corruption Eradication Commission (KPK) arrested by Police of the Republic of Indonesia on October 29, 2009. This group called the Movement of 1 Million Facebookers to Support Chandra Hamzah – Bibit Samad Riyanto (Gerakan 1.000.000 Facebookers Dukung Chandra Hamzah & Bibit Samad Riyanto). The day after Bibit-Chandra was arrested, this group was launched on Friday, October 30, 2009, ie 6 days ago from this post published. Since then, up to this day a total facebookers that join in this group had reached 790,884 members. As the name implies this group is targeting 1 million facebookers to support for Bibit-Chandra.

In the description of this group explains.
“Regardless of whether guilty or not, we who are outside the system may be disturbed by the incident for what happened to Chandra and Bibit. It is not possible in such cases is like an iceberg, as a child of nation loves the Commission. For that, lets us support the Chandra and Bibit in this group. We call Movement Supports One Million Facebookers Chandra and Bibit,Let’s tell all our friends, chasing a target of 1 million Facebooker.”

This movement was initiated by the Chairman of the Foundation Lembak Bengkulu, Usman Yasin. He also is one lecturer at the Muhammadiyah University Faculty of Agriculture, Bengkulu.

So? If you still think facebook functions only for friendship and fun? Or in your country ever used facebook to garner support? Hopefully this becomes a valuable lesson,

one vote can make a difference, one million votes could change the world.

At 9 p.m. on Tuesday, November 03, 2009, two deputy chairmen of the Corruption Eradication Commission (KPK) who were released from detention, Bibit Samad Rianto and Chandra M Hamzah. They left the National Police Headquarters at midnight.

Chandra and Bibit thanked the public who supported them and the KPK.

“Thank you to everyone who supports corruption eradication. We are very happy that Indonesian people still want the KPK to fight against corruption,” Chandra said.

Bibit and Chandra said their release was not a matter of winning or losing.

“Let’s take it as strong momentum to improve the fight against corruption, because in this situation, the loser is the country and the winner is the corruptor,” Chandra said.

Bibit added that they knew their friends were fighting to get them out of detention but that they did not know the public support would be so strong.

“The public support was amazing, we are overwhelmed. Justice has started to show its face,” Bibit said.

The men said they also hoped the fact finding team will be objective so that justice is served.

One of their unforgettable moments while in detention was when they met four corruptors they helped put in jail.

“We shook hands with them. They were friendly to us, no hard feelings at all,” Bibit said.

The Movement of One Million Facebookers Support Chandra Hamzah & Bibit Samad Riyanto

Please visit this facebook group, Gerakan 1.000.000 Facebookers Dukung Chandra Hamzah & Bibit Samad Riyanto a.k.a. The Movement of 1,000,000 Facebookers to support Chandra Hamzah & Seed Samad Riyanto, and leave your comment about lizard vs crocodile in my country, Indonesia. The police institution called himself as a crocodile to compare Corruption Eradication Commission a.k.a. KPK called a lizard.

The facts have proved that the police institution and the attorney general has failed to realize the ideals of our country, free from corruption and collusion. Therefore the initiative of the Head of State some time ago (when the government of Megawati Soekarnoputri) had been born with the hope of this commission, KPK. But now the light began to fade because of suspicions of manipulation is done systematically by the police and prosecutor  to weaken or to dwarf the KPK’s authority and then maybe they want to eliminate KPK.

The police arrested two suspended deputy commissioners of Indonesia’s powerful Corruption Eradication Commission or KPK. The two commissioners, Chandra Hamzah and Bibit Samad Rianto, were suspended from their positions in September,2009 after police named them suspects in a case in which they were accused of misusing their power by issuing travel bans on businessmen related to case Bank Century.Both men denied the charges, saying they had the right to issue travel bans under the 2002 law that set up the KPK. They had remained free, during which time their legal teams held news conferences saying the allegations against them were politically motivated.

The two men were considered the driving force behind the KPK’s successes. Earlier, the police had also held KPK’s chairman, Antasari Azhar, who was also as if there was manipulation scenario to arrest him.  How is it possible just to kill 1 person, an official need so many people are involved?

Tensions between police-prosecutor and the KPK intensified in July,2009 when a senior policeman was wiretapped by the KPK, according to people familiar with the matter. Indonesians regularly cite the police as one of the nation’s most corrupt institutions in polls.

As written in the latest edition of Tempo Magazine 6-12 July,  2009, in an interview rubric Susno answer questions about the parties that negatively prejudiced him, in the context of the wiretapping issue that was warm.

“… In comparison, the proverbial, here is crocodile, over there is lizard. The lizard want to against crocodiles?. Is crocodile angry? Nah, just sorry. The lizard still stupid. We had to make lizard smarter, but over many years lizard not smarter. and now lizard given power to find something that will not get anything” he said as quoted of Tempo Magazine.

And now, just you think if your beloved country has been rampant corrupt practices in every aspect of life. And then you have an institution can be expected, Indonesia’s Corruption Eradication Commission (KPK) which has been remarkably successful in eradicating corruption that can not be shown by police and prosecutors.

How embarrassing for the government of SBY, where during the campaign was always bragging about the eradication of corruption, but now? Now, the people of Indonesia stands behind lizard to fight against crocodile and its cronies, the police, prosecutor, parliament and president.

Who will win the battle,
LIZARD? crocodile?
CICAK? buaya?
people power? elite power?

How Can Fix Blogspot Error Code bX-9d2teg ?

Some problem i found, my blog at pandazenwi.blogspot.com, the first page can show, but when i try to sign in i got this error,

We’re sorry, but we were unable to complete your request.

When reporting this error to Blogger Support or on the Blogger Help Group, please:

* Describe what you were doing when you got this error.
* Provide the following error code and additional information.

bX-9d2teg
Additional information
host: www.blogger.com
uri: /home

This information will help us to track down your specific problem and fix it! We apologize for the inconvenience.
Find help

See if anyone else is having the same problem: Search the Blogger Help Group for bX-9d2teg
If you don’t get any results for that search, you can start a new topic. Please make sure to mention bX-9d2teg in your message.

Is Blogspot hacked or just some internal server problem?

I can only hope that blogspot team can handle this, keep good work it out. Bless you all.

How Can Fix Blogspot Error Code bX-59cppw ?

Today, when i want to visit my another blog http://tanganmulut.blogspot.com, i got this page showing some error messages,

We’re sorry, but we were unable to complete your request.
When reporting this error to Blogger Support or on the Blogger Help Group, please:

• Describe what you were doing when you got this error.
• Provide the following error code and additional information.

bX-59cppw

Additional information
host: tanganmulut.blogspot.com
uri: /
This information will help us to track down your specific problem and fix it! We apologize for the inconvenience.
Find help

See if anyone else is having the same problem: Search the Blogger Help Group for bX-59cppw
If you don’t get any results for that search, you can start a new topic. Please make sure to mention bX-59cppw in your message.

I have search over internet, but i cannot find any solution. Anyone can help me, please…..

How to install Ruby On Rails running Xampp on Windows (hello world, Ruby!)

Hohoi…i’m so interested to write a post on my struggles to get my first Ruby on Rails work on Windows.
Thanks to internet which provided so many Guru who want to share their knowledge and skills.
Finally, this was a lot simpler than i had figured.
You may install Apache2 on windows or you may use some Apache2 install packages.
I picked XAMPP beside AppServ, Apache2Triad, WAMP just because i like packages included on it.
So here some step that i use,

1. install Xampp from ApacheFriends (http://www.apachefriends.org/en/index.html),
for a simpler download (http://www.apachefriends.org/download.php?xampp-win32-1.6.6a-installer.exe).
I install Xampp at c:\xampp

2. install Ruby (ruby186-26.exe or new version) from RubyForge ((http://rubyforge.org/projects/rubyinstaller/),
download an easy one-click Ruby installer, a self-contained installer that includes the Ruby language,
dozens of popular extensions, a syntax-highlighting editor and the book “Programming Ruby: The Pragmatic Programmer’s Guide

3. install Rubygem (rubygems-0.9.5.zip or new version) from RubyForge (http://rubyforge.org/projects/rubygems/)
tract it and then run ruby setup.rb

4. install Rails

gem update
gem install rails –include-dependencies

The install could take minutes which will show you like this message,
Bulk updating Gem source index for: http://gems.rubyforge.org

If you encounter an error like this,

Updating installed gems…
ERROR: While executing gem … (Gem::RemoteFetcher::FetchError)
getaddrinfo: no address associated with hostname.(SocketError)

then you must make sure you have internet connection
or may be your are behind a firewall.

When you don’t have internet at home or at office, then you will need
to go to a netcafe and download some files separately from rubyforge gems
(http://rubyforge.vm.bytemark.co.uk/gems/)

The following files need to download,
a. actionmailer
b. actionpack
c. actionwebservice
d. activerecord
e. activesupport
f. rails

Next, install it one by one,
gem install activesupport
gem install activerecord
gem install actionwebservice
gem install actionpack
gem install actionmailer
gem install rails

5. create a rails application
i create it at C:\xampp\htdocs\FirstProject, so run
rails -d mysql C:/xampp/htdocs/FirstProject

6. open C:\xampp\apache\config\httpd.conf file in a text editor,
scroll to the bottom and add the following,

#################################
Listen 3000
LoadModule rewrite_module modules/mod_rewrite.so

ServerName rails
DocumentRoot “c:/xampp/htdocs/FirstProject/public”
<Directory "c:/xampp/htdocs/FirstProject/public/"

Options ExecCGI FollowSymLinks
AllowOverride all
Allow from all
Order allow,deny
AddHandler cgi-script .cgi
AddHandler fastcgi-script .fcgi

#################################

7. start server with run this command,
cd c:/xampp/htdocs/FirstProject
ruby script\server

8. run the following at the command-line to keep from getting an “Unknown database” error,
rake db:create

10. make sure your connection to mysql can connect with right user and password,
set C:\xampp\htdocs\FirstProject\config\database.yml

11. to use Rails without a database, open C:\xampp\htdocs\FirstProject\config\environment.rb,
find the commented out line that reads,
# config.frameworks -= [ :active_record, :active_resource, :action_mailer ]
remove the comment and you must remove the Active Record framework

Rails is a MVC (Model View Controller) framework, so all the output will happen in the controllers and views.

12. generate a controller named “hello” with an action “index”
ruby generate controller hello index

If you browsing to http://localhost:3000/hello, you will get
Hello#index
Find me in app/views/hello/index.html.erb

That message occurs because an action after “hello” doesn’t specified,
rails then search the “index” action and a view for this action doesn’t created too.

13. open the controller file at C:\xampp\htdocs\FirstProject\app\controllers\hello_controller.rb

Any public methods in a controller become actions in Rails. Notice the index action.
Add the following method just before end of file,

def world
@greeting = “hello world!”
end

The “@” sign lets views access the variable.

12. When browse to http://localhost:300/hello/world,
we have error like this,
Template is missing
Missing template hello/world.html.erb in view path C:/xampp/htdocs/FirstProject/app/views

13. “Template” is Rails word for the “View”. So Rails expecting the template at the path listed. Create or edit C:\xampp\htdocs\FirstProject\app\views\hello\world.rhtml, add the following text,

Try again, browse http://localhost:3000/hello/world and voila, “hello world, Ruby!”

Happy Rails developing and if you have any other learning resources that you’d like to share, please leave them in the comments!

Life is Now

In a time of the Buddha taught the Dhamma to his students with the most beautiful sentence. This sentence is very realistic, but to realize it may be very difficult.

“The past is a memory,
the future is a plan that might not happen.
Life is now ”

A lot of people who feel uneasy, many This anxiety arises because of ignorance of what will happen, because of attachment to the current conditions such as fear of losing their jobs, wealth, relationships and so on.

For the many who often consults for fortune-tellers, astrologers, shamans and so on. Not certain that the person consulted really can predict, some are just cheating to get money. Such cases, as we’ve heard the news in various media. But there are still tempted to look for shortcuts. Well, there are also proved able to predict that produce satisfaction for that person. Then the question, whether the future people will not worry anymore? Next what he would do if it felt anxious again?

Besides worrying about the future, there are also people who always regretted what had passed, was not satisfied with what has happened so that life was always overshadowed his past which would hinder his progress.

Life right now is trying to make this time as the quality of life. Someone at this moment should be tried in a maximum in the act, speak and think. Life today does not mean refusing the future or the past.

That future should be guidelines or purpose in life is achieved by improving the quality of life and business at this time. The past should also be accepted as it is, better or worse to be a lesson and corrected in the present. Thus, the present or current is crucial for the best act in order to improve the past and build a bright future.

If we do not understand that sentence will display the wrong view of Buddhism. Live today as if directed only to live resigned, hopeless, empty, just accept what is there. This phrase is often misconstrued by those who interpret not understand the teachings of Buddhism. So that a view that buddha was pessimistic religion, there is no passion, decrepit, empty.

Indeed the Buddha and Arya students had instructed, “live is now” but that does not mean Buddhism does not teach about the mission and vision. When asked why the noble creatures who have developed the mind, they seem so on and shine? The Buddha replied,

“They’re not sad in the past,
they do not pursue what is yet to come.
now is simply enough for them
hence they do shine. “

“Missing the future,
regret the past,
This way the fool languish
like a weed that was burned.”

Remember that,
today is the child of the past, and the father of the future.
Yesterday is history, tomorrow’s just a daydream.

Today well lived makes every yesterday a beautiful history, and every tomorrow a vision of hope and happiness. Everything that exists in this world is not eternal, so try earnestly. Live this day well.

The recipes of happy and successful life lies in what is done at this moment, we do not worry in the past and the future. We can not go back in time to fix what we have done in the past, and we also can not be sure what’s happening in the future. Because the condition of the world constantly changing, so there is only one moment that can be consciously controlled to apply correctly this is the moment.

Such prescriptions have been transmitted through the Dhamma by the Buddha. May this recipe is always practiced in everyday life. The medicine will be useless if we only have it. Have the medicine and swallow it and you will soon recover from the disease. Hopefully this summary useful for us all.
Sadhu…! Sadhu …! Sadhu… !

Crocodiles and Lizards from the Ramu River – Lizard vs Crocodile of Indonesia

When I search the web for lizard vs crocodile, I am interested in one of the search results, namely the origin story of the lizard and crocodile. My first reason i search “lizard vs crocodile” because in Indonesia revealed that the anti-corruption practices are facing a big test.

The lizard will be crippled by a crocodile and his friends. KPK (Indonesia’s anti-corruption commission) is the lizard. Polri (Indonesia’s Police) are crocodile. Crocodile was now also supported other crocodile species, ie judiciary, parliament and also president. Very, very embarrassing. But the lizard is still getting support from the public of anti-corruption. May the lizard still alive on Earth of Indonesia, if not “what the world say”?

perang cicak vs buaya

Below is the story of the people of Papua New Guinea from “One Thousand One Papua New Guinean Nights: Tales from 1986-1997″

Crocodiles and Lizards Came from the Ramu River

Long, long ago, in the Ramu River, there were no crocodiles or lizards. Everyone lived well there. In a village called Nodubu [Nodabu], there lived a man, his wife and their two sons [Nokopo People, Madang Province]. The boys’ names were Nronari and Mambokuri

One time, a big famine arose on the Ramu and every one was hungry, Nronari and Mambokuri’s parents thought hard. They thought that it would be bad if the two children died from hunger.

One day, the boys’ parents decided to put them inside baskets to sleep and drift along the Ramu River.

While the boys were playing outside the house, their parents carefully arranged their sleeping baskets so that the water would not enter.

Late at night, when everyone in the village was asleep, the parents took the boys and their baskets. They went down to the Ramu River and put them in the water. The water carried the boys downstream.

In the morning, the boys’ baskets stuck to a tree by  the river. Nronari felt very cold, so he awoke. He went out of the basket and saw that Mambokuri’s basket was nearby. He awakened his little brother. Then they followed the tree and went up by the side of the water. Mambokuri asked Nronari, “Where are we now?” Nronari replied, “I don’t know, but I think that Papa and Mama did this to us.”

The little boys sat by the side of the water for a long time, until the sun rose completely. Later, Mambokuri said, “Hey Nronari, go back down and get [your] rattan sleeping basket.” He fetched it and came up. Then he rubbed it in the middle of a tree and a fire arose.

Mambokuri took some wood and they made a big fire. Later, Nronari climbed a breadfruit tree. He gathered many breadfruits. He brought them down, and then they cooked and ate them.

Many breadfruits were ripe, so they did not finish eating them. The two boys began play fighting, shooting each other with the breadfruits.

Nronari jumped down to the Ramu River and Mambokuri stayed up by the side of the water. They played at shooting each other, and then their bodies began to change. Nronari’s legs became like that of a crocodile. His buttocks lengthened and became like that of a crocodile’s tail.

The same thing also happened to Mambokuri. His legs and buttocks became like the legs and tail of the lizard used for hand drums. After they had shot each other with all of the ripe breadfruits, Nronari told Mambokuri, “That’s good. You can stay up there and I’ll stay in the water.”

Mambokuri replied, “That’s alright. You can watch from the river and I can watch from the trees.”

After they finished speaking, their bodies change completely and they became a crocodile and lizard entirely.

Now we can see many crocodiles and lizards thar are used for hand drums in the Ramu River. This is because they came from these two brothers, Nronari and Mambokuri.

Jimbegim of Viutobua Village, by the Ramu River, told this story.

Otto G. Ume
Kwalakessi Village
Hoskins
West New Britain Province

staticports.ini

When installing Oracle Application Server 10g Release 2 (10.1.2.0.2) you can control the ports configuration using staticports.ini.

A sample default staticports.ini show below,

# staticports.ini - default
# J2EE and HTTP Server
Oracle HTTP Server port = 7777
Oracle HTTP Server Listen port = 7777
Oracle HTTP Server SSL port = 4443
Oracle HTTP Server Listen (SSL) port = 4443
Oracle HTTP Server Diagnostic port = 7200
Java Object Cache port = 7000
DCM Discovery port = 7100
Oracle Notification Server Request port = 6003
Oracle Notification Server Local port = 6101
Oracle Notification Server Remote port = 6200
Application Server Control port = 18100
Application Server Control RMI port = 18140
Oracle Management Agent port = 18120
Log Loader port = 44000
ASG port = 7890

# Infrastructure
Oracle Internet Directory port = 13060
Oracle Internet Directory (SSL) port = 13130
#Oracle Certificate Authority SSL Server Authentication port = port_num
#Oracle Certificate Authority SSL Mutual Authentication port = port_num

Enterprise Manager Console HTTP Port (orcl) = 5500
Enterprise Manager Agent Port (orcl) = 1830

# OracleAS Metadata Repository: Installation Port = 1521

Oracle – No Response from Application Web Server

* Today my Oracle Application Server give me this message
No Response from Application Web Server

There was no response from the application web server for the page you requested.
Please notify the site’s webmaster and try your request again later.

* I have restart OracleOraFRSHomeProcessManager service many times, but always have same message.

* I try to start OracleOraFRSHomeASControl, it started but same message on the screen,
when i run manually, D:\OraFRSHome\opmn\bin>nmesrvc.exe, i got this message
“StartServiceCtrlDispatcher failed with err 1063.”

* Then i also run manually using command line opmnctl startall, and the problem have a little bit clue, here :
opmnctl: starting opmn and all managed processes…
===================================================================

opmn id=achilles:6200
0 of 1 processes started.

ias-instance id=itcapps10.achilles
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

ias-component/process-type/process-set:
HTTP_Server/HTTP_Server/HTTP_Server

Error
–> Process (pid=2992)
failed to start a managed process after the maximum retry limit
Log:
D:\OraFRSHome\opmn\logs\HTTP_Server~1

* So i look at D:\OraFRSHome\opmn\logs\HTTP_Server~1, many lines fill with this messages,

09/10/02 13:40:32 Start process
——–
fopen: No such file or directory
Apache.exe: could not open document config file d:/orafrshome/uix/uix.conf

* Now i know that d:/orafrshome/ no folder named uix, and no file named uix.conf

* Then i copy file from another Oracle Application Server and paste, then start opmn again and the server is up again.
Hmmmmm………….Maybe my harddisk has corrupt, ohhh.!!!!

Bizarreness / Oddity of START WITH … CONNECT BY in Oracle SQL

Usually, the “start with .. connect by” clause can be used to select data that has a hierarchical relationship (usually some sort of parent->child (boss->employee or thing->parts). For example, see this data hierarchical :

000
    001
        100
            110
                111
                112
    002
        200
        250
    004
999

then the sql scripts like this :
create table tmp_test_connectby (
ORG_ID varchar2(3 byte),
org_parent varchar2(3 byte),
constraint c01 unique (org_id)
);

insert into tmp_test_connectby values (‘000′, null);
insert into tmp_test_connectby values (‘999′, null);

insert into tmp_test_connectby values (‘001′, ‘000′);
insert into tmp_test_connectby values (‘002′, ‘000′);
insert into tmp_test_connectby values (‘004′, ‘000′);

insert into tmp_test_connectby values (‘100′, ‘001′);
insert into tmp_test_connectby values (‘110′, ‘001′);

insert into tmp_test_connectby values (‘111′, ‘110′);
insert into tmp_test_connectby values (‘112′, ‘110′);

insert into tmp_test_connectby values (‘200′, ‘002′);
insert into tmp_test_connectby values (‘250′, ‘002′);

commit;

select lpad(‘ ‘,2*(level-1)) || to_char(org_id) s
from tmp_test_connectby
start with org_parent is null
connect by prior org_id = org_parent;
———————————————
From here, if i want to get result

002
    200
    250

i run this sql,
SELECT org_id
FROM tmp_test_connectby
WHERE org_id IN (
SELECT org_id
FROM tmp_test_connectby
WHERE org_id = :b1
UNION ALL
SELECT org_id
FROM tmp_test_connectby
CONNECT BY org_id = org_parent
START WITH org_parent IN (
SELECT org_id
FROM tmp_test_connectby
WHERE org_id = :b1
UNION ALL
SELECT org_id
FROM tmp_test_connectby
CONNECT BY org_id = org_parent
START WITH org_parent = :b1))
ORDER BY org_id;

but when i make an update to record like this
update tmp_test_connectby
set org_parent = ‘999′
where org_id = ‘999′;

and run this again,
SELECT org_id
FROM tmp_test_connectby
WHERE org_id IN (
SELECT org_id
FROM tmp_test_connectby
WHERE org_id = :b1
UNION ALL
SELECT org_id
FROM tmp_test_connectby
CONNECT BY org_id = org_parent
START WITH org_parent IN (
SELECT org_id
FROM tmp_test_connectby
WHERE org_id = :b1
UNION ALL
SELECT org_id
FROM tmp_test_connectby
CONNECT BY org_id = org_parent
START WITH org_parent = :b1))
ORDER BY org_id;

then you may have your database memory consume to nothing,
you may got this error too :

ORA-04030: out of process memory when trying to allocate 80 bytes (kxs-heap-w,cursor work heap)
ORA-04031: unable to allocate 8224 bytes of shared memory…

so be carefull about using “START WITH … CONNECT BY”, if something wrong, check your data

Oracle/PLSQL Check-Unique Constraint / Index

Oracle constraints are used to enforce database integrity (enforce table rules and prevent data dependent. It can be used to enforce business rules.

Generally, there are 5 types of constraints (PUNCR) in the Oracle, ie:
* Primary Key (Type P)
* Unique (Type U)
* Not Null (Type N)
* Check (Type C)
* Foreign Key (Referential – Type R)

But I want 1 more type that use check and then unique, so i can be called Oracle Check-Unique Constraint. So I googling around and I did not find even one article that discusses it.

And then with the advice of my partner, Hendra Ong, by using the unique index this can be done.

So here, my problem
I want table TRD_COLLECTION have validation
if status = ‘3′ and pay_type =’C’ then must be use unique on these columns (ORG_ID, AGREEMENT_ID, PAY_TYPE)
and if status ‘3′ then no unique.

and the solution
CREATE UNIQUE INDEX TRD_COLLECTION_T01 ON TRD_COLLECTION
(CASE WHEN STATUS = ‘3′ AND PAY_TYPE = ‘C’ THEN
ORG_ID || AGREEMENT_ID || PAY_TYPE
ELSE
NULL
END)
TABLESPACE TMP_IDX

Any suggestions on that would be acceptable.

The Mystery of Number 9

Let’s play with to find some mystery

1. Numbers in each multiplication of nine, when added together the end result is always nine
example:
1 x 9 = 9 —> 9
2 x 9 = 18 —> 1 + 8 = 9
3 x 9 = 27 —> 2 + 7 = 9
4 x 9 = 36 —> 3 + 6 = 9
5 x 9 = 45 —> 4 + 5 = 9
10 x 9 = 90 —> 9 + 0 = 9
etc. …

This also applies even to a complex multiplication.
sample (random):
638 x 9 = 5742 —> 5 + 7 + 4 + 2 = 18 —> 1 + 8 = 9
23477 x 9 = 211293 —> 2 + 1 + 1 + 2 + 9 + 3 = 18 —> 1 + 8 = 9
etc. …

2. Each number is not divisible by nine, then the numbers behind the comma the results will be repeated
example:
8 / 9 = 0.88888888888888………
23 / 9 = 2.55555555555555………
56768231 / 9 = 6307581.22222222………

3. Multiplication with the number that composed of the same digit
example:
33 x 9 = 297 —> 3 x 9 = 27 put 9 (1 times) in the middle of 2 and 7, so the result 297
444 x 9 = 3996 —> 4 x 9 = 36 put 9 (2 times) in the middle of 3 and 6, so the result 3996
5555 x 9 = 49995 —> 4 x 9 = 36 put 9 (3 times) in the middle of 4 and 5, so the result 49995
etc. …

4. If 12345679 (remember without the number multiplied by 1-9 multiples of 9 then the result must contain the numbers over and over
example:
12345679 x 9 = 111111111
12345679 x 18 = 222222222 —> 12345679 x 9 x 2
12345679 x 27 = 333333333 —> 12345679 x 9 x 3
12345679 x 36 = 444444444 —> 12345679 x 9 x 4
.
.
.
12345679 x 81 = 999999999 —> 12345679 x 9 x 9

That’s all, maybe next time i will add some more fun with 9. Cheers.

Six of Nines

teng… teng… teng… 09/09/09 09:09:09
let’s play with this time

9*9*9*9*9*9=531441 => 5+3+1+4+4+1=18 => 1+8=9
9+9+9+9+9+9=54     => 5+4=9
9-9-9-9-9-9=-36    => -3-6=-9
9/9/9/9/9/9        => 0.000152415(9 digit decimal)    => 0+0+0+1+5+2+4+1+5=18 => 1+8=9

what will happen?

iPhone Killer from Nokia

Nokia 5800 Xpress Music Tube

Next episode will be Nokia 5900 to be iPhone Killer “the next generation” (or just rumor). This rumor could prove to be false though since the source is from China, and we know just how many cloned handsets have made their way there to date. But i may hope there will be another successor to the Nokia 5800 XpressMusic.

Here some picture about it,

Change MySQL root password

1. use command line by going to the Start Menu > Run and typing cmd
2. change your directory to wherever you installed mysql to:
C:\> cd C:\mysql\bin
3. open mysql command line:
C:\mysql\bin> mysql -u root mysql
4. reset a new password:
mysql> SET PASSWORD FOR root@localhost=PASSWORD(‘pandazen’);
where “pandazen” is the new password you want to use

Nokia Hidden Code Tips

Here some useful Nokia secret code

*#0000#    – Check phone software version
*#06#          – Phone IMEI, more information on IMEI codes.
*3370#       – Activate Enhanced Full Rate Codec (EFR) – Your phone uses the best sound quality but talk time is reduced my approx. 5%
#3370#      – Deactivate Enhanced Full Rate Codec (EFR)
*#7370#* – To Reset phone

Nokia 5800 Software

I bought Nokia 5800 XM for Rp. 3.435.000,- (USD 338,4) on August 21, 2009.

I am a bit disappointed because i got some stuff not included on my nokia 5800 package. Is this the new package for new Nokia 5800 that do not included
- one backup stylus
- kickstand
- slip case
- TV-Out cable ? Hmm….. how unfortunate i am.

But it’s time for me to hunt software application to have fun with this tube.

Some useful Nokia Tips and Tricks

1. Opera Mini
2. Nimbuzz
3. Google Maps Go to this link directly from your mobile phone.
I had try it but there is a problem. For there further information, keep looking some fix from

Google Mobile Help

4. Mobile Paint
5. Handwriting Calculator
6. Y-Browser (File Manager)
7. ..

Here some list link to another stuff for Nokia 5800 XM (Tube 5800)

Applications from Nokia

SoftArchive.net

S60 5th Edition Freeware Downloads for Nokia 5800

http://www.bitsforfree.eu/5800_list.html

http://www.symbianthemes.us/nokia_5800_xpressmusic

http://sjc-nokia5800.blogspot.com/

http://www.getjar.com/software/Nokia/5800_XpressMusic

Show hidden folder in Windows

Yesterday, I called by friend complained that folder in the computer can not even show after edit option in the “folder option” | “show hidden files and folders”.

So here some solution i found after googling,

- open registry using regedit
- find key “HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced“
change “Hidden” key value to 1
- test it, if folder can’t show yet
find key “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\
Advanced\Folder\Hidden\SHOWALL“
change “CheckedValue” key value to 1
- check again, if can’t show yet
try to unregister two .dll file from “Start” | “Run”
type regsvr32 /i browseui.dll, press OK
type regsvr32 /i shell32.dll, press OK
- after above step, the computer should show hidden folder
if it can’t show, maybe your computer had been infected by some virus.
Use antivirus to scan and fix your operating system to normal condition

(^_^)