Next time this happens, a simple 'strings' command against the spfile will get you an
init.ora file. (Assuming UNIX server here). Edit it as needed. Rename/remove old spfile,
and you can startup the database again. Recreate spfile if desired.
Regards,
- Kirti
- david wendelken <davewendelken_at_earthlink.net> wrote:
>
> No, they didn't have an init.ora file. If they had, I wouldn't have been scrambling to
> create one!
> And, of course, if I knew the accounts, passwords, directories being used, etc., (not
> to mention being able to put my hands on the keyboard!) I could have just created a
> stub init.ora file. But that takes time to research because I'm not the dba for that
> system.
>
> Thanks for the help!
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Jul 22 2004 - 11:47:41 CDT