| ORA-01092: ORACLE instance terminated. [message #73839] |
Wed, 21 July 2004 23:51  |
Tarun Biswas
Messages: 23
Registered: May 2004
|
Junior Member |
|
|
i try to create the database manually but following message is coming . pls help
create database TAR
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
Regards,
Tarun
|
|
|
|
| Re: ORA-01092: ORACLE instance terminated. [message #73843 is a reply to message #73839] |
Thu, 22 July 2004 22:10  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Just verify whether you have included any obsolete parameters in the init.ora file.
Are you sure you have included compatible parameter, UNDO_MANAGEMENT etc., in the init.ora file.
This happens because of parameter file only and also verify that the directories on filesystems specified for system, redo, datafiles, control files exist and writable by Oracle.
Please check alert.log file also for correct reason for the instance failure.
Daljit Singh
|
|
|
|
| Re: ORA-01092: ORACLE instance terminated. [message #74181 is a reply to message #73839] |
Wed, 29 September 2004 11:52 |
Kristina M. Murray
Messages: 1
Registered: September 2004
|
Junior Member |
|
|
|
i discovered that my initSID.ora file incorrectly named the UNDO_TABLESPACE listed in my createdb.sql script. once i made sure that my UNDO tablespace was spelled exactly the same in both locations, my database was created and started up no problem. good luck.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
