hi Suhen, i too before tried to create a db like millie, i failed now i applied as u suggested and i succeed also in one case. What happened u know, i have 2 machines development machine(V731) and in my PC i have my own database(V815). First time i created a db link from the development machine to my server. This case i suceeded. But again i tried to create another DB link from my server to development machine. i time i got 'Uable to resolve TNS names' like that for the first time and 2nd time also got the error similar to the first one, 3rd time i got the error as like below "ORA-00602: internal programming exception %SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual address=0000000000000000, PC=0000000000000000, PS=00000000". then i stoped to create the db link. Now the problem is, am not able to connect to my development m/c through any tool like sql, d2k. All cases i got the following error. What is the proble.... what i did mistake in that, Could any one clear me please, it's very urgent...... thanks in advance.. SQL*Plus: Release 8.0.6.0.0 - Production on Sun Apr 8 13:35:19 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. ERROR: ORA-00602: internal programming exception %SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual address=0000000000000000, PC=0000000000000000, PS=00000000 ERROR: ORA-00602: internal programming exception %SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual address=0000000000000000, PC=0000000000000000, PS=00000000 Error accessing package DBMS_APPLICATION_INFO ERROR: ORA-00602: internal programming exception %SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual address=0000000000000000, PC=0000000000000000, PS=00000000 Connected to: Oracle7 Server Release 7.3.4.3.0 - Production With the distributed option PL/SQL Release 2.3.4.3.0 - Production SQL> Regards, Nirmal. > -----Original Message----- > From: Suhen Pather [SMTP:[EMAIL PROTECTED]] > Sent: Saturday, April 07, 2001 9:00 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: database links > > Millie, > > Check both instances and verify if global_names parameter is switched on. > What is the name of your db link? > select * from global_name; > Is it the same as global_name? > > I have a problems creating database links when I have global_names > parameter > set to TRUE. > I normally switch global_names=false unless the application uses > global_names. > > I create my database link using the connect description from my > tnsnames.ora > file for > that instance. It normally works. > > eg. > create database link test connect to jdatest identified by jdatest > using '(DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST = odbms)(PORT = 1521)) > ) > (CONNECT_DATA = > (SERVICE_NAME = test) > ) > )' > ; > > This normally works for me. DB links are very fussy when it comes to > global > names. > Also the name that is given to your db link when global names are used. > > HTH > Suhen > > > > Suhen > > > > We are setting up a test Oracle 8i (8.1.7 with OSDI) on our > mainframe (os/390 v2.8), we can connect to the database instance (ORS1) > from > windows NT client, but when we try to connect to it using database links > set > up from our unix platform, > we get ORA-12154 > TNS: Could not resolve service name > > When we try to link from ors1 I get: > ORA-02019 > Connection Description For Remote Database Not Found. > > We created a tar with Oracle and waiting to hear from them. Just > wondering if anyone on the list has the same problem? > > > Millie Chan > Rutgers, The State University of New Jersey > Administrative Computing Services > 65 Davidson Road > Piscataway, NJ 08855 > Tel: (732)445-5433 > EMAIL: [EMAIL PROTECTED] > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Chan, Millie > 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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Suhen Pather > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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).