Re: DB creation from script - problems

The ora-01432 message is normal. It is save to ignore in this case.

You can either control the databases that start up with the oratab file, or
if you are starting and stopping them manually just set ORACLE_SID in your
environment to the database that you want. The best way is to do like this:

> . oraenv

and then answer the prompt(s).

Ken

kev wrote:

> Hi,
>
> I've managed to create and run my DB creation script - however it
> doesn't do what I expected properly.
> First off, the errors - the first one is:
>
> "drop public synonym v$dlm_misc
> *
> ORA-01432: public synonym to be dropped does not exist"
>
> and I have lots more of these too (about 50 or so).
> Any idea why it's not creating these synonyms in the first place?
>
> I have attached my creation script.
>
> Also, when the script has finished running, if I do a 'ps -auxww | grep
> oracl' I see that there lots of processes with an 'ORCL' extension, but
> none with 'WWS', which is the name of the DB just created.
> Any idea why this is? How can I select whichh DB I want to startup?
>
> Any help very much appreciated,
>
> - Kev
Received on Thu Aug 19 1999 - 06:38:59 CDT