Re: SOS - URGENT********DB LINK

Here is a little know fact -

If you create $HOME/.tnsnames.ora file (NOTE preceeding period [hidden file] before the "t"),
SQL*Net will use it before any other file.

HTH & YMMV! On 9/11/06, crcbedoy_at_proteccion.com.co <crcbedoy_at_proteccion.com.co> wrote:
>
>
> I checked the tnsnames.ora and the IP address is incorrect, but I can't
> change it now because I don't have the permissions on the machine (Solaris),
> I am now waiting for the Server Administrator. After changing the IP
> address, it should work, isn't it??
>
>
> Isabel Bedoya Gómez
> Centro de Gestión y Control
> Tel. 2307500 ext:
>
>
> *"Baumgartel, Paul" <paul.baumgartel_at_credit-suisse.com>*
>
> 11/09/2006 17:20
> Para
> "'crcbedoy_at_proteccion.com.co'" <crcbedoy_at_proteccion.com.co>, "Smith,
> Steven K - MSHA" <Smith.Steven_at_DOL.GOV> cc
> oracle-l_at_freelists.org Asunto
> RE: SOS - URGENT********DB LINK
>
>
>
>
>
>
> That means that the database instance to which the link refers is not
> running.
>
>
> *Paul Baumgartel* *
> CREDIT SUISSE*
> Information Technology
> DBA & Admin - NY, KIGA 1
> 11 Madison Avenue
> New York, NY 10010
> USA
> Phone 212.538.1143
> paul.baumgartel_at_credit-suisse.com
> www.credit-suisse.com
>
> -----Original Message-----*
> From:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org
> ]*On Behalf Of *crcbedoy_at_proteccion.com.co*
> Sent:* Monday, September 11, 2006 6:13 PM*
> To:* Smith, Steven K - MSHA*
> Cc:* oracle-l_at_freelists.org*
> Subject:* RE: SOS - URGENT********DB LINK
>
>
> I changed, and still getting errors, now I get this error:
>
>
> ERROR at line 2:
> ORA-02068: following severe error from DESAROLLO9
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> SVR4 Error: 2: No such file or directory
>
> Isabel Bedoya Gómez
> Centro de Gestión y Control
> Tel. 2307500 ext:
>
> *"Smith, Steven K - MSHA" <Smith.Steven_at_DOL.GOV>*
>
> 11/09/2006 17:02
>
> Para
> <crcbedoy_at_proteccion.com.co>, <oracle-l_at_freelists.org> cc
>
> Asunto
> RE: SOS - URGENT********DB LINK
>
>
>
>
>
>
>
>
> That error is because you defined the database link as
> PRUEBAS.US.ORACLE.COM and you reference it in the statement as PRUEBAS.
>
> Be consistent.
>
> Steve Smith
>
> Envision Technology Partners / MSHA MSIS Team
>
> Desk: 303-231-5499
>
> -----Original Message-----*
> From:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> *On Behalf Of *crcbedoy_at_proteccion.com.co*
> Sent:* Monday, September 11, 2006 3:46 PM*
> To:* oracle-l_at_freelists.org*
> Subject:* SOS - URGENT********DB LINK
>
>
> Could you please help me??
>
>
> I am tryieng to create a DB link such as:
>
> CREATE DATABASE LINK PRUEBAS.US.ORACLE.COM
> CONNECT TO userid IDENTIFIED BY password
> USING 'PRUEBAS.US.ORACLE.COM';
>
>
> And then, when I try to do:
>
> insert into SRHCXN1.empleado
> select * from userid.empleado_at_PRUEBAS where
> emp_fecha_ingreso>=to_date('20060901','yyyymmdd')
> /
>
> I get the following error:
>
> select * from srhcxn2.empleado_at_PRUEBAS where
> emp_fecha_ingreso>=to_date('20060901','yyyymmdd')
> *
> ERROR at line 2:
> ORA-12154: TNS:could not resolve service name
>
>
> I checkl the TNSNAMES.ORA and everything is alright, could anybody please
> help me??.. I am in a rush:(.. I have the privileges as a DBA, my username
> is XXX, creating running a script to insert values to the schema SRHCXN1,
> getting the data from the userid.
>
> HELPPP!!!:(:(
>
> Isabel Bedoya Gómez
> Centro de Gestión y Control
> Tel. 2307500 ext:
>
>
> ==============================================================================
> Please access the attached hyperlink for an important electronic
> communications disclaimer:
>
> http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
>
> ==============================================================================
>
>

--
http://www.freelists.org/webpage/oracle-l