SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-25-2008, 04:45 AM
| ||||
| ||||
 Can't find spfile I'm trying to investigate problems on an oracle 9i server however I cannot find an init.ora, pfile or spfile. What's strange is that show parameter spfile says ?/dbs/spfile@.ora and yet there is no directory dbs in $ORACLE_HOME (linux btw).      |
|
02-25-2008, 04:45 AM
| |||
| |||
| Re: Can't find spfile pfa wrote: > I'm trying to investigate problems on an oracle 9i server however I > cannot find an init.ora, pfile or spfile. What's strange is that show > parameter spfile says ?/dbs/spfile@.ora and yet there is no directory > dbs in $ORACLE_HOME (linux btw). Thoughts that come immediately to mind: Wrong $ORACLE_HOME dbs directory deleted (unix keeps deleted files open until they are closed, you just can't see their directory entries - renaming can be confusing, too) find / -name "*ora" started with a pfile that didn't end in ora broken link to dbs or nfs issue or cluster issue create pfile from spfile What are the problems? jg -- @home.com is bogus. http://www.salon.com/dec96/tomorrow961202.html |
|
02-25-2008, 04:45 AM
| |||
| |||
| Re: Can't find spfile joel garry wrote: > pfa wrote: > > I'm trying to investigate problems on an oracle 9i server however I > > cannot find an init.ora, pfile or spfile. What's strange is that show > > parameter spfile says ?/dbs/spfile@.ora and yet there is no directory > > dbs in $ORACLE_HOME (linux btw). > > Thoughts that come immediately to mind: > > Wrong $ORACLE_HOME Don't believe so...sqlplus is working and which sqlplus shows it under the bin under $ORACLE_HOME > dbs directory deleted (unix keeps deleted files open until they are > closed, you just can't see their directory entries - renaming can be > confusing, too) Ok, could be, it's not my machine > find / -name "*ora" Yeah, did that, only found network/admin files > started with a pfile that didn't end in ora > broken link to dbs or nfs issue or cluster issue ok, maybe...I'll have to investigate that. > create pfile from spfile Is that a suggestion or that I should be looking for a pfile? show parameter pfile results in the same spfile display. Couldn't find any file containing *pfile*. > > What are the problems? All I wanted to do was modify the init.ora/spfile to set a trace file (for ORACLE_TRACE_ENABLE) to track down a ORA-03113 error in an OCI app. However, I've just realised unless I can guess the oracle password I'm screwed :-( |
|
02-25-2008, 04:45 AM
| |||
| |||
| Re: Can't find spfile pfa wrote: > joel garry wrote: > > pfa wrote: > > > I'm trying to investigate problems on an oracle 9i server however I > > > cannot find an init.ora, pfile or spfile. What's strange is that show > > > parameter spfile says ?/dbs/spfile@.ora and yet there is no directory > > > dbs in $ORACLE_HOME (linux btw). > > > > Thoughts that come immediately to mind: > > > > Wrong $ORACLE_HOME > Don't believe so...sqlplus is working and which sqlplus shows it under > the bin under $ORACLE_HOME > > > dbs directory deleted (unix keeps deleted files open until they are > > closed, you just can't see their directory entries - renaming can be > > confusing, too) > Ok, could be, it's not my machine > > > find / -name "*ora" > Yeah, did that, only found network/admin files > > > started with a pfile that didn't end in ora > > broken link to dbs or nfs issue or cluster issue > ok, maybe...I'll have to investigate that. > > > create pfile from spfile > Is that a suggestion or that I should be looking for a pfile? show > parameter pfile results in the same spfile display. Couldn't find any > file containing *pfile*. > > > > > What are the problems? > All I wanted to do was modify the init.ora/spfile to set a trace file > (for ORACLE_TRACE_ENABLE) to track down a ORA-03113 error in an OCI > app. However, I've just realised unless I can guess the oracle password > I'm screwed :-( 1- The create pfie command will create an init.ora file from the spfile. You can then modify the init.ora file and use if to re-create the spfile. 2- Even if you have lost the SYS password you can connect to Oracle using the default OS security feature. You have to be a member of the same UNIX group as the Oracle owner, usually Oracle. Once connected you are SYS and can reset the password. 3- Instead of tracing the entire database why not just set a 3113 event and trace those processes that puke on the error? HTH -- Mark D Powell -- |
|
02-25-2008, 04:45 AM
| |||
| |||
| Re: Can't find spfile Ok, looks like I'll have to wait 'till they wake up in India as the only login I know isn't in oracle's group :-( As for tracing...I'm a complete newbie on that. At this time of day I'm the only one on the machine so I'm only going to see my activity. The process that causes the error is an OCI app. I can re-run it and it always crashes (takes about 10-15mins). It performs a series of OCIStmtExecute/Fetch operations (way too many to step through using dbx) then suddenly the 3113 error occurs. Any other suggestions on how I might trace what's causing the 3113 error (I'm guessing it maybe dodgy XML in an XMLTYPE column but...I am guessing)? Mark D Powell wrote: > pfa wrote: > > joel garry wrote: > > > pfa wrote: > > > > I'm trying to investigate problems on an oracle 9i server however I > > > > cannot find an init.ora, pfile or spfile. What's strange is that show > > > > parameter spfile says ?/dbs/spfile@.ora and yet there is no directory > > > > dbs in $ORACLE_HOME (linux btw). > > > > > > Thoughts that come immediately to mind: > > > > > > Wrong $ORACLE_HOME > > Don't believe so...sqlplus is working and which sqlplus shows it under > > the bin under $ORACLE_HOME > > > > > dbs directory deleted (unix keeps deleted files open until they are > > > closed, you just can't see their directory entries - renaming can be > > > confusing, too) > > Ok, could be, it's not my machine > > > > > find / -name "*ora" > > Yeah, did that, only found network/admin files > > > > > started with a pfile that didn't end in ora > > > broken link to dbs or nfs issue or cluster issue > > ok, maybe...I'll have to investigate that. > > > > > create pfile from spfile > > Is that a suggestion or that I should be looking for a pfile? show > > parameter pfile results in the same spfile display. Couldn't find any > > file containing *pfile*. > > > > > > > > What are the problems? > > All I wanted to do was modify the init.ora/spfile to set a trace file > > (for ORACLE_TRACE_ENABLE) to track down a ORA-03113 error in an OCI > > app. However, I've just realised unless I can guess the oracle password > > I'm screwed :-( > > 1- The create pfie command will create an init.ora file from the > spfile. You can then modify the init.ora file and use if to re-create > the spfile. > > 2- Even if you have lost the SYS password you can connect to Oracle > using the default OS security feature. You have to be a member of the > same UNIX group as the Oracle owner, usually Oracle. Once connected > you are SYS and can reset the password. > > 3- Instead of tracing the entire database why not just set a 3113 event > and trace those processes that puke on the error? > > HTH -- Mark D Powell -- |
|
02-25-2008, 04:45 AM
| |||
| |||
| Re: Can't find spfile On Thu, 01 Jun 2006 14:49:43 -0700, pfa wrote: > I'm trying to investigate problems on an oracle 9i server however I > cannot find an init.ora, pfile or spfile. What's strange is that show > parameter spfile says ?/dbs/spfile@.ora and yet there is no directory > dbs in $ORACLE_HOME (linux btw). You've got a problem. There should be $ORACLE_HOME/dbs. If you don't have it, you can always create it. If $ORACLE_HOME/dbs is missing, God knows what else might be missing as well. -- http://www.mgogala.com |
|
02-25-2008, 04:45 AM
| |||
| |||
| Re: Can't find spfile On Thu, 01 Jun 2006 16:01:23 -0700, pfa wrote: > All I wanted to do was modify the init.ora/spfile to set a trace file > (for ORACLE_TRACE_ENABLE) to track down a ORA-03113 error in an OCI > app. However, I've just realised unless I can guess the oracle password > I'm screwed :-( What would you do with ORACLE_TRACE_ENABLED? ORA-03113 means that the server process has given up on the life in this valley of tears and that the real error, usually ORA-07445 or ORA-0600 is in the alert log. You can find the alert log by looking into parameter background_dump_dest. That is the reason why DBA people like me carry firearms: anybody who attempts to change instance parameters without approval from the resident DBA will be shot on the spot. You would add overhead, clog filesystem, slow everything down, without resolving the problem. Before changing instance parameters, you gotta ask yourself one question: do I feel lucky? Well, do you? -- http://www.mgogala.com |
|
02-25-2008, 04:45 AM
| |||
| |||
| Re: Can't find spfile Thanks for the tip (background_dump_dest). As for your DBA concerns...it's a development machine with a copy of a test database so we can work out the customer's problem (or try and work out :-)). But I hear what you're saying. Mladen Gogala wrote: > On Thu, 01 Jun 2006 16:01:23 -0700, pfa wrote: > > > All I wanted to do was modify the init.ora/spfile to set a trace file > > (for ORACLE_TRACE_ENABLE) to track down a ORA-03113 error in an OCI > > app. However, I've just realised unless I can guess the oracle password > > I'm screwed :-( > > What would you do with ORACLE_TRACE_ENABLED? ORA-03113 means that the > server process has given up on the life in this valley of tears and that > the real error, usually ORA-07445 or ORA-0600 is in the alert log. You > can find the alert log by looking into parameter background_dump_dest. > That is the reason why DBA people like me carry firearms: anybody who > attempts to change instance parameters without approval from the resident > DBA will be shot on the spot. You would add overhead, clog filesystem, > slow everything down, without resolving the problem. Before changing > instance parameters, you gotta ask yourself one question: do I feel lucky? > Well, do you? > > -- > http://www.mgogala.com |
|
02-25-2008, 04:45 AM
| ||||
| ||||
| Re: Can't find spfile So I'm not going mad after all... As I said in another post it's a development machine. No idea why dbs would've been deleted. Will be emailing my colleagues in Chennai right now... Mladen Gogala wrote: > On Thu, 01 Jun 2006 14:49:43 -0700, pfa wrote: > > > I'm trying to investigate problems on an oracle 9i server however I > > cannot find an init.ora, pfile or spfile. What's strange is that show > > parameter spfile says ?/dbs/spfile@.ora and yet there is no directory > > dbs in $ORACLE_HOME (linux btw). > > You've got a problem. There should be $ORACLE_HOME/dbs. If you don't have > it, you can always create it. If $ORACLE_HOME/dbs is missing, God knows > what else might be missing as well. > > -- > http://www.mgogala.com |
Linear Mode
