RE: ORA-28030: Server encountered problems accessing LDAP directory service
Yes, that's correct. That is what the error message says. Anyone have any idea why it's trying to use LDAP to resolve the database link? I thought with my sqlnet.ora file set to use tnsnames.ora I'd be using my local files to resolve the service name. Any suggestions as to why it's trying to use LDAP are welcome. David -Original Message-From: ora ak [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 1:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: ORA-28030: Server encountered problems accessing LDAP directory service Looks like are trying to resolve service name using LDAP naming . David Mitchell [EMAIL PROTECTED] wrote: I've recently inherited an Oracle 8.1.6 system and was just trying tosetup a database link between two instances. I've granted the "createdatabase link" priv to the user account and can successfully create thelink but when I try to do a "select from table_name@linked_db;" I getthe following error:ERROR at line 1:ORA-28030: Server encountered problems accessing LDAP directory serviceEarlier I had a TNS error and found that my tnsnames.ora file wasmissing one of my instances. I fixed that problem and tnsping nowresponds correctly but I'm still getting the error listed on the subjectline. My sqlnet.ora file contains "NAMES.DIRECTORY_PATH= (TNSNAMES)" soeverything should be set to use my local tnsnames.ora file. I've beengoing through Oracle Net 8 documentation but still haven't foundanything. Does anyone have any suggestions? Thanks..! .David-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: David MitchellINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!?Yahoo! Mail Plus - Powerful. Affordable. Sign up now
RE: ORA-28030: Server encountered problems accessing LDAP directory service
Title: RE: ORA-28030: Server encountered problems accessing LDAP directory service Yes. This was indeed the case. I was using "current_user" to create the link. I just dropped and re-created the link using an named user account and the link works fine now. Thanks for the quick response! David -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02, 2003 9:57 AMTo: David MitchellSubject: RE: ORA-28030: Server encountered problems accessing LDAP directory service Displayed below are the messages of the selected thread. Thread Status: Closed From: TABAINET MOHAMED 01-Aug-02 14:54 Subject: ORA-28030 Server encountered problems accessing LDAP directory service RDBMS Version:: 8.1.7.0 Operating System and Version:: windows NT4 Error Number (if applicable):: ORA-28030 Server encountered problems accessing LDAP directory service Server Net Version:: 8.1.7.0 Client Operating System and Version:: 8.1.7.0 Client Net Version:: 8.1.7.0 ORA-28030 Server encountered problems accessing LDAP directory service I have 2 servers def03 and def64 I have created a dblink in def03 to connect to def64 I deinstalled Oracle advanced security in def03. but when I want to connect to database in def64 using dblink whith current_user option, i have this message ORA-28030 Server encountered problems accessing LDAP directory service SQL select name,value from v$parameter 2 where name in ('db_domain','db_name','global_names'); NAME VALUE -- db_domain global_names FALSE db_name THORATFE any helps please morad From: Oracle, MICHAEL SEIBT 01-Aug-02 16:09 Subject: Re : ORA-28030 Server encountered problems accessing LDAP directory service This is a bug (954379) Workaround: === Don't use current_user or create user identified globally. OR Set _ENT_DOMAIN_NAME to ANY value in init.ora file for dblinks which use current_user. Is this your case ?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: David Mitchell [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 12:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-28030: Server encountered problems accessing LDAP directory service Yes, that's correct. That is what the error message says. Anyone have any idea why it's trying to use LDAP to resolve the database link? I thought with my sqlnet.ora file set to use tnsnames.ora I'd be using my local files to resolve the service name. Any suggestions as to why it's trying to use LDAP are welcome. David
ORA-28030: Server encountered problems accessing LDAP directory service
I've recently inherited an Oracle 8.1.6 system and was just trying to setup a database link between two instances. I've granted the create database link priv to the user account and can successfully create the link but when I try to do a select from table_name@linked_db; I get the following error: ERROR at line 1: ORA-28030: Server encountered problems accessing LDAP directory service Earlier I had a TNS error and found that my tnsnames.ora file was missing one of my instances. I fixed that problem and tnsping now responds correctly but I'm still getting the error listed on the subject line. My sqlnet.ora file contains NAMES.DIRECTORY_PATH= (TNSNAMES) so everything should be set to use my local tnsnames.ora file. I've been going through Oracle Net 8 documentation but still haven't found anything. Does anyone have any suggestions? Thanks... David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David 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-28030: Server encountered problems accessing LDAP directory service
Looks like are trying to resolve service name using LDAP naming . David Mitchell [EMAIL PROTECTED] wrote: I've recently inherited an Oracle 8.1.6 system and was just trying tosetup a database link between two instances. I've granted the "createdatabase link" priv to the user account and can successfully create thelink but when I try to do a "select from table_name@linked_db;" I getthe following error:ERROR at line 1:ORA-28030: Server encountered problems accessing LDAP directory serviceEarlier I had a TNS error and found that my tnsnames.ora file wasmissing one of my instances. I fixed that problem and tnsping nowresponds correctly but I'm still getting the error listed on the subjectline. My sqlnet.ora file contains "NAMES.DIRECTORY_PATH= (TNSNAMES)" soeverything should be set to use my local tnsnames.ora file. I've beengoing through Oracle Net 8 documentation but still haven't foundanything. Does anyone have any suggestions? Thanks..! .David-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: David MitchellINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now