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)OracleService<SID> 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 OracleService<SID> 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).