Re: Help! how do I "run" catrep?

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sat, 03 Apr 1999 23:25:44 GMT
Message-ID: <370c8e0b.2591489@netnews.worldnet.att.net>

On Sat, 03 Apr 1999 04:53:42 GMT, sams_at_mediateam.de wrote:

> "run catrep.sql"
>
>How on earth do I *do* that? I dont know which of the many executables I need
>to start and under which user name in order to "run" the script.

Bruce,

You run that script using Server Manager. Log on as the oracle user, and from the Unix command line, issue the following commands:

svrmgrl
svrmgr> connect internal
svrmgr> @$ORACLE_HOME/rdbms/admin/catrep.sql

and away you should go. I'm not 100% certain about the path, but I think I'm remembering it right. I can't check easily right now.

If you get a strange error when you start Server Manager, you may need to setup your Oracle environment. For example:

ORACLE_SID=ORCL; export ORACLE_SID
ORACLE_HOME=/oracle/product/8.0.5; export ORACLE_HOME LD_LIBRARY_PATH=/oracle/product/8.0.5/lib:/usr/lib; export LD_LIBRARY_PATH

Hope this helps.

regards,

Jonathan Received on Sat Apr 03 1999 - 17:25:44 CST