Link to home
Start Free TrialLog in
Avatar of NovaCharged
NovaChargedFlag for United States of America

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%\database\initPTSYS.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\system01.dbf'   SIZE   2000M
  8  LOGFILE        'D:\ORACLE\oradata\PTSYS\log01.dbf'         SIZE   70M,
  9                'D:\ORACLE\oradata\PTSYS\log02.dbf'         SIZE   70M;
CREATE DATABASE   PTSYS
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ASKER CERTIFIED SOLUTION
Avatar of meluhk
meluhk

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of helpneed
helpneed

could you please paste the alert log.....


regards
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.