Changes. Symptoms. Then created SPFILE from PFILE.

If running the below, the database starts normally: strace -fo sqlplus_trace.trc sqlplus "/ as sysdba" <===== startup nomount pfile=init.ora. In the mount state control files specify in the parameter file provided during startup are located and read. However in case you would like to start oracle from a remote machine, you will need a local copy of the PFILE in that machine.

startup nomount pfile=init.ora. When you issue a ‘Startup’ command, this is the first stage. PFILE. Oracle 11.2.0.4 running normally on this server. ie, starting up the instance. oracle reads controlfile and check the contents are valid.. then used SPFILE to startup with no issues.you can make spfile from pfile without ever starting the DB. ORACLE_HOME\database\SPFILEORCL.ORA (default location of the binary spfile file, we may open and edit only pfile INITorcl.ORA) SQL> create spfile from pfile; Custom database startup, from the pfile and create spfile from it 1. This file can be edited with a standard text editor like notepad or vi editor. 2) In this state, the database instance is allocated with processes and memory structures but control file is not opened. Ora-01031 When Startup Nomount Pfile= On Windows Platform With Oracle RDBMS and GRID (Doc ID 1466737.1) Last updated on FEBRUARY 03, 2019. Also, you can run this query to see if the database was started via an spfile. This file normally resides on the server. oracle reads pfile/spfile parameters and view the controlfiles in this stage. New database right after installing new Oracle 12.1.0.2 binaries on server RHEL 6. The oracle instance reads the parameter file during startup which are then used to control the behavior of database instance and many other aspects as well. On : 11.2.0.3 version, Database Security Startup Nomount: 1)An instance is started in NOMOUNT mode during database creation,during re-creation of control files or during backup and recovery scenarios. To see whether a pfile opf spfile was used at startup time, the first place to check is the alert log, especially of the startup command contains the pfile or spfile clause. Here, – Oracle will read the parameter file (spfile or pfile) in the default location or in the location specified in the startup command. 2. newbie_962764 wrote: In addition after creating the PFILE , I used PFILE to startup. There are 2 types of parameter files, namely : pfile and spfile

Nomount stage. Startup Mount: when you trigger "startup mount". Total System Global Area 143727516 bytes Fixed Size 453532 bytes Variable Size 109051904 bytes Database Buffers 33554432 bytes Redo Buffers 667648 bytes Database mounted. – It will then allocate the memory area (SGA) and starts the background processes.


Syntax: STARTUP NOMOUNT PFILE = 'initORCL.ora' Database instance startup in MOUNT mode The following is the procedure to mount a database.
A PFILE is a static, client side text file. Such as : memory allocation (SGA and PGA), startup of optional background processes, Setting of NLS parameters etc. Cause Applies to: Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2] Information in this document applies to any platform.

if/when DB starts using pfile, DB will start from spfile made from working pfile. Startup NoMount: when you trigger "startup nomount". SQL> startup pfile='D:\ora9i\admin\ora9i\pfile\init.ora'; ORACLE instance started.