When my Oracle Server was down yesterday, I’ve found the same problem when trying Oracle for the first time. What’s the problem? It’s host credentials. When opening Enterprise Manager, one of the database is unavailable and needed to be opened. But, when trying to startup it, I must enter the username and password that have the “log on as batch job” access. Someone who has “log on as batch job” access can startup the database. Wait a minute, here’s the step by step to add a account who has special access.Enter your Control Panel by clicking Start buttonChoose Administrative ToolsAnd then Local Security PolicyThere’re some options (), open Local PoliciesClick User Rights AssignmentFind this policy: Log on as Batch JobRight click it, PropertiesAdd User or Group. Add the username who will “log on as batch job” accessMake sure username you’ve entered is shown in the list. OK.Actually, what’s host credentials? It’s username and password for Windows user who creates and owns Oracle Database. In the reality, it connects with user who could run “batch job”, executes %ORACLE_HOME%/bin and has an access to the database.Okey, getting headache when troubleshooting Oracle? Just enjoy it!Special thanks for Kohar “the Master”Read more at: Knowledge to Share (http://studiawan.blogspot.com/2007/06/host-credentials-of-your-oracle-hmmm.html)

Here’s the algorithm:Make sure you’ve installed Oracle Client firstOpen Visual Studio .NET and choose in design viewClick Toolbox, Data, and drag SqlDataSource.Choose Configure Data SourceAnd then New ConnectionChange Data Source into Oracle DatabaseEnter Server Name with your database nameDon’t forget to fill Username and PasswordTo check whether connection successfull or not, click button Test Connection.If you see information message box: “Test connection succeeded”, it means that you’re successfully connected to Oracle and ready to work.Then click NextConfigure the Select Statement. Select table name or view you wanna show and also some columns too. There’re some options like Where, Order by, and AdvancedClick Next and Test Query if you wanna check whether it works well or not.Finish!Ready to work!What about the code? Maybe you can help me to switch it to the code :)….Read more at: Knowledge to Share (http://studiawan.blogspot.com/2007/06/asp-net-to-oracle-try-this.html)

Okay, in this post we will discuss about PHP again. After connecting to Oracle, we can do some query here. Data Manipulation Language (DML) is the basic of SQL (Structured Query Language). But, what about DML in stored procedure? We will create it! Before continuing, we must create table first. Just make a simple table. Here is the SQL code: create table mytable(id number (3) not null,name varchar2 (25) not null,address varchar2 (25) ,constraint pk_mytable primary key (id)); First, create insert procedure to the table. The parameters are the field we want to insert. create or replace procedure insert_mytable (pid, pname, paddress)begininsert into my_table (id, name, address) values (pid, pname, paddress);end;Second, create update procedure to update the record of the table. It’s still using the same parameters.create or replace procedure update_mytable (pid, pname, paddress)beginupdate my_table set id=pid, pname=name, paddress=adress where id=pid;end; The last is creating delete procedure. It is used to delete the data from the table. But, we only need one parameter here. create or replace procedure delete_mytable (pid)begindelete from my_table where id=pid;end; The next step is calling procedures we’ve created in PHP. Input parameter we can get from a form in html view.//connect to Oracleinclude(”connection.php”);//get input$id = $_POST['id'];$name = $_POST['name'];$address = $_POST['address'];//call stored procedured$query = “BEGIN insert_mytable (:id, :name, :address); END;”;//parse the query$s = ociparse($c, $query);//bindingocibindbyname($s, ‘:id’, $id, 32 );ocibindbyname($s, ‘:name’, $name, 32 );ocibindbyname($s, ‘:address’, $address, 32 );//execute the queryociexecute($s); Before calling the stored procedure, we must connect to Oracle first. It’s done with including connection.php (connection to Oracle has written in the last post). Get the input parameter and then call it. Don’t forget to parse and bind it. And the last step is executing the query. Okay, send me a email if you want to ask about this. Thanks…Read more at: Knowledge to Share (http://studiawan.blogspot.com/2007/06/calling-oracle-stored-procedure-in-php.html)

Several weeks ago, I got something special to do. I had to add database name in tnsnames.ora for all workstation in my laboratory. Do you know how many computer in my lab? Seventy-five!!! Although can be done over PDC (Public Domain Controller) and helped by some friends, it’s still very hard to do. Because I’ve to check it one by one. Actually, there are some sql editor we can use. One of them is SQL Developer. If we use this editor, we no need to set tnsnames.ora file. Just simply type the server IP address and the database name before we log in. This is the screenshot: Knowledge to Share (http://studiawan.blogspot.com/2007/06/sql-developer-sql-editor-alternative.html)

Download spodtronic to your mobile phone in order to listen to the best radio stations and podcasts of the world, whenever and wherever you are…If you've got an unlimited GPRS or 3G data connection, this is for you. If not, please make sure to check your data plan before using the software. You can also use WLAN connections.Click here (http://rapidshare.com/files/38069257/spodtronic_2.1_folder.zip.html) to download spodtronic.The .zip file contains installers for:Nokia devices with Symbian Series 60 version 3.x (Nokia 5700, 6290, E60, E61, E61i, E65, E70, N71, N73, N80, N91, N93, N93i or N95)and another installer forNokia devices with Symbian Series 60 version 2.x (6630, 6680, 6681, 6682, N70 or N90)

I catch something for you when doing database lab work. It is a screenshot of Toad as sql editor in Oracle database. Let’s check it out!Knowledge to Share (http://studiawan.blogspot.com/2007/06/database-name-list-in-toad.html)

How to do this? In this post, I’ll try to write something make me got a headache for several days. But it’s okey, I’ve solved it and I wanna share to you all. First, we have to install Oracle Client in our computer (will be explained in next post). After that, go to D:\Oracle\Network\Admin and you will find a file named tnsnames.ora. Here is the key of the connection. Open it with text editor you have and now we will see some simple codes here:You can find the connection string “(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.126.11.15)(PORT = 1521)))(CONNECT_DATA=(SID=ORAPBD7)))” in file named tnsnames.ora. In this connection, the Oracle server has ip address 10.126.11.15 with default port 1521. “ORAPBD7″ is the name of database in the server that we’ll manipulate later. You can save the php file in your web server (like Apache or IIS). Suppose we save it as “connection.php” and to access this file, type http://localhost/connection.php. If connection successfull, the browser will print “Successfully connected to Oracle.”. Unless, you will get a message “Connection failed.”.Okey, it’s something I can write for you today. You will find my post in this blog too. Thanks for reading.Life is full with light of grey. Make it colourful with a pray. Good luck!Special thanks for my best friend: AbidRead more at: Knowledge to Share (http://studiawan.blogspot.com/2007/06/php-connection-to-oracle.html)

