Skip to main content

Posts

Showing posts from May, 2008

Try Asterisk on Ubuntu Hardy

I try install asterisk server on ubuntu hardy from repos. The 'asterisk-sounds-extra' is for testing sound[locate in /usr/share/asterisk/sounds/]. pnix@v400ast:~$ sudo aptitude install asterisk asterisk-sounds-extra Reading package lists... Done Building dependency tree Reading state information... Done Reading extended state information Initializing package states... Done Building tag database... Done The following NEW packages will be automatically installed: asterisk-config asterisk-sounds-main build-essential debhelper dpkg-dev g++ g++-4.2 gettext html2text intltool-debian libc-client2007 libc6-dev libcompress-raw-zlib-perl libcompress-zlib-perl libct3 libdigest-hmac-perl libdigest-sha1-perl libfile-remove-perl libgsm1 libiksemel3 libio-compress-base-perl libio-compress-zlib-perl libio-stringy-perl libmail-box-perl libmail-sendmail-perl libmailtools-perl libmime-types-perl libobject-realize-later-perl libpq5 libpri1.0 libradiusclient-ng2 libstd

Fixing sendmail take a long time to start

I notice that my database box[FC6+Oracle10.2] take along time to startup. Sendmail and sm-client very very slow to start[ about 5 minutes ]. There's something wrong in /etc/hosts file. 'newalises' command take long time to update and finish with error below. [root@ora10g ~]# newaliases WARNING: local host name (ora10g) is not qualified; see cf/README: WHO AM I? /etc/aliases: 76 aliases, longest 10 bytes, 765 bytes total [root@ora10g ~]# cat /etc/hosts # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 localhost.localdomain localhost 192.168.1.55 ora10g [root@ora10g ~]# To fix this, custom hostname[ora10g] need to append to localhost line in /etc/hosts. [root@ora10g ~]# cat /etc/hosts # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 localhost.localdomain localhost ora10g 192.168.1.55 ora10g [root@ora10g ~]# newaliases /etc/alia

Using Datapump on oracle 10g to export/import

This will be update version of this post if you are using oracle 10g or 11g. Last month I post about export/import data in oracle using exp,imp utility. Actually oracle has something newer and better performance if you're using 10g or 11g. Assume that we want to export one table from one oracle db and import it into another oracle db. So create the folder /home/oracle/dbbackup on two oracle db server to store <.dmp> file[that will be created when exporting and importing]. Next, we need to tell oracle to know this folder, create directory on both db by run command below in sqlplus SQL> create directory dmpdir as '/home/oracle/dbbackup'; Directory created. SQL> Now on source database export table with command below. [oracle@k8n ~]$ expdp username/password DIRECTORY= dmpdir DUMPFILE= filename.dmp TABLES= tablename Export: Release 10.1.0.3.0 - Production on Friday, 09 May, 2008 10:54 ... [oracle@k8n ~]$ after finish you will have filename.dmp in /home/oracle/db

Single user mode in fedora core

Again that electricity in area of Sukhumvit road, Bangkok down yesterday night. This time one database refuse to boot it freeze at "Starting system logger:". Look like there's no way to get a shell from any normal run level startup. Not like ubuntu that has recovery mode in grub menu. This box is fedora core, I know there's a way to get in to single user mode by pass kernel parameter at grub boot menu [but can not remember how to at that time:(]. After some googling I found the way. To get single user mode in FC, at grub menu press a [to append kernel parameter]. Now add s to tell fedora kernel that you want single user mode. After finish, enter to continue booting. Now you will get root shell and can figure out what wrong with your system then fix it. In my case now I just want Oracle to come up so i need atleast two service 'network' and 'oracle'. Try to bring it up by run these two command and pray. sh-3.00# service network start sh-3.00# service