NovaCharged
asked on
How to resolve ORA-01092 - Oracle Instance Terminated. Disconnection Forced Error
Gurus,
Listed below is the code which generated the error. I need help resolving this FAST!!
Thanks!
SQL> startup nomount pfile=%ORACLE_HOME%\databa se\initPTS YS.ora
ORACLE instance started.
Total System Global Area 101784276 bytes
Fixed Size 453332 bytes
Variable Size 50331648 bytes
Database Buffers 50331648 bytes
Redo Buffers 667648 bytes
SQL>
SQL> CREATE DATABASE PTSYS
2 maxdatafiles 1021
3 maxinstances 1
4 maxlogfiles 8
5 maxlogmembers 4
6 CHARACTER SET WE8ISO8859P15
7 DATAFILE 'D:\ORACLE\oradata\PTSYS\s ystem01.db f' SIZE 2000M
8 LOGFILE 'D:\ORACLE\oradata\PTSYS\l og01.dbf' SIZE 70M,
9 'D:\ORACLE\oradata\PTSYS\l og02.dbf' SIZE 70M;
CREATE DATABASE PTSYS
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
Listed below is the code which generated the error. I need help resolving this FAST!!
Thanks!
SQL> startup nomount pfile=%ORACLE_HOME%\databa
ORACLE instance started.
Total System Global Area 101784276 bytes
Fixed Size 453332 bytes
Variable Size 50331648 bytes
Database Buffers 50331648 bytes
Redo Buffers 667648 bytes
SQL>
SQL> CREATE DATABASE PTSYS
2 maxdatafiles 1021
3 maxinstances 1
4 maxlogfiles 8
5 maxlogmembers 4
6 CHARACTER SET WE8ISO8859P15
7 DATAFILE 'D:\ORACLE\oradata\PTSYS\s
8 LOGFILE 'D:\ORACLE\oradata\PTSYS\l
9 'D:\ORACLE\oradata\PTSYS\l
CREATE DATABASE PTSYS
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi.
I removed the parameter REMOTE_PASSWORD_FILE from the init.ora and that was it, my CREATE DATABASE command finally worked.
Hope it helps.
I removed the parameter REMOTE_PASSWORD_FILE from the init.ora and that was it, my CREATE DATABASE command finally worked.
Hope it helps.
regards