Re: 8.1.7 on RH7.3 database creation problems.

From: dbuckingham <member8912_at_dbforums.com>
Date: Thu, 07 Aug 2003 04:52:59 +0000
Message-ID: <3211333.1060231979@dbforums.com>

ORA-01403 on startup of database

ORACLE instance started.

Total System Global Area                                72704160

bytes
Fixed Size
73888 bytes
Variable Size
55681024 bytes
Database Buffers

16777216        bytes
Redo Buffers                                            172032  bytes

Database Mounted
ORA-01403: No Data Found

The initial database creation was incomplete due to errors such as:

ORA-00603: ORACLE server session terminated by fatal error
ORA-01990: error opening password file <name>
ORA-00600: internal error code

which were ignored at the time of the database creation. Since data population into props$ table happens at the end of database creation, incomplete database creation will not populate this table hence this above error.

Solution Description:

---

The sys.props$ table is not properly populated with NLS parameter values.

To verify, you have to check the number of rows in sys.props$:

SVRMGR> connect internal;
connected.
SVRMGR> select count(*) from sys.props$;

The number of rows differs for different versions of the database:

In 7.3.x there should be 14 entries in sys.props$
In 8.0.x there should be 15 entries in sys.props$
In 8.1.x there should be 21 entries in sys.props$

Check the alert.log file for other possible errors. For example, possible
sys.props$ table corruption message.

The only available solution in this case is to recreate the database.

To solve, delete database, created new password file using orapwd utility and then recreated database.

--

Posted via http://dbforums.com Received on Wed Aug 06 2003 - 23:52:59 CDT