Re: Webdb Error

Steve McKay <deeb1_at_home.com> schreef in berichtnieuws 7pbpgsop2f89iffnvrb6meritdatflbhf5_at_4ax.com...
> Hello,
>
> I have recently installed webdb on a linux box with oracle 8i. After
> the initial install everything was fine. However I rebooted the
> machine. Now every time I try to connect the the webdb site I get the
> following error message:
>
> 28/Apr/2000:16:14:12
>
> ORA-01552: cannot use system rollback segment for non-system
> tablespace
> 'USERS'
> ORA-06512: at "WEBDB.WWV_LOG", line 127
> ORA-06512: at "WEBDB.WWV_LOG", line 272
> ORA-06512: at "WEBDB.WWV_MENU", line 734
> ORA-06512: at "WEBDB.HOMEMENU", line 23
> ORA-06512: at "WEBDB.HOME", line 14
> ORA-06512: at line 5
>
> DAD name: WebDB
> PROCEDURE : WEBDB.home
> USER : webdb
> URL : http://xxx.xxx.xxx.xxx:81/WebDB/WEBDB.home?
> PARAMETERS :
> ===========
>
> ENVIRONMENT:
> ============
> SERVER_PORT=81
> SERVER_SOFTWARE=Oracle WebDb Listener 2.1
> SERVER_NAME=deeb.dhs.org
> GATEWAY_INTERFACE=CGI/1.1
> SERVER_PROTOCOL=HTTP/1.0
> REMOTE_HOST=x.x.x.x
> REMOTE_ADDR=x.x.x.x
> REQUEST_METHOD=GET
> QUERY_STRING=
> SCRIPT_NAME=
> PATH_INFO=/WebDB/WEBDB.home
> HTTP_ACCEPT=image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
> application/pdf, */*
> HTTP_ACCEPT_LANGUAGE=en-us
> HTTP_ACCEPT_ENCODING=gzip, deflate
> HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 5.0; Windows 98;
> DigExt)
> HTTP_HOST=xxxx.xxxx.xxxx:81
> HTTP_CONNECTION=Keep-Alive
> HTTP_AUTHORIZATION=Basic d2ViZGI6d2ViZGI=
>
>
> Unfortunately Im not a dba, so I have no idea how to correct this.
>
> Thank you in advance to anyone who can help.

For a safe configuration
- if you don't have it create a second rollback segment in the tablespace system.
  (create rollback segment rb_temp storage (initial 500k next 500k minextents 2) tablespace system
- alter rollback segment rb_temp online
- create 4 rollback segments in a non-system tablespace, preferably called RBS or ROLLBACK_DATA (to create a tablespace create tablespace RBS etc) to verify whether that tablespace exists, select tablespace_name from dba_tablespaces), in the same fashion you did above, however, make the initial and next extent at least 2M
- alter them to be online.
- add the four rollback segments to $ORACLE_HOME/dbs/init<SID>.ora in the following fashion
rollback_segments=(r0,r1,r2,r3)
to make sure they will be online the next time you restart the database. Save init<sid>.ora and bounce the database. The rb_temp will be spare, in case of emergency.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon May 01 2000 - 00:00:00 CEST