Installing two seperate NW2004S on one server

[Former Member]

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.

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

During the install of the second Portal I've encountered a problem that my listener was created with my first portal SID.

Most likely this is due incorrect settings somewhere. (perhaps ORACLE_HOME)

Anybody any suggestions?

Thank you for responding.

Best regards,

Tom.

[Former Member · Accepted solution]

See your /usr/sap/SID/SYS/profile/oracle directory. Edit the port there.

Also check the values in tnsnames.ora for port. Both should match.

Kedar

[Former Member · Accepted solution]

Is it really necessary to have two listeners for my two Oracle databases?

I saw on the forum for Oracle that it is possible to use just one listener for 2 databases (on 1 server) and that works perfectly.

Can I install two portals onto 1 server with 1 listener? If yes what must I enter during the installation of the SAP NetWeaver 2004S installation at the listener section?

Thank you for your feedback.

[Former Member · Accepted solution]

Hi All,

I've succeeded in installing two portals onto 1 server.

It can be done with only one listener. During the installation of the second portal use the same listener as in the first portal installation.

My listener config for both portals is the same:

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(

ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC) (KEY = PD1.WORLD))

(ADDRESS = (PROTOCOL = IPC) (KEY = PD1))

(ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = OUR_SERVER) (PORT = 1527))

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PD1)

(ORACLE_HOME = C:\oracle\PD1\102)

)

(SID_DESC =

(SID_NAME = PP1)

(ORACLE_HOME = C:\oracle\PP1\102)

)

)

Just don't forget to set the correct ORACLE_HOME & ORACLE_SID before starting the installations.

If someone has questions about this don't hesistate to contact me.

Best regards,

Tom.

[Former Member · Accepted solution]

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.

[Former Member]

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

[Former Member]

And during the installation of the new (additional) portal do I change the listener port to another one? If I'm not mistaken the default port is 1527, the new portal to eg 1528?

And are there other issues during the installation of the portal itself that I must be carefull for?

Thank you for your feedback.

Best regards,

Tom.

PS I did not forget to reward you points.

[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.