my question is "why are you insisting on root logging into the database???" create a new userid to do the connection.
i thought i remembered somewhere about root not being able to login, maybe that was back and hardcoded for svrmgrl. joe Sujatha Madan wrote: > > Ok, I have solved the issue of the listener, however I still cannot get root > to log on as system. > > - My Oracle home is set correct > - My Oracle sid is set correct > - ld library path is correct > - other path;s are correct > > does anyone have an idea on how to fix this? > > thanx > > -----Original Message----- > Sent: Tuesday, 30 October 2001 1:40 PM > To: Multiple recipients of list ORACLE-L > > I have set the SID correct and all the environment variables correctly. What > I didn't do was set up the listener and tnsnames. However, when I am trying > to set up the listener, for some reason it is not able to find the > executables. It is looking in a different directory. The Oracle Home is set > correctly. > > -----Original Message----- > Sent: Tuesday, 30 October 2001 12:20 PM > To: Multiple recipients of list ORACLE-L > > Looks like your oracle sid is set incorrectly and you > are trying to connect without using a tns service name > > Deepak > > PS: have you set the env variables .. type env at the > unix prompt and check if PATH /ORACLE_HOME/ > LD_LIBRARY_PATH are set correctly > > --- Sujatha Madan <[EMAIL PROTECTED]> > wrote: > > 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 > > -- > > 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). > -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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).
