Repository navigation
Assignment 5:‐PARAMETER & PASSWORDFILE
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?
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 cannot be changed?
2.Checking IP
3.seconf way to check IP
4.opening 2nd VM
5.doing settings in 2nd VM & pitting the IP address manually
6.Checking IP address in 2nd machine
7.checking connections in both the VM
8.setting environment
9.creating listners
10.starting listener
