techxplore blog

Archive for the 'Database Tips' Category

11 Feb

Command Line Startup of Oracle Database in Linux

In a perfect world of Database Administrator everything is worry free. Everything could be automated using a software where nothing to think about backup and disaster recovery. Tuning up the database for optimum performance is magically taken cared by the software. That’s my impression of Oracle RAC One Node during the i-Seminar. Database administrator’s life […]

09 Feb

Server Virtualization with Oracle RAC One Node Benefits

IT training are very important for an IT professional to keep up with the fast changing computer world. I welcome training for it’s an opportunity to go out of the four walls of the office. Reality never allows a leave at work to attend training due to the busy work load. An option for this […]

03 Feb

Changing MySQL Database Storage Engine from MyISAM to InnoDB

MySQL is a popular open source database that is being used mostly in web applications together with PHP. Storage engine of a MySQL database is a factor for getting optimum database performance. I installed a MySQL database for web application development on a test computer server. The performance was kind of slow. I was thinking […]

29 Jan

MySQL in Danger with Oracle and Sun Deal Completed

The acquisition of Sun Microsystems by Oracle Corporation has been looming for sometime already. Today, I got email that the deal has been completed. The acquisition would allow Oracle to become a player in the cloud computing business. The merger would deliver various technology innovation with the addition of servers, storage, SPARC processors, Solaris operating […]

19 Jan

RHEL4 Oracle Database 10g Installation Xlib: connection to “:0.0” refused by server

Computer software installation sometimes present some surprises especially on the Linux system. I have encountered such case when installing Oracle Database 10g Release 2 on a Redhat Enterprise Linux version 4. Expecting for an Oracle GUI for a Universal Installer, I was prompted by a series of text. It’s good to read closely those text […]

20 Dec

Oracle ERP Network Shared Printing Through Samba Could Not Print

Redhat Linux powers our Oracle ERP Financial Module Application. We have set it up in such a way that users could print to a networked printer identified inside the Oracle Application. There are occasions where people could not print to a particular printer. It was noted that this happens usually after a long work break […]

01 Dec

Oracle ERP Installation Redhat Linux File System Sample

It’s often that new system administrator are stuck on how to partition a Redhat Linux server for Oracle ERP installation. Well, there is an official guide in installing Oracle ERP on Redhat Linux Enterprise Edition, but I would show here a sample of an actual file system with Oracle ERP E-business Suite Financial Module installed. […]

20 Nov

Oracle Database Startup Process Modes

Starting up Oracle database requires some important detail to note. Failure to follow the proper steps would end up to failed database startup. Remember that we need to login as a user with SYSDBA privileges to startup an Oracle database which would enable us to for example do a – SQL>connect / as sysdba. Oracle […]

30 Aug

PL/SQL Same Page Redirect Script

While working with Oracle PL/SQL web applications, I have encountered a case where a feature for click on the button link will send some email notification. A successful email sent will hide the send button in the original page; if not, the send button will still be shown. I was thinking of using some Oracle’s […]

27 Jul

Upgrade Advisor Reduce Risk on MSSQL Server 7.0 to MSSQL Server 2005 Upgrade

There’s a popular saying from computer geeks which goes like – “If it’s ain’t broken don’t fix it”. This month our Windows 2000 computer server which host MSSQL 7.0 Database crashed several times. Thus, I consider putting in something new. I thought that it would be the time to upgrade to a newer MSSQL version. […]