Oracle and SQLPlus no longer start.

My department has recently (within the last 4 months) begun to actually use Oracle8i
for some of our applications and the other day, after a system reboot, I can no longer
get sqlplus or oracle to come up.

We're running Solaris 8 on Sun Model 220 and as recently as perhaps 4 weeks ago
we were fine. Now my attempts, as user Oracle or myself , to fire up sqlplus are
returning an error message to me that says "Message file sp1<lang>.msb not found.
Error 6 initializing SQL*Plus."

Also 4 weeks ago I was able to run svrmgrl and the system would not challenge me
asking for a password. Today it does and no matter if I enter the sys or system password
the error message "ORA-09925: Message 9925 not found; No message file for
product=RDBMS, facility=A. SVR4 Error 13:Permission denied. Additional information:
9925."

I suspect that ownerships and permissions have gotten changed.

Question please: Can I run the "root.sh" script and have that utility change ownerships and
permissions back sufficiently that SQLPlus and Oracle8i will start?

Alternatively, is there a document that indicates proper ownerships and permissions?

We need this system back up to continue with work already in place and I am willing to
check files individually and "brute force" try to get things back in working order BUT
if there's a utility available that will do these things automatically ("root.sh"?), we'd
be grateful.

Sincerely,

John Ragsdale
US Library of Congress
Washington, DC 20540
ph: 202-707-8751
fax: 202-707-3670
email to: jragsdale_at_crs.loc.gov

PLEASE get back to me via jragsdale_at_crs.loc.gov

Thanks very much. Received on Mon Jul 09 2001 - 14:44:49 CDT