Wijaya Kusumo
![Subscribe to Wijaya Kusumo feed](http://www.orafaq.com/misc/feed.png)
keep learning and explore the unknownWijaya Kusumohttp://www.blogger.com/profile/07788309628385463226noreply@blogger.comBlogger19125
Updated: 9 hours 16 min ago
"conn / as sysdba" on Windows
We can do the following when we want to connect to Oracle db using "conn / as sysdba" in *nix environment:% export ORACLE_SID=ORCL% sqlplus /nolog% conn / as sysdbaNot a big deal. However, I got the following doing the same on Windows XP:C:\>set ORACLE_SID=ORCL
C:\>sqlplus /nologSQL*Plus: Release 10.2.0.4.0 - Production on Tue Sep 29 16:08:51 2009Copyright (c) 1982, 2007, Oracle. All Rights
Tune up your JDeveloper
JDeveloper is slow, or is it? I'm using Oracle JDeveloper 11g - Technical Preview (Studio Edition Version 11.1.1.0.0), and it was incredibly slow. Opening project, drawing database diagram, switching between application, etc are really testing my patient.
I'm using a pretty good notebook: Win XP, dual core processors, 2 GB RAM, and plenty of HD space. After a few searches here and there, the
: bad interpreter: No such file or directory
When I run a bash script, it gives the following error:
: bad interpreter: No such file or directory
It turn out that the carriage return was not properly converted to *nix format, since it was written using Notepad in Windows.
Quick fix:
$ dos2unix filename -- convert to *nix format
$ unix2dos filename -- convert to Windows/DOS format
Start OC4J with user thread option
When starting an OC4j using datasource, this error may arise:
"Javax.naming.NamingException: Not in an application scope - start Orion with the -userThreads switch if using user-created threads"
Solution:
If using stand alone OC4J, start it with -userThreads parameter.
For example: java -jar oc4j.jar -userThreads
If using Oracle Application server, add the oc4j.userThreads=true parameter to <
Checking Oracle Application Server version
I was trying to find the exact version of Oracle Application Server installed months ago. A simple task, but may not be straight forward if you don't know where to find it. ..
After searching for a while, the fastest way to find it is to check the installation report. You can find it at: <ORACLE_HOME>/install/readme.txt
As a bonus, it also shows where is the exact URL to the Enterprise Manager
Oracle XMLDB: Create XML data with ease
It is a fact that we, as software developer, will encounter more and more data in XML format. Either we receive xml data or actually need to produce one for information sharing with other system (web service, legacy system, .net vs Java, etc...).
XMLDB of Oracle database (version 9i Release 2 and above) provides us with a convenience data type (XMLType) to store xml data, as well as the full
Problem with PUTTY connection to SUSE9
When I tried to connect to SUSE9 via Putty from my windows 2000, for some reasons I kept getting the Access denied message. Since connecting from Cygwin is ok, then the problem should be on the Putty.
After searching for a while, here is how I fixed the connection issue:
1. Update my Putty to the latest version: 0.58.
2. Open Putty. Load the Saved Session to the SUSE server.
3. In the Category
Jdev tip of the day
This screen pop up when I started my Jdev 10.1.3.0.4:
Interesting.... Has anyone ever seen "other" useful tips? :)
Viva Opera
Opera browser is now version 9. I think this is the best ever release they ever have. One of my friends introduced me to Opera some 4 years ago, and it’s been my default browser ever since.
Here are the features I like most about Opera:
1. Session Saver.
The first thing that really made me use Opera is the Session Saver. They are the first and the best. When the OS hang, crash, or just
Multiple OC4J containers on one server
In development, very often we want to have a controlled, dedicated environment for testing the new codes. This is why sometimes I find having multiple OC4J containers running on a single machine is very helpful. In this way, restarting one container will not affect other “projects”.One problem with this is port contention. In my Oracle Containers for J2EE 10g (10.1.3.0.0), the HTTP server is
RAC on VMware
There is an interesting article by Tarry Singh about Installing Oracle 10gR2 RAC on VMware. With VMware Server are being offered for free, I believe there will be more and more instances of Oracle running on VMware. But do we really want to have RAC on VMware? Perhaps I will use it for demo and learning purposes, but not in production system.
To me, nothing beats the real stuff. VMware
Potential pitfall with Oracle Sequence
Robert Vollman talks about Oracle sequences in his blog. Basically there are 3 potential issues with Oracle sequences that we need to consider when doing db design: 1. The squence number may "jump", that is 1,2,3,5,6,8,... with number 4 and 7 missing. One reason is if you do a transaction with NEXTVAL and then rollback, the sequence doesn't roll back to where you started. 2. By default,
Checking Redhat version installed
I was looking at how to tell the version of Redhat Linux installed on a machine from a command line. Mostly I used uname -a to view the server settings. Here is a sample: $ uname -a Linux myserver.mydomain.com 2.4.21-32.ELsmp #1 SMP Fri Apr 15 21:17:59 EDT 2005 i686 i686 i386 GNU/Linux It return the server kernel's version: 2.4.21-32.ELsmp, but not something my mother could understand.
Bitmap Index
I often heard people say create a bitmap index when you need an index and when the cardinality of the data is low. How low is considered low is another thing altogether. But one important aspect that people often forget is it only works well in read-only data. If it is a table with lots of insert, update, and delete operation, you end up having to lock many rows at once for each of the DML
Petals Around the Rose
A friend introduced this interesting game to me. It is more like an observation game plus a little bit of math. Apparently it took Dr. Richard Duke at the University of Michigan over a year to "see the solution". He claimed "the smarter you were, the longer it took to figure it out". Maybe smarter people tend to think too much, or loose themselves in the details.... (hint)
Interestingly I got it
Mac OS X on your PC
With Apple moves to x86 architecture, it is no wonder people start to do "what if" scenario. And now someone built a Mac for US $199!
http://osx86project.org/
It is a shame why it took Apple so long to realize its cash cow is actually on x86 platform. Just imagine if you get a Dell box pre-installed with Mac OS!
Google@moon
Google map now has a branch in the moon! Google Moon, as it called, is unfortunately lacking the powerful locality search for now. Not until July 20th, 2069..... sigh!
Should we use Transparent Data Encryption?
If your data requires the highest level of privacy and security, by all means, use it. However if it falls somewhere in the mid to low range, then you may want to carefully consider your options. Transparent Data Encryption (TDE) is a new feature of Oracle 10gR2 database that provides transparent encryption and decryption of table columns. Transparent means there is no code change required,
Google map is now in Japan
Google map now covers the land of samurai. The map's look and feel is quite
different from other region (US,UK, Canada). It has more info and show the
building lay out as well. Too bad the satellite view is not as good as US.http://maps.google.co.jp