Oracle DBA | Creation of Parameter Files | Bangla | DBA1-13

Опубликовано: 28 Апрель 2026
на канале: OracleDB Solutions
357
5

Oracle DBA | Creation of Parameter Files | Bangla | DBA1-13
To See More DBA part-01 Tutorial Click here    • Oracle DBA (Part-01) Tutorial For Beginners  
To See More DBA part-02 Tutorial Click here    • Oracle DBA (Part-2) Tutorial For Beginners  
To See More Reports Tutorial Click here    • Introduction To Database & Out Line The Se...  
To See More Forms Tutorial Click here    • Oracle Forms: How to Install Oracle Databa...  

Dear viewer, In this tutorial you will know about Parameter Files Create Parameter Files

Concept Of Parameter Files:
A parameter file is a file that contains a list of initialization parameters and a value for each parameter. You specify initialization parameters in a parameter file that reflect your particular installation.

Types of Parameter Files:
Oracle supports the following two types of parameter files:
1.Server parameter file (SPFILE)
2.Text initialization parameter file (PFILE)

Location Of Parameter Files:
SPFILE: E:\app\Administrator\product\11.2.0\dbhome_1\database

PFILE: E:\app\Administrator\product\11.2.0\dbhome_1\database

Create Text initialization parameter file(PFILE):
Command:sql-create pfile from spfile;

Create Server parameter file (SPFILE):
Go shutdown mode
sql-shutdown immediate
Command: sql-create spfile from pfile;

To Get more Tutorial Subscribe The Channel
click here    / @oracledbsolutions2678  

To Get All Post Like The Facebook Page
Click here   / oracledbsolutions  

Follow us:
Facebook:   / oracledbsolutions  
Youtube link:    / @oracledbsolutions2678  
Facebook Group:   / 465557066961548  

Contact us:
email: [email protected]
Skype: oracle26solutions
Mob: 01734557080, 01627422780