RE: SOS - URGENT********DB LINK

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Mon, 11 Sep 2006 23:27:26 +0100
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC0F40E846@ENYC11P32005.corpny.csfb.com>

After the SA corrects the file, test the link with

SELECT * from dual_at_PRUEBAS.US.ORACLE.COM;

As long as no error is returned, the link is correct.

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: crcbedoy_at_proteccion.com.co [mailto:crcbedoy_at_proteccion.com.co] Sent: Monday, September 11, 2006 6:32 PM To: Baumgartel, Paul
Cc: oracle-l_at_freelists.org; Smith, Steven K - MSHA Subject: RE: SOS - URGENT********DB LINK

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.

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

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

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

Received on Mon Sep 11 2006 - 17:27:26 CDT