How do I set up the options files to start an Oracle database instance?

Question

Oracle

My task is to create a database instance, which I did (My database administration environment is sqlplus) , whose name and SID = 'orcl'. Now I need to run it, but for this I need 4 parameter files for this database instance, respectively:

* spfileORCL.ora
* spfile.ora
* initORCL.ora
* init.ora

When initializing the DB (Database) 'orcl' , the init.ora file is created, and the rest are not. In this case, what should I do with respect to these remaining three files in order to successfully launch the orcl database: you still need to create them yourself and manually write something else in them to set up the configuration inside these files, or is there such a command for sqlplus or sql, which creates and binds these 3 files to a specific instance of the database, which one do I want? If so, what should I put on the command line? And then so much water is written in docs.oracle.com, but my question regarding those files is too specific and therefore I can’t find the answer to my question there?

Answer 1

Do you really need two files init.ora (pfile) and spfile.ora (spfile) to start an instance, or do you have 2 instances? If you have one instance, then you just need to create an spfile.
init.ora and initORCL.ora are normal parameter files that can be edited.
spfile.ora and spfileORCL.ora are binary files that cannot be edited. They can be created with the command:

SQL> create SPFILE from PFILE='c:\temp\initORCL.ora';
File created.

There are a lot of manuals on the Internet for creating a database with handles, for example here .

Answer 2

I recommend that you start reading the documentation with the concepts.
https://docs.oracle.com/cd/E11882_01/server.112/e4...