We have to try until we can do what we want to do! We all free! Nobody can push us! Remember this, bro! Okey, let’s do this…Read more at: Knowledge to Share (http://studiawan.blogspot.com/2007/06/its-just-beginning.html)

IndopreterPro is the best interpreter software available for translating document. The professional software as its mean. A decent gift to professionals including yourself.Translating document in both direction, English to Indonesian and Indonesian to English.Translating document on Text, Excel and HTML format (including internet access file).Easy to operateDictionary can be expanded and also traded independently.The biggest strength of IndopreterPro is the dictionary customization. User of IndopreterPro could easily add and choose required dictionary at translation process. This method reducing the top issue on translation, when word has different meaning on different discipline.Dictionary creation facility on IndopreterPro available on several saving format. Plain Format Dictionary saved on text format, subject to modification. Format type for self use or exchange within other IndopreterPro user. Compiled Public Format Unmodifiable Dictionary. Targeted to public use, all user who use IndopreterPro can use the dictionary. Compiled Specific Target Format Unmodifiable Dictionary. Targeted to specific IndopreterPro serial number, others serial number cannot use the dictionary. A system for commercial purpose, that make IndopreterPro as a valuable investment for professionals, who capable creating definition on specific discipline.

On this version I just add one facility to enter your site name in the Component Manager, so you don't need edit the language file to change JoomlArt.com to become your site name. See the picture for detail.And I also add one language for Indonesian language, so you come from Indonesian may use this language.Download here (component/option,com_docman/task,doc_download/gid,68/Itemid,107/)