Re: Help!! Oracle Application Crash

Daniel Morgan wrote:

>Unknown wrote:
>
>>Hello,
>>
>>I have, rather "HAD" an Oracle Database v. 7.3 running on NT crash.
>>
>>The good news is, the database instances were on D drive.
>>
>>I re-installed Oracle back to C drive, but do not know how to create a
>>new instance, and point Oracle to the still intact database files on D
>>drive.
>>
>>I have a backup of the init<SID>.ora file, as well as the control files,
>>but do not know how use these to recover the database.
>>
>>Please help this newbie, cause all of my PL/SQL code in stored in the
>>DB.
>>
>>Thank you.
>>
>>Sincerely,
>>Christopher C. Keeler
>>
>
>The best help I can give you is to NEVER store all of your PL/SQL code in
>any one place. Doing so stands on a fine line between masochistic and
>suicidal.
>

I'm curious. Where else would you keep your PL/SQL code, if not in the database?

>
>
>Have you tried starting the listener?
>
>c:\oracle\ora81\bin>lsnrctl start
>
>Does it start?
>
>c:\oracle\ora81\bin>lsnrctl status
>
>Can you get into server manager?
>
>c:\oracle\ora81\bin>svrmgrl
>
>Can you connect?
>
>SVRMGR> connect internal
>
>Can you run a simple SQL statement?
>
>SVRMGR> select count(*) from tab$;
>
>If you get any errors report back the full error text not just the number.
>
>Daniel Morgan
>
Received on Wed May 01 2002 - 20:08:08 CDT