Problem creating second instance
From: Ross Klippert <rossk_at_cso.geg.mot.com>
Date: Fri, 10 Mar 1995 22:30:00 GMT
Message-ID: <1995Mar10.223000.10683_at_schbbs.mot.com>
Date: Fri, 10 Mar 1995 22:30:00 GMT
Message-ID: <1995Mar10.223000.10683_at_schbbs.mot.com>
--- I am encountering a problem trying to create a second database instance under Oracle 7 runnig on a SCO Unix platform. I have used both the orainst procedure and also modifications of existing crdbxxx.sql scripts. The problem arrises while attempting to run the catproc.sql script to add PL/SQL support. When the standard.sql script is run I am receiving the following:Received on Fri Mar 10 1995 - 23:30:00 CET
.
.
.
drop public synonym ORA_KGLR7_DB_LINKS * ORA-01432: public synonym to be dropped does not exist tatement processed. Statement processed. is * ORA-00900: invalid SQL statement create or replace package body STANDARD is * ORA-00900: invalid SQL statement ORA-04043: object DBMS_STANDARD does not exist create package dbms_standard is * ORA-00900: invalid SQL statement create package body dbms_standard is * ORA-00900: invalid SQL statement
.
.
.
And the problems snowball from here. The original instance "orac" created on install works just fine, but I can't get a second to install correctly. Any and all hints are greatly appreciated. Thanks, ------------------------------------------------------------------------------ Ross Klippert | Motorola GSTG | Scottsdale, AZ | rossk_at_cso.geg.mot.com | (602)-441-6794 | ------------------------------------------------------------------------------