Re: catrep.sql - Installaion Problem

The only script which should be run as root is the 'root.sh' script which is normally run ONCE just after the installation of the oracle software. It's in the $ORACLE_HOME/orainst directory.

The caprep.sql script loads the system tables with the tables and views necessary to support database replication.

Wen using server manager you must be logged in as oracle or a unix account which has the 'dba' group, then

cd $ORACLE_HOME/rdbms/admin

svrmgrl
connect internal
@catrep.sql
exit

dpm.

Todd W. McLain <mclaint_at_kdd-ok.ne.jp> wrote in message news:7mhir2$315d$1_at_news2.marinemwr.or.jp...
> I just installed Oracle 8.0.5 on a Sparc w/ Solaris 2.7. Following
through
> with post-installation steps, the documentation says to run the catrep.sql
> script as the root user. I tried doing this straight from server manager,
> but after each entry I get : ORA-01012: not logged on
>
> I then tried connect internal to log into server manager, but it
asks
> me for a password. I have tried the password for the oracle account and
for
> the system account when the database was created, but it only comes back
> with: ORA-01031: insufficient privileges
>
> The installation documentation is fairly well written, but is very vague
on
> this part. Does anybody know how I can get the script to run.
>
> Thanks.
>
> Todd W. McLain
> Systems Engineer
> KDD Okinawa Service Co., Ltd.
>
>
Received on Wed Jul 14 1999 - 20:05:33 CDT