Assignment 1

1. Create pfile from spfile to location '/home/oracle/init<sid.ora>'

<img width="722" height="150" alt="image" src="https://github.com/user-attachments/assets/f8d4a3d5-aa6c-420f-8b03-b683974163d5" /

2. Create password file with sys password as oracle1

3. Create parameterfile in different location /u01 & start the DB to up and running condition.

4. How to check all parameters associated with database?

Display all initialization parameters

Display specific parameters

5. How to change specific parameters with Scope=both/spfile/memory?