Home » RDBMS Server » Server Administration » db creation error
db creation error [message #179984] Thu, 29 June 2006 10:14 Go to next message
tedd
Messages: 13
Registered: June 2006
Junior Member
i get this error when i try to open the database
the basic scripts were run when i created the database (catalog and catproc).i am now working with the default database which was created during the installation i use ora-9i server.
the error follows

Enter user-name: /as sysdba
Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 101478272 bytes
Fixed Size 282496 bytes
Variable Size 67108864 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted


SQL> alter database mount;

Database altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
Re: db creation error [message #179989 is a reply to message #179984] Thu, 29 June 2006 10:37 Go to previous messageGo to next message
tedd
Messages: 13
Registered: June 2006
Junior Member
when i shutdown i get the following msg
SQL> shu
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
Re: db creation error [message #180837 is a reply to message #179989] Wed, 05 July 2006 08:03 Go to previous message
imtj
Messages: 12
Registered: July 2006
Location: Chinese
Junior Member
Please parse alter.log content.
Previous Topic: how to copy the data from the data file
Next Topic: monitoring Oracle database
Goto Forum:
  


Current Time: Fri Sep 20 10:40:08 CDT 2024