Tuesday, October 21, 2014

HypnoBirthing - Reading Part 2 from the book

Have you done your birth plan ?

  • Would you plan a vocation and not bother to learn anything about the hotel you will stay in?
  • If you were in the market for a car, would you drive into the Proton dealership and buy a blue Proton sedan if what you really wanted was a red Honda City ?
    I am sure the answer to all of these questions is an emphatic "NO". And these are not possible life-changing decisions.

     Preparing for your baby's birth is far more important than any other major decision you have ever made. You simply can't "settle". A woman needs to be free to birth her babies as she chooses
       

Sunday, October 19, 2014

HypnoBirthing

About HypnoBrithing 

             I came across to this HypnoBirthing few months ago from the CT clinic. I started to search the internet for more information. I started to practice it with the downloaded MP3. It seems work for me. The breathing method, the music with the hypno scripts guided me to relax my muscles and even the headache and put me into a nice sleep after that.
            After attending the talk conducted by Dr. Tan Ee Ping https://www.facebook.com/206199172735683/photos/pcb.795322270490034/795322230490038/?type=1 . I decided to attend the proper hypnoBirthing class conducted by her midwife Norhayati binti Mold Sede, one of the hypnoBirthing practitioner, you can find her name @ http://hypnobirthing.com/directory/?country=Malaysia . You may also find your nearest practitioner to attend the class. RM800 for my case.
            I had found the online same version for the scripts from Morgan. http://grooveshark.com/#!/album/Rainbow+Relaxation/5407014
         
              This is what it got it from the session 1. 5 sessions for the whole course. I started to read the book and recall what I have learnt from the class. 

  1. Have anyone of us being hypnotized before ?
    • Have you ever turn into the junction in the road to go to work but in fact you were not really wanted to go there ? 
    • Have you ever reading a book until too focus and others need to call you few times to make you alert ?
    • If the above happened to you then you had been hypnotized before. 
  2. Do you know human body can generate endorphins that have an effect 200 times that of morphine ?
    • Endorphins can be generated by our body naturally. 
    • Our body has such capabilities to overcome it. 
  3. How the uterus work?
    • There are 3 layers of the uterus.
    • There are 2 layers we need to focus.
    • Outer layer - vertical pattern (during labor will pull up )
    • Inner layer - horizontal muscle (during labor work together and harmony with Outer layer open to release baby)
  4. How our Automatic Nervous System (ANS) work with the organs ?
    • When human in 'FEAR'/defensive mode, those blood and Oxygen will be supplied to those defensive organs. However, uterus is not one of the defense organ.
    • A lot of midwife saw the screaming and terrifying birthing mama were having pale uterus.
    • When uterus lack of Blood and Oxygen supplied and tense. The harder and more painful for the birthing. 
  5. Releasing Fear 
    • Fear is the source of pain.
    • Dr. Dick-Read 
      • He saw a mother refused his medical intervention during her childbirth under a dim room and rain pouring from the leaky roof. The baby was born with no fuss or noise from the mother.
      • During World War 1, he saw a mother give birth very easily and apparently with no discomfort even the war was going on around her.
      • There is nothing wrong with their labor
      • After years of researches , he concluded that the FEAR is the source of pain.
    • Your own birth - What stories have you heard about your own birth ? Are they positive and encouraging, or negative and frightening ? Do you feel you will duplicate your mother's labor ? If what you've been told is less than encouraging, you might want to work on establishing that you are not your mother, an this is not her pregnancy. You are an entirely different person at a different time and under different circumstances. 

Wednesday, October 23, 2013

Export CSV with french or UTF-8 in Linux and Excel open it correctly with UTF-8

You may append the 3 bytes to the file before exporting, it works for me . Before doing that system only work in Windows and HP -UX but failed in Linux.

    FileOutputStream fStream = new FileOutputStream( f );
    final byte[] bom = new byte[] { (byte) 0xEF, (byte) 0xBB, (byte) 0xBF };
    OutputStreamWriter writer = new OutputStreamWriter( fStream, "UTF8" );
    fStream.write( bom );
    // writer to have your contents

