vsuripeddi
asked on
Oracle error during database creation --- ORA-01092: ORACLE instance terminated. Disconnection forced
Experts,
I am getting this ORA-01092 during database creation ---- Oracle9i database on Solaris
I tried a bunch of things --- ranging from changing the init.ora parameters ,
tried creating without UNDO, temp tablespaces etc.
this getting this error.
(I created a similar database successfully on Redhat Linux9 with almost identical settings and it worked
But getting this error on Solaris)
-------------------------- ---------- ---------
THis is the content of the alert log :
ORA-01501: CREATE DATABASE failed
ORA-01526: error in opening file '?/rdbms/admin/sql.bsq'
ORA-07391: sftopn: fopen error, unable to open text file.
Error 1526 happened during db open, shutting down database
USER: terminating instance due to error 1526
Instance terminated by USER, pid = 9056
ORA-1092 signalled during: CREATE DATABASE HANPROD NOARCHIVELOG
control...
-------------------------- ---------- ---------- --
I am getting this ORA-01092 during database creation ---- Oracle9i database on Solaris
I tried a bunch of things --- ranging from changing the init.ora parameters ,
tried creating without UNDO, temp tablespaces etc.
this getting this error.
(I created a similar database successfully on Redhat Linux9 with almost identical settings and it worked
But getting this error on Solaris)
--------------------------
THis is the content of the alert log :
ORA-01501: CREATE DATABASE failed
ORA-01526: error in opening file '?/rdbms/admin/sql.bsq'
ORA-07391: sftopn: fopen error, unable to open text file.
Error 1526 happened during db open, shutting down database
USER: terminating instance due to error 1526
Instance terminated by USER, pid = 9056
ORA-1092 signalled during: CREATE DATABASE HANPROD NOARCHIVELOG
control...
--------------------------
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.