Re: Error in Oracle Database Cache Configuration Assistant

From: Andreas Stephan <as.no.spam.stedat_at_gmx.net>
Date: Wed, 19 Dec 2001 10:36:45 GMT
Message-ID: <3c206d63.85832931@by-news.bayer-ag.com>

On 19 Dec 2001 08:54:02 GMT, Cyber Office <jcheong_at_cooper.com.hk> wrote:

>When I installed o9ias on Linux, I got the following error when
>Configuring the Cache:
>
>--------------------------------------
>Preparing the Origin Database
>Installing PL/SQL packages
>Retrieving the global name
>Retrieving the character set
>Retrieving the national character set
>
>Configuring the Cache
>Creating the Cache
>Starting up the Cache
>Setting up the Cache Listener
>Connecting to the Cache
>Verifying the Cache
>Creating the Cache failed.
>Reason: ORA-01219: database not open: queries allowed on fixed
>tables/views only
>
>Processing failed.
>
>
>--

Seems as if the db has crashed.
Have a look in your alert_SID.ora file. You will find an error describing why the db crashed (error msg).

hth
Andy

>http://www-902.ibm.com/hk/sme/corner/solution_detail.html#a3
>http://www.attunity.com

---

Andreas Stephan
Oracle DBA

---

Pls. remove .no.spam from my mailaddress Received on Wed Dec 19 2001 - 04:36:45 CST