Current work station @ vss

This my current workplace where my main pc located. The table im using as my table was a meeting's table and i conquer it all by myself..(tamak haloba punya tempat). The white color cpu was previously used by x-staff so its maintain as it is since the mgmt need the data inside the harddisk (eventough they can just grab the hard disk instead the cpu..).

There goes another 2 cpu being controlled by me the left white cpu is used by another x-staff previously and it stay as it is. and the black cpu with yellow tab installed ubuntu 8.04 server with Oracle 11g inside. The red box on top of the table is the x700 Firebox. A hardware firewall, haven't get the right time to explore it (yet!).

Well there you goes, the x700 Firebox and the black monitor you see is shared by 4 cpus. there is another black cpu which previously was a DNS Server, previously installed windows server 2000 but already reformatted and installed ubuntu 8.04 and haven't have time to configure it as dns server. Since the temporary dns server is still OK so i guess got time to finish other task 1st.

Creating DPDS database in oracle 11g.

Coming to the office this morning showing the same thing on the ubuntu desktop. so what i did just reboot it. while after that not sure what to do .. then just try to re-run the dbca when part to put the database name ("DPDS") it saying the database already created. so I just cancel it and when try to manage the database my ubuntu start to hang (i think the processing is slowing down the other processing) so i just cancel it.. and try to check by connecting to sqlplus.. then this error 'ORA-12162 "TNS:net service name is incorrectly specified" ' show up and asking for username and password when i run this command "sqlplus '/as sysdba' " and what i did, i check the /etc/oratab and i set to 'DPDS:/u01/app/oracle/product/11.1.0/db_1:Y' and i reboot it and rerun back again it clear without asking the username and password and when i try to create user then another error occur, " ORA-01034: ORACLE not available " and i exit from sqlplus and run " export $ORACLE_SID=DPDS " and run back the sqlplus command and try to create the user and give full access grant to the user. Succesfully.

My next stage would be to import dump.dmp

After successfull transfered the dump.dmp from my XP to server (using the webmin upload download services...heh heh) i create the user peran & docctrl in sqlplus + giving full access grant on DPDS. then i exit from sqlplus and run imp command then i import all from dump.dmp under user peran then docctrl.
After successful the importing, i still having problem with the ORACLE_SID and TNS_ADMIN and tnsnames.ora. Well what i did, set the
ORACLE_SID = DPDS
TNS_ADMIN=..../oradata/DPDS

in /etc/profile at below

then i set the tnsnames.ora adding the DPDS,hostname

(bla bla bla...)

Installing Oracle 11g in Ubuntu 8.04

After installing Ubuntu Linux 8.04, my task was to be able to run Oracle database in it. I follow guide from "Installing Oracle 11g on Ubuntu 8.04 LTS (Hardy Heron)" by Augusto Bott. Thanks to him i manage to install it even because of some typo error like "binbash" and he did help within a second. Thanks Bott.

What im trying to do in here right after i've restart the server i did try to run the dbca command, I get into problems where got something to do with export DISPLAY=ip_address:0.0 until i came out into 1 of the comment whereby saying to login using oracle id.I also did do the command export display and another error come out, No protocol specified. So what i did to unlock the oracle acount in ubuntu and login in using username oracle.
And seems to be the problem solved after login ubuntu using oracle account i manage to run dbca and another problem occur, where the popup start to go blank after i manage to create new database another popup of confirmation database creation and i just Enter 2 to 3 times then another popup came up and just blank but it seems like the server a lil bit heavy.I assume it does create the database.
I'll come back on Monday or Tuesday to see the result either the database created or not and it took me a week to manage until this and i will come out with the picture to show what im talking about.