Re: ORA-01041: internal error. hostdef extension doesn't exist
Sami You have to set ORACLE_SID to your instance name, The oracle software can not gues the name of the instance. You can set the ORACLE_SID in the registey, the global -, the local - or the the local session enviroment. [EMAIL PROTECTED] wrote: Hi Murray I'm running Win 2000. 1)OracleServiceSID is running. 2)But why do i need listener? I'm not going to use connect string. Thanks Sami Murray, Margaret [EMAIL PROTECTED] To eating.com Multiple recipients of list Sent by: ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc .com Subject RE: ORA-01041: internal error. 06/25/2003 10:09 hostdef extension doesn't exist PM Please respond to [EMAIL PROTECTED] com Are you running on NT or Windows 2000? If so, make sure both the TNSListener service and the OracleServiceSID are running. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject: ORA-01041: internal error. hostdef extension doesn't exist 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: Murray, Margaret 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). -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram 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).
Re: ORA-01041: internal error. hostdef extension doesn't exist
Does anyone have information about salaries in Denver? I looked at salary.com and saw the median salary was $72K. Does anyone have any opinions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Helen J Mitchell 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).
Re: ORA-01041: internal error. hostdef extension doesn't exist
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).
RE: ORA-01041: internal error. hostdef extension doesn't exist
Are you running on NT or Windows 2000? If so, make sure both the TNSListener service and the OracleServiceSID are running. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject: ORA-01041: internal error. hostdef extension doesn't exist 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: Murray, Margaret 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).
Re: ORA-01041: internal error. hostdef extension doesn't exist
Hi Reginald Thanks for your response. I would like to use OS authentication instead if password file authentication. Anyways i'll try setting the REMOTE_LOGIN_PASSWORDFILE = TRUE and let you know. Thanks Sami Reginald.W.Bailey @jpmorgan.com Sent by: To [EMAIL PROTECTED] Multiple recipients of list .com ORACLE-L [EMAIL PROTECTED] cc 06/25/2003 09:54 Subject PMRe: ORA-01041: internal error. hostdef extension doesn't exist Please respond to [EMAIL PROTECTED] com 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). -- 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).
RE: ORA-01041: internal error. hostdef extension doesn't exist
Hi Murray I'm running Win 2000. 1)OracleServiceSID is running. 2)But why do i need listener? I'm not going to use connect string. Thanks Sami Murray, Margaret [EMAIL PROTECTED] To eating.com Multiple recipients of list Sent by: ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc .com Subject RE: ORA-01041: internal error. 06/25/2003 10:09 hostdef extension doesn't exist PM Please respond to [EMAIL PROTECTED] com Are you running on NT or Windows 2000? If so, make sure both the TNSListener service and the OracleServiceSID are running. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject: ORA-01041: internal error. hostdef extension doesn't exist 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: Murray, Margaret 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).