Re: Oracle and SQLPlus no longer start.

"John Ragsdale" <jragsdale_at_crs.loc.gov> wrote in message news:3B4A09B1.80AC54B_at_crs.loc.gov...
> 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.
>
>

You need to check:
correct environment variables (looks like you're missing ORA_NLS<nn>_DATA) correct privileges
Both are of course outlined in the installation manual for your platform. IIRC root.sh doesn't change ownership and protections, you need to issue one to two chmod commands to accomplish this. Default protection 4755 for most files and the setuid bit should be on for the Oracle executable and the tnsnlistener executable. But of course you should confirm this in your manual. You may also want to verify your .profile (bash and ksh) or your .login (csh), chances are it is incomplete.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Mon Jul 09 2001 - 15:15:37 CDT