Learning Support and Core Cir Instructions

Problem Description : 

 Resolution : 

To run the Learning Support/Core Cir. Process for Janet

If Janet asks you to run the script - she means the gasis_permissions.

Log into Dino as banmgr. go to /gdn00/scripts

type in sqlplus at the $

you will be prompted to log in - Baninst1 and password.

at the sql prompt type in @/gdn00/scripts/gasis_permissions

This will run the script that she needs. 

At the end of the process she should call and ask for you to run the fix process. You do the very same thing but run the /gdn00/scripts/gasis_permission_fix.sql

process.

_________________________________________________________________________________

From Jody on 7-6-07

Replace step 2's instructions in the EAS email below with these instructions. Give me a call if you have any questions.

1. You will get an email from OIIT announcing that the Core Curriculum/Learning Support data collection is open for submission. It will tell you the reporting terms. Once you have the reporting terms you will complete the following steps.

2. Ask Computer Services to run the /gdn00/scripts/gasis_permissions.sql (This is only temporary) 

3. login into dino and go to the GUAHOST prompt 

4. type cd /gdn01/prodhome/links

5. type sh gasis.shl (This will give you a SQL> prompt)

6. type sh gasis1.shl at the SQL> prompt you should see the following.

$ sh gasis.shl

SQL*Plus: Release 9.2.0.6.0 - Production on Fri Jul 6 10:38:46 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production JServer Release 9.2.0.6.0 - Production

SQL> @gasis1.shl

Session altered.

SQL>

7. type @ls_collect

8. At this point you will be back at the $ prompt. You will then type the following command again. type sh gasis.shl 

9. type sh gasis1.shl at the SQL> prompt 

10. exec ls_collect('Begin','End'); (substitute the command above for the Begin and End.

11. Call computer services and ask them to run /gdn00/scripts/gasis_permission_fix.sql

 Revision Date : 7/21/2008