Re: Install replication on solaris

From: <mikes_at_bcs.org.uk>
Date: Wed, 25 Aug 1999 09:14:50 GMT
Message-ID: <7q0c65$fkg$1@nnrp1.deja.com>

I have seen this problem on NT also. There is a known bug in the catrep.sql script. Basically there is a blank line between a create table statement and the executing "/" e.g. create table ... (
..)

/
Oracle's solution to this was to run it from svrmgr not sqlplus and this seems to work. To trap this try running it from sqlplus with echo on and a spool file then look for errors.

Hope this helps

Mike

In article <37C1B101.3C4664D1_at_us.oracle.com>,   Pete Sharman <psharman_at_us.oracle.com> wrote:
> This is a multi-part message in MIME format.
> --------------985C0BF75B41704F6BBD3BD8
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Guy
>
> What's the output of running catrep.sql show? It could be one of a
> couple of things:
>
> 1. You couldn't create a table for space reasons, and packages
depended
> on the table (and hence weren't created)
> 2. Your shared pool is too small (should be at least 18 Mb).
>
> HTH.
>
> Pete
>
> palgi_at_my-deja.com wrote:
>
> > I have a problem installing replication on Solaris.
> >
> > I run all the scripts in order to create the tables ,view , packages
> > but some of the packages/tables have not been created or
> > that the packages does not compile fine.
> >
> > Did anyone had this problem or have an idea what should i do ?
> >
> > Thanks Guy Peleg
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
>
> --
> Regards
>
> Pete
>
> --------------985C0BF75B41704F6BBD3BD8
> Content-Type: text/x-vcard; charset=us-ascii;
> name="psharman.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Pete Sharman
> Content-Disposition: attachment;
> filename="psharman.vcf"
>
> begin:vcard
> n:Sharman;Peter
> tel;cell:+1.650.868.9969
> tel;fax:+1.650.633.1669
> tel;work:+1.650.607.0109
> x-mozilla-html:FALSE
> url:http://eif.us.oracle.com
> org:Advanced Technology Solutions;Oracle Corporation
> adr:;;500 Oracle Parkway M/S OPL-A4019;Redwood
Shores;California;94065;USA
> version:2.1
> email;internet:psharman_at_us.oracle.com
> title:Managing Principal Consultant
> note;quoted-printable:=0D=0A=0D=0A **** The statements and opinions
expressed here are my **** =0D=0A **** own and do not necessarily

represent those of          **** =0D=0A **** Oracle
Corporation.                                             =20

****=0D=0A=0D=0A"Controlling application developers is like herding cats." =0D=0AKevin Loney, ORACLE DBA Handbook =0D=0A=0D=0A"Oh no it's not! It's much harder than that!" =0D=0ABruce Pihlamae, long term ORACLE DBA
> x-mozilla-cpt:;24448
> fn:Pete Sharman
> end:vcard
>
> --------------985C0BF75B41704F6BBD3BD8--
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 25 1999 - 04:14:50 CDT