RE: db link from oracle 8.1.7 to 8.0.5

I think I forgot to mention that a public synonym has to be involved...

Regards,
Patrice Boivin
Systems Analyst (Oracle DBA)
Acting Head, System Admin & Operations
Bedford Institute of Oceanography
Fisheries and Oceans Canada

> -----Original Message-----
> From: nlzanen1_at_EY.NL [SMTP:nlzanen1_at_EY.NL]
> Sent: Wednesday, September 12, 2001 9:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: db link from oracle 8.1.7 to 8.0.5
>
>
> Hi
>
>
> *************************************************************
> SQL*Plus: Release 8.1.6.0.0 - Production on Wed Sep 12 09:01:55 2001
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.7.2.1 - Production
> With the Partitioning option
> JServer Release 8.1.7.2.1 - Production
>
>
>
>
> Session altered.
>
> 13:37:45 37-HOMEBASE-JACK> desc dbs_at_cc1
> Name
> ---------------------------------------------------------
> DB_NM
> HOST_NM
> DESCRIPTION
> DB_ID
> AUTO_CHECK
> BLOCKSIZE
>
> 13:38:13 37-HOMEBASE-JACK>
>
> *******************************************************************
>
> This is using SQL*plus on NT4 SP6 version 8.1.6 logged on to Oracle
> 8.1.7.2.1 EE on W2K connecting via dblink to Oracle 8.0.5 EE on AIX 4.3.2
>
>
> Jack
>
>
>
>
> "Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca>@fatcity.com on 12-09-2001
> 14:11:21
>
> Please respond to ORACLE-L_at_fatcity.com
>
> Sent by: root_at_fatcity.com
>
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
>
> Try doing a describe across that db link from 8i to 8.0.5...
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle DBA)
> Acting Head, System Admin & Operations
> Bedford Institute of Oceanography
> Fisheries and Oceans Canada
>
>
>
> > -----Original Message-----
> > From: nlzanen1_at_EY.NL [SMTP:nlzanen1_at_EY.NL]
> > Sent: Wednesday, September 12, 2001 5:05 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: db link from oracle 8.1.7 to 8.0.5
> >
> >
> > Hi
> >
> > That should be no problem.
> > I just tried it.
> > Connect to database 8.1.7.2.1 and created database link cc1 without
> > username & password that connects to cc1 (8.0.5, take my word for it)
> and
> > works fine
> >
> > ****************************************************************
> >
> >
> > SQL*Plus: Release 8.1.6.0.0 - Production on Wed Sep 12 09:01:55 2001
> >
> > (c) Copyright 1999 Oracle Corporation. All rights reserved.
> >
> >
> > Connected to:
> > Oracle8i Enterprise Edition Release 8.1.7.2.1 - Production
> > With the Partitioning option
> > JServer Release 8.1.7.2.1 - Production
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Session altered.
> >
> > 09:01:58 37-HOMEBASE-JACK> drop database link cc1;
> >
> > Database link dropped.
> >
> > 09:02:14 37-HOMEBASE-JACK> CREATE DATABASE LINK cc1
> > 09:02:24 2 USING 'cc1';
> >
> > Database link created.
> >
> > 09:02:26 37-HOMEBASE-JACK> SELECT * FROM v$database_at_cc1;
> >
> > DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS_TIME
> > PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_T LOG_MO
> > ---------- --------- ----------------- -----------------
> -----------------
> > ----------------------- ----------------- ---
> > 728855776 CC1 01-feb-2000 09:49 1 01-feb-2000
> 09:49
> > 0 NOARCHIVE
> >
> > 09:02:42 37-HOMEBASE-JACK>
> >
> >
> **************************************************************************
> > *
> >
> >
> > Jack
> >
> >
> >
> >
> > Arslan Dar <arslandar_at_skm.org.pk>@fatcity.com on 11-09-2001 19:10:24
> >
> > Please respond to ORACLE-L_at_fatcity.com
> >
> > Sent by: root_at_fatcity.com
> >
> >
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
> >
> > hi list,
> >
> >
> > i am trying to make a database link from oracle 8.1.7 to oracle 8.0.5,
> > but its failing,
> > giving message "DB LINK NOT ACTIVE"
> > global_names parameter is false on both the database,
> > the schema in which its being created exists in both the databases with
> > same password and privillages, and i am using CONNECTED USER mode of
> > database link,
> >
> >
> > is that possible to create db link in such conditions,
> > any suggestions,
> >
> >
> > Thanks in Advance
> >
> >
> > Arslan
> >
> >
> >
> >
> >
> >
> >
> > =====================================================================
> > De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
> > uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
> > vermenigvuldiging, verspreiding en/of verstrekking van deze informatie
> aan
> > derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
> > Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
> > volledige overbrenging van de inhoud van een verzonden e-mailbericht,
> noch
> > voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat
> een
> > verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
> > worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
> >
> > Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
> > vriendelijk doch dringend het e-mailbericht te retourneren aan de
> > verzender
> > en het origineel en eventuele kopieën te verwijderen en te vernietigen.
> >
> > Ernst & Young hanteert bij de uitoefening van haar werkzaamheden
> algemene
> > voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
> > algemene voorwaarden worden u op verzoek kosteloos toegezonden.
> > =====================================================================
> > The information contained in this communication is confidential and is
> > intended solely for the use of the individual or entity to whom it is
> > addressed. You should not copy, disclose or distribute this
> communication
> > without the authority of Ernst & Young. Ernst & Young is neither liable
> > for
> > the proper and complete transmission of the information contained in
> this
> > communication nor for any delay in its receipt. Ernst & Young does not
> > guarantee that the integrity of this communication has been maintained
> nor
> > that the communication is free of viruses, interceptions or
> interference.
> >
> > If you are not the intended recipient of this communication please
> return
> > the communication to the sender and delete and destroy all copies.
> >
> > In carrying out its engagements, Ernst & Young applies general terms and
> > conditions, which contain a clause that limits its liability. A copy of
> > these terms and conditions is available on request free of charge.
> > =====================================================================
> >
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: nlzanen1_at_EY.NL
> >
> > 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: Boivin, Patrice J
> INET: BoivinP_at_mar.dfo-mpo.gc.ca
>
> 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).
>
>
>
>
> =====================================================================
> De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
> uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
> vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
> derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
> Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
> volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
> voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
> verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
> worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
>
> Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
> vriendelijk doch dringend het e-mailbericht te retourneren aan de
> verzender
> en het origineel en eventuele kopieën te verwijderen en te vernietigen.
>
> Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
> voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
> algemene voorwaarden worden u op verzoek kosteloos toegezonden.
> =====================================================================
> The information contained in this communication is confidential and is
> intended solely for the use of the individual or entity to whom it is
> addressed. You should not copy, disclose or distribute this communication
> without the authority of Ernst & Young. Ernst & Young is neither liable
> for
> the proper and complete transmission of the information contained in this
> communication nor for any delay in its receipt. Ernst & Young does not
> guarantee that the integrity of this communication has been maintained nor
> that the communication is free of viruses, interceptions or interference.
>
> If you are not the intended recipient of this communication please return
> the communication to the sender and delete and destroy all copies.
>
> In carrying out its engagements, Ernst & Young applies general terms and
> conditions, which contain a clause that limits its liability. A copy of
> these terms and conditions is available on request free of charge.
> =====================================================================
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: nlzanen1_at_EY.NL
>
> 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: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

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