Hi, Thanks to everyone who replied!
I figured it out. I had to apply 6751 permissions to the oracle.exe ... and it worked just fine after that! Thanks sujatha -----Original Message----- Sent: Tuesday, 30 October 2001 3:01 PM To: Multiple recipients of list ORACLE-L First, make root a member of the "dba" unix group. You will then be able to "connect internal" or "/as sysdba". This is a bad idea. Second, at the command line, logged in as root, type: ~oracle/.profile Make sure your ORACLE_SID is set properly and fire away. This is still a bad idea. It would be better for root to "su" to oracle and do anything it needs to do as the oracle user, i.e., su - oracle As root, no password will be required on most *nix flavors. Happy "su"'ing, Scott Shafer San Antonio, TX ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, October 29, 2001 6:40 PM > Hi, > > How can I allow root to connect to the database as system. At the moment > when I try this, I keep getting a ORA-01034: Oracle not available error, > even though the database is up and running fine. > > Regards, > > Sujatha _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).