Re: Oracle and SQLPlus no longer start.

Sounds like you may have lost your .profile / .login scripts.

The errors that you are receiving are symptomatic of improperly set environment variables.

--
Robert Fazio
Senior Technical Analyst
dbabob_at_yahoo.com

"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.

>

>