Assignment 1

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

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?

6. How to check which parameter files required DB bounce for the changes to get reflected?

7. How to check which parameter files which can be change dynamically ?

8. How to check which parameter files cannot be changed?