Installing the database objects

Create the database objects for this chapter before you start by using a script provided. The code comes with the readme file, readme_4_1.txt.

We will be creating a database package that we will use in some of the following recipes in this chapter. Finally, we will create a sequence that will be used to generate a unique number for new records. For all the database objects, there is a script provided called 4842_04_01.sh. The following recipe provides details on how to run the script.

How to do it...

To create the database objects, perform the following tasks:

1. 1. Create a local directory, C:\packt\scripts\ch4, where the scripts are downloaded to.

2. 2. Open Putty and connect to the application tier user.

3. 3. Create a new directory on the application tier under $XXHR_TOP/install with the following commands:

   cd $XXHR_TOP/install
   mkdir ch4
   
   

4. 4. Navigate to the new directory with the following command:

   cd ch4
   
   

5. 5. Open WinSCP and FTP the files from C:\packt\scripts\ch4 to...