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_5_1.txt.

We are going to create a number of objects that we will use throughout the chapter. For all the database objects, there is a script provided called 4842_05_01.sh. The following recipe provides details of how to run the script.

How to do it...

To create an advanced queue, perform the following steps:

1. 1. Create a local directory C:\packt\scripts\ch5 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 ch5
   
   

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

   cd ch5
   
   

5. 5. Open WinSCP and ftp the files from C:\packt\scripts\ch5 to $XXHR_TOP/install/ch5 as shown in the following screenshot:

   

6. 6. In Putty, change the permissions of the script with the following...