Re: repository creation problem

I have resolved this problem, but would appreciate it if anyone can supply a few references to oracle tutorials / learning resources on the web.

thanks

Iain

i.b.kerr_at_leeds.ac.uk (IKerr) wrote in message news:<83462b5a.0210220747.7a753f68_at_posting.google.com>...
> Hi,
>
> I am a complete newbie to oracle (using v9) and am trying to create a
> repository. The following error has come up in the
> "CKGLBWRK
> Creating the Global Shared Work Area"
>
> stage. Object details: "CKGLBWRK" in "CKGLBWRK.sql". Below follows
> the error messages. Can anyone help please.
>
> thanks
>
> Iain
>
> Message
> -------
> ORA-04068: existing state of packages has been discarded
>
> Cause
> -----
> One of errors 4060 - 4067 when attempt to execute a stored
> procedure.
>
>
> Action
> ------
> Try again after proper re-initialization of any application's
> state.
>
>
> --------------------------------------------------------------------------------
>
> Message
> -------
> ORA-04063: package body "C3031819.JR_WORKAREA" has errors
>
> Cause
> -----
> Attempt to execute a stored procedure or use a view that has
> errors. For stored procedures, the problem could be syntax errors
> or references to other, non-existent procedures. For views,
> the problem could be a reference in the view's defining query to
> a non-existent table.
> Can also be a table which has references to non-existent or
> inaccessible types.
>
>
> Action
> ------
> Fix the errors and/or create referenced objects as necessary.
>
>
> --------------------------------------------------------------------------------
>
> Message
> -------
> ORA-06508: PL/SQL: could not find program unit being called
>
> Cause
> -----
>
>
>
> Action
> ------
>
>
>
> --------------------------------------------------------------------------------
>
> Message
> -------
> ORA-06512: at line 108
>
> Cause
> -----
> Backtrace message as the stack is unwound by unhandled
> exceptions.
>
>
> Action
> ------
> Fix the problem causing the exception or write an exception
> handler for this condition. Or you may need to contact your
> application administrator or DBA.
>
>
> --------------------------------------------------------------------------------
>
> Message
> -------
> RME-02124: Failed to execute SQL statement:
> DECLARE
> wkarea_irid number;
> rtn_id number;
> comment varchar2(100);
> l_SUPPORTS_DESIGNER varchar2(1);
> l_SUPPORTS_JDEVEE varchar2(1);
>
> BEGIN
> dbms_output.enable(1000000);
>
> -- Added for Bug 1326447
> update ck_installed_objects
> set ci_created = 'N'
> where ci_stage='CKGLBWRK';
> -- End addition for Bug 1326447
>
> select SUPPORTS_JDEVEE
> , SUPPORTS_DESIGNER
> into l_SUPPORTS_JDEVEE
> , l_SUPPORTS_DESIGNER
> from rm$repositories;
>
> -- Create a Shared WorkArea called GLOBAL SHARED WORKAREA
> dbms_output.put_line('* Creating Shared WorkArea named GLOBAL SHARED
> WORKAREA' );
>
> comment := 'Global Shared Workarea for a Non-Versioned Repository';
>
> wkarea_irid := jr_workarea.create_workarea( user,
> 'GLOBAL SHARED
> WORKAREA',
> comment,
> 'SHARED');
>
> -- Added to Fix 1132361 need to grant access on WA to PUBLIC so that
> subordinates can connect to it
> rtn_id := jr_acc_rights.ins( wkarea_irid
> , 'WA'
> , sdd_acc_priv_list('Y', -- 'Delete'
> 'N', -- 'Administrate'
> 'Y', -- 'Insert'
> 'Y', -- 'Select'
> 'Y', -- 'Update'
> 'N', -- 'Version'
> 'N', -- 'Compile'
> 'N') -- 'Update Spec'
> , 'PUBLIC');
>
> -- Revoke access rights from workarea
> dbms_output.put_line('* Revoking Configuration Management and
> Version Control access rights from GLOBAL SHARED WORKAREA');
>
> update sdw_access_rights
> set access_privs = sdd_acc_priv_list('Y', -- 'Delete'
> 'Y', -- 'Administrate'
> 'Y', -- 'Insert'
> 'Y', -- 'Select'
> 'Y', -- 'Update'
> 'N', -- 'Version'
> 'N', -- 'Compile'
> 'N') -- 'Update Spec'
> where object_type = 'WA'
> and object_reference = wkarea_irid;
>
>
> -- Revoke system privileges from repository owner
> dbms_output.put_line('* Revoking Configuration Management and
> Version Control system privileges');
>
> update sdw_users
> set system_privs = sdd_sys_priv_list('N', -- 'Manage Workarea'
> 'N', -- 'Manage Configuration'
> 'Y', -- 'Manage Container'
> 'Y', -- 'Manage User'
> 'N', -- 'Manage Branch Label'
> 'Y', -- 'Manage Dependency'
> 'N', -- 'Manage VVC' ** NOT USED **
> 'Y', -- 'Register Schema'
> 'Y', -- 'Set Policy'
> 'N', -- 'Purge'
> 'Y', -- 'Force Delete'
> 'N', -- 'Global Purge'
> 'Y', -- 'Connect via Repository Object Navigator'
> 'Y', -- 'Connect via Repository Adminstration Utility'
> 'Y', -- 'Connect via Matrix Diagrammer'
> 'Y', -- 'Connect via Repository Reports'
> 'Y', -- 'Connect via Command Line Interface'
> 'N', -- 'Connect via Version History Viewer'
> 'N') -- 'Connect via Version Event Viewer'
> where username = user
> and sdd_owner = 'Y';
>
> -- if we have got this far evereything should have worked correctly
> -- update ck_installed_objects to reflect this
> -- Added for Bug 1326447
>
> update ck_installed_objects
> set ci_created = 'Y'
> where ci_stage='CKGLBWRK';
> -- End addition for Bug 1326447
>
> commit;
>
> dbms_output.put_line('* Operation Complete');
>
> EXCEPTION
>
> WHEN OTHERS THEN
> dbms_output.put_line('* Exception Raised ');
> dbms_output.put_line('...ERROR: '||substr(sqlerrm,1,240));
> rollback work;
>
> Cause
> -----
> An error occurred while executing a SQL statement.
>
>
> Action
> ------
> Examine reported errors for specific details.
>
>
> --------------------------------------------------------------------------------
Received on Tue Oct 22 2002 - 18:47:52 CDT