Skip to Content
author's profile photo Former Member
Former Member

Installing two seperate NW2004S on one server

Hi,

Can somebody help me with some information about the installation of two seperate NW2004S portals onto 1 server?

I've managed to install one portal PD1 with Oracle 10g on the server but now I want to install the production version (PP1) on the same server (with a seperate Oracle installation).

What I've been able to do is installing a second Oracle instance on this server called PP1 which I will use during the install of my second PP1 NW2004S portal.

During the installation of my second portal (I've tried it allready but did not succeed in it) I saw that I could enter an other listener port for the Oracle Listener server which I did. Other things to watch out for?

And what with the both Oracle homes. How do I configure two oracle homes for two installations on the same server?

Can somebody help me pointing out which steps to take and where to watch out for not destroying my other current development portal PD1.

Thank you for your feedback on this.

Points will be rewarded for helpfull answers.

Br,

Tom Cockaert.

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 26, 2007 at 11:20 AM

    Hi

    look in to the script to start multiple databases on one server if your systemsis a unix based.

    #

    1. chkconfig: - 95 35

    2. description: Starts and stops the Oracle database and listeners

    3. /etc/rc.d/init.d/oracle

    4. See how we were called.

    ORACLE_HOME=/usr/local/oracle

    case "$1" in

    start)

    echo -n "Starting Oracle Databases: "

    echo "----


    " >> /var/log/oracle

    date +"! %T %a %D : Starting Oracle Databases as part of system up." >> /var/log/oracle

    echo "----


    " >> /var/log/oracle

    1. echo `expr 1024 \* 1024 \* 1024` > /proc/sys/kernel/shmmax

    2. echo 250 32000 100 128 > /proc/sys/kernel/sem

    su - oracle -c $ORACLE_HOME/bin/dbstart >> /var/log/oracle

    echo "Done."

    echo -n "Starting Oracle Listeners: "

    su - oracle -c $ORACLE_HOME/bin/"lsnrctl start" >> /var/log/oracle

    echo "Done."

    echo ""

    echo "----


    " >> /var/log/oracle

    date +"! %T %a %D : Finished." >> /var/log/oracle

    echo "----


    " >> /var/log/oracle

    touch /var/lock/subsys/oracle

    ;;

    stop)

    echo -n "Shutting Down Oracle Listeners: "

    echo "----


    " >> /var/log/oracle

    date +"! %T %a %D : Shutting Down Oracle Databases as part of system down." >> /var/log/oracle

    echo "----


    " >> /var/log/oracle

    su - oracle -c $ORACLE_HOME/bin/"lsnrctl stop" >> /var/log/oracle

    echo "Done."

    rm -f /var/lock/subsys/oracle

    echo -n "Shutting Down Oracle Databases: "

    su - oracle -c $ORACLE_HOME/bin/dbshut >> /var/log/oracle

    echo "Done."

    echo ""

    echo "----


    " >> /var/log/oracle

    date +"! %T %a %D : Finished." >> /var/log/oracle

    echo "----


    " >> /var/log/oracle

    ;;

    restart)

    echo -n "Restarting Oracle Databases: "

    echo "----


    " >> /var/log/oracle

    date +"! %T %a %D : Restarting Oracle Databases as part of system up." >> /var/log/oracle

    echo "----


    " >> /var/log/oracle

    su - oracle -c $ORACLE_HOME/bin/dbstop >> /var/log/oracle

    su - oracle -c $ORACLE_HOME/bin/dbstart >> /var/log/oracle

    echo "Done."

    echo -n "Restarting Oracle Listeners: "

    su - oracle -c $ORACLE_HOME/bin/"lsnrctl stop" >> /var/log/oracle

    su - oracle -c $ORACLE_HOME/bin/"lsnrctl start" >> /var/log/oracle

    echo "Done."

    echo ""

    echo "----


    " >> /var/log/oracle

    date +"! %T %a %D : Finished." >> /var/log/oracle

    echo "----


    " >> /var/log/oracle

    touch /var/lock/subsys/oracle

    ;;

    *)

    echo "Usage: oracle {start|stop|restart}"

    exit 1

    esac

    1. the above script uses dbstart to start all database instances defined in file /etc/oratab

    2. ie substitute Y for N at end of each line in oratab to control instance startup

    3. ensure ORACLE_HOME in script agrees to your installation.

    #

    1. to make it run at startup issue following command as root $ chkconfig oracle on

    2. to test it without shutdown/startup as root $ service oracle stop $ service oracle start

    3. PS I did not write this script. I'm just passing it along. All credit due to the real author

    Regards,

    Phani

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Tom,

      May I check with you, how do you set the oracle home & oracle SID for the second installation?

      I'm exploring on multiple oracle home installation.

      what is the setting for oracle home & oracle sid?

      Could you share the step by step guide for multiple oracle home installation? what to look out and what need to be set?

      thanks.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 26, 2007 at 11:15 AM

    Hi,

    Check that you have enough memory values for both, the database instances.

    You need multiple oracle homes to run both the instances at the same time.For Multiple ORACLE_HOME 's check with this link

    http://www.lc.leidenuniv.nl/awcourse/oracle/em.920/a96697/moh.htm

    Regards,

    Phani

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Tom,

      You need to set different listner ports for both the system, and also you need to take that the ports which you are using for EP should no conflict with each other.

      Best Regards,

      Sachin.