catrep.sql - Installaion Problem

catrep.sql - Installaion Problem

Post by Todd W. McLai » Sun, 31 Dec 1899 09:00:00



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.

 
 
 

catrep.sql - Installaion Problem

Post by Pete Sharma » Sun, 31 Dec 1899 09:00:00


Todd

The catrep script is only needed if you're using replication.  If not, don't
bother run it.  If you are, then log on as the owner of the Oracle kernel
(usually an account called oracle), not as root.  Then ensure your environment
variables are set correctly (specifically ORACLE_HOME and ORACLE_SID) and issue
the following commands:

$ svrmgrl
SVRMGR> connect internal

HTH.

Pete


> 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.

--
Regards

Pete

  psharman.vcf
< 1K Download

 
 
 

catrep.sql - Installaion Problem

Post by David P. Melto » Sun, 31 Dec 1899 09:00:00


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

exit

dpm.



Quote:> 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.

 
 
 

1. Installation: can′t execute catrep.sql

Hello,

at the end of installation I have to execute

   /opt/oracle/product/8.1.5/rdbms/admin/catrep.sql  

But I always get an error (as user oracle or as root):


   sh: ./product/8.1.5/rdbms/admin/catrep.sql: Permission denied

Why ?

Ekkard

2. When to use ADO?

3. catrep.sql

4. Help on cross calculations

5. post-install catrep.sql?

6. Largest Table Size (6.5 and 7.0)

7. Oracle 8.05 + Solaris 2.6 and catrep.sql

8. Problems with Deadlock in Query

9. catrep.sql syntax error ???

10. catrep.sql in 8.1.6

11. catrep.sql

12. catrep