5 Database Administration

Voice System Database Administration

Shell Wrapper Approach

Perform the following:

1Compile the original source file that communicates with the database along with all the other source files.

2Rename the executable file using the move command, but keep it in the same directory.

3Using your favorite editor, edit a file with the same name as the original executable file.

4Enter the following on the first line:

ORACLE_SID=ORACLE_SID_name;export ORACLE_SID

where ORACLE_SID_name is the name of the instance of the ORACLE database on the server.

5Enter the following on the second and third lines:

ORACLE_HOME=‘/usr/lbin/dbhome $ORACLE_SID‘;exportORACLE_HOMEexec new_executable_file_name

where new_executable_file_name is the full path name of the newly- renamed executable file.

6Save the file and exit the editor.

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 241