Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: LRM-00109 and ORA-01078 while starting up database remot

Re: LRM-00109 and ORA-01078 while starting up database remot

From: Philip Chee <philip_at_aleytys.pc.my>
Date: Sat, 13 Apr 2002 21:29:17 GMT
Message-ID: <1018733357.6015snx@aleytys.pc.my>


In article <3CB73988.6E027D8B_at_BACKSIESearthlink.net> smckeownNO_at_BACKSIESearthlink.net writes:
>Philip Chee wrote:

>> What's so difficult about telnetting to the server and opening a
>> SQL*Plus session there?

>Could be that the person wanting to start the database doesn't have
>access to an OS account with these privs, but does have the right Oracle
>account level privs.

If I can't trust somebody with an OS account on a server, I sure wouldn't give out an Oracle account with those privileges either.

man sudo
man RBAC (Solaris only)
man jail (*BSD) etc etc etc.

>Could be that Telnet is prohibited but secured SqlNet is admissible
>for security reasons.

So run ssh. Security levels won't be compromised this way.

>Could be that you want a single location from which to execute such
>commands withouth the hassle of telnetting to different machines
>first (scripted backup maybe, who knows).

With scripted stuff, it's trivial to script logins to remote servers via rsh (unsecure) or ssh (better security) so your claims of extra hassle are unwarranted.

man expect
man kermit

>But 9i and and spfile would probably help no matter what.

Ok. Good point. Also I just remembered that the original poster had the DBMS on a Windows server, so telnet/ssh won't work. I concede.

Philip

---=====================================================================---
 Philip Chee: Tasek Corporation Berhad, P.O.Box 254, 30908 Ipoh, MALAYSIA   e-mail: philip_at_aleytys.pc.my Voice:+60.5.291.1011 Fax:+60.5.291.9932    Guard us from the she-wolf and the wolf, and guard us from the thief,
                  oh Night, and so be good for us to pass.
-- 
 þ 20410.07 þ Fatal Database Error #10070: Sysop late for work
Received on Sat Apr 13 2002 - 16:29:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US