RE: database links - had problem, hlp me urgent pls

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Sun, 08 Apr 2001 04:10:15 -0700
Message-ID: <F001.002E4B43.20010408034519@fatcity.com>

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

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:Suhen.Pather_at_strandbags.com.au]
> 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: mchan_at_acs.rutgers.edu
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Chan, Millie
> INET: mchan_at_surfside.rutgers.edu
>
> 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: ListGuru_at_fatcity.com (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: Suhen.Pather_at_strandbags.com.au
>
> 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: ListGuru_at_fatcity.com (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: NIRMALK_at_qtel.com.qa

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: ListGuru_at_fatcity.com (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).

Received on Sun Apr 08 2001 - 06:10:15 CDT