To the experienced:
I am preparing to install an Oracle Application Server 10g on Solaris x86. One thing the installation guide emphasizes is the prerequisite of
installing ORABPEL, ORAESB and ORAWSM schemas before installing the application server. I am going to do a basic installation of the App server; but this schema installation is required whether the App server installation is basic or advanced.
Nowhere in the installation guide did I see any explicit mention of installing an Oracle database server on the same machine on which the application server is to be installed, and I wonder if that is required. I looked into the irca.sh script and found that it verifies the existence of $ORACLE_HOME/bin/sqlplus and $ORACLE_HOME/jdbc/lib/ojdbc14.jar, etc., which pretty apparently refers to an Oracle database server. And then it runs the jar file in Disk1 of the installation package:
# Set Classpath
CLASSPATH=lib/bpm-install.jar:$ORACLE_HOME/jdbc/lib/ojdbc14.jar
export CLASSPATH
# Run java command
$JAVA_HOME/bin/java -classpath $CLASSPATH -DORACLE_HOME=$ORACLE_HOME oracle.tip.install.tasks.IRCA "$@"
It is pretty clear that Disk1 must be on the machine on which the Oracle database server is already installed.
I already have an Oracle database server running. And it is not the machine on which I am going to install the application server. So my question is: Can I install an application server without installing a database on the same machine, and instead let the application server use a database server that is already on a separate machine?
Also, is the database server with the ORABPEL, ORAESB and ORAWSM schemas installed required to be exclusively dedicated to the application server?
I do not fully understand the "Database Connect Information" in the installation screen in
Figure 4-2 for basic installation. Specifically, in the format ("{color:green}hostname:port:service name{color}") given by the installation guide (just below Figure 4-2), it is not clear to me what "service name" means. If the application server and database server are allowed to be on separate machines, and the information about the two machines are:
Application server:
--------------------------------------
hostname: appserver.mycompany.com
Database server:
--------------------------------------
hostname: dbserver.mycompany.com
jdbc port: 1521
database sid: dbtest
then what is the correct, complete string to be filled in the "Database Connect Information"?
Many thanks for your help!
Newman