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

  • From: crcbedoy@xxxxxxxxxxxxxxxxx
  • To: paul.baumgartel@xxxxxxxxxxxxxxxxx
  • Date: Mon, 11 Sep 2006 18:04:54 -0500

Done, thanks to all for your great help!:D

:):)

Isabel Bedoya Gómez
Centro de Gestión y Control
Tel. 2307500 ext:



"Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx> 
Enviado por: oracle-l-bounce@xxxxxxxxxxxxx
11/09/2006 17:27
Por favor, responda a
paul.baumgartel@xxxxxxxxxxxxxxxxx


Para
"'crcbedoy@xxxxxxxxxxxxxxxxx'" <crcbedoy@xxxxxxxxxxxxxxxxx>
cc
oracle-l@xxxxxxxxxxxxx
Asunto
RE: SOS - URGENT********DB LINK






After the SA corrects the file, test the link with 
 
SELECT * from dual@xxxxxxxxxxxxxxxxxxxxx;
 
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@xxxxxxxxxxxxxxxxx 
www.credit-suisse.com 
-----Original Message-----
From: crcbedoy@xxxxxxxxxxxxxxxxx [mailto:crcbedoy@xxxxxxxxxxxxxxxxx]
Sent: Monday, September 11, 2006 6:32 PM
To: Baumgartel, Paul
Cc: oracle-l@xxxxxxxxxxxxx; 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@xxxxxxxxxxxxxxxxx> 
11/09/2006 17:20 


Para
"'crcbedoy@xxxxxxxxxxxxxxxxx'" <crcbedoy@xxxxxxxxxxxxxxxxx>, "Smith, 
Steven K - MSHA" <Smith.Steven@xxxxxxx> 
cc
oracle-l@xxxxxxxxxxxxx 
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@xxxxxxxxxxxxxxxxx 
www.credit-suisse.com 
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of crcbedoy@xxxxxxxxxxxxxxxxx
Sent: Monday, September 11, 2006 6:13 PM
To: Smith, Steven K - MSHA
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxx> 
11/09/2006 17:02 


Para
<crcbedoy@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx> 
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 
On Behalf Of crcbedoy@xxxxxxxxxxxxxxxxx
Sent: Monday, September 11, 2006 3:46 PM
To: oracle-l@xxxxxxxxxxxxx
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@PRUEBAS where 
emp_fecha_ingreso>=to_date('20060901','yyyymmdd') 
/ 

I get the following error: 

select * from srhcxn2.empleado@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
==============================================================================

Other related posts: