Assignment 5:‐PARAMETER & PASSWORDFILE - eshan3101/DataBase-Architech GitHub Wiki

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

2.Create password file with sys password as oracle1

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

4.How to check all parameters associated with database? image image image

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

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

7.How to check which parameter files cannot be changed? image image image

image

2.Checking IP image

3.seconf way to check IP image

4.opening 2nd VM image

5.doing settings in 2nd VM & pitting the IP address manually image

6.Checking IP address in 2nd machine image

7.checking connections in both the VM image

image

8.setting environment image

9.creating listners image

10.starting listener image

⚠️ **GitHub.com Fallback** ⚠️