Re: Oracle 9iAS + Redhat 9.0

From: vrajaraman <member33310_at_dbforums.com>
Date: Tue, 15 Jul 2003 08:37:06 +0000
Message-ID: <3111306.1058258226@dbforums.com>

Hi ,
i successfully installed the above following the instructions from

http://codah.net/install-oracle9iR2-on-redhat9.html

opened sqlplus /nolog
connected as sysdba

startup nomount
alter database mount

both worked OK

alter database open

failed giving the following error message

Errors in file
/oracledb/opt/oracle/product/9.2.0/rdbms/log/bheema_ora_2314.trc: ORA-01403: no data found
Error 1403 happened during db open, shutting down database USER: terminating instance due to error 1403 Instance terminated by USER, pid = 2314
ORA-1092 signalled during: alter database open ..

---

from the *.trc file

• 2003-07-11 18:36:26.448
• SESSION ID:(7.3) 2003-07-11 18:36:26.448 (blkno = 0x153, size = 276, max = 1, in-use = 1, last-recid= 0) (blkno = 0x154, size = 56, max = 36, in-use = 1, last-recid= 1) ----- Redo read statistics for thread 1 ----- Read rate (ASYNC) = 17Kb/sec => 34 blocks in 1s Read buffer = 8192Kb (16384 blocks) Longest record = 0Kb Record moves = 0/49 (0%)

  ---

• 2003-07-11 18:36:40.147 KCRA: start recovery claims for 10 data blocks
• 2003-07-11 18:36:40.203 KCRA: buffers claimed = 10/10, eliminated = 0 ORA-01403: no data found

searched on the web and was told to increase the kernel shmmax from 2147483648

did that but ran out of memory trying to start up the instance

would appreciate any help in solving this.

thanks

--
Posted via http://dbforums.com

Received on Tue Jul 15 2003 - 03:37:06 CDT