Have a UTF-8 BOM (3 bytes, hex EF BB BF) at the start of the file. Otherwise Excel will interpret the data according to your locale's default encoding (e.g. cp1252) instead of utf-8

Friday, April 19, 2013


Dynamically Clean up the target Oracle DB

  1. This job will call a main script. This script will first call a pre-defiend SQL file by replacing the proper DB USERNAME.
    SPOOL /home/tmp/drop.sql
    select 'drop table '||owner ||'.'||table_name||' cascade constraint;' as LBL_SCRIPT from all_tables where owner = upper('#_dbuser_#');
    select 'drop sequence '||sequence_owner||'.'||sequence_name||';' as LBL_SCRIPT from all_sequences where sequence_owner = upper('#_dbuser_#');
    select 'drop PROCEDURE '||object_name||';' as LBL_SCRIPT from ALL_OBJECTS where OWNER = upper('#_dbuser_#') and OBJECT_TYPE IN ('PROCEDURE');
    select 'drop FUNCTION '||object_name||';' as LBL_SCRIPT from ALL_OBJECTS where OWNER = upper('#_dbuser_#') and OBJECT_TYPE IN ('FUNCTION');
    SPOOL OFF
    exit
  2. The script will then try to select out the table,sequence,procedure and function from the target DB and paste it into a sql file by executing the SQL file in previous step.
    #########################################
    #  generate the drop script for existing db
    #########################################
    function generate_drop_script
    {
        echo "generate the drop script"
        sqlplus $dbuser/$dbpassword@ORCL @$gropFile
        echo "remove unwanted lines int the drop script"
        sed -i -e 's/[0-9]*.*row.*//ig' $finalDropFile
        sed -i -e 's/LBL_SCRIPT//g' $finalDropFile
        echo "append exit command to the drop script"
        echo "exit;" >> $finalDropFile
    }
  3. The script will remove those unwanted characters/words from the generated sql file in previous step.
  4. Execute the generated sql file to clean up the DB.

Remotely run the dump file for Oracle

When we have TWO servers
  1. server 1 (client server )
    • Platform - Linux Ret Hat
    • Oracle - Client
  2. server 2 (host server - the target server host the DB) - Linux Ret Hat
    • Platform - Linux Ret Hat
    • Oracle - Full Version
The following are the suggested steps to achieve this.
  1. Ensure the client server's Oracle Client is Administrator Type. If not, please do re-run the runInstaller
  2. This to ensure the Oracle Client provide 'import' and 'export' services.
  3. Add the host server IP into client server's
    • File name - host.allow
      • E.g: /etc/host.allow
      • Line to be added -> nfs: 10.116.1.123
    • File name - hosts
      • E.g: /etc/hosts
      • 10.116.1.123 ORCL dbmain.company.com
  4. Both server need to start the following services
    • portmap
    • netfs
    • nfs
    • E.g : $ /sbin/service nfs start
  5. Add the following line into file etc/exports
    /home linux(rw,sync) linuxd600(rw,sync)
    /u01 10.116.1.123(rw,sync)
  6. Must define the database address for establishing connection instead of pure text such as :-
    $ imp host_user/host.com@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST='$DB_HOST')(PORT='$DB_PORT')))(CONNECT_DATA=(SID='$DB_SID')))' FILE=/get/dump/file/directory/dbdump.dmp FULL=y
    • Please define it in tnsnames.ora file E.g: /u01/app/oracle/product/11.2.0/client_1/network/admin/tnsnames.ora
      ORCL=
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = dbmain.company.com)(PORT = 1521))
          )
          (CONNECT_DATA =
            (SID = orcl)
          )
        )
    • No need to restart listener as Oracle Client do not have such services being installed.
  7. Set the proper environment variables
    $ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1
    $ PATH=$PATH:$ORACLE_HOME/bin
    $ LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib; export LD_LIBRARY_PATH
    $ export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
  8. Now is the time to execute the dump file.
    $ imp cnm_developerX/password@ORCL FILE=/get/dump/file/directory/dbdump.dmp FULL=y