Re: DB creation from script - problems

This is because the script has been written to be capable of being repeated. You should ignore this message, it means nothing! As to the startup issue,
please make sure your oratab is correct. On most Unix ports it is located in /etc/oratab.
The SID should be there as follows
WWS <your oracle home> Y
(which signifies whether the database will be started automatically at boot, when the boot scripts
have been configured properly)
Before you start a database manually you need to set $ORACLE_SID. You are advised to do that by using
. oraenv

This will read /etc/oratab, and set all environment variables accordingly. I'm a bit tempted to use a famous four letter abbreviation.

Hth anyway,

Sybrand Bakker, Oracle DBA

kev <kevin.porter_at_fast.no> wrote in message news:37BAE6CF.3B4D7536_at_fast.no...
> 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 Wed Aug 18 1999 - 12:37:02 CDT