Oracle

1. If you have not already done so, set database-specific environment variables:

C Shell:	

	setenv ORACLE_HOME oracle_directory 
	setenv ORACLE_SID default_oracle_database

Bourne/Korn Shell:
	ORACLE_HOME=oracle_directory
	export ORACLE_HOME

		ORACLE_SID=default_oracle_database
		export ORACLE_SID

where oracle_directory is the directory in which Oracle is installed and default_oracle_database is the connection string for the Oracle database.

Note: This connection string is the database name if the database is local; it is a connect string if the connection is going over SQL*Net v1. If the connection uses SQL*Net v 2., see the chapter "Troubleshooting" in this Guide.

2. Since tutorials require data from a database, as well as dynamic SQL and stored procedures to manipulate the data, you will have to load a set of tables which are supplied with the Sapphire/Web distribution. Unless you have an "sa" account on the database, your database administrator will have to perform this step.

	$SAPPHIRE/bin/build_pubs2_ora user pword database 0


 user: 	the username of the user who is to own the tables (you may wish to use the scott/tiger account)

 pword:	the password of the user who is to own the tables

 database:	the name or SID of the database in which to install the tables

 0:	should always be 0 (zero).

Note: If you already have a database called pubs2, you will need to remove it before running these scripts.

3. To load the tutorial's DSQL Objects into the correct location, type the following at the command line:

	$SAPPHIRE/bin/install_db sid owner O


 sid: 	the SID of the database where the sample tables are located

 owner: 	the username of the owner of the sample tables

 O: 	Vendor Type should always be O for Oracle 

4. Copy the DSQL Objects into your DSQLDIR by typing:

	cp $SAPPHIRE/tutorials/dsql/* $HOME/dsql

5. Finally, grant connect privileges to all potential users of the pubs2 database.