Saminathan: Try setting the REMOTE_LOGIN_PASSWORDFILE = TRUE. Before bouncing the database, create the password file with the orapasswd utility and assign a password. Then in the database, alter the SYS userid to use the same password as in the file. Then bounce the database. Then try "sqlplus / as sysdba".
RWB ============================================================================================================ Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) ============================================================================================================ Saminathan_Seeran [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: ORA-01041: internal error. hostdef extension doesn't exist .com 06/25/2003 09:04 AM Please respond to ORACLE-L Hi All, I have the following environment variable set ORACLE_HOME ORACLE_SID TNS_ADMIN init.ora file ========= REMOTE_LOGIN_PASSWORDFILE=NONE sqlnet.ora file ============ SQLNET.AUTHENTICATION_SERVICES= (NTS) I'm getting the following error. What could be wrong? SQL> connect / as sysdba ERROR: ORA-01041: internal error. hostdef extension doesn't exist Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).