السلام عليكم و رحمه الله و بركاته

عندي مشكلة في قاعدة البيانات. عندما اقوم بعمل Startup لقاعدة البيانات يظهر لي هذا المسج
ORA-01092: ORACLE instance terminated. Disconnection forced


ارجوكم افيدوني في حل هذه المشكلة

is there any other error in the alert log file?

dear all
[l have same problem when l try to open database (startup) l see this message
ORA-01092: ORACLE instance terminated. Disconnection forced
and also i have another problem whenever l comleted the database and create if l want to execute scrips catalog.sql and catproc.sql l saw this message also
ERROR at line 1:
ORA-39706: schema 'DBSNMP' not found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_REGISTRY", line 71
ORA-06512: at "SYS.DBMS_REGISTRY", line 494
ORA-06512: at line 2

تم تعديل 4 يناير 200818 سنة بواسطة ganabo

dear all
[l have same problem when l try to open database (startup) l see this message
ORA-01092: ORACLE instance terminated. Disconnection forced
and also i have another problem whenever l comleted the database and create if l want to execute scrips catalog.sql and catproc.sql l saw this message also
ERROR at line 1:
ORA-39706: schema 'DBSNMP' not found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_REGISTRY", line 71
ORA-06512: at "SYS.DBMS_REGISTRY", line 494
ORA-06512: at line 2

if you used the dbca (database create assistance), would you have the same problem ?

dear sir
l did't use dbca (database create assisstance)

try the following command
startup force

try the following command
startup force

daer sir
l tried but isnot working
today l try to create database is created but when l want to execute script catalog.sql is executed but catproc.sql is not executed
l saw this messege
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS.SOURCE$ by 25 in tablespace SYSTEM


BEGIN
*
ERROR at line 1:
ORA-39706: schema 'DBSNMP' not found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_REGISTRY", line 71
ORA-06512: at "SYS.DBMS_REGISTRY", line 494
ORA-06512: at line 2

deat all
el hamdo llaha
l resolve my problem jusr i did that to increase the size of system tablespace
because the capacity is not suffucient for it
but the first you should delete all thing it created in some destination like bdump after that you can create again
thanks