Standby Database

[vbsmanian]

Hi All,

When I open the standby database in read only mode and
try to connect as any user other than internal, I get
the following error

$ sqlplus hll/hll

SQL*Plus: Release 8.1.6.0.0 - Production on Sun Sep 2 03:38:20 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-00372: file 1 cannot be modified at this time
ORA-01110: data file 1: '/hll_d1_s0/system/hllrsnet/sys1hllrsnet.dbf'


Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-00372: file 1 cannot be modified at this time
ORA-01110: data file 1: '/hll_d1_s0/system/hllrsnet/sys1hllrsnet.dbf'



Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

Is this error a serious one ? How do I rectify this ?
Also once connected,I'm not able to execute any query which has a group by clause.
eg.
select distinct type,count(distinct name) from user_source group by type
*
ERROR at line 1:
ORA-25153: Temporary Tablespace is Empty

What should I do, if I have to execute complex queries ?


Thanks

manian

[julian]

Once connected write first:

SET TRANSACTION READ ONLY;

Are you querying the standby directly or through a database link from the primary database? There is a bug concerning queries via DB links.

The 2nd issue: If it is not possible to increase sort_area_size on the standby large enough to handle the sorting needs, you need a temporary tablespace. However, it is not possible to create a temporary tablespace directly on the standby. It must be created on the primary database and be propagated to the standby using the same procedure

Why do you read from standby? Be careful with that!