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