Oracle Tablespace Configuration
Run the ImportSamples script to create a SAMPLE database, create a SAMPLE
data source, and install the Samples Enterprise Application on your WebSphere
Application Server.
- On Windows:
- Verify that the WebSphere Application Server has started.
- Open a command window.
- Change to the <WAS_ROOT>\bin directory.
- Invoke the following script:
ImportSamplesOracle.bat oracleadmin oraclepwd
[@oracle_connect_string]
where:
- oracleadmin is the Oracle DBA user ID.
- oraclepwd is the Oracle DBA password.
- oracle_connect_string is the Oracle connect string. You
must specify this parameter when the Oracle database is remote.
Here is an example of the command syntax for Windows:
ImportSamplesOracle.bat system manager @ORCL
The database
script requires that you provide the user ID and password of an account
that has Oracle DBA authority.
- Start or restart the Default Server.
- Select Enterprise Application and click Refresh,
to show the newly installed Enterprise Application
- On UNIX:
- Verify that the WebSphere Application Server has started.
- Open a command window.
- Change to the <WAS_ROOT>/bin directory.
- Invoke the following script:
./ImportSamplesOracle.sh oracleuser oracleadmin
oraclepwd [@oracle_connect_string]
where:
- oracleuser is the Oracle operating system user name.
The default value is oracle.
- oracleadmin is the Oracle DBA user ID.
- oraclepwd is the Oracle DBA password.
- oracle_connect_string is the Oracle connect string. You
must specify this parameter when the Oracle database is remote.
Here is an example of the command syntax for UNIX:
./ImportSamplesOracle.sh oracle system manager @ORCL
The database
script requires that you provide the user ID and password of an account
that has Oracle DBA authority.
- Start or restart the Default Server.
- Select Enterprise Application and click Refresh,
to show the newly installed Enterprise Application.
Run the servlet to create and configure the tables in the SAMPLE tablespace.