Oracle 10g
BEA AquaLogic Commerce Services Deployment Guide 19
If the MySQL server and the web application server run on different hosts, create a user
account and grant privileges to the host which runs the web application server with the
following command:
mysql> grant all privileges on ALCS.* to username@'ipaddress';
If your database is on a different machine than the web application server, you may want to
specify a password by adding identified by 'password' to your grant command.
Commit the permission changes:
mysql> flush privileges;
5. Change database to ALCS:
mysql> use ALCS;
6. Copy the sql files from <WL_HOME>\commerce\database-scripts\mysql to c:\mysql\bin.
7. Create a blank ALCS database:
mysql> source schema.sql;
mysql> source base-insert.sql;
8. Optionally, deploy the AquaLogic Commerce Services Demo Store "Snap It Up" to your
database
mysql> source snapitup-insert.sql;
9. If you chose to run the snapitup-insert.sql script, you will also need to import the SnapItUp
product catalog data (see the Running SnapItUp Import Jobs section).
Oracle 10g
This section contains the instructions for creating an Oracle 10g AquaLogic Commerce Services
database.
You will need to set the database to use case-insensitive comparisons and also
ensure that the indexes are created in case-insensitive mode to allow searches
to be case-insensitive and to avoid full table scans on certain tables.
• When installing Oracle 10g on a Windows system as a domain user as
opposed to a local administrator you must set the
SQLNET.AUTHENTICATION_SERVICES configuration value to NONE in
the <ORACLE_BASE>\NETWORK\ADMIN\sqlnet.ora file (where
<ORACLE_BASE> refers to the Oracle home directory on your system,
for example C:\Oracle\product\10.2.0\db_1).
• In order to install Oracle on a Windows system with a dynamically
assigned IP address you must install the Microsoft Loopback Adapter:
http://support.microsoft.com/kb/839013
