Re: Oracle EBU installation questions

It sounds like you need to run the catproc.sql script. It should be located in the $ORACLE_HOME/rdbms/admin directory.

Scott Dravet

Rick Larson wrote:
>
> I installed Oracle7 Enterprise Backup Utility release 2.0.12.4 on my
> Solaris 2.5.1 system.
>
> When I installed the backup catalog, I ran into a couple of problems.
> I created the database using the obkcrbkcat.sh script. This seems to
> create the database tables, user, password, ...
>
> I used obackup to test the installation but it fails when I register it
> target database.
>
> The obackup script file looks like:
> db_name = "CMS_VIEW"
> oracle_home = "/home/oracle"
> oracle_sid = "CMS_VIEW"
> pfile = "?/dbs/init@.ora"
> log = "/home/oracle/obackup/log/obkCMS_VIEW.log"
>
> The output is:
>
> oracle# obackup cms_view
>
> Oracle7 Enterprise Backup Utility: Release 2.0.12.4.0 - Production on Tue May 13 15:11:17 1997
>
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
>
> CORE Version 2.3.7.1.0 - Production (LSF Alpha)
> NLSRTL Version 2.3.6.0.0 - Production
>
> REGISTER job FAILED
>
> The log file contains:
>
>
> Oracle7 Enterprise Backup Utility: Release 2.0.12.4.0 - Production on Tue May 13 15:11:18 1997
>
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
>
> CORE Version 2.3.7.1.0 - Production (LSF Alpha)
> NLSRTL Version 2.3.6.0.0 - Production
> Tape API: Release 1.1
> Tape Management Software: Release 2.0.0.0
> System name: SunOS
> Node name: westmalle
> Release: 5.5.1
> Version: Generic
> Machine: sun4u
>
> Command script "cms_view", follows:
> register
> db_name = "CMS_VIEW"
> oracle_home = "/home/oracle"
> oracle_sid = "CMS_VIEW"
> pfile = "?/dbs/init@.ora"
> log = "/home/oracle/obackup/log/obkCMS_VIEW.log"
>
> Verifying presence of Instance Manager process...
> OBK-2627: SQL statement failed. "BEGIN SELECT BRDID..." - sqlerror=-6553
> on 05/13/1997 15:11:18 [ 23663 : brctjbrdpid ]
> OBK-504: SQL error ORA-06553: PLS-213: package STANDARD not accessible
>
> on 05/13/1997 15:11:18 [ 23663 : brctjbrdpid ]
> OBK-2687: ORA-6553 is normally caused due to: a)procedural option not installed or b)catproc.sql not run in Catalog Database
> on 05/13/1997 15:11:18 [ 23663 : brctjbrdpid ]
> OBK-3120: SQL error reported from Catalog Database
> on 05/13/1997 15:11:18 [ 23663 : brcbrd ]
> OBK-2453: Error while obtaining information about Instance Manager in Catalog
> on 05/13/1997 15:11:18 [ 23663 : brcbrd ]
> REGISTER job FAILED
>
>
> Does anyone know what is wrong?
> Any idea what 'catproc.sql not run in Catalog Database' means and
> how to fix it?
>
> I have a TAR from Oracle but haven't heard back since last week.
>
> I really need to get this done. I'll even re-install if it helps.
>
> rick
> --
> Rick Larson rick_at_adc.com
> ADC Telecommunications, Inc. Voice: (612) 896-2707
> 4900 West 78th Street, MS34 FAX: (612) 896-2959
> Minneapolis, MN 55435
  Received on Wed May 14 1997 - 00:00:00 CDT