| Which parameter file [message #110917] |
Fri, 11 March 2005 01:40  |
PompeytilIDie
Messages: 9
Registered: March 2005
Location: Western Australia
|
Junior Member |
|
|
May sound a noddy question, but how can I determine which parameter file is being used by my databases. My predecessor favoured the shotgun approach to DB admin and has scattered files wide and far. I have parameter files in /dbs, /var, /var/opt, /admin, ...... While amusing to you no doubt, it's causing me a lot of stress.
Any help would be gratefully received. Thanks in advance.
|
|
|
|
| Re: Which parameter file [message #110923 is a reply to message #110917] |
Fri, 11 March 2005 02:40  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
If your database is using an SPFILE, you can do the following:
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /app/oracle/product/10.1.0/dbs
/spfileorcl.ora
If not, you have a problem. Try to compare all those files (Unix diff command). If you are lucky they might all be the same.
Best regards.
Frank
|
|
|
|
| Re: Which parameter file [message #111672 is a reply to message #110917] |
Fri, 18 March 2005 09:54 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
When you start up the db, are you telling it which pfile to use? If not, one option is to create your own, and then use it explicitly whenever you start the database. Then you could get rid of all of the other pfiles out there.
Also your platform should have a default pfile location, so it is probably using the file that is there.